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)
989 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)
811 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,187 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,426 reads
2017-07-24 (first published: 2017-07-12)
637 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,949 reads
2017-07-18 (first published: 2015-10-16)
1,763 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)
498 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,108 reads
2017-06-05 (first published: 2016-08-15)
956 reads
Blogs
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
How AgentDBA Identifies Backup Failures
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Forums
ALAMAT BCA KCU PURI INDAH Telp:08218154393
WA:08218154393 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk 02, RT.3/RW.2,...
ALAMAT KONTAK BCA KCP Santa Telp:08218154393
WA:08218154393 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Have you done a Mid year check in?
Comments posted to this topic are about the item Have you done a Mid...
Question of the Day
Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers