Something for the Weekend – SQL Server Links 10/12/10

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.

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.

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