Monthly Archives: January 2012

Capacity planning for new hardware

Posted on January 9, 2012 by way0utwest

I get asked this question a lot: When getting a new application and database, what kind of hardware do I need? The answer is easy: it depends. It depends on the load you will put on the SQL Server instance. … Continue reading →

Posted in Blog | Tagged , | Comments Off on Capacity planning for new hardware

Read-only Data

Posted on January 6, 2012 by way0utwest

We keep gathering, storing, and managing more and more data. Many of our systems could use an archiving plan to migrate older data to another database or system where it can be accessed, but it won’t impact the performance of … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Read-only Data

Creating Strong Passwords

Posted on January 6, 2012 by way0utwest

I was writing a presentation recently on encryption and one of the important things to show in the presentation is the use of strong passwords. Many of the encryption functions will use passwords as an alternate way to secure keys, … Continue reading →

Posted in Blog | Tagged , | 4 Comments

SQL Server 2012 Licensing VMs without SA

Posted on January 5, 2012 by way0utwest

I ran across a blog talking about Microsoft licensing, and found it very interesting. I learned a few things, and it’s a bookmark I’ll keep in mind. A subtle change, one that caught my eye. In SQL Server 2012, if … Continue reading →

Posted in Blog | Tagged , | 1 Comment