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)
913 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,569 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,069 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,353 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,133 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,310 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,537 reads
2014-03-13 (first published: 2014-02-25)
1,106 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,110 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers