Skip to content
SQL Nuggets
Menu
  • Home
  • Blog
  • Speaking
  • Presentations
  • Downloads
  • About

Category: PowerShell

Home » PowerShell
PowerShell

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 …

Configurations / PowerShell

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, …

PowerShell

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 …

Configurations / PowerShell

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 …

Configurations / Corruption / PowerShell / SQL Agent

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 …

Configurations / PowerShell

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 …

Backups / PowerShell

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 …

PowerShell

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 …

PowerShell

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 …

PowerShell

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.  …

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, …

PowerShell

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 …

PowerShell

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 …

Indexes / PowerShell / Tools

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 …

PowerShell

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 …

Search

2020 IDERA ACE
MSCE: Data Platform

SUBSCRIBE VIA RSS

RSS feed RSS - Posts

Subscribe via Email

Receive notifications of new posts by email.

Categories

  • Availability Groups
  • Azure
  • Backups
  • Career
  • Conferences
  • Configurations
  • Corruption
  • DB Engine
  • Errors
  • Extended Events
  • Indexes
  • Management
  • MongoDB
  • Monitoring
  • Open Source Projects
  • Performance Tuning
  • PowerShell
  • Security
  • SQL Agent
  • SQL Scripts
  • SSIS
  • System Views
  • T-SQL
  • Tools

Recent Posts

  • The Power Of Proper Indexing
  • Yikes! Cannot recover the master database!
  • PowerShell: Compare Users’ AD Groups
  • Slides From My March 17th 2021 Geek Sync
  • Upcoming IDERA Geek Sync – March 17th, 2021

Top Posts

  • SQL Scripts: How To Find Missing Indexes
  • SQL Scripts: How To Find Index Usage
  • Using PowerShell To List Folders And Sizes
  • Checking The Status Of Email Sent From SQL Server
  • SQL Scripts: How To Find A Database’s Compatibility Level

Tags

Automation Azure Migration Backups Bad T-SQL Client Tools Clustered Indexes Database Mail Database Maintenance Data Files Data Storage dbatools DBCC CheckDB Encryption Execution Plans Express Edition Getting Started Index Basics Internals Log Files Music City Data Musings NOLOCK Nonclustered Indexes NoSQL Performance Permissions Presentations Quickies Server Administration Speaking SQL Agent SQL Index Insight SQL Metrics Pack SQL Permissions Manager SQL Saturday SQL Sentry SQL Server 2008 R2 SSMS Storing Passwords System Procedures Top Developer Tips Trace Flags Training Transaction Isolation Levels Visual Studio
Copyright © 2025 SQL Nuggets – OnePress theme by FameThemes
This website uses cookies to improve your experience. To find out more see our Privacy & Cookies Policy. Accept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT