• 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

(SFTW) SQL Server Links 15/11/13

November 15, 2013 by John Sansom Leave a Comment

It’s Something For The Weekend(SFTW) time, I hope you’ve had a great week!

Time to start looking toward your training opportunities for next year folks. UK chaps, I’ll see you in Exeter in March. For more details regarding the event and to register click the image below.

sqlsat269 Exeter

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

SQL Server Links

  • Yes Virginia, SANs Can Fail – After a brief hiatus Mike Walsh (Blog|Twitter) is back on outstanding blogging form. Good to have you back sir.
  • Cloud – the forecast is improving – Rob Farley (Blog|Twitter) discusses how evolving Cloud technology is offering hybrid solutions that may open up the possibility of use to those with reservations.
  • What You Can (and Can’t) Do With Filtered Indexes – Sharing a quick overview of this SQL Server Indexing feature, it’s Jes Borland (Blog|Twitter).
  • SQL Saturday Exeter–What’s the Point? My Experience of 2013 SQLSatExeter – Rob Sewell (Blog|Twitter) on community, professional development and why you should get more involved.
  • Cargo Cult Data Professionals– Thought provoking stuff from this week with Grant Fritchey (Blog|Twitter). Do you/your team need a reality check? Make sure to read on through to the comments chaps for insightful community discussion.
  • Are I/O latencies killing your performance? – Paul Randal (Blog|Twitter) explains some methods for investigating and reducing high tempdb and transaction log I/O latencies.
  • Compare tables to find missing rows – Sharing a T-SQL walkthrough this week, it’s Jen McCown (Blog|Twitter).
  • How to Winterize Your Database – Brent Ozar (Blog|Twitter) shares his approach for winding down your databases toward decommission.
  • Why is log_reuse_wait_desc saying LOG_BACKUP after doing a log backup? – Sharing a further reason for why you might encounter this wait type, it’s Paul Randal (Blog|Twitter).
  • Filtered Indexes and Dynamic SQL – A novel “tweak” shared courtesy of Jeremiah Peschka (Blog|Twitter) for addressing a stored procedure limitation when it comes to using Filtered Indexes.

Misc. Technology Posts from Around the Web

  • Parsing Microsoft’s Massive 42% Gain In 2013 – TechCrunch
  • Advice for the Wannabe (International) Road Warrior – Allan Hirt
  • How d’ya make a JP Morgan banker cry? Ask him questions on Twitter – TheRegister
  • Chatting With Mr Snapchat – BBC News Technology

Have you read a great post or article that others might enjoy? We’d all love to know about it so please feel free to share it in the comments and on Twitter(@SQLBrit).

If you enjoyed this weeks round-up of SQL content the best way to show your support is by sharing it.

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