Latest Blog Posts

2020 IDERA ACE

I am super excited to announce that I have been selected to participate in the 2020 IDERA ACE program! IDERA made the announcement last week, and I am honored to be chosen as one of the 10 IDERA ACEs for 2020. You can read the full announcement on their blog: Introducing the IDERA ACE Class …

Yikes! Cannot recover the master database!

Recently, during patching for a 2019 SQL Server, the SQL services refused to start after the patching. It was throwing the following heart attack inducing error: Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. This is not the first time I …

PowerShell: Compare Users’ AD Groups

When it comes to user logins and permissions in SQL Server, I typically prefer to use Active Directory groups. The problem with that is that you don’t always know what groups a given user is in. I recently had a case where I needed to compare the Active Directory Groups of 2 users and determine …

Upcoming IDERA Geek Sync – March 17th, 2021

Don’t miss my upcoming IDERA Geek Sync, How To Be The DBA When You Don’t Have A DBA, this Wednesday, March 17, 2021. This webinar is for the “Accidental DBA”: the developer, sysadmin, or other IT professional that got stuck managing SQL Servers because their company doesn’t have a Database Administrator. This session will show …

Will You Run Out Of INT And BIGINT Identities In SQL Server?

In the war over Identities vs GUIDs as clustered indexes, one of the arguments in favor of Unique Identifiers is that you may run out of numbers when using a numeric Identity column (such as INT or BIGINT) for a clustered index.  Is this a realistic concern? The short answer is yes, it is possible, …