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)
3,843 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)
807 reads
Blogs
ANSI_WARNINGS = OFF can break update statements with some SQL features
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors...
Forums
Extract date from String
Folks: I have to extract the date from this string which is between files_...
Detereming Trends in SSAS Cube
I have Analysis Services cubes with over 200 dimensions in them (product requirement believe...
SSDT server setup and using 3rd party tools across servers
Hello, We are a small shop and want to run, for data warehousing/reporting, 2016...
Ask SSC