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,158 reads
Chad Feghali
Read-Only Routing for Non-Microsoft Clients
An alternative read-only routing technique for non-Microsoft clients.
2015-12-28
2,452 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,182 reads
Blogs
Daily Coping 28 Sep 2022
By Steve Jones
Today’s coping tip is let go of other people’s expectations of you. I think...
SQL Server In Place Upgrades
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Daily Coping 27 Sep 2022
By Steve Jones
Today’s coping tip is take your time. Make space to just breathe and be...
Forums
SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud
Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...
SQL Master Data Services 2019 - Website keeps prompting for login
I have two SQL 2019 servers running Master Data Services which are continually prompting...
Add more columns to output
$msg = Get-Content 'C:\miscjunk\SQL_Servers.txt' | ForEach-Object {New-Object 'Microsoft.SqlServer.Management.Smo.Server' $_} | Select-Object -Expand Databases |...
Ask SSC