I hope you’ve had a great week! To get the weekend off to an even better start, you’ll be delighted to here that this weeks SFTW post is a Double Edition!
Some of you despaired that there was was no link post last week. Before you ask no I was not slacking and instead was busy having far too much fun at SQLBits 7. As I’m a nice guy (ask anyone, seriously just ask, go on do it), to make it up to you dear reader, this weeks round-up is a double bill and is jam packed full of even more SQL awesome sauce.
So without further ado here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Being A Good Customer – We’re all customers at some point right, but do you know what makes a good customer? Although not a pure SQL Server topic, experienced DBA Thomas Larock discusses some great points we should all consider.
- A Small Selection of SQL Azure System Queries – How to find out what your data transfer rate and therefore cost is, courtesy of SQL Server MVP Glenn Berry.
- Windows Power Plans and CPU Performance – Do you know what Power Plans your servers are currently using? Do you even know why you should care? Then read on to ensure your servers are performing to their potential.
- How to Tell if Execution Plans are Reused – The ScaryDBA reveals all…
- Parameter Name Size And Performance – Do you know the answer, are you absolutely certain? Find out how the size of your SQL Server parameters can effect your performance.
- SQL SERVER – Find Total Number of Transaction on Interval -Another handy T-SQL query here from Pinal Dave.
- How to Prove a Fact (Again) – If like me, you too are always right ;-) then be sure to check out this post from Jen McCown that stirred up some passionate debate.
- Can Deadlocks be Resolved by Adding an Index? – A really good post here from David Levy, providing a detailed walk-through by example.
- SQL Server Database Maintenance Checklist – Anyone that has had the pleasure of working with me knows that I love a good check-list, I just hate writing the dam things and that’s why I love it when Brad McGehee does the work for me! Brad is an incredibly knowledgeable DBA, who I was actually fortunate enough to meet at SQLBits 7.
- SQL 2008 sp 2 – partitioning changes – Some interesting developments with Partitioning.
- Index Operations Showdown: Drop & Create vs. Create With Drop_Existing vs. Rebuild – Performance analysis in action from Kendal Van Dyke.
- How Do I Spot Identity Columns That Are About to Max Out? – Very useful T-SQL query. I know DBA’s and customers that have been caught out by this. Do you know when your identity columns will max out?
- Recent Webcasts on Parallel Processing Available for Download – SQL Guru Adam Mechanic has put together some FREE Webcasts on Parallel Processing. If you like these then just imagine how awesome his Post-Con is going to be at PASS.
- Programmatically picking apart foreign-key constraints – Back from his extended vacation (I’m still wondering when I’ll get one of those ;-)), Paul Randal shares this handy T-SQL snippet.
- Query performance and plan cache issues when parameter length not specified correctly – An interesting customer case, brought to you by the clever chaps in the Microsoft Customer Service and Support (CSS) SQL Support team. Dang that’s a mouthful.
- Hosting the Performance Dashboard Reports in SSRS – If you’re not aware of just how awesome the SQL Server 2005 Performance Dashboard Reports are then you have been missing a trick! So how cool would it be to be able to use them on SQL Server 2008 and host them from a Reporting Server Instance. Pretty dam cool, check it out!
- Which Azure Cloud Storage Model Should I Choose for my Application? – Continuing the trend of posting brilliant SQL Azure focused content, ladies and gentlemen I give you Buck Woody.
- SQL SERVER – Simple Explanation of Data Type Precedence – I’m sure if you’d made it this far in the weekly SQL Server Link round-up then your head is probably about to explode from all the great content but if you still want more, check out Pinal Dave’s post.
UK SQL Server Upcoming Events
UK SQL Server Usergroups
- Leeds – 27th October – User group evening with Martin Bell and SQL Server and Virtualisation with Mike Kiersey.
- Manchester – 28th October – SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008.
- Leeds – Wed 8 Dec – User group evening with Tony Rogerson and Neil Hambly explores indexed views and computed columns.
- MANCHESTER – Thu 9 Dec – User group evening – Agenda to be confirmed.
- EDINBURGH – Thu 9 Dec – SQL Server Internals (Tony Rogerson); SQL Server 2008 R2 :: a X factor for DBA’s life (Satya Jayanty)
- LEEDS – Wed 19 Jan – User group evening with Chris Burns and the Resource Govenor and Policy Based Management with Chris Testa-O’Neill
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).
Oh and be sure to keep an eye out on the Blog for SQL Server Crossword #3 coming soon……