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,406 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
14,746 reads
Blogs
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
Forums
Running Trace - Error: Login timeout expired
Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...
query perf issue
Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...
Looking for some guidance on avoiding Scalar UDFs for DB lookups
Hello. I am not a SQL Developer - just an IT generalist (if that)...
Ask SSC