• 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 27/05/11

May 27, 2011 by John Sansom Leave a Comment

I hope you’ve had a great week!

You can make sure you don’t miss out on future posts right now by Subscribing to the Blog Feed. You can also receive posts via Email.

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

SQL Server Links

  • The most important consulting skill is… effective communication – Being one of the most renowned SQL consulting outfits there is, these folks would certainly know. This week Paul Randal (Blog|Twitter) shares with us the most important consulting skill.
  • PowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition – A handy tip/script here from Rob Farley (Blog|Twitter).
  • SQL Azure Query Tuning – Taking a look at the subset of DMVs that ARE available for us to use in SQLAzure it’s, Grant Fritchey (Blog|Twitter).
  • Sweet Charlotte! – The big news last week was that the PASS Summit will be moving. Here PASS Board member Thomas Larock (Blog|Twitter) discusses some of the reasoning behind the decision.
  • Pliant Technology, Enterprise Flash Drives For Your SQL Server: Part 1 – If you’re interested in storage hardware performance, let’s face it who isn’t, then you will want to check out this post from Wes Brown (Blog|Twitter).
  • SQL Server Filegroup Piecemeal Restores – It’s been a while since Jes Borland (Blog|Twitter) has featured on SFTW, this week giving us an excellent technical walkthrough.
  • I Think You’re Exceptional. No, Really. – A motivation piece here from Brent Ozar (Blog|Twitter), encouraging you to take part in this years Exceptional DBA Awards.
  • Understanding Non-Uniform Memory Access/Architectures (NUMA) – High quality technical content as always from Jonathan Kehayias (Blog|Twitter), good stuff!
  • Benchmarking: Multiple data files on SSDs (plus the latest Fusion-io driver) – More storage goodness from Paul Randal (Blog|Twitter) with some very interesting results reported. You don’t want to miss this.
  • Covering Index because it’s Covering up the truth? – Closer inspection of query plans is on the agenda this week from Rob Farley (Blog|Twitter). It’s without a doubt very interesting reading but I can’t help but wonder about the of real world application given the contrived examples. What do you think?
  • Pssdiag/Sqldiag Configuration Manager released to codeplex – This tool from the CSS SQL Server Engineers (Blog) has the potential to be very useful indeed! I’ve yet to play with it so I’d be very interested to hear about how you get on.
  • New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO – A new Whitepaper is available this week and shared via Robert L. Davis(Blog|Twitter).

UK SQL Server Upcoming Events

New This Week: Advanced SQL Server Troubleshooting Workshop in Central London: September 12 – 14. In this 3 intensive days workshop Klaus Aschenbrenner shows you the right tools and gives you the knowledge to resolve advanced performance and troubleshooting scenarios

  • LONDON – Tue 7 Jun – An evening with the SQL Server Leadership Team
  • SOUTHAMPTON – Wed 8 Jun – User group evening of TBA
  • MANCHESTER – Wed 15 Jun – Andrew Fryer from Microsoft and Allan Mitchell
  • LONDON – Thu Jun 16 – Tony Rogerson (MVP) and Neil Hambly (Wait Stats) + Guest presenter – Topics to be updated shortly
  • LEEDS – Thu 16 Jun – UG meeting with Andrew Fryer from Microsoft and Allan Mitchell
  • LONDON – Mon 20 Jun – Multi Day Seminar – SQLskills Immersion Event on Internals and Performance – 5 day event 20th June – 25th June
  • EDINBURGH – Thu 23 Jun – Scottish Area User Group Meeting
  • LONDON – Fri 15 Jul – SQL in the City

Misc Technology Posts

  • PayPal sues Google over mobile wallet technology
  • Billionaire Zuckerberg kills to eat
  • Aurasma: Augmented reality future or forgettable fun?

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).

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
  • SQL Server Memory Configuration, Determining MemToLeave Settings
  • Script SQL Server Agent Jobs Using PowerShell
  • 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 © 2023 · Santech Solutions Limited · Powered by the Genesis Framework · Privacy Policy