Rollback and Recovery Troubleshooting; Challenges and Strategies

What happens if your database deployment goes awry? Grant Fritchey has some troubleshooting advice to get you out of a bind.

Cloud Skills

The cloud is going to be important for the future of SQL Server.

Creating Memory-Optimized Table in SQL Server 2014

A quick introduction of how to create memory-optimized tables in SQL Server 2014

DBAs and the Fear Factor

Louis Davidson on why DBAs ought to do one thing, every day, that is scary.

Finding Unused SQL Server Stored Procedures With PowerShell

Tim Smith describes a number of ways to tell which Stored Procedures are in use, DMVs, a SQL Server Trace, and his preferred method, the Source Code and PowerShell.

SQLServerCentral.com 2014 Users Survey

We want to make sure we're covering the things that are relevant to you, so we're asking for some feedback on what you use on SSC, where we need to improve, and what you'd like to see.

It should only take a few minutes, and three randomly-selected people will win a $50 Amazon gift card for their efforts.

July 4, 2014

A holiday in the US and Steve is briefly writing something on his sabbatical.

Granular or Cell Level Encryption in SQL Server

Arshad Ali demonstrates granular level encryption in detail and explains how it differs from Transparent Data Encryption (TDE).

Do Other Departments Know What You Do?

Do other departments know what you do? One on one discussions is a great way to make sure.

Dynamic Management Views: Changes in SQL Server 2012

There were many new DMVs added in SQL Server 2012, and some that have changed since SQL Server 2008 R2. This is a brief overview of the biggest changes and what they mean to you!