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 …
Setting The Database Owner, Compatibility Level, And Recovery Model With PowerShell
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, …
Upcoming Geek Sync: Practical PowerShell For The Busy DBA
Be sure to sign up for my upcoming IDERA Geek Sync, Practical PowerShell For The Busy DBA on November 19th, 2020 at 11:00 AM CT. I will be focusing on …
SQL Server Crashes When Hitting 80 Percent RAM Usage
I recently ran into a situation where a new SQL Server would crash hard every time it would get under a load. Here is a synopsis of what we were …
Be Proactive: A Good DBA Goes Looking For Signs of Trouble
Last month I did a session for IDERA Live 2020. This is a free, one day virtual conference put on by IDERA each year, and this year’s focus was “How …
PSSDIAG Error: There Is No Instance Named X
I’m writing this as a reminder to myself for a problem I just had to solve. When running the PSSDIAG tool, if you are running it against SQL 2016 SP2 …
Disabling An Index Drops Compression
This post is more of an FYI, and to remind myself in case I run into it again down the road. Here at work we have a very large, very …
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, …
Does SQL Server Now Distribute Transactions Evenly Across Multiple Log Files?
It is generally known throughout the SQL Server world that having multiple log files on a database is not a good idea. While multiple data files spread across multiple drives …
Setting Drive Allocation Unit Size With PowerShell
There seems to be some ongoing debate around whether or not formatting your data and log drives with 64KB allocation unit size even matters anymore. I would encourage you to …