• 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 25/06/10

June 25, 2010 by John Sansom 4 Comments

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

  • Benchmarking: do multiple data files make a difference? – Some very interesting performance benchmarking data here from Paul Randal.
  • Hyperlinks to T-SQL Code – I’m not even sure what Brad is on about half the time but his posts contain pretty T-SQL so here you go.
  • SQL SERVER – TRANSACTION, DML and Schema Locks – A tricky interview question here.
  • SQL Server Operating System Checklist – Shared for the benefit of all, courtesy of Brad McGehee.
  • SQL Server Hardware Checklist – The same as above but for hardware of course.
  • How To Stay Current with SQL Server Cumulative Updates – Interesting that this post was shared by Glenn Berry this week, as I have just been debating whether or not to apply a Cumulative Update to SQL Server 2005 Sp3 after recently encountering a Database Mirroring bug. Get the low down on Cumulative updates here.
  • Vote for the Exceptional DBA of the Year – Be sure to have your say on who wins this prestigious award. What I really want to know is how many of the contenders nominated themselves for the award :-)
  • Smashing a DMV Myth: session_id > 50 == User Process – Another myth dispelled as Adam Machanic reveals all.
  • SSMS : Which parts do you love? Which parts do you hate? – Love them or hate them, every feature in SSMS has a purpose right.
  • Lock Pages in Memory – How can you tell if this setting has been enabled? Gethyn Ellis discusses. Oh and Gethyn in case you had not noticed, I’m the “SQL Server DBA in the UK”, stealing my tagline dude now that’s just low ;-)

SQL Server Upcoming Events

  • 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

  • iPhone 4: Perfect for everyone, except humans – You see the thing about mobile phones is that you kinda need to be able to hold them in order to use them.
  • Unlimited data deals on mobiles wither away – No more unlimited data usage on UK mobiles. iPhone 4 anyone?

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