Steve’s tweets
- @SQLSoldier do it, they are in source control, right? 1 day ago
- Loading All CSV Files with PowerShell voiceofthedba.com/2017/06/23/loa… https://t.co/8BbCuMSMau 1 day ago
- Nice to see security is a popular developer topic at @denverdevday https://t.co/Chu8Pwm4fC 1 day ago
Speaking at VS Live – Austin
Register with AUSPK14 and save $400
Tags
administration auditing Azure backup Backup/Recovery big data blogging bloopers business Business Intelligence career career cell phone Cloud Computing computers conferences continuous delivery continuous integration data analysis database design databases Database Weekly deployment Dev Connections DevOps disaster recovery DLM encryption Filetable Friday Poll hardware high availability Humor hyper-v life mcm Microsoft misc monitoring networking NoSQL PASS patching Performance powershell presentations Redgate sabbatical security software development software development speaking SQL Bits SQL Connections SQL Intersection SQL in the City SQLNewBlogger SQL Prompt SQL Saturday SQLServer sql server SQLServerCentral syndicated T-SQL T-SQL Tuesday testing TopTenSkills training travel tsqlt vacation version control virtualization windows work
Tag Archives: T-SQL
Move a Stored Procedure to a New Schema–SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I needed to do recently was move an object. I was testing the WideWorldImporters database … Continue reading
A Busy Few Years
Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking engagements. This person noted they had done over 40 talks in the last few years, which is a lot. I … Continue reading
Limiting the Max–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was chatting with someone the other day about MAX() and how it can work within a set of … Continue reading
Watch Your DataTypes in Aggregates–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve got a database of NBA statistics with data like this for players. I downloaded a CSV and loaded … Continue reading
Implicit Time Conversions – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was trying to work with times recently and needed to get the current time. I thought, well, Getdate(), … Continue reading
Posted in Blog
Tagged SQLNewBlogger, syndicated, T-SQL
Writing the Correct Query is Important
There’s a saying in the data world: garbage in, garbage out. We use that when we can’t get good information from our database because the data we’ve stored isn’t as useful as we would like. That’s a problem, and it’s … Continue reading
Quick Prompt Tips–Custom Procedure Templates
One of the things that I often do is create stored procedures. The syntax for doing so is simple, but it has a number of items that need to be included. SQL Prompt makes this much quicker with the “cp” … Continue reading
Posted in Blog
Tagged Redgate, SQL Prompt, syndicated, T-SQL
Be Careful of Your Create Stored Procedure Batch
I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this: CREATE PROCEDURE UpdateEmpID @empid INT AS BEGIN UPDATE dbo.Employees SET empid = 3 WHERE empid = @empid ; END However, this … Continue reading
Posted in Blog
Tagged syndicated, T-SQL
Finally, Create or Alter
There are lots of reasons to upgrade to SQL Server 2016, but this is the one for me. We finally get a CREATE OR ALTER statement in T-SQL. This not only makes lots of code easier to write, it means … Continue reading
#SQLNewBlogger – T-SQL ESCAPE for Wildcards
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran into a really interesting issue recently. I was working with a table and wanted to determine if … Continue reading
