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,087 reads
Chad Feghali
Read-Only Routing for Non-Microsoft Clients
An alternative read-only routing technique for non-Microsoft clients.
2015-12-28
2,428 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,178 reads
Blogs
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Seeding an Availability Group Replica from Snapshot
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
Microsoft Build event announcements
By James Serra
There were a number of data platform announcements at Microsoft Build yesterday that I...
Forums
Account logging - pwd change/db access change
Is there a way to continuously log account changes? For SQL accounts log for...
Starting on Monday
Comments posted to this topic are about the item Starting on Monday
Charindex values of a substring inside a long sentence
I need to gather the starting position of the keyword "sql" from a sql...
Ask SSC