• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

Soemthing for the Weekend – SQL Server Links 12/02/10

February 13, 2010 by John Sansom Leave a Comment

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.

Misc Technology News

  • First results from Large Hadron Collider published

That’s it for this week. If I’ve missed anything that you think is worth mentioning then be sure to let me know. Fire me an email or Follow me on Twitter.

Filed Under: Link Posts

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy