One of my clients is in the process of standardizing all their servers on RAID 10. We discovered one of their smaller servers had been delivered with RAID 5 already configured. I took the opportunity to run some tests on the drives prior to reconfiguring them into RAID 10. My…
I'll be speaking to the St. Louis SQL Server Users Group [http://www.stlssug.org/index.html]on the afternoon of June 12th at the Microsoft offices from 1PM until 4PM. I'll be doing two presentations back to back. The first is What I Wish Developers…
MSDN has one of the better articles I've read on LINQ: The Evolution Of LINQ And Its Impact On The Design Of C# [http://msdn.microsoft.com/msdnmag/issues/07/06/csharp30/default.aspx]. It really helped to see the design history to understand why things are the…
If you're in the Kansas City area tomorrow night I'm going to be doing a presentation on the procedure cache, parameterization and parameter sniffing. Details are on the Kansas City SQL Server User Group [http://www.kcsqlserverusersgroup.com/] web site. I'm a last minute…
We were having some disk drive performance issues at a client recently. They have a 6 drive array running RAID 10. We spent some time running SQLIO [http://www.microsoft.com/downloads/details.aspx?familyid=9a8b005b-84e4-4f24-8d65-cb53442d9e19&displaylang=en] against the array. Our standard test was an 8KB random read…
Bob Ward finally posted the definitive answer on how to handle SP2 and it's releases and hotfixes [http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx] . I wish the MS KB articles were written like this. Thanks Bob!…
There was a post today in the MVP newsgroups that I needs much broader distribution. Written by James Howey of Microsoft it says: > We recently posted updates to address an issue in two SP2 Maintenance Plan tasks. The KB article describes the symptoms as follows: FIX: The Check Database…
The client I'm at today has the best time for server upgrades. They do all their upgrades from Noon until 1PM on Tuesdays. I think I love them.…
The joy that is SP2 just keeps on giving. Microsoft released a hotfix (KB934458 [http://support.microsoft.com/kb/934458]) to bring it up to 3054: > FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances…
And here is my blog post. And I want more text.!…