• 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

Something for the Weekend: SQL Server Links this week 21/08/09

August 21, 2009 by John Sansom 1 Comment

I hope you’ve had a great week!

New to SQL Server or just getting started on the road to becoming a DBA? Then you will want to check out the SQL Server Essentials Series.

With the Holiday Season coming to an end it’s time to get the SQL Server Guru Challenge under way. If you have not entered yet then you’re almost out of time. Basically, you have between now and the time I send out the first challenge next week to get your entry in.

Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

SQL Server Links

PASS Virtualization VC: Now Open for Syndication – Brent Ozar has done a cracking job pulling together the Virtualization Chapter of PASS and along with his fantastic team, they are now centralising their content for the benefit of us all. I for one really enjoy this new and rapidly expanding subject area and appreciate the effort that goes into producing such excellent content. Great work chaps!

EXISTS vs IN – Gail Shaw sets the record straight on this matter, walking you through the problem solving process. Includes source code and execution plan screen caps.

Correlate Session State Information With Cached Query Plans – Tim Ford provides this little tip, utilising the SQL Server DMV’s.

Top 10 T-SQL Code Smells – Excellent set of smells to watch out for. This is the first article I have read by the author, Merrill Aldrich and I would certainly be interested in more.

Performance impact: tempdb and update statistics – A nice detailed article here, courtesy of Linchi Shea.

A Unicode Compression example – Those clever chaps from the SQL Server Storage Team walk us through the the Unicode compression capability introduced in SQL Server 2008R2.

Misc Techie Stuff

Free PowerShell E-Book

TechNet webcast on Getting Started in IT Consulting

Tech giants unite against Google – The latest developments in Google’s world domination plan.

My Non-SQL Server Pick of the Week

All Programming is Web Programming – Jeff Atwod (aka Coding Horror) discusses in response to a rant.

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 a tweet on Twitter.

Have a great weekend!

Filed Under: Link Posts, SQL Server Community

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