Dynamic Management Views: Changes in SQL Server 2014

SQL Server 2014 has a number of new DMVs, and some changes from SQL Server 2012. What are the new views and changes, and how can be useful to you?

Never give up

When facing a problem you aren't sure you can solve, keep working on it and believe in yourself.

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).