2011-06-13 (first published: 2008-04-19)
5,847 reads
Scripts
SQL DBAdmin toolbox - Part 1: Restore single database
A stored procedure for restoring a database up to the latest log backup from a file folder. Compatible with the backups made by standard SQL maintenance plan.
2011-06-10 (first published: 2011-05-27)
1,576 reads
Mask PII data (Personally Identifiable Information)
When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.
2011-06-09 (first published: 2011-05-25)
1,454 reads
Numero de Registros y espacio usado en disco
Generacion de numero de registros y espacio usado en disco todas las tablas de la base de datos
2011-06-08 (first published: 2008-06-24)
535 reads
SQL Server 2005 Remove Dups - CTE
Easily remove duplicate records without temp tables by using a CTE.
2011-06-07 (first published: 2008-03-19)
6,932 reads
2011-06-03 (first published: 2008-08-18)
1,087 reads
2011-06-02 (first published: 2008-04-24)
9,282 reads
2011-06-01 (first published: 2007-09-02)
10,474 reads
Point in time restore to a new DB from files of a Full Recovery Model
Script generator to restore to a new DB. Designed on Ola Hallengren's backup solution.
2011-05-31 (first published: 2011-05-20)
960 reads
2011-05-30 (first published: 2011-05-23)
2,416 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