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

November 4, 2011 by John Sansom 1 Comment

I hope you’ve had a great week!

Don’t miss out on your weekly fix of SQL Server Links, community news and technology banter. Subscribe to the Blog Feed now to ensure you catch all posts. You can also receive posts via Email.

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

SQL Server Links

  • Getting graphical ShowPlans back in SQL Server 2008 R2 – “If it’s not broke then don’t…” oh wait it is. Aaron Bertrand (Blog|Twitter) with the fix.
  • Over and under indexing – how bad is it out there? – Some fantastic community contribution and excellent analysis of the results from Paul Randal (Blog|Twitter). I wonder what you will find out about your environments?
  • Congrats to Lori Brown and her SQL Server and Trace Replay article – With thanks and some pretty diagrams it’s Lee Everest (Blog).
  • How to Estimate Data Utilization – A really interesting perspective provided on how you use your data, courtesy of Michelle Ufford(Blog|Twitter).
  • So You Want To Be Mission Critical? Hire a DBA – Taking no nonsense and telling it like it this week, it’s Allan Hirt (Blog|Twitter).
  • Code to list index counts per table –  Here’s the accompanying code resulting from the earlier post by Paul Randal (Blog|Twitter).
  • Stopping a Series of SQL Agent Jobs – A handy T-SQL snippet from Mike Hilwig (Blog|Twitter).
  • Everybody Needs a Test Harness – We most certainly do and Kevin Kline(Blog|Twitter) shows us how.
  • Are You Approaching Your Partition Range Limits – The second offering this week from Michelle Ufford(Blog|Twitter) with a T-SQL snippet.
  • New SQL Server 2012 Licensing Changes Mean Nothing To Me – You and me both. Thomas Larock (Blog|Twitter) is getting his rant on.
  • The case against INFORMATION_SCHEMA views –  If you’re not already using the Catalog Views, here’s Aaron Bertrand (Blog|Twitter) with why you darn well should be.
  • SQL Tribal Knowledge – Fancy yourself as a SQL Server author but not had the opportunity to make your début? Now’s your chance thanks to Jen McCown (Blog|Twitter).

UK SQL Server Upcoming Events

  • SOUTHAMPTON – Wed 9 Nov -Allan Mitchell and James Rowland-Jones taking over the evening.
  • DUNDEE – Sat 19 Nov – A FREE single-day software development conference.
  • LEEDS – Wed 23 Nov – Cursors are evil, and shouldnt be used with Dave Ballantyne and a session from James Boother.
  • MANCHESTER – Thur 24 Nov – Cursors are evil, and shouldnt be used with Dave Ballantyne and a session from James Boother.
Use the SQL Server Event Calendar to keep informed of all upcoming SQL Server events, User Groups, and training opportunities here in the UK. You can also add this calendar alongside you existing Google calendar.

Misc Technology Posts

  • Groupon share sale raises more than expected
  • Free wi-fi in central London promotion launched
  • Asus Eee Pad Transformer is Stuff’s gadget of the year

That’s it for this week. If you’ve read a post this week that you think deserves a mention be sure to let me and other readers know by using comments section below. You can also reach me on email and find me on Twitter(@JohnSansom).

Have a great weekend!

Did you enjoy this  post? The best way to show your support is by clicking the Like/Google Plus 1 button at the top of the on site post.
It spreads the word helping our SQL community grow and shows you care :-)

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