I hope you’ve had a great week!
I know some of you enjoy a little music with your weekly SQL Blog fix. Here’s this weeks DBA Weekend Anthem from Taio Cruz.
“I throw my computer in the air sometimes, saying ahyoo %$£$%% Dev oh”
Got a suggestion for next weeks DBA Weekend Anthem then let me know.
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- T-SQL Tuesday #13 – What the Business Says Is Not What the Business Wants – Here is this months invitation and the topic looks set to stir up some great discussions. Make sure you get involved and share your thoughts!
- Review: Idera SQL Doctor – Giving us his thoughts on the product it’s SQL Server MVP and speaker superstar Grant Fritchey.
- SQL Server Southampton UserGroup – An insiders view from Adrian Hills (@AdaTheDev) of the very first Southampton UserGroup Meeting. Good work all round chaps!
- Microsoft Codename Atlanta Attempts to Help Out DBAs By Providing Basic Assistance – Find out about this new service offering and how it can benefit you and your customers, courtesy of Brad McGehee.
- HEAPs o’ Trouble With Multi-Column JOINs – Back on regular posting form, here’s another great walk-through of a recent client problem scenario and solution, delivered in impressive style by Brad Schulz.
- AlwaysON – HADRON Learning Series – What Is HADRON? – This week the CSS SQL Server Engineers start a series that looks at the new DR/Availability features of SQL Server Denali.
- Tip: Schema Qualify Objects in SPs – Need another dose of awesomesauce this week? Always! Jen McCown, 1 half of the MidnightDBA’s, shares another important tip with us this week and be sure to check out her brilliant interview of Jes Borland(@grrl_geek) too.
- Server is in script upgrade mode. Only administrator can connect at this time – A sneaky little issue here, brought to our attention by Pradeep Adiga, you’ve been warned.
- Insufficient system resources exist to complete the requested service – Although not directly a SQL Server related post, I have seen this issue cause people problems when attempting to move backup files around a corporate domain. Make sure you know what the cause of this issue is and how you can solve it.
- Heaps of Trouble? – This is a follow on to Brad Shulz’s earlier post from Paul White and you simply must check it out if performance tuning is your thing as it provides some very interesting insights into the internal behaviour of the query optimizer.
- Wait statistics, or please tell me where it hurts – The results are in, at last, from Paul Randal‘s latest survey. No more vacations for you sir, unless of course I’m invited.
UK SQL Server Upcoming Events
Don’t forget it’s party time next Friday! What, you’ve not reserved your spot already? No problem, come crash the party and join in the fun anyway! Just don’t tell Neil Hambly I told you.
- London: SQLFAQ 2010 Festive Soirée (Buffet & Dance) – Friday 17th December – This should be quite simply, brilliant.
- LEEDS – Wed 19 Jan – Chris Burns and the Resource Governor and Policy Based Management with Chris Testa-O’Neill
- MANCHESTER – Thu 20 Jan – User Group meeting with Tony Rogerson
Provisional Dates for your Diary
- MANCHESTER – Wed 2 Mar
- LEEDS – Thu 3 Mar
- LEEDS – Wed 11 May
- MANCHESTER – Thu 12 May
- MANCHESTER – Wed 15 Jun
- LEEDS – Thu 16 Jun
- LEEDS – Wed 20 Jul
- MANCHESTER – Thu 21 Jul
Misc Technology Posts
That’s it for this week. What was your favourite post? If I’ve missed anything that you think deserves a mention then be sure to let me know! You can leave your comments below, send me an email and find me on Twitter(@JohnSansom).