• 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 03/12/10

December 3, 2010 by John Sansom 1 Comment

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.

Be sure to reserve your place for the SQLFAQ 2010 Festive Soirée (Buffet & Dance) – Friday 17th December organised by Neil Hambly(@Neil_Hambly) and the SQLFAQ team.

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

SQL Server Links

  • Why You Can’t Trust sysdepends – Sneaky stuff here revealed before your eyes by Thom LaRock.
  • SQL SERVER – Automated Type Conversion using Expressor Studio – An interesting discussion with Pinal Dave revealing his DB Developer side.
  • More considerations for the clustering key – the clustered index debate continues! – Continuing her epic campaign, Kimberly Trip discusses some of the often overlooked internals considerations to Clustered Indexes.
  • SQL Internals Viewer – Here’s a brief look at this cool tool.
  • An XEvent a Day (1/31) – An Overview of Extended Events – Jumping on the “post a day for a month” bandwagon, Jonathan Kehayias tackles the subject of Extended Events. This should be very good!
  • The Top-Five Most Valuable Development Team Positions – Never one to shy away from controversy, Buck Woody clears up just how important a Developer you are in the grand scheme of things.
  • Get Going on Powershell – A excellent resource reference shared here courtesy of Jason Crider.
  • SQL Server 2008 R2 Best Practices Analyzer – Walking us through the BPA it’s Brad McGehee. I was fortunate enough to have the opportunity to meet Brad at SQLBits earlier in the year. Be sure to add his work to your Feed Reader!
  • Using DMVs to Find the Ports that SQL Server is Listening On – A handy little T-SQL snippet here.
  • HOW IT WORKS: IO Affinity Mask – Should I Use It? – Brilliant post from the CSS SQL Server Engineers that clearly discusses this often misunderstood  SQL Server configuration setting.
  • Stop Tuning Your Queries – That’s right Brent Ozar is telling us to stop tuning our queries…. well sort of.

UK SQL Server Upcoming Events

London: SQLFAQ 2010 Festive Soirée (Buffet & Dance)

London: SQLFAQ 2010 Festive Soirée (Buffet & Dance) – Friday 17th December

  • This should be quite simply, brilliant.

UK SQL Server Usergroups

  • LEEDS – Wed 8 Dec – Tony Rogerson and Neil Hambly explores indexed views and computed columns.
  • MANCHESTER – Thu 9 Dec – User group evening – Agenda to be confirmed.
  • EDINBURGH – Thu 9 Dec – SQL Server Internals (Tony Rogerson); SQL Server 2008 R2 :: a X factor for DBA’s life (Satya Jayanty)
  • LEEDS – Wed 19 Jan – Chris Burns and the Resource Governor and Policy Based Management with Chris Testa-O’Neill

Keeping up with PASS – Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

Misc Technology Posts

  • EU launches antitrust probe into alleged Google abuses

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