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)
757 reads
Stored procedure to ensure CDC job will be started once failover happen.
2017-08-25 (first published: 2017-08-22)
757 reads
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,174 reads
Script database and object level permissions for all database users
2017-07-25 (first published: 2016-02-26)
13,634 reads
2017-07-24 (first published: 2017-07-12)
610 reads
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,868 reads
2017-07-18 (first published: 2015-10-16)
1,735 reads
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)
477 reads
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,055 reads
2017-06-05 (first published: 2016-08-15)
927 reads
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
2,661 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Hi everyone My SSIS package does a bulk insert of csv files into a...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers