Tag Archives: sql server

Enabling Filestream in SQL Server 2012

Posted on March 7, 2012 by way0utwest

Filestream is a cool feature, albeit one that’s cumbersome to use in SQL Server 2008 and R2. However the FileTable feature in SQL Server 2012 builds on Filestream and you must enable this feature for FileTable to work. There is … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

Restoring a Certificate

Posted on March 5, 2012 by way0utwest

I have written about creating a certificate and backing up a certificate, and the next step is the restoration of a certificate into a server instance. This post covers the basics of restoring a certificate. There is no RESTORE CERTIFICATE … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

High Availability Upgrades

Posted on March 2, 2012 by way0utwest

  SQL Server 2012 will be released soon. I have no idea of the exact date, though I suspect a peek at the SQL Server developers’ vacation schedule in Redmond might provide some clue. The announcement last year was a first … Continue reading →

Posted in Editorial | Tagged , | Comments Off on High Availability Upgrades

AdventureWorks in SQL Server 2012 RC0

Posted on February 29, 2012 by way0utwest

The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version here for AdventureWorks. This download gives you an mdf, and that’s it. You can’t directly attach that in SSMS, but … Continue reading →

Posted in Blog | Tagged , | 1 Comment