Getting Started With The dbatools PowerShell Module
If you are looking for a super easy way to start using PowerShell to manage your SQL Servers, then the dbatools PowerShell module is for you! For those that aren’t familiar, …
Blog
Slides From Scenic City Summit 2018
The slides and code from my session, Exploring The New JSON Features In SQL Server, are attached here. As I mentioned in my presentation, I am using the Stack Overflow …
Speaking At Adobe ColdFusion Summit 2018
I’m heading to Vegas…to speak at the Adobe ColdFusion Summit again! This will be my third year speaking at the CF Summit, and I’m really excited to be heading back! This year’s event will …
Speaking At Scenic City Summit 2018
I’m a little late in announcing this, but next week I will be returning to speak at Scenic City Summit! The conference, which covers a variety of topics for Developers …
Using PowerShell To List Folders And Sizes
One of the things I run into regularly when dealing with storage is needing to know the sizes of folders in a directory. For example, if something filled up a …
Notes From A SQL 2017 Azure Install – Availability Group Nodes Across Multiple Azure Regions
One of the really great things about Azure is the capability to easily create servers in other data centers, in other parts of the country or world (referred to as …
SQL Scripts: How To Find Missing Indexes
One of the really cool things that SQL Server does is keep up with index statistics behind the scenes. It knows how an index has been used, how often it …
Speaking At Music City Data 2018
Music City Data (part of the 3-day Music City Tech conference) is this Saturday, June 2nd, and I realized last night that I had completely forgotten to announce that I will …
SQL Scripts: How To Find Filtered Indexes
Filtered indexes are one of those neat little SQL Server features that a lot of people don’t seem to know about, or if they do they don’t use them very …
SQL Scripts: How To Find A Database’s Compatibility Level
One thing that a lot of DBAs, especially Accidental DBAs such as myself, don’t seem to realize is that just because a database is sitting on a specific version of …