Forcing Execution Plan
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
2,407 reads
Harsh Mishra
Send SMS from SQL Server
We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...
2014-03-31
1,503 reads
Merge outputs of perfmon and profiler to get a great view
There is a way by which we can merge the .trc and .blg files to get a great view as...
2013-10-17 (first published: 2013-10-09)
5,911 reads
SQL Server Statistics
INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....
2013-09-29
3,138 reads
Blogs
Containers: Working With Volumes
In the previous two posts on containers I showed how use Docker commands to...
Speaking at PASS Summit 2019
I am delighted to announce that I have been selected to speak at the...
High Security Prices–Always Encrypted 2019 needs Datacenter Edition
By Steve Jones
I was recently doing some work on Always Encrypted in SQL Server 2019 and...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Query help on Pivoting on two columns
DECLARE @RegionCounts Table ( TYear char(2), Region varchar(30), RowCnt int ) Insert into @RegionCounts...
Response to Bloor article on SQL Provision
I found the article https://www.sqlservercentral.com/articles/bloor-scores-sql-provision-4-5-out-of-5-for-test-data-provisioning Interesting if a little shallow. It would be more...
Ask SSC