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)
531 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,140 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,271 reads
2016-07-18 (first published: 2016-06-28)
658 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)
3,129 reads
2016-07-05 (first published: 2016-05-26)
4,890 reads
2016-07-04 (first published: 2016-06-08)
882 reads
2016-07-01 (first published: 2016-05-24)
659 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)
795 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,946 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Forums
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers