2013-08-08
5,541 reads
Shashank Srivastava
Orphaned Distribution Transactions
Learn about orphaned distribution transactions in SQL Server and how you can clear them.
2013-07-16
5,555 reads
Change the Maintenance Plan Owner
This article shows how you can change the maintenance plan owner in SQL SERVER
2013-07-02
8,396 reads
How to Change the SQL Server Name after Renaming the Windows Host
This article shows how to change a SQL Server name after changing the Windows machine name.
2013-05-16
55,275 reads
Blogs
Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
Azure chaos STUDIO
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
Announcing a New Book on SQL from 3Cloud Authors
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Forums
Azure DW default schema in a query / proc equal to "Search_Path" in AWS
I know you can't do this in MSSQL, but hoping DW has progressed more....
Call SQL Agent job using different account to one executing powershell
Hi Folks trying the below but having zero luck and was wondering if anybody...
Encrypt Varchar(max) column in SQL Server
I have a varchar(max) column which has sensitive data and want to encrypt it....
Ask SSC