Monthly Archives: November 2012

The Last DBCC CHECKDB Date and Restores

Posted on November 28, 2012 by way0utwest

I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For those of you that don’t know this, you can run this command on your instance (in a database) DBCC DBINFO … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Targeted Learning

Posted on November 27, 2012 by way0utwest

I received an email just after I arrived in Seattle for the last SQL in the City 2012 stop. It was from Simon Doubt, who was also coming to Seattle for the PASS Summit, but who hadn’t planned on just … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Targeted Learning

How Application Roles Work in SQL Server

Posted on November 26, 2012 by way0utwest

One very interesting security technique available in SQL Server is the application role. It’s an interesting way of applying security to a user, and perhaps a way of preventing users from accessing data with unauthorized applications. An application role is … Continue reading →

Posted in Blog | Tagged , | 4 Comments

Review Your Indexing

Posted on November 26, 2012 by way0utwest

In the latest versions of SQL Server, there are some amazing new features. Many of them allow us to expand the capabilities of SQL Server, but some are added to allow us to dive more deeply into how the system … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Review Your Indexing