I hope you’ve had a great week!
Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
- Looking Under the Hood – A very interesting, T-SQL performance tuning post here from Brad Schulz, that highlights how the Query Optimizer behaves when using the coalesc() function and the implications, it would seem of LEFT JOIN ordering.
- SQL Server 2008 and 2008R2 Diagnostic Information Queries – FREE performance review of your server from SQL Server expert Glenn Berry !
- What Service Pack are Your Client Tools At? – I have been caught out by this issue historically too. Make sure that you and your users do not get caught out by following Mike Walsh’s advice.
- A SQL Server DBA myth a day: (26/30) nested transactions are real – If you have not been following this AWESOME blog post series from Paul Randal then you are missing a real treat. The series contains a huge amount of valuable information to you. I wanted to highlight this particular post because I see Developers caught out by this misconception an awful lot.
- Nominations for the 2010 Exceptional DBA Award are Now Open – It’s that time of year again where get to recognise excellence in our profession. Nominations are open now.Thinking of entering yourself? Gail Shaw was on the judging panel last time around and she offers some good advice for entrants .
- SQL Server Monitoring Checklist – Are all these items included on your Day-To-Day DBA checklist?
- Using CPU-Z to Discover Hardware Information – I’m also a big fan of this utility. As a DBA it’s important that you know and understand as much information about the hardware used in your environment.
- Recap of April 2010 DMV a Day Series – This blog post series from Glenn Berry has been awesome and is an excellent way to develop an improved understanding of work with SQL Server DMV’s. Check out this summary of all the posts in the series.
- Check Out These Tools – SQL University – A great list of SQL Server Tools here collated by Mike Walsh.
- Benchmarking: Introducing SSDs (Part 1: not overloaded log file array) – Very interesting post here from Paul Randal looking at using SSDs for SQL Server. As a DBA it’s important you keep up to speed on the latest hardware technology and we are going to be seeing more and more about SSD drives in the coming months.
- Follow-up to Questions from Europe PASS 2010…. – Some very interesting items here from the CSS SQL Server Engineeers Team including How To Remove Statistics Left Behind by the Database Tuning Advisor.
SQL Server Upcoming Events
- 24 Hours of PASS 2010 – 19th May, Global.
- SQLCruise – 2nd August – This will be awesome!
- Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.
Misc Technology News
- Microsoft’s Internet Explorer losing browser share – So what else is new right?
- Spring 2010 Hardware Recommendations – Great summary of what’s currently hot in terms of both retail consumer hardware and database loadouts.