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,228 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
8,388 reads
Blogs
Using Erik Darling’s sp_pressure_detector to resolve CPU issues
By DesertDBA
Last Friday I spent my lunch break going through some links I had marked...
How to Resolve Remove-AzKeyVaultKey : Operation returned an invalid status code ‘Forbidden’ Error
I’ve come across another error message in my seemingly never-ending battle with Azure Key...
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2
By Rayis Imayev
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...
Forums
SSIS compoenents
For SSIS to pickup any dll componenet where do we need to deploy? some...
AWS instance storage
We are planning to use one of AWS instance for sql server and wanted...
Insert New Rows in sql based on difference between 2 dates
Hi, I want to create a new records based on the difference between...
Ask SSC