SQL Toast

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)

13,197 reads

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,949 reads

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)

6,326 reads

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,930 reads

I haven’t done one of these in awhile, but I saw an article recently...

In last months one of the scenarios where you can use AI has been...

Do you spend so long manipulating your data into something vaguely useful that you...

Comments posted to this topic are about the item Fun with JSON

Comments posted to this topic are about the item Creating JSON II

Comments posted to this topic are about the item Engineer Lessons

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON)
GO