Refreshing Availability Group Database with PowerShell
Following last weeks post on Refreshing A Mirrored Database with PowerShell I thought I would write the script to refresh...
2014-09-04
1,613 reads
SQL DBA With A Beard
Refreshing A SQL Mirrored Database Using Powershell
SQL mirroring is a means of providing high availability for your SQL database. It is available in Standard Edition and...
2014-08-25
1,102 reads
Enable CLR with Powershell
I had an email last night from someone who attended my PowerShell Box of Tricks session at SQL Saturday Exeter
He...
2014-05-05
910 reads
Listing the SQL Server SysAdmins With PowerShell
A very short blog today just to pass on this little script.
I was required to list all of the SysAdmins...
2014-04-14
530 reads
Blogs
Getting Started with the MSSQL AI Agent in VS Code
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
Summer Speaking Summary 2025
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
From Chaos to Clarity: How Microsoft Purview Streamlines Data Governance
By Chris Yates
In today’s digital landscape, data is both a strategic asset and a potential liability....
Forums
Change Tracking Data Retention Options
Comments posted to this topic are about the item Change Tracking Data Retention Options
Requiring Technical Debt Payments
Comments posted to this topic are about the item Requiring Technical Debt Payments
Using the FP-Growth Algorithm to Mine Useful Patterns in Data
Comments posted to this topic are about the item Using the FP-Growth Algorithm to...
Question of the Day
Change Tracking Data Retention Options
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers