Alert for low identities available
This script alert when a table on a DB has a low number of identities available
2016-07-25 (first published: 2016-07-16)
528 reads
Scripts
Missing Index Script with Create Statement
standard missing index script but has a create statement to copy and past
2016-07-21 (first published: 2016-07-07)
2,133 reads
Capture Linux Drive Space data with Powershell
Capture Linux Drive Space data with Powershell using Posh-SSH module
2016-07-19 (first published: 2016-07-06)
1,251 reads
2016-07-18 (first published: 2016-06-28)
656 reads
Get earliest and latest date values in a database
Query the earliest and latest date values found in all datetime columns in the current database.
2016-07-12 (first published: 2016-06-21)
2,984 reads
2016-07-05 (first published: 2016-05-26)
4,845 reads
2016-07-04 (first published: 2016-06-08)
881 reads
2016-07-01 (first published: 2016-05-24)
654 reads
Getting LEAD and LAG values manually
LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also
2016-06-28 (first published: 2016-05-18)
786 reads
Function for Getting Interval Dates by days,months,years.
Function for Getting Interval Dates by days,months,years for particular week number, for particular month, for particular date between 1 to 31. etc...
All in One Date Interval Related Function.
2016-06-27 (first published: 2015-11-27)
1,938 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers