Nuggets Of SQL Server Knowledge
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 …
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 …
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 …
You can download the slides from today’s How To Be The DBA When You Don’t Have A DBA Geek Sync here.
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 …
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, …
One of the great things about dbatool is that it allows you to run commands against multiple things. Sometimes you may need to run the same command on every server, or every database on a server, or every database on every server (not recommended). Today we’re going to look at some simple examples of how …