Add new Databases to a AG Setup with PowerShell
Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.
2017-09-12 (first published: 2017-09-07)
965 reads
Scripts
CDC watchdog for databases in AlwaysOn AG
Stored procedure to ensure CDC job will be started once failover happen.
2017-08-25 (first published: 2017-08-22)
792 reads
SQL Server Agent Jobs Statistics
This script will give you a thorough report about sql server jobs based on historical data.
2017-07-26 (first published: 2013-09-25)
2,184 reads
Script DB Level Permissions v4.3
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
15,132 reads
2017-07-24 (first published: 2017-07-12)
631 reads
Add a login to multiple SQL Servers
This is a simple powershell script that will add a particular login to multiple SQL Server instances in a go.
2017-07-19 (first published: 2017-07-04)
1,946 reads
2017-07-18 (first published: 2015-10-16)
1,759 reads
XML import from a Cross-tab Report
Source xml is a rendition of a cross-tab report. I show the evolution of a Spackle solution for import as a SQL resultset.
2017-06-08 (first published: 2017-06-01)
489 reads
PBM Policy / WMI query to see which CPUs are in power-saving mode
A simple PBM policy which uses WMI to find out if the CPUs in the target are running at their maximum clock speed.
2017-06-06 (first published: 2011-01-14)
2,098 reads
2017-06-05 (first published: 2016-08-15)
955 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Purpose of the Rice Purity Test
The main purpose of the Rice Purity Test is entertainment and self reflection. Many...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers