• 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 26/07/13

July 26, 2013 by John Sansom Leave a Comment

It’s SFTW Time, I hope you’ve had a great week!

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

SQL Server Links

  • Marble Coffee cake and Coffee...

    Marble Coffee cake and Coffee…

    Many Masters, One Truth – “It’s the application requirements that dictate the database platform, not the database platform that dictates application features.” – Jeremiah Peschka (Blog|Twitter)

  • How to Find ‘Secret Columns’ in Nonclustered Indexes – Your Nonclustered Indexes are hiding something from you. Kendra Little (Blog|Twitter) reveals all.
  • SQL Server 2012 Extended Events Add-in to Manage 2008/R2 Instances – Now you can access the power of Extended Events that little bit easier, thanks to Jonathan Kehayias (Blog|Twitter).
  • SQL Server 2012 partitioned table statistics update behavior change when rebuilding index – Be mindful of this behavioral change highlighted by the CSS SQL Server Engineers (Blog).
  • Updated Availability Group Demonstrator – Sharing the latest version of his excellent testing tool for Availability Groups, it’s Jonathan Kehayias (Blog|Twitter).
  • How to Move a Database That Has Database Snapshots – An alternative approach to solving this problem, courtesy of David Browne (Blog).
  • Blocking Is Not Bad – A reminder from Denny Cherry (Blog|Twitter) that all the bad press blocking receives just might be misplaced. It happens for a reason after-all.
  • Windows Azure SQL Database Strategies – A straight talking look at WASD. What you need to ensure you’ve covered off and understood to ensure a successful experience, courtesy of Thomas Larock (Blog|Twitter).
  • Temp table caching improvement for table valued parameters in SQL Server 2012 – Teachings from the CSS SQL Server Engineers (Blog).
  • Indexes Supporting Foreign Keys – You always want to put Indexes on Foreign Key columns right? David Browne (Blog) discusses.

Misc. Technology Posts

  • The Rule of Three – CodingHorror
  • Amazon scraps free delivery on some purchases under £10 – BBC News Technology
  • Google launches Chromecast low-cost TV dongle – BBC News Technolog

Have you enjoyed a blog post this week that deserves a mention? Share it in the comments and on Twitter(@SQLBrit).

If you enjoyed this weeks round-up of SQL content please show your support by sharing it. Click a share option at the top of the on site post.

Thanks for reading and have a great weekend!

Filed Under: Link Posts

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