Custom Maintenance Plans - the T-SQL way
The non-SSIS/GUI method I use to deploy standardized Database Maintenance Plans.
2013-05-16 (first published: 2009-05-07)
4,080 reads
Mark Marinovic
Runaway Job Management
Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.
2009-09-25 (first published: 2009-09-15)
849 reads
Blogs
My Toolbox - Greenshot
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
Daily Coping 11 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using DBCC CLONEDATABASE to create a schema only copy of your database.
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s...
Forums
Does cloud computing require a lot of coding?
I have brushed up on my scripting languages, but want to know what sort...
How to get number of occurrences in varbinary datatype?
I have a table with varbinary datatype (file stream enabled) column which store pdf...
MS SQL Server licensing questions.
I inherited a fairly large system with a couple dozen servers (1/4 physical, the...
Ask SSC