• 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 30/01/15

January 30, 2015 by John Sansom Leave a Comment

Good reads from around the Web.

Smart Coffee

The best way to make sure you don’t miss a blog post and enjoy these SQL Server links every week is to Subscribe to get them delivered free, direct to you by email.

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

From the SQL Server blogs

  • Making SQL Backups better with #Powershell – Mike Fal (Blog|Twitter)
  • Reporting From Log Shipped Secondary STANDBY mode – Kendra Little (Blog|Twitter)
  • Geek City: Creating New Tools for Statistics – Kalen Delaney (Blog|Twitter)
  • Medians pre-SQL 2012 – Rob Farley (Blog|Twitter)
  • Designing Indexed Views for OLTP Workloads – Michael J. Swart (Blog|Twitter)
  • EAV data model meets Clustered Columnstore  – Tony Rogerson (Blog|Twitter)
  • Are You Getting the Benefits of Virtualization? – Brent Ozar (Blog|Twitter)
  • Am I Alive? SQL Connectivity Checks with #Powershell – Mike Fal (Blog|Twitter)
  • Using Templates With SQL Server Management Studio – Thomas Larock (Blog|Twitter)
  • Optimizing Substring Search Performance in SQL Server – Dmitri Korotkevitch (Blog)
  • Three reasons to use Extended Events – Jes Borland (Blog|Twitter)
  • Random Unexplained Replication Job Failure – Denny Cherry (Blog|Twitter)
  • SQL Windowing Functions: ROWS vs. RANGE – Klaus Aschenbrenner (Blog|Twitter)

SQL Community Conversations

These are some of hot topics being discussed right now in the Forum by ambitious Data Professionals just like you. Join the conversation.

  • Script to find SID mismatches from SQL to Windows – Nice script shared for the solution
  • Favourite DBA Job Interview Questions – Have you asked these/been asked yourself?
  • Get after it – Excellent advice for developing your career as a Data Professional

Other Stuff Worth Reading

  • 5 Essential Elements of an Email That Respects People’s Time
  • The Basics of 3D Printing in 2015
  • Out of control AI will not kill us, believes Microsoft Research chief
  • Facebook says it caused fault that sent services offline

If you have an article/blog post suggestion for inclusion, a question about SQL Server or just want fancy a chat then get in touch. Thanks for reading and have a great weekend.

Like these links posts? Subscribe to get them every week and you’ll also receive a Free copy of my ebook DBA JumpStart. 

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