• 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 for the week 16/05/10

May 16, 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

  • Career Advice for the Novice SQL Server DBA – Take a look at a compilation of the results of a recent survey collated by Brad McGehee.
  • Bug: log file growth broken for multiples of 4GB – An interesting bug here concerning the management of SQL Server Log files with respect to VLF’s.
  • Resolving DTC Related Waits and Tuning Scalability of DTC – A nice technically detailed article about experiences working with the Distributed Transaction Coordinator(DTC).
  • Are non-modified FILESTREAM files excluded from DIFFERENTIAL backups? – Find out how you can find out with this walk-through from Tibor Karaszi.
  • SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup – A good collection of four posts here from Pinal Dave, that cover the often misunderstood query tuning topic of Bookmark Lookups.
  • SQL-U Day Four SSIS Fundamentals : Miscellaneous Components – I’ve been getting my hands dirty with SSIS recently for first time in a long while and during my readings I stumbled across an excellent Blog post series authored by Josef Richberg. The content is detailed and thoroughly well presented. I recommend you taker a look.
  • Conor vs. Anti-Semi-Join Reordering – Interesting performance tuning information regarding the behaviour of the Query Optimizer.
  • What 5 things should SQL Server get rid of? – This is the kick off post from Paul Randal. Responders included:
    • Brent Ozar
    • Mike Walsh
    • Michelle Ufford
    • Jonathan Kehayias
    • Tom LaRock
    • Aaron Bertrand

SQL Server Upcoming Events

  • 24 Hours of PASS 2010 – 19th May, Global.
  • SQLCruise – 2nd August – This will be awesome!
  • Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

Misc Technology News

  • Big leap: Microsoft makes free version of Office, its cash cow

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! 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