I hope you’ve had a great week.
One point that deserves a special mention this week is that there will be a Service Pack 4 for SQL Server 2005 following on from much debate and pressure from the SQL Server Community. For full details of the service pack release schedule see the Microsoft SQLReleaseServices Blog.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- MCM Prep Week: Interview with Joe Sack – Facinating interview courtesy of Brent Ozar. Have you got what it takes to be a Microsoft Certified Master?
- Native Restore From Litespeed Backup – Here’s a great tip from Thomas Larock on how to extract the natural SQL Server Backup file from a Litespeed backup archive.
- Some Initial Insert Test Benchmarks on SQL Server 2008 R2 – Detailed performance testing walk through here, learn how the Pro’s do it.
- Round Two of Insert Benchmark Tests – Part 2 of the the above……..
- A Tale Of Two Execution Plans – Solved! – A lesson well worth learning here from Kendal Van Dyke. It’s also great to see how the SQL Server community collaborates on issues together making us all better Data Professionals.
- Top 10 Reasons Why Access Still Doesn’t Rock– Wait a minute, should this not have been a top 100 post? Brent Ozar sets the record straight.
- A Simple Refactoring- Applying the principle of low hanging fruit to performance tuning.
- FREE SQL Server Training – More Free SQL Server Training has come to my attention this week. In the current economic climate, not all employers have budget for training so be sure not to miss out and make the most of these opportunities.
- Pay Attention to Maintenance Cleanup Job Configuration (If you use Maintenance Plans) – Make sure you are not leaving yourself exposed to a Data Loss Event by avoiding this common mistake.
- Mirroring Multiple SQL Server Databases on a Single Instance – Did you know that Microsoft officially only support up to 10 Database Mirroring sessions on a 32 bit installation of SQL Server? Neither did I…….
- Caching SSRS Reports for Performance – A nice walk through here.
- Ad-Hoc Rollup by date/time Interval – A detailed T-SQL Walkthrough here courtesy of Dan Guzman.
- SQL Server Help – Find out how to get SQL Server Help.