Home

Latest from the Blog

SQL Formatting in SSMS 22.7

Code formatting can be a touchy subject. Sometimes there are clear rules to designate right and wrong, and sometimes there’s not. Tabs versus spaces, anyone? Surprisingly, SQL Server Management Studio has never had a built-in SQL formatter. Users were always left to use third-party tools or format by hand. But with the latest SSMS 22.7,…

T-SQL Tuesday #199 – Moving Back From the Cloud

This month’s T-SQL Tuesday invite comes from Koen Verbeeck, who asks us to think about what it would look like to move back to on-premises infrastructure after years in the cloud. Do we still have the skills to go back to on-premises? What types of on-premises issues would be the most frustrating? Click the T-SQL…

Impact of Automatic Index Compaction

Index work has almost always been a core task for database administrators. If indexes aren’t performing well, then your queries probably aren’t performing well. And if your queries aren’t performing well, you aren’t performing well, because users will be complaining. There isn’t one set way to manage indexes. Maybe you use Ola Hallengren scripts. Maybe…

Get new content delivered directly to your inbox.