Skip to content
Software and Booz
  • About
  • Speaking

SQL Server

Thoughts and experiences with SQL Server over 15 years.

Long-Running Query Alerts With sp_WhoIsActive

October 19, 2017October 17, 2017 by Ryan

Who doesn’t love sp_WhoIsActive? Nearly every single DBA talk I have attended in the last two years mentions as a “must have!” I do the same during my DBA Newbie talk at SQL Saturdays. About 18 months ago I came across this post by Tara Kizer and started logging activity every 30 seconds on most … Read more

Categories Monitoring, SQL Server Tags Long-Running Queries, sp_WhoIsActive 4 Comments

What? All of the constraints are disabled? (T-SQL Tuesday #88)

March 14, 2017 by Ryan

T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. And although this is only the second actual post of this blog (fret ye not, there’s more on the way), I’m delighted to finally be participating more in the SQL community that has helped me … Read more

Categories SQL Server Tags #tSQL2sday 2 Comments

Tuning a large, legacy SQL Server DB – A Journal

March 13, 2017March 13, 2017 by Ryan

The Backstory As noted in the About page, I’ve worked at EnergyCAP for over 12 years (as of this post).  We’re a leader in our industry… and have been for more than 35 years.  But with any long-term history comes long-term technical debt, especially when not handled well team-to-team, year-to-year.  For us one of the major … Read more

Categories SQL Server Tags SQL Server, Tuning Leave a comment
Newer posts
← Previous Page1 Page2 Page3

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Follow Me

  • Twitter
  • LinkedIn

Recent Posts

  • PostgreSQL for the SQL Server DBA: Transaction Isolation and Table Bloat
  • Save the Date! PostgreSQL at the 2023 PASS Data Community Summit
  • In Defense of PostgreSQL MVCC and Vacuuming
  • PostgreSQL for the SQL Server DBA: The First Four Settings to Check
  • Triggers: A Love/Hate Relationship

Categories

  • .NET
  • Advent of Code
  • AWS
  • Community
  • Developer Relations
  • DevOps
  • Monitoring
  • Open Source
  • PASS Summit
  • PGSQLPhriday
  • Pluralsight
  • PostgreSQL
  • PostgreSQL Patch of Interest
  • Power BI
  • Power Query
  • Speaking
  • SQL Server
  • Uncategorized
  • Wordpress
© 2023 Software and Booz • Built with GeneratePress
 

Loading Comments...