Tag Archives: sql server

The Platform as Code

Posted on June 6, 2012 by way0utwest

SQL Server has grown more and more complicated over the two decades that I have worked with the product. At the same time anyone can install it and set up a database with almost no training. There are more and … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Platform as Code

Creating a Filetable

Posted on June 5, 2012 by way0utwest

How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable data. Then you just do this: — Create a filetable CREATE TABLE AuthorDrafts AS FileTable GO The only optional part … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Creating a Filetable

Detecting Database Option Changes with DDL Triggers

Posted on May 29, 2012 by way0utwest

One of the keys to managing a large production SQL Server environment is being aware of changes that are taking place in the environment, and preventing potentially harmful changes. There are any number of ways to do this: triggers, auditing, … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Detecting Database Option Changes with DDL Triggers

Always restore with NORECOVERY

Posted on May 24, 2012 by way0utwest

Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option. It’s trivial to switch the database online. Not trivial to recover from an accidental restore with RECOVERY (the default) ‘nuff said.

Posted in Blog | Tagged , , , | 5 Comments