Tag Archives: sql server

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

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

Windows OS Information from SQL Server

Posted on January 3, 2012 by way0utwest

I ran across a thread recently where someone was asking how to get the Windows start time from within SQL Server. Since SQL Server is a process running on the Windows host, I wasn’t sure how one would do this … Continue reading →

Posted in Blog | Tagged , | Comments Off on Windows OS Information from SQL Server