- I hope you’ve had a great week!
No prizes (literally) for guessing what the biggest technology news of the week is. Yes it’s all about iPad 2. You can get the low-down on all the latest technology news, that is actually worth knowing about, in the Misc Technology Posts section below. Oh and in case you were wondering it is indeed my Birthday this month, thanks in advance.
This week I was fortunate enough to share a fantastic evening with the folks from the London SQL Server User Group. Neil Hambly (Blog|Twitter) and Dave Ballantyne (Blog|Twitter) were our hosts serving up the SQL content for the evening and both were dishing out performance tuning wisdom like it was going out of fashion with their respective presentations on “XQuery fundamentals” and “re-engineering for faster performance”. In attendance were a good selection of the Twitterati including Gavin Payne (Blog|Twitter) and James Boother (Blog|Twitter) to mention but a few. It was without a doubt a great event and for those of you that could not make it you missed out on a real treat let me tell you. Get in on the fun and make sure you get yourself along to your next local SQL Server User Group event, remember it’s one of your resolutions (Techie Resolutions for You, Not Me) for the year.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Do changes to index keys really do in-place updates? – Detailed technical insight from Paul Randal (Blog|Twitter), just what I like to get the weekend off to a great start!
- Don’t even believe SSMS when you think it’s telling the truth – Very astute observations, important to all performance tuners out there, courtesy of Jonathan Allen (Blog|Twitter).
- Some Suggested SQL Server 2008 R2 Instance Configuration Settings – More fantastic advice from Glenn Bery (Blog|Twitter).
- Didn’t You Hear? – Giving us the inside scoop, well at least what NDA will allow right, it’s Thomas Larock (Blog|Twitter).
- What’s Your SLA? – Well, do you know the answer? As a Database Administrator you need to know this information for your company. Erin Stellato (Blog|Twitter) discusses.
- Database ‘mssqlsystemresource’ cannot be opened due to inaccessible files – Solving more real world DBA problems it’s Pradeep Adiga (Blog|Twitter) showing some excellent initiative.
- I Give Up: What IS an MVP? – Not a technical post as such but definitely one of the better explanations I have read of what exactly is an MVP, from Jen McCown (Blog|Twitter).
- Replication Agent fails with “An error occurred during decryption” – More advanced replication troubleshooting gems from real world customer cases via those super clever chaps in the Microsoft SQL Server Replication Support Team(Blog).
- March Question: What’s Your Biggest SQL Server Performance Headache? – It’s competition time! Brad McGehee (Blog|Twitter) wants you to share your stories for a chance to win. Personally I really enjoy reading the comments about other peoples problems (hmm not sure that came out right but you know what I mean).
- Out of Identity Values – Are There Performance Considerations for Re-seeding? – Jim Mcleod (Blog)
- Reflecting on the MCM Exam Experience – Talking of MCM experiences with his first post over on the SQLskills team blog it’s Jonathan Kehayias (Blog|Twitter). Congratulations once more sir! Just don’t go slacking off on the MSDN forums now champ else who is going to cover my back when I have no clue what’s going (which is all too often :-) ).
- Windows Azure Use Case: High-Performance Computing (HPC) – Showing us all how it’s done Azure style it’s Buck Woody (Blog|Twitter).
- How To: Automate Continuous SQLServer Activity with Stored Procedures and Powershell Jobs – I just LOVE automation, as regular readers will know already and this week Kendra Little (Blog|Twitter) is sharing a real treat with us. Great stuff, who knew automation could be this much fun. I’m off to annoy the Developers now by using this technique to bring their servers to a grinding halt, not that they need my help of course.
UK SQL Server Upcoming Events
- SOUTHAMPTON – Wed 9 Mar – Gavin Payne speaking on different replication services SQL Server offers, primary and secondary design goals of each and considerations for deployment and in-life management.
- BIRMINGHAM – Thur 10 Mar – Allan Mitchell and Neil Hambly – Covering StreamInsight (Complex event Processing and Event Stream Processing) and an introduction to Service Broker
- CARDIFF – Thur 24 Mar – Cardiff User Group with RedGate SQL Monitor, Alex Whittles on using SSRS, DMVs & spatial data to visualise SSAS cube structures, also Chalk and Talk on HA/DR/Scaling with Tony Rogerson
- EDINGBURGH – Thur 31 Mar – Scottish Area User Group Meeting – April
- SOUTHAMPTON – Wed 13 April – User group evening of Neil Hambly.
- SQLBits 8 – 7th – 9th April – Europe’s biggest SQL Server event will be at he seaside this time around. Only a few place remain now
- LEEDS – Wed 11 May – Leeds UG meeting – Resource Govenor and Policy Based Management with Chris Testa-O’Neill
- SOUTHAMPTON – Wed 11 May – User group evening of TBA.
- MANCHESTER – Thu 12 May – Planning for Stored Procedures with Munsoor Negyal and another speaker- Thursday night meeting at BSS
- SOUTHAMPTON – Wed 8 Jun – User group evening of TBA.
Misc Technology Posts
- iPad 2 tablet launched by Apple’s Steve Job
- iPad 2? Let’s be kind and call it iPad 1.5
- PS3 imports banned in patent row
That’s it for this week. What was your favourite post?