I hope you’ve had a great week!
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
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 a great weekend!