Tag Archives: sql server

Not So Unbreakable

Posted on December 8, 2011 by way0utwest

There’s a report on Dark Reading that says some researchers think Oracle is not working on security as hard as they should. The proportion of security fixes has diminished, which some people think implies that they are not taking security as seriously … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Not So Unbreakable

Sharing Your Database Server

Posted on December 7, 2011 by way0utwest

Some of the details for SQL Server 2012 are out now, and as expected, we have feature limitations in various editions. I was hoping for a change, and maybe it will come at some point in the future. I did … Continue reading →

Posted in Editorial | Tagged | Comments Off on Sharing Your Database Server

Not having TDE in all editions is stupid

Posted on December 5, 2011 by way0utwest

The whole point of encrypting data at rest is to protect the database if physical files or backups are lost. In the Books Online (BOL) page for Transparent Data Encryption (TDE), it notes that “…, in a scenario where the physical … Continue reading →

Posted in Editorial | Tagged , | 3 Comments

Autogrow guidelines

Posted on December 2, 2011 by way0utwest

I always enable autogrow on my databases. However, it’s there for emergencies, not as a space management tool. I monitor disk space, and I grow my files manually as space runs low. I want to control the growth, but in … Continue reading →

Posted in Blog | Tagged , , | 2 Comments