Monthly Archives: November 2012

Staging Deployments

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

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

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

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

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

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

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

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

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

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 ,