2014-01-30 (first published: 2012-10-07)
2,173 reads
Scripts
2014-01-28 (first published: 2013-01-16)
2,268 reads
2014-01-21 (first published: 2013-12-28)
2,251 reads
2014-01-17 (first published: 2014-01-03)
1,779 reads
TEMPDB Configuration per vCPU
A simple script for automation of additional secondary data files of tempdb.
2014-01-14 (first published: 2013-12-27)
2,410 reads
To check the full backup duration of an SQL Instance
This script will check the full backup time taken by all the databases of an SQL Server instance.
2014-01-13 (first published: 2014-01-07)
1,368 reads
To check the Backup Status for an SQL Instance
This Script will fetch database backup information from msdb and give the idea about full, diffrential and log backup.
2014-01-10 (first published: 2014-01-04)
1,408 reads
Total Space Used for all databases per disk
Tells you how much the databases are using the space on disk taking in account the free space at the end of the database.
2014-01-08 (first published: 2012-05-04)
3,977 reads
View Active Session SQL
This script can be used to view current SQL statements being executed for all or any one SPID.
2014-01-06 (first published: 2012-01-26)
4,310 reads
Advanced Display Table and Column Info
A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.
2014-01-03 (first published: 2013-12-10)
1,730 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