First Responder Kit

A lot of people would think we’re crazy for releasing a FRK update a few days before a new version of SQL Server drops, but we’ve been adding 2017 compatible features for months Also none of you are on 2017 Most of you won’t live to be on 2017 If you’re lucky, your kids3000 will…

First Responder Kit Release: Fully Hand Automated

August 31, 2017

Did you know there are more issues closed in this FRK than there are planets in this solar system? Special thanks to Pluto for making that statement possible, and all the other planets that didn’t form. Also thanks to @mches for making the FIRST EVER contribution to sp_foreachdb, and @rabryst for hooking us up with some Linux Love in…

First Responder Kit Release: Yukon Ho!

August 1, 2017

We’re going to Alaska this month, so try not to find any bugs, okay? To celebrate, I’m channeling childhood nostalgia, and quoting a verse from one of my many Taco-Bell-dripping-stained Calvin and Hobbes tomes. We’ll never have to clean a plate, Of veggie goops and goos Messily we’ll masticate, Using any fork we choose! When…

sp_BlitzCache: Eventual Compatibility With Azure

July 18, 2017

Execution Plans, Microsoft Azure, sp_BlitzCache

azure, dba, development, performance tuning, sp_BlitzCache

Better than nothing Yesterday it was announced that global temp tables were available in public preview for Azure. That means that unmodified versions of sp_BlitzCache (which uses a global temp table to hold a whole bunch of information) will be compatible up there. This is a nice addition for Azure, and an even nicer addition…

Introducing sp_AllNightLog: Log Shipping at Scale, Open Source

June 29, 2017

Brent Ozar

Backup and Recovery, First Responder Kit, kCura Relativity

faux paas

In our Faux PaaS project, we need a backup plan – or rather, a restore plan. On each SQL Server instance, clients can create as many databases as they want, anytime they want, with no human intervention. We need those databases covered by disaster recovery as quickly as practical. SQL Server’s newer disaster recovery options – Always On Availability Groups and…

First Responder Kit Release: Weather Is Here, Wish You Were Wonderful

June 28, 2017

ONE TWO THREE FOUR FIVE SIX SEVEN WHO DO WE APPRECIATE? No one. Appreciate doesn’t rhyme with seven. Special thanks to @JohnKNess, @jsetliffe, @rabryst, @gdoddsy and @SOlsonFAC for various levels of contribution. I’ve made a $10,000 donation in each of your names to the Erik Darling Home For Little Wanderers. Very thoughtful of me. You…

Introducing sp_BlitzQueryStore

June 6, 2017

Execution Plans, First Responder Kit, Query Store (QDS), sp_BlitzQueryStore

Oh, so you’re the one While SQL Server 2016 adoption is still pretty low, and 2017 still quite isn’t out yet, that’s no reason to not invest a few days of dev time into a stored procedure that is only usable by the smallest portion of SQL Server users. Right? Look, someone around here has…

First Responder Kit Release: Now With 50% MORE Double Checking

June 3, 2017

So many things happen in mid-Summer. Dreams. Death. Pit stains. And FRK updates! Special thanks to @digitalohm for once again taking the axe to sp_DatabaseRestore. You are the only person on our email list who isn’t getting a Box O’ Tripe® You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #872 @MosesOfJ pointed out that,…

Announcing sp_BlitzBackups: Check Yourself Before You Wreck Yourself.

May 30, 2017

Brent Ozar

If one of your SQL Servers went down at some point over the last week: What’s the most data you could have lost? What’s the longest you would have been down for? To find out, Erik and I (mostly Erik) wrote sp_BlitzBackups (sure, blame me for everything. –ED). Download the latest First Responder Kit including the…

First Responder Kit Re-Release: The Hubris Of Titles

May 2, 2017

The Gods of the Copy Book Headings Frowned Upon Me So yesterday, I pushed out a new FRK. You could say I FRKed up, and you’d be right. Not so much See, before I push stuff to master, I do a round of testing in our AWS lab to find version-specific bugs and make sure…

First Responder Kit Release: Ça plane pour moi

May 1, 2017

Ah, May. Spring has sprung, and young people’s minds turn towards seasonal allergies. Special thanks to @digitalohm for the Differential Restore code and general sp_DatabaseRestore spiffiness. May you live to an age that can only be described in Unix. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #857 Do you have any idea how much…

First Responder Kit Release: Now With 100% More Working Code Than The Irish Space Program

April 7, 2017

Every April I think about this girl I grew up with named April who smelled like Cheez-Wiz. She died tragically in a home for the blind on Taco Tuesday. Special thanks to @jeffrosenberg , @mrthomsmith , @rwhoward for contributing this month. Your complimentary oxygen is now available. The rest of you can go download the First…

sp_BlitzCache Tip: Cutting Through Heavy Dynamic SQL Use

March 17, 2017

First Responder Kit, sp_BlitzCache, T-SQL

dba, development, performance tuning, sp_BlitzCache, sql server

It keeps me up at night Out of the box, sp_BlitzCache will give you enough stuff to work on in your server’s plan cache to last a month of leap days. This is great for most people, but if you use a ton of dynamic SQL in stored procedures, it can make things difficult. What’s…

sp_DatabaseRestore: Open Source Database Restore Stored Procedure

March 7, 2017

Tara Kizer

Backup and Recovery, First Responder Kit

Welcome to the sp_DatabaseRestore documentation page. We were looking for a script that restores a database including the transaction log chain using the backup files in a folder. We also wanted it to be able to continue applying transaction log backups. In other words, we were looking for a custom Log Shipping solution. We could…

Crappy Missing Index Requests

February 21, 2017

Execution Plans, Indexing, sp_BlitzIndex

dba, development, performance tuning, sql server

When you’re tuning queries It’s sort of a relief when the first time you get your hands on it, you get the plan and there’s a missing index request. Even if it’s not a super high-value one, something in there is crying for help. Where there’s smoke, there’s a bingo parlor. But does adding missing…

A Tourist’s Guide to the sp_Blitz Source Code, Part 1: The Big Picture

February 9, 2017

Brent Ozar

First Responder Kit, sp_Blitz

sp_blitz

sp_Blitz is our open source free SQL Server health check script. From a really high level, here’s what it does: Create #BlitzResult, a temp table to hold its output Check something on your SQL Server, and if it’s found, insert a row into #BlitzResult Check something else, and insert a row if it’s found Do that…

First Responder Kit Updates: So Many Updates, Brent Quit

January 27, 2017

dba, development, sp_blitz, sp_BlitzCache, sp_BlitzFirst, sp_blitzindex

I got 128 GB of RAM just to develop sp_BlitzCache with! Also, thanks to @RichBenner @BrentOzar and @douglane for code, and @LitKnd and @HenrikStaunPoulsen for great ideas! Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #677 Finally! A bug that isn’t ours! Microsoft forget to let SE clean up…

Analyzing Temporary Stored Procedures with sp_BlitzCache

January 24, 2017