Determine if BACKUP COMPRESSION is available
This script will determine the SQL Server version and edition in order to find out if BACKUP COMPRESSION is available.
2014-04-02 (first published: 2013-09-10)
916 reads
Scripts
Get the all user and their server role
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,570 reads
2014-03-31 (first published: 2014-03-03)
1,242 reads
DBCC,Backup, Verify and create Agent Job to restore
Script to Automatically Backup, Drop and create Agent Job to restore from that backup.
2014-03-25 (first published: 2014-03-03)
1,071 reads
Using Seqence Container instead of Identity
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,354 reads
Script to Check the Database Backup duration
Script to Check the Database Backup duration of entire instances
2014-03-19 (first published: 2014-02-25)
2,136 reads
Script to Get the Database Restore history
Script to get the Database restore history details including with the files by which the database is restored.
2014-03-17 (first published: 2014-02-25)
1,312 reads
Script to Get the Backup History
Script to get the database backup history on SQL Server 2000/2005/2008
2014-03-14 (first published: 2014-02-25)
1,540 reads
2014-03-13 (first published: 2014-02-25)
1,108 reads
Calendar Table by Year
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
2,131 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