• Home
  • Contact

John Sansom

SQL Server DBA Blog

  • About
    • The Blog
    • John Sansom
    • Contact
  • Ebook
  • Archives
    • Start Here
    • Popular Posts
    • All Posts
    • SFTW
  • Becoming a DBA
    • What it’s Really Like
    • Interview Tips
    • Certification
    • FAQ
  • Books
  • Resources
    • Blog Tools and Technology
    • UK Events Schedule
    • References & Resource Lists
  • Subscribe

Something for the Weekend – SQL Server Links 02/09/11

September 2, 2011 by John Sansom 1 Comment

I hope you’ve had a great week!

Don’t miss out on your weekly fix of SQL Server Links, community news and technology banter. Subscribe to the Blog Feed now to ensure you catch all posts.   You can also receive posts via Email.

Every DBA needs a vacation (How to Raise Your Game By Doing Nothing) and I’m most certainly no exception to the rule. In the not too distant future I will be taking my leave of you for a short while, meaning there will be no weekly post for you to enjoy. Fear not however, for I shall of course return.

As is often the case in life, with misfortune also comes opportunity for those who are prepared to see it and brave enough to take it. So whilst I’m away I would be delighted for one of you to take the SFTW baton from my hand and play host for a week or two. You might want stick with the existing format or even add your own spin on it. It’s your call and opportunity to shine. Drop me an email if you’re interested.

Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

SQL Server Links

  • Can a SELECT query cause page splits? – Advanced, well at least I think so ;-), query plan investigations from Paul White (Blog|Twitter).
  • Building a Completely Free Playground for SQL Server  – Part 2 of Jonathan Kehayias’s (Blog|Twitter) series on building your very own SQL Server playground. This week looking at setting up your AD and Virtual SAN.
  • Secret New SQL Server Denali Feature: Data Director –  Brent Ozar (Blog|Twitter) is pitching this as potentially the most exciting feature of SQL Server Denali. What do you think?
  • The Dedicated Admin Connection: Why You Want It, When You Need It, and How To Tell Who’s Using It – Every self respecting DBA should know about this, no excuses. Kendra Little (Blog|Twitter) is here to fill you in.
  • SQL Server Hardware Choices Made Easy – Everyone loves a freebie and when the quality is this high who can blame them. Courtesy of the talents and hard work of Glenn Berry (Blog|Twitter), you can get your hands on this excellent knowledge packed ebook absolutely free. Be sure to thank the man himself and provide your feedback/comments via his blog.
  • Stop and checked your Virtual Log Files (VLFs) – I can tell you on good on authority that this really does make a difference when it comes to the performance of your Replication topologies. Here to explain all it’s those clever folks from the Microsoft SQL Server Replication Support Team(Blog).
  • “QUOTED_IDENTIFIER” causes Unexpected Query Plan for Persisted Computed Column query – More performance tuning insights from Microsoft SQLCAT (Blog).
  • How to Prove It’s a SAN Problem Webcast Video – As if you ever needed proof, Brent Ozar (Blog|Twitter) shows you how in this video.
  • Applied SQL: Server Side Traces – It’s been a four day working week here in the UK, so most of us have been scrambling to get things done but if you just can’t get enough SQL Server action and feel the need to flex those brain muscles some more then Jen McCown (Blog|Twitter) has got an assignment for you.
  • Sometimes it’s the little things… – Ah the jokes we could have with this post tittle at the expense of Mr Rob Farley (Blog|Twitter), too easy I say. Instead check out the new features in SQL Server Management Studio (Denali) that he kindly highlights for us.
  • Indexing for Deletes – Is your indexing strategy all about read performance? You may be missing out on performance improvement opportunities as Jeremiah Peschka (Blog|Twitter) explains.

UK SQL Server Upcoming Events

  • SOUTHAMPTON – Wed 7 Sep – Simon Sabin (MCMMVP) and Jessica Meats presenting at the Southampton User Group.
  • LONDON – Sep 12 – 14 – Advanced SQL Server Troubleshooting Workshop
  • SQLBits 9 –  Thur 29 Sep – 1 Oct – The UKs largest SQL Server event heads to Liverpool.
  • SQLRelay – Mon 3 Oct – Thur 6 Oct – 13 SQL Server Events taking place across 4 days throughout the whole of the UK.
Use the SQL Server Event Calendar to keep informed of all upcoming SQL Server events, User Groups, and training opportunities here in the UK. You can also add this calendar alongside you existing Google calendar.

Misc Technology Posts

  • Are You Willing To Relocate?
  • Germany lifts Doom sales ban after 17 years
  • FT pulls app over customer data dispute with Apple
  • ‘Black swans’ busting IT budgets

Even More SQL Server Stuff

What’s that you say, you still hunger for even more SQL Server goodness? Check out my most Popular Posts area, where you can see what other readers have enjoyed reading as well as my personal favourites.

That’s it for this week. If you’ve read a post this week that you think deserves a mention be sure to let me and other readers know by using comments section below. You can also reach me on email and find me on Twitter(@JohnSansom).

Did you enjoy reading this weeks post? The best way you can show your support is by clicking the Like and/or Google Plus 1 button at the top of this post. It spreads the word helping our SQL community grow and shows you care :-)

Have a great weekend!

Filed Under: Link Posts, SQL Server Community

About John Sansom

I’m a Microsoft Certified Master(MCM) of SQL Server. I’ve been working with database technology in a variety of flavors for over fifteen years. I absolutely love what I do and genuinely feel privileged to be a part of our tremendous technology community. Got a question about SQL Server or being a DBA? Ask me!

Popular Articles

  • Top 10 Free SQL Server Tools
  • Performing fast SQL Server delete operations
  • How to identify the most costly SQL Server queries using DMV’s
  • Top 10 Junior DBA Interview Tips
  • The Database Administrator’s Primary Responsibility
  • Your Road to Becoming a DBA: Laying a Strong Foundation
  • Top 5 SQL Forums
  • Script SQL Server Agent Jobs Using PowerShell
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

Categories

  • Administration (38)
  • Blogging (8)
  • Customer Service (5)
  • Disaster Recovery (5)
  • DMVs (4)
  • Index Optimisation (6)
  • Interviews (1)
  • Link Posts (243)
  • Memory (2)
  • Performance Tuning (15)
  • Professional Development (70)
  • Reporting Services (5)
  • Reviews (1)
  • SQL Server Community (144)
  • SQL Server Tips (11)
  • SQLServerCentral Syndication (112)
  • SQLServerPedia Syndication (116)
  • Tools (7)

Copyright © 2022 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy