Announcing Minion CheckDB release date!
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup...
2016-11-28
1,056 reads
Jen McCown
Fight harassment: be the “Backup” at PASS Summit
Harassment is a problem at some of the conferences we go to. What can we, as attendees and speakers and...
2016-10-11
401 reads
Step by Step: WHERE, GROUP BY, and HAVING
People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the...
2016-10-07
617 reads
PASS Summit 2016: Recommendations and Invitations (#sqlpass #sqlsummit)
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2016-09-06
499 reads
October precon in Orlando: “The Lifecycle Approach: Maintenance Problems & Solutions”
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...
2016-09-05
470 reads
Conference speakers: Why do you teach at events?
I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at...
2016-08-29
834 reads
An MCM teaches COMMENTS at SQL Saturday OKC
Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events...
2016-08-26
486 reads
Slash star, dash dash: Be obsessive about comments
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...
2016-08-12 (first published: 2016-08-08)
1,988 reads
Tricky TSQL: NOT IN (NULL)
We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means...
2016-08-11
1,030 reads
Feasel’s Grand Analysis of the PASS 600 mile radius rule
UPDATE: Last week, PASS announced an update to the 600 mile radius announcement: “…we will be piloting the 600-mile driving radius...
2016-08-10 (first published: 2016-08-01)
1,176 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...