• 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/02/12

February 3, 2012 by John Sansom 4 Comments

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.

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

SQL Server Linkscoffee

  • Hey App, quit wasting my time sorting your data  – Every once in a while it’s good to have a bit of rant. Sprinkle it with a smidgen of humour, like Rob Sullivan(Blog|Twitter) and your definitely on to a winner. Preach on brother!
  • Bad Habits to Kick : Thinking a WHILE loop isn’t a CURSOR – The man just keeps informing us of our wrong doing but for our own good of course. Here’s Aaron Bertrand (Blog|Twitter).
  • SQL SERVER TABLE COLUMNS UNDER THE HOOD – I have a confession to make, I missed an awesome post for the roundup from some time ago. I know right! A fascinating look at some database engine internals from Remus Rusanu (Blog|Twitter).
  • What IP are you listening on SQL – Sure there are a lot of ways you can do this but how would you get it done across a large number of instances? Using a little PowerShell magic of course. Here with the fairy dust it’s Amit Banerjee (Blog|Twitter).
  • A Temporary Configuration – Continuing the crusade for automation and sharing a script for us to play this week it’s Mike Fal (Blog|Twitter).
  • Execution Plans, What Do I Look At? – Given the man has written a number of publications on the subject this is information gold. Grant Fritchey (Blog|Twitter) sharing how he gets the job done.
  • Removing Duplicate Dimension Rows in SSIS– Wandering into new territory but with confidence and flair, this week
    Michael J. Swart (Blog|Twitter) gives us some SSIS goodness.
  • The SQLRAP Wrap Up – Sharing his experiences of using this Premier Support service it’s Mitchell Bottel (Blog|Twitter). I was not even aware that this service existed, interesting stuff!
  • If you weren’t a DBA, what would you like to do? – A brilliant question from Brad McGehee (Blog|Twitter). I would naturally have been a worldclass sportsman, maybe darts? What would you like to do?
  • Management Studio tricks you may or may not know about – This week I’m loving keyboard shortcuts, and there’s some great ones down in the Misc Technology posts section below. Back to SQL right now though, here’s the CSS SQL Server Engineers (Blog) with some SSMS tricks for you.

UK SQL Server Upcoming Events

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

  • Facebook unveils $5bn stock market flotation plans
  • The One Button Mystique
  • The Web is the new Terminal: Are you using the Web’s Keyboard Shortcuts and Hotkeys?

Have you read a post this week that you think deserves a mention? Be sure to let me and other readers know by leaving a comment. You can also reach me on email and find me on Twitter(@JohnSansom).

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
  • 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