• 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 02/12/11

December 2, 2011 by John Sansom Leave a 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.

Interested to know which blog posts other readers have enjoyed the most? Check out My Popular Posts page which lists your favourites alongside mine. I’m often surprised by which posts generate the most traffic. Posts that I thought were literary and informational masterpieces(OK maybe not but they did seem to have potential) turned out not to be so, like the apparently not top 10 worthy The Best Database Administrators Automate Everything or the thought piece Outstanding DBAs Make Relationships a Priority. Conversely posts like My Guide to Passing MCTS Exam 70-432 proved immediate hits.

My daily commute to the office this week has been productive, knowledge packed and highly enjoyable, courtesy of those very nice folks over at Manning Publishing. I was delighted to have received a copy of the new title SQL Server MVP Deep Dives Volume 2 and I will be sharing my thoughts on the book in full with you in an upcoming post. Subscribe to the blog feed to make sure you catch it.

Will you be in town next Thursday evening? Why not join myself and other SQL server community folks for a festive tipple (or two) at the London SQL Server User Group’s Pre-Christmas get together.

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

SQL Server Links

  • Determining distribution of NULL values – A handy T-SQL tip from Aaron Bertrand (Blog|Twitter).
  • Geek City: Growing Rows with Snapshot Isolation – An interesting look at the internal effect of enabling this isolation level from Kalen Delaney (Blog|Twitter).
  • Stored Procedures with SSRS? Hmm… not so much – Having a whine about sanitization(not sanitation) this week it’s Rob Farley (Blog|Twitter).
  • Using CNAMEs with clustered file share resources – Clustering master class as Denny Cherry (Blog|Twitter) shares more tips.
  • Free Clustering & HA Training for Hyper-V & Private Cloud – Sounds like it has the potential to be very interesting indeed. Let me know if you attend!
  • SQL Fingertips – Sharing a wholse assortment of tips this week, it’s Michael J. Swart (Blog|Twitter).
  • SQL Server First Responders Kit Video – Being a DBA on the front lines of production support means you need to know your tools(I’ve worked with a few ;-)). This week Kendra Little (Blog|Twitter) shares how she manages a crisis.
  • When learning database design, be careful where you learn from – Sage advice from Denny Cherry (Blog|Twitter) on why just because something works in your shop, that does not make it good design.
  • Writing New Hash Functions for SQL Server – Performance tuning gold this week from Thomas Kejser of Microsoft SQLCAT (Blog).
  • 3 SQL Server Book Review Short Takes – Harsh but fair? I’ll let you decide. Brent Ozar (Blog|Twitter) with his thoughts then.
  • Hadoop Basics for SQL Server DBAs – An excellent introduction to this technology, courtesy of Jeremiah Peschka (Blog|Twitter). This post has uncanny timing as I’m just starting to get my hands dirty with this in my current shop. Maybe a follow up video on administration advice and performance tuning is on the cards?
  • A Computed Column Defined with a User-Defined Function Might Impact Query Performance – Microsoft SQLCAT (Blog)
  • Enabling Kerberos Authentication for Reporting Services – A little something for the BI DBA perhaps? A an excellent walk though then courtesy of Rob Carrol(Blog).

UK SQL Server Upcoming Events

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

  • Five Absolutely Essential Utilities that make Windows better
  • GCHQ challenges codebreakers via social networks
  • Assange: ‘iPhone, Blackberry, Gmail users – you’re all screwed’
  • UK faces connected-home challenge to overcome confusion

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