Monthly Archives: November 2012

Staging Deployments

Posted on November 30, 2012 by

Software development can be a complicated dance. Most of us do not work for a software vendor and don’t have the strict requirements for our deployments when we control the client systems. That doesn’t mean it’s easier for us, especially … Continue reading →

Posted in Editorial | Tagged | 2 Comments

SQL Server Thumbnail Metrics – OS Memory

Posted on November 29, 2012 by

I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to run a SQL Server. This is a series of posts that I’m making to gather these metrics up for easy … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Don’t Explain Too Much

Posted on November 29, 2012 by

I was reading a note recently from a DBA working at a software company. Their management wanted to ensure clients had a simple backup solution and were leaning towards Windows OS backup instead of SQL Server backups. They were planning … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Regulators, Mount Up

Posted on November 28, 2012 by

I have an encryption talk that I give and usually find a few people in the audience that have implemented encryption. In almost every case this has been because of PCI or HIPAA regulations that dramatically reduce penalties if data is encrypted. … Continue reading →

Posted in Editorial | Tagged , ,

The Last DBCC CHECKDB Date and Restores

Posted on November 28, 2012 by

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

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

How Application Roles Work in SQL Server

Posted on November 26, 2012 by

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

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 ,

Locking Your Disk

Posted on November 23, 2012 by

This editorial was originally published on Feb 28, 2008. It is being re-run as Steve is on holiday. With the tremendous growth in disk sizes and the trend towards more and more people using laptops, someone sent me a note … Continue reading →

Posted in Editorial | Tagged ,

Happy Thanksgiving

Posted on November 22, 2012 by

It’s Thanksgiving in the US and I’m in the mountains of Colorado enjoying the holiday while skiing with my family. Hopefully many of you are having a quiet day if you’re at work, or enjoying the day off if it’s … Continue reading →

Posted in Editorial | Tagged ,