I hope you’ve had a great week!
Do you enjoy reading SFTW? Show your support by clicking the Like and/or Google Plus 1 button at the top of this post. It spreads the word in helping our SQL community grow and shows you care :-)
Perhaps you would like to guest post one week? If this is something that would be of interest to you then let me know!
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- ACID Properties By Example (And Counterexample) Part Four: Durable - Here’s the finale to Michael J. Swart’s (Blog|Twitter) brilliant blog post series. Good form sir.
- Building a Completely Free Playground for SQL Server - Looking for something to do this Bank Holiday Weekend? Jonathan Kehayias (Blog|Twitter) kicks of a post series on how to configure your very own SQL Server playground. If you don’t have one already, shame on you, every DBA should.
- Expert? Ha! - Living proof that when you think you know it all, you really don’t ;-) it’s Grant Fritchey (Blog|Twitter).
- Even Simple Changes Can Cause Trouble: A Tale of TempDb - A fascinating real world troubleshooting case involving the tempdb and having multiple data files from Kendra Little (Blog|Twitter). It’s not what you might expect.
- A Couple of Data Compression Tricks in SQL Server 2008 - I’ve been implementing data compression for my customers with great success. If you’re not using it already I really do recommend you look into it. Here Glenn Berry (Blog|Twitter) shares a few handy tips for working with this feature.
- T-SQL thoughts about the 95th percentile - Another excellent and insightful post this week from Rob Farley (Blog|Twitter).
- SharePoint in a SQL Server environment - Shocking as may seem, yes people really do use it. Here’s the latest survey results courtesy of Paul Randal (Blog|Twitter).
- Video: How to Use the Denali Windowing Functions - New functionality coming our way in Denali, Jeremiah Peschka (Blog|Twitter) explains all.
- How Many Log Files Should My SQL Server Database Have? - A rhetorical question this week from Thomas Larock (Blog|Twitter), who also shares a handy T-SQL script for you to put to work.
- Using sp_repldone to SKIP a transaction - If you ever have to get your hands dirty with SQL Server Replication this type of knowledge becomes invaluable, brought to you by the Microsoft SQL Server Replication Support Team(Blog).
- Interview with BI Expert Tim Mitchell - This is one of two excellent SQL celebrity interviews this week from Brad McGehee (Blog|Twitter). Be sure to also check out the interview with Grant Fritchey too.
UK SQL Server Upcoming Events
- MANCHESTER - Wed 24 Aug - Replication by Neil Hambly and Cube versus tables with Steve Powell at the Coop
- LEEDS -Thu 25 Aug - XQuery Fundamentals with Neil Hambly
- SOUTHAMPTON - Wed 7 Sep - Simon Sabin (MCMMVP) and Jessica Meats presenting at the Southampton User Group.
- 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.
Misc Technology Posts
- When algorithms control the world
- HP’s UK PC boss: We’re going nowhere
- UK’s atomic clock ‘is world’s most accurate’
- Microsoft unveils file-move changes in Windows 8
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 Bank Holiday weekend!