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!

• 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

Misc Technology Posts