I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in column names. For example, if Table1 has a column named Col1, and Table2 has COL1, well that’s no good. But, how do we easily find those mismatches on a… Read more
Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two different days: Wednesday, February 1 – Done! We will post the video next week. Meanwhile, here is the WebinarDemo script, and the webinar survey. Friday, February 3 at 12pm… Read more
If you're lucky enough to have SQL Server 2016, go on and upgrade to SP1....you get extra-lucky special database snapshots in any version! Oh what's that? You don't use snapshots? Well let's see a couple of good use cases for them.
“Wow! A family, a marathon, and two businesses! So how do you keep up with it all?” asked Twitter. “Work-life balance,” she replied, glancing furtively at her sparsely populated blog. Fin (P.S. The latest blog on MinionWare.net, at least, is What Really Causes Performance Problems?)
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup and Minion Reindex...and it's coming in early 2017.
Harassment is a problem at some of the conferences we go to. What can we, as attendees and speakers and volunteers, can do to help? There should be a better way to ask others for help, and there should be a better way to show that you are willing to… Read more
People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the SELECT statement. The summary of each of these is simple to tell, but that doesn’t really sink in well, so we’ll walk through some examples.
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I said last year and the year before – “this is the highlight of most SQL Server speakers’ years…a sort of educational, Christmassy nerdfest, with a feel… Read more
On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at it, register for the free SQL Saturday Orlando that follows! http://www.sqlsaturday.com/564/eventhome.aspx Abstract for “The Lifecycle Approach” Database maintenance isn’t a single event; it’s a lifecycle. Aside from the… Read more
I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at events where there’s no compensation. I know more or less why I do this, but I’ll hold off on my answer. I want to hear about you. #SQLSaturday and… Read more
Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events page! (Direct link to WMV.) Tomorrow (as of the blog’s publish date) at8:30am, I will be teaching “T-SQL’s Hidden Support Feature” at SQL Saturday Oklahoma City (totally free,… Read more
We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means “I don’t know”. It stand for an unknown value. Nothing can be equal to NULL. We simply can’t say that 1 = NULL, or ‘ABBA’ = NULL, because we don’t… Read more
I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the reasons why I’m writing and presenting an hour long session on /* */ and — a bit later, but first: Why am I calling comments a “hidden support feature”? Comments… Read more