Convert Mirroring to Log Shipping
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
2010-08-19
5,788 reads
Jeremy Egbert
Repair Corruption Using the Mirror Database in SQL 2005
Explanation of how to repair a database in SQL 2005 Enterprise which is mirrored.
2010-05-10
4,266 reads
Script to Compress Tables and Indexes
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
9,231 reads
Blogs
Fixing the PoSh Hotkey in ADS
By Steve Jones
I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...
Capture Execution Plans Only For Long Running Queries
I love questions. Most of all, I love questions I can answer. I spotted...
Daily Coping 28 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Simple Python question...
I have a table in SQL Server like this: CREATE TABLE #SymptomData ( ...
Regular expressions in script component
In one of our SSIS package we have a script component that validate a...
SSRS - Filtering data in a report
I have a dataset (Name, Product A Installed, Product B Installed, Product 3 Installed,...
Ask SSC