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 …
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 …
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 …
Setting Up Database Mail And SQL Agent Alerts With PowerShell
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 …
Disable Telemetry On Multiple SQL Servers With PowerShell
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 …
Backing Up Databases With The dbatools PowerShell Module
We do a lot of database backups and restores at work, outside of our regular backup routines. A lot! I’ve actually done as many as 40 in one day. Our …
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. …
Getting Started With The dbatools PowerShell Module
If you are looking for a super easy way to start using PowerShell to manage your SQL Servers, then the dbatools PowerShell module is for you! For those that aren’t familiar, …
Using PowerShell To List Folders And Sizes
One of the things I run into regularly when dealing with storage is needing to know the sizes of folders in a directory. For example, if something filled up a …
Calling PowerShell From SQL Agent Gives Syntax Error
One cool thing that you can do in SQL Server that a lot of people don’t know about is run PowerShell code from a SQL Agent job. However, I recently ran into a …
Using PowerShell To Store sp_BlitzIndex Results In A Table
I really like Brent Ozar’s sp_BlitzIndex procedure. It offers a lot of great insight into the indexes in your databases. If you are not currently using it, you should check it …
Call Multiple SQL Jobs In Sequence Via PowerShell
Recently I had an issue come up where I needed to run about 15 SQL Agent Jobs in a specific order, bouncing back and forth across multiple SQL Servers, ensuring …