The Power Of Proper Indexing
This image is an actual screen shot of one of our production SQL Server’s CPU usage, taken from our SQL Sentry monitoring system. Obviously this server was under some strain. …
This image is an actual screen shot of one of our production SQL Server’s CPU usage, taken from our SQL Sentry monitoring system. Obviously this server was under some strain. …
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 …
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 …
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”: …
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 …
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, …
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 …
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 …
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 …
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 …
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 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, …
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 …
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 …
As a DBA, you need to know when there’s a problem on your SQL Servers. And while I highly recommend you use a full-fledged monitoring system, there are also some …
SQL Saturday Tampa 2020 was this past weekend , and I have to say that I really enjoyed it! This was my first time at the Tampa event, and I …
Starting with SQL Server 2016, when you install SQL Server it also installs the CEIP (Customer Experience Improvement Program) Services, also known at Telemetry. In previous versions of SQL Server …