I hope you’ve had a great week!
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.
Misc Technology Posts
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 :-)