I’m Speaking at Data Platform Discovery Day!

I'm always honored to be chosen to present at events, but I'm especially happy to be speaking at the first ever Data Platform Discovery Day! Data Platform Discovery Day is "A free one-day virtual conference introducing you to the Microsoft Data Platform", and it's new this year. It's actually 2 days, consisting of 10 sessions, each 50 minutes long. There's a U.S. edition taking place on April 29, and a European edition on April 30. Anyone can attend or speak at either edition, the only real difference is time zone convenience. My Session I'll be presenting a classic session entitled…
Read More

Split Views of Files: SSMS Still is Best

While programming, I often need to view different parts of a file at the same time. Consider a long stored procedure: the list of parameters is at the top and it may be helpful to reference them when working elsewhere in the code. I could scroll repeatedly between the top of the file and wherever I am working, but that becomes annoying rather quickly, in addition to wasting time. Fortunately, SQL Server Management Studio, which is built on Visual Studio, has a wonderful solution to this. Each file has a splitter located in the top right corner. Simply grab the…
Read More

Video: SQL Prompt Execution Warnings

A while back, I wrote about how SQL Prompt now includes execution warnings and how useful I think that feature is. It's saved my bacon several times now, including just last week! I'm now happy to announce that I've recorded a demo video of this feature for Redgate's series of #SuperSQLTips for SQL Prompt. Be sure to check out my video, as well as the rest of the series - there's some super-helpful stuff in there!  
Read More

T-SQL Tuesday #68: Defaults

I'm so happy to be able to contribute to this month's T-SQL Tuesday! Andy Yun picked an excellent topic: default settings. Defaults exist for a reason: in the absence of a user's preference, they represent the option that the application's author(s) believe will generally work the best for the greatest number of people. All that being said, if you're reading this blog, you probably aren't the average computer user, and you probably aren't a fan of all the default settings your applications choose. I've got plenty of defaults for different applications that I despise and do my best to change as quickly as possible. Here's…
Read More

Multiple Result Sets = Multiple Row Counts

I'm sure this one's been in SQL Server Management Studio for quite a while, but I never noticed it before now. Let's say you're running a batch in SSMS containing 2 T-SQL Statements. For simplicity's sake, I'll do some selects from my Numbers table: SELECT TOP 10 * FROM Numbers; SELECT TOP 100 * FROM Numbers; The "Results" tab appears with 2 result sets. The first has 10 rows, and the second has 100. The rows counter at the bottom right says "110 rows". All of is exactly what I've come to expect. (Click on any screenshot to enlarge) Row…
Read More