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,310 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
10,679 reads
Blogs
Using Write-Debug
By Steve Jones
I wrote a post about PoSh output recently, noting that in general we ought...
T-SQL Tuesday Retrospective #002: A Puzzling Situation
For the second T-SQL Tuesday ever — again, hosted by Adam Machanic — we...
Daily Coping 28 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Index question
We have some indexes we have changed over the last few years to address...
Getting the top unique value by group
Alright, so I've been banging my head against the wall for a bit on...
Ask SSC