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,269 reads
Chad Feghali
Read-Only Routing for Non-Microsoft Clients
An alternative read-only routing technique for non-Microsoft clients.
2015-12-28
2,501 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,184 reads
Blogs
Daily Coping 2 Feb 2023
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Why Managed Identities are Awesome
For the first workdays of this new year, I had the pleasurable task of...
Forums
Dimensional table and Stored Procedure
To meet these requirements below, I came up with this SQL. Please evaluate my...
Anderson-Darling Calculation
Hi I am following an article posted on sql server central on the...
Use of an NCI - that does not contain the Column required.
Hello. I am a bit confused and not sure what terms to use to...
Ask SSC