Archives: December 2010
This is a subject I have written about a couple of times before, here and in much more depth here. Much more recently, fellow SQL Server MVP Brent Ozar (blog| twitter) has also blogged about this subject. I thought I would show you how to… Read more
There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction Processing (OLTP) and the second being Decision Support (DSS)/Data Warehouse (DW). OLTP workloads are characterized by numerous, short transactions, where the data is much more volatile than in a DSS/DW…
Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the transaction log should be sized and maintained, I run into many databases that have a high number of virtual log files inside the transaction log file.
Even though I have… Read more
If you are in the market to buy or build a new laptop or desktop computer, you might want to wait a few weeks, for several reasons. First, Intel is going to formally roll out the brand new Sandy Bridge family of processors at the Consumer Electronics Show on January… Read more
Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday, but the “View and request hotfix downloads” link was broken until earlier today. I waited to blog about it until you could actually request it.
I have… Read more
Redgate Software has released a useful free tool called SQL Server Scripts Manager. I was happy to be included as one of the nine authors of the included scripts. It is always nice to get a free tool that does something useful.
This is how Redgate describes the tool: Read more
Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 5 (CU5), which is Build 1753. I count 40 separate fixes in this Cumulative Update, with quite a few SSAS fixes.
Last Friday afternoon (December 17, 2010), Microsoft released the final RTM build of Service Pack 4 (SP4) for SQL Server 2005. This is scheduled to be the last Service Pack for SQL Server 2005, which is not that surprising, since SQL Server 2005 is a little over five years old… Read more
One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working to finish my first solo book, SQL Server Hardware, which is due to be published in February 2011 by Simple Talk Publishing. You can read the blurb on their… Read more
I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse is that I have been working on finishing my book for Redgate Publishing.
Here is the December 2010 version of my SQL Server 2008 Diagnostic Information Queries. I have… Read more
I will be giving a presentation and demo to the PASS Database Administration Virtual Chapter on Wednesday, December 8 2010 at Noon, Mountain Time. I will be giving my Dr. DMV presentation, and here is the abstract:
Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance…