• 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 02/07/10

July 2, 2010 by John Sansom Leave a Comment

I hope you’ve had a great week!

Make sure you don’t miss out on posts by Subscribing to the Blog Feed. You can also receive this Blog feed via Email.

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

SQL Server Links

  • SQL Server Instance Checklist – Following on from his posts last week, Brad McGehee shares his SQL Server Instance Checklist this week.
  • Coomunity Communication – A non-technical post here from Thom LaRock providing a philosophical look at what is it that makes the SQL Server Community so dam awesome, whilst other I.T disciplines struggle.
  • Brent Ozar to team up with SQLSkills.com – The Blogging and SQL Community legend that is Brent Ozar is to team up with Paul Randal and Kimberly Tripp of SQLSkills.com.
  • Brent Ozar joining SQLskills.com – Here is what Paul Randal had to say on Brent joining the team.
  • Does a missing data file send a database suspect? – Think you know the answer? Gail Shaw reveals all.
  • Merge Replication Capacity Planning – Excellent list of resources here. If you work with SQL Server Replication and have not subscribed to this Blog you are missing out on a fantastic resource.
  • The Windows Page File and SQL Server – Buck Woody sets the record straight.
  • How SQL Server 2005/2008 Replication resumes interrupted snapshot delivery – Now this is cool. I was not even aware it was a feature!
  • Revisiting ISNULL, COALESCE, and the Perils of Micro-Optimization – Which do you prefer? Do you even care? Adam Machanic has better things to do with his time.
  • Using Indexed Views to Replace Triggers – An interesting look at a practical implementation of Indexed Views from Jeremiah Peschka.
  • Conor vs. Join Algorithms – An interesting look at some of the database engine mechanics behind specific join algorithms.
  • Validating sql query programmatically – What appears to be a nice bug find here, identified by AdaTheDev.

SQL Server Upcoming Events

  • SQLCruise – 2nd August – This will be awesome!
  • SQL Usergroup in Kent – 18th August – This is a new SQL Server Usergroup.
  • SQLBits 7 – 30th September – 2nd October – The Seven Wonders of SQL.
  • Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

Misc Technology News

  • VoltDB Decapitates Six SQL Urban Myths and Delivers Internet Scale OLTP in the Process – Is this the end for RDBMS’s as we know it?
  • Google enters travel market with flight data purchase – Is there no stopping Google’s world domination?

That’s it for this week. If I’ve missed anything that you think deserves a mention this week then be sure to let me know! Leave a comment below, send me an email or message me on Twitter(@JohnSansom).

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