It’s SFTW Time, I hope you’ve had a great week!
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy.
SQL Server Links
“Performance problems all scone”
- DBCC WRITEPAGE: an introduction – Essential reading here from Paul Randal (Blog|Twitter). Have fun
breakinglearning things. - The Fastest Query is the One You Never Make – This post from Brent Ozar (Blog|Twitter) is worth a visit for game changing graphic alone, never-mind the great content.
- HOW SAFE IS YOUR DATA FROM THEFT? – A history lesson couple with some great advice from Thomas Larock (Blog|Twitter), imploring you to get off your ass and check your security is up to scratch.
- DBAs and the Dark Closet – Grant Fritchey (Blog|Twitter) on coming out of the closet.
- Incorrect Results with Indexed Views – If you use MERGE, indexed views and foreign keys, your queries can return incorrect results. Paul White (Blog|Twitter) with the lowdown.
- Building a Larger Capacity SQL Server 2012 Workstation – Because bigger is better, it’s Glenn Berry (Blog|Twitter).
- WHERE to JOIN? – Getting a bit nostalgic on us this week it’s Mike Fal (Blog|Twitter), looking at join performance based on positioning within query syntax. Also an interesting look at an online SQL comparison tool.
- How Does the Cloud Change a Database Administrator’s Job? – More career wisdom from Mr Buck Woody (Blog|Twitter).
- Don’t change value of that parameter – A parameter sniffing case with a difference from the CSS SQL Server Engineers (Blog).
- “UPSERT” Race Condition With MERGE – An insightful look at the the locking behaviour of the MERGE statement from Dan Guzman (Blog|Twitter).
SQLBrit Community Forum
These are some of the discussions going on right now in the SQLBrit Community Forum
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
- Why you need a home lab to keep your job – TheRegister
- Apple sued as activist demands it share out more cash – BBC News Technology
- In pictures: The household gadgets of yesterday – BBC News Technology
- LibreOffice 4.0 ships with new features, better looks – TheRegister
What was your favourite post? Read a blog this week that you think deserves a mention? Share your thoughts in the comments and find me on Twitter(@SQLBrit).
Make sure you don’t miss this weekly round-up of SQL Server Links, community news and technology banter by Subscribing to the Blog Feed.
Get SFTW posts delivered direct to your Inbox free via Email.
