Something for the Weekend – SQL Server Links for the Week 25/06/10

Jun 25th, 2010

by John Sansom.

I hope you’ve had a great week!

Make sure you don’t miss out on posts by Subscribing to the Blog Feed. You can also receive this Blog feed via Email.

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?

That’s it for this week. If I’ve missed anything that you think deserves a mention this week then be sure to let me know! Send me an email or message me on Twitter(@JohnSansom).

http://blog.gre-sqlserver-solutions.com Gethyn Ellis

John,

I’m the the “The SQL DBA in the UK” which does differ slightly from yours. That said I didn’t know about your blog when I named mine back last year, if I did I may have gone with something else but it is too late now.

Thanks for including my post in your weekly roundup though, much apprecaited.

http://www.johnsansom.com John Sansom

Hey Gethyn, thanks for stopping by! You’ve been posting some really good stuff recently.

You know I’m only messing with you right….I couldn’t care less what you call your blog as long as keep posting great content.

Do me a favour though and give up on the football updates….based on current form Germany are gonna trounce us this weekend…..sort it out Rooney!

http://blog.gre-sqlserver-solutions.com Gethyn Ellis

John, I’m glad you like what I’ve writing its nice to know. Its actually been one of my goals to get into your weekly list so I was well pleased this morning.

I know your only messing, but when I did find your blog I did feel bad about my name… for a little while.

I can’t promise I’ll stop the football updates but for what its worth I England will be fine this weekend… I think its time for the Germans let the left footers and the centre halfs take the penalties and put them into row Z or hit them straight at the keeper. That said I think England should beat them in normal time as long as Rooney gets his game in order, and he looked much better in the last game.
Pingback: Tweets that mention Something for the Weekend – SQL Server Links for the Week 25/06/10 | John Sansom - SQL Server DBA in the UK -- Topsy.com
http://bradsruminations.blogspot.com/ Brad Schulz

Hi John…

Thanks for including my hyperlink blog post in your weekly list.

As for “what Brad is on”, I guess I’m just high on life… and SQL Geekiness. 8^)

Thanks again, and keep up the great work.

–Brad

http://www.johnsansom.com John Sansom

Hey Brad,

My pleasure and I look forward to reading more great content!

John Sansom SQL Server DBA in the UK

Something for the Weekend – SQL Server Links for the Week 25/06/10

SQL Server Links

SQL Server Upcoming Events

Misc Technology News

Search

Categories

Archives