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

January 27, 2012 by John Sansom 3 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 Links

  • Bad Habits to Kick : Using AS instead of = for column aliases – Are you guilty of this bad habit? Maybe you don’t even consider it to be a bad habit? Here’s Aaron Bertrand (Blog|Twitter) with his thoughts.
  • The 5 DBA Interview Questions You Have to Ask – Getting straight down to business, Thomas Larock (Blog|Twitter) tells you what you need to be asking to hire your next DBA.
  • Statistics and Recompilations – A really good piece of writing and a not so well known gem of knowledge here from Erin Stellato (Blog|Twitter).
  • Monitoring – Where to start? – Taking it to the next level, Service Level that is, it’s Mike Fal (Blog|Twitter) showing how you can lay the ground work for professional quality monitoring for your customers.
  • How It Works: sys.dm_tran_session_transactions – DMV internals insight from the CSS SQL Server Engineers (Blog).
  • DBAs and the Career-Life Balance – Striking the balance but how, asks Brad McGehee (Blog|Twitter).
  • How It Works: sys.dm_io_pending_io_requests – More DMV internals insights from the CSS SQL Server Engineers (Blog)
  • Understanding Database Choice – Adorning the consultant hat this week it’s Brent Ozar (Blog|Twitter), explaining why it is so important to consider the bigger picture in order to understand what’s really being asked.
  • Rebuild Your Indexes Online (When You Can) – Introduction? None required reader! More high calibre content from Michael J. Swart (Blog|Twitter).
  • Ten reasons to attend SQLBits X – That is apart from the opportunity to meet yours truly of course ;-) Here’s
    Simon Sabin (Blog|Twitter) with the details.

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

  • Twitter to selectively ‘censor’ tweets by country
  • Galaxy drives up profits for Samsung
  • Miracle material graphene can distil booze, says study

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