• 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/04/2010

April 17, 2010 by John Sansom Leave a Comment

I hope you’ve had a great week!

I want to say a big thank you to everyone involved with SQLBits this week. The calibre of speakers and the quality of the presentations delivered was excellent. The highlight for me personally was the opportunity to meet with so many great SQL people and already I cannot wait for the next SQLBits!.

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

SQL Server Links

  • Important things for DBAs to consider – Great list here from Paul Randal, that provides a lot of excellent references to further reading for each consideration.
  • SQL Server 2008 R2 Release Date: May 21 2010 – Some thoughts from Brent Ozar on the upcoming SQL Server 2008 R2 release.
  • A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records – Continuing this excellent post series, Paul Randal dispels yet another myth.
  • A SQL Server DBA myth a day: (12/30) tempdb should always have one data file per processor core – Administrators who design and manage how the tempdb database is configured in SQL Server need to read this! Interestingly this also came up as a heated discussion point at SQLBits this week so clearly there it quite a lot of confusion in the community about this topic.
  • T-SQL Tuesday #005: Focus on Users when Reporting – A reminder here from Michael J Swart about the importance of understanding what the end user wants to achieve from your BI project.
  • The case of the additional indexes – Real life support experiences from the SQL Server CSS team.
  • How to Avoid Some Common Developer and DBA Mistakes – It’s always good to know what NOT to do as well as what you should be doing.
  • Mirroring: what happens if principal loses contact with both mirror and witness? – Tibor Karaszi discusses.

SQL Server Upcoming Events

  • PASS European Conference – 21-23rd April 2010 – Germany
  • 24 Hours of PASS 2010 – 19th May, Global.
  • Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

If there is an upcoming SQL Server event that I’ve not included?

Misc. Technology News

  • Opera iPhone app downloaded a million times in 24 hours
  • Twitter used to predict box office hits
  • Icelandic ash cloud to keep UK skies closed ’til Saturday

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 contact me on Twitter.

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