SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Why won’t my SP work THIS time?

Why won't my SP work? I did this exact thing. You're never too old to do something like this.

The post Why won’t my SP work THIS time? appeared first on The MidnightDBA Star-Times.

Read more

6 comments, 467 reads

Posted in SQL Awesomesauce on 9 December 2016

December: A two-line play.

“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?)  

The post December:… Read more

0 comments, 511 reads

Posted in SQL Awesomesauce on 5 December 2016

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 and Minion Reindex...and it's coming in early 2017.

The post Announcing Minion CheckDB release date! appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 776 reads

Posted in SQL Awesomesauce on 28 November 2016

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 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

5 comments, 342 reads

Posted in SQL Awesomesauce on 11 October 2016

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 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 post Step by Step:… Read more

0 comments, 524 reads

Posted in SQL Awesomesauce on 7 October 2016

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 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

5 comments, 425 reads

Posted in SQL Awesomesauce on 6 September 2016

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 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

0 comments, 380 reads

Posted in SQL Awesomesauce on 5 September 2016

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 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

1 comments, 580 reads

Posted in SQL Awesomesauce on 29 August 2016

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 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

0 comments, 398 reads

Posted in SQL Awesomesauce on 26 August 2016


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

2 comments, 926 reads

Posted in SQL Awesomesauce on 11 August 2016

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 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

6 comments, 1,884 reads

Posted in SQL Awesomesauce on 8 August 2016

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 distance for events in North America beginning January 1, 2017. We will not include the back-to-back weekend restriction during this pilot…” Last month, PASS – the professional SQL organization…

Read more

0 comments, 1,012 reads

Posted in SQL Awesomesauce on 1 August 2016

Share custom solutions in the MinionWare Community Zone

Since we released Minion Reindex over a year and a half ago, we’ve had a ton of wonderful feedback, praise, questions, and best of all, custom made solutions to custom in-house problems. You see, Minion Reindex and Minion Backup are both free, and completely open. Nothing’s encrypted, and all data…

Read more

0 comments, 576 reads

Posted in SQL Awesomesauce on 7 June 2016

Minion CheckDB Beta

Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is the time. We’re putting the finishing touches on the 1st beta and it’s looking great with some fabulous features. So this is the open call for beta users. If you’d…

Read more

3 comments, 506 reads

Posted in SQL Awesomesauce on 18 May 2016

See you Saturday in Houston!

Here’s your friendly neighborhood reminder to get free learnin’ at SQL Saturday Houston this weekend, where we’ll have the MinionWare booth, and sessions all over! Sean’s Monster Text Manipulation: Regular Expressions for the DBA is at 11am My Designing Stored Procedure Solutions is at 2:45pm Sean’s Understanding Backups is at…

Read more

0 comments, 420 reads

Posted in SQL Awesomesauce on 12 May 2016

Easy SQL mistakes: Accidental Correlated Subquery

Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup (you knew it had to be Minion related, didn’t you?) and I just got the oddest error. Here’s how it went. First, I got a list of backups…

Read more

2 comments, 2,867 reads

Posted in SQL Awesomesauce on 18 April 2016

XP_CmdShell isn’t Evil

Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have the power to turn on and use xp_cmdshell anyway.  Xp_cmdshell is not a security hole. This is a reprint of Sean McCown’s original post on DBARant. You know, reprinted…

Read more

6 comments, 1,665 reads

Posted in SQL Awesomesauce on 9 April 2016

Announcement: Backup(n.) vs Back Up(v.)

Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it refers to an action. I’m going to back up the database. It will produce a backup. I’ll save that backup until we back up the database three…

Read more

6 comments, 428 reads

Posted in SQL Awesomesauce on 7 April 2016

Utility function: dbo.JobName(@job_id)

As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly stunned that I’ve never done this before: CREATE FUNCTION dbo.JobName ( @job_id UNIQUEIDENTIFIER ) /* A little utility function to return a job name based on the job_id. No…

Read more

2 comments, 1,380 reads

Posted in SQL Awesomesauce on 28 March 2016

Catch The Enterprise Scripting Workshop in Orange County, Baton Rouge, Albany, or Atlanta this year!

Sean and I have put together our bazillion (read: like 30 combined) years of SQL Server DBA-ing into one big, shiny pre-conference session that’s coming at you in multiple states of the union! The Enterprise Scripting Workshop. What on earth is that about, anyway?  The short version is that we…

Read more

0 comments, 407 reads

Posted in SQL Awesomesauce on 16 March 2016

Newer posts

Older posts