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
- Benchmarking: do multiple data files make a difference? – Some very interesting performance benchmarking data here from Paul Randal.
- Hyperlinks to T-SQL Code – I’m not even sure what Brad is on about half the time but his posts contain pretty T-SQL so here you go.
- SQL SERVER – TRANSACTION, DML and Schema Locks – A tricky interview question here.
- SQL Server Operating System Checklist – Shared for the benefit of all, courtesy of Brad McGehee.
- SQL Server Hardware Checklist – The same as above but for hardware of course.
- How To Stay Current with SQL Server Cumulative Updates – Interesting that this post was shared by Glenn Berry this week, as I have just been debating whether or not to apply a Cumulative Update to SQL Server 2005 Sp3 after recently encountering a Database Mirroring bug. Get the low down on Cumulative updates here.
- Vote for the Exceptional DBA of the Year – Be sure to have your say on who wins this prestigious award. What I really want to know is how many of the contenders nominated themselves for the award :-)
- Smashing a DMV Myth: session_id > 50 == User Process – Another myth dispelled as Adam Machanic reveals all.
- SSMS : Which parts do you love? Which parts do you hate? – Love them or hate them, every feature in SSMS has a purpose right.
- Lock Pages in Memory – How can you tell if this setting has been enabled? Gethyn Ellis discusses. Oh and Gethyn in case you had not noticed, I’m the “SQL Server DBA in the UK”, stealing my tagline dude now that’s just low ;-)
SQL Server Upcoming Events
- 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
- iPhone 4: Perfect for everyone, except humans – You see the thing about mobile phones is that you kinda need to be able to hold them in order to use them.
- Unlimited data deals on mobiles wither away – No more unlimited data usage on UK mobiles. iPhone 4 anyone?