Latest Blog Posts

I Am Now A Microsoft Certified Trainer

I am very excited to announce that as of yesterday I am now a Microsoft Certified Trainer (MCT)! This is something that I have been wanting to do for years, and finally took the initiative to try to make it happen. I am looking forward to the opportunities this will allow for me to teach …

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 …

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