Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout
Your SQL Agent Jobs may be silently failing when using Linked Servers.
2016-05-02
2,708 reads
Chad Feghali
Read-Only Routing for Non-Microsoft Clients
An alternative read-only routing technique for non-Microsoft clients.
2015-12-28
2,633 reads
The Case for Specifying Data Types and Query Performance
Performance penalties for omitting SQL data types when using ADO.Net or light weight ORMs.
2015-06-22
6,229 reads
Blogs
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I...
Master SQL Server Query Tuning in Just Two Days! Online Live Training – June 17 – 18, 2025
I’m excited to announce that on June 17 – 18, 2025, I’ll be running...
Forums
importing from PowerQuery... but with multiple powerqueries
I finally got the PowerQuery source to "show" in SSIS (so I can see...
Third party backup softwares
Hi Team, Can you someone suggest a few good third part backup tools, with...
2022 SSIS PackageFormatVersion?
Recently I upgraded my ssis package from 2016 to 2022, but package format version...
Question of the Day
The Monitor Server
What does the monitor server do in log shipping?
See possible answers