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 …
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”: …
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 …
Patching Multiple SQL Servers With Powershell and dbatools
Patching SQL Server can sometimes be a time consuming process, especially when you have multiple servers that need to be patched. Remoting in to each box to run through the …
Using dbatools PowerShell Module To Set MAXDOP And Max Memory
As I continue my blog series on using the dbatools PowerShell module, today I want to discuss using it to set MAXDOP and Max Memory on your SQL Server. This builds directly …
Using dbatools PowerShell Module To Configure SQL Server
The more I use the dbatools PowerShell module, the more I like it. It really is a solid set of scripts that allow you to easily manage your SQL Servers via PowerShell. …
SQL Scripts: How To Find A Database’s Compatibility Level
One thing that a lot of DBAs, especially Accidental DBAs such as myself, don’t seem to realize is that just because a database is sitting on a specific version of …
Change The Isolation Level Of An Availability Group Database
I recently needed to change the Transaction Isolation Level of one of our databases in an Availability Group. As it turns out, this is not as straight forward as you …
Discover Which Deprecated Features Are Being Used
With each new release of SQL Server comes a list of new features, along with a list of features that have been deprecated. These deprecated features are not immediately disabled …
What Features Are Disabled Between Compatibility Levels In SQL Server?
Have you ever wondered what features may or may not be available when your database is running in a different compatibility level than your SQL Server version? I recently came …
Checking The Status Of Email Sent From SQL Server
When sending email via sp_send_dbmail, SQL Server will log the status of each message processed by Database Mail. Below is quick list of Database Mail Views you can query to …