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, …

Read More

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 …

Read More

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 …

Read More

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 …

Read More

More often than not, I’ll expand the “Tables” folder in SQL Server Management Studio and browse the list to find whatever table or index I’m looking for. This works well in many situations, but when your database has over 20,000 tables, the results can be overwhelming! As your databases get larger and more complex, you …

Read More

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: 1SELECT TOP 10 * FROM Numbers; 2SELECT TOP 100 * FROM Numbers; The …

Read More