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

January 20, 2012 by John Sansom 2 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.

Several weeks into January already then and it’s great to see that the SQL community is clearly back into the swing of things following the holidays, delivering a large variety of SQL content for your weekend reading pleasure. Forget SOPA, this week we’ve got PASS scandal, High Availability discussions, Lying DBAs, T-SQL Tips, XML Tricks, Query Plan insights and much more….

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

SQL Server Links

  • Is Your DBA Lying To You? – If you’re not sure, then yes. If you’re convinced their not then they clearly are. Thomas Larock (Blog|Twitter) here with the truth of it.
  • Availability, Data Locality, and Peer-to-Peer Replication – Architectural discussions from Jeremiah Peschka (Blog|Twitter).
  • SQL Server Interview Questions and Answers – Book Review – Here with his review of the latest book offering from Pinal Dave (Blog|Twitter), it’s  Brent Ozar (Blog|Twitter).
  • Including Missing Values in Data Ranges Without a Lookup Table – Why use the “stock answer” when there might be a better way. Robert L. Davis(Blog|Twitter) here with a T-SQL/reporting tip.
  • Dynamic Seeks and Hidden Implicit Conversions – Query Plan Internals and insights from Paul White (Blog|Twitter).
  • Let’s Get Recursive! – An excellent T-SQL walk-through of CTEs, courtesy of Matt Velic (Blog|Twitter).
  • Great SQL Server Debates: Buffer Cache Hit Ratio – In this excellent article over on Simple-Talk, Jonathan Kehayias (Blog|Twitter) explains exactly why the Buffer Cache Hit Ratio metric is just not as useful as you think it is.
  • Excluding nodes from XML data before returning from SQL Server – A handy coding tip from Adrian Hills (Blog|Twitter).
  • Is the problem with PASS, the community? – A fresh perspective on the matter then from Simon Sabin (Blog|Twitter).
  • Conor vs. SQL Azure Resource Usage – Learn how you can gain more insight into your SQLAzure solutions resource utilization from Connor Cunningham (Blog).
  • Backups and Disk Space – Are you accounting for all the storage that you really need for those database backups? Erin Stellato (Blog|Twitter) with an important reminder.
  • Does filing bugs on Microsoft Connect for SQL Server work? – A lot of community folks submit their bugs and feature suggestions for the product via Connect but just how effective is it? Sharing his thoughts, Jonathan Kehayias (Blog|Twitter).

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

  • Apple launches three-pronged education assault
  • Defeating SOPA and PIPA Isn’t Enough
  • Google revenues worse than expected
  • Wikipedia joins blackout protest at US anti-piracy moves
  • Microsoft quarterly profits fall slightly

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