Linked server creation to MySQL Server
Here is a step by step procedure to create a linked server to MySQL from SQL Server.
2014-10-13
3,347 reads
Vinayaka Gangadhar
Monitoring Longest Running Transaction using SQL Server Agent Alerts
Step by Step guide to setup SQL Server Agent Alert for the proactive monitoring of Monitoring of Longest Running Transactions.
2014-09-25
12,105 reads
Blogs
The Diverse Data Platform–Dativerse.io
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Extended Events and Azure SQL Database
Knowledge of how your system behaves is vital to better control, maintain, and grow...
Daily Coping 19 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
upgrade path to SQL 2019
I read the upgrade path for standard edition to SQL server 2019, the oldest...
Help with detecting and sending alerts for lengthy blocking
Over the weekend we had 2 ETL jobs that were causing unresolved blocking with...
Ask SSC