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

September 9, 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.

Every DBA needs a vacation (How to Raise Your Game By Doing Nothing) and I’m most certainly no exception to the rule. In the not too distant future I will be taking my leave of you for a short while, meaning there will be no weekly post for you to enjoy. Fear not however, for I shall of course return.

As is often the case in life, with misfortune also comes opportunity for those who are prepared to see it and brave enough to take it. So whilst I’m away I would be delighted for one of you to take the SFTW baton from my hand and play host for a week or two. You might want stick with the existing format or even add your own spin on it. It’s your call and opportunity to shine.

I’m delighted to announce that next week UK SQL Server community champion and speaker Neil Hambly(Blog|Twitter) will be your host! I’m really looking forward to seeing what content Neil chooses to share with us and hope that you will make him feel welcome here. There’s one more host slot up for grabs the following week so drop me an email if you’re interested.

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

SQL Server Links

  • Mythbusting: Concurrent Update/Insert Solutions – Busting myths this week with an excellent look at a common programming pattern from Michael J. Swart (Blog|Twitter). Includes source code for you to follow along and experiment with. Can you find alternative successful methods?
  • How Do You Mask Data for Secure Testing? – Brent Ozar (Blog|Twitter) discusses the practice of Data Masking and asks how you go about it for your projects.
  • RIP OLE DB – Dan Guzman (Blog|Twitter) bids farewell to this protocol and offers advice on how to accommodate the change in your development going forward.
  • SQL Server 2008/2008 R2 on Newer Machines with More Than 8 CPUs Presented per NUMA Node May Need Trace Flag 8048 – CSS SQL Server Engineers (Blog) discuss the details.
  • Tips, Tricks and Hints for Using SSIS from A-Z – A new blogger added to the mix for you this week, sharing some best practice SSIS tips from his own experience it’s Rob Symonds(Blog|Twitter).
  • How the Cannot generate SSPI context error was fixed – After a quiet spell Pradeep Adiga (Blog|Twitter) returns with more real world DBA troubleshooting tales.
  • SQL Education – Sharing a useful list of SQL learning resources it’s Jen McCown (Blog|Twitter).
  • September Question: Your DBA interview experiences: good and bad – These community questions are always an interesting read, courtesy of Brad McGehee (Blog|Twitter).
  • The DMV sys.dm_os_memory_clerks May Show What Appears To Be Duplicate Entries – CSS SQL Server Engineers (Blog)
  • From Developer to Administrator – Pondering the roots of the DBA, Chris Shaw(Blog|Twitter) shares his thoughts with us.

UK SQL Server Upcoming Events

  • LONDON – Sep 12 – 14 – Advanced SQL Server Troubleshooting Workshop
  • SQLBits 9 –  Thur 29 Sep – 1 Oct – The UKs largest SQL Server event heads to Liverpool.
  • SQLRelay – Mon 3 Oct – Thur 6 Oct – 13 SQL Server Events taking place across 4 days throughout the whole of the UK.
  • SOUTHAMPTON – Wed 9 Nov -Allan Mitchell and James Rowland-Jones taking over the evening.
  • LEEDS – Wed 23 Nov – Provisional date.
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

  • HTC sues Apple after Google sells tech patents
  • Why modern music sounds rubbish
  • Cutting the Gordian Knot of Web Identity – Very interesting.
  • .XXX web domain registration begins

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