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

Attend “T-SQL’s Hidden Support Feature” online September 11!

I’m presenting T-SQL’s Hidden Support Feature for the DBA Fundamentals virtual chapter on Monday, Sep 11 at 9:30 PM CDT! Session description: The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database… Read more

0 comments, 141 reads

Posted in SQL Awesomesauce on 6 September 2017

Tech news: Your phone screen is a dirty rotten spy

Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic (@AdamMachanic) August 29, 2017 OH GOODY, your phone’s screen could totally be spying on you. Great.

The post Tech news: Your phone screen is a dirty rotten spy appeared… Read more

2 comments, 168 reads

Posted in SQL Awesomesauce on 29 August 2017

That thing you want to do? Do the thing.

You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it? Could he keep up with it? Will you end up embarrassing yourself? Let's talk.

The post That thing you want to do? Do the thing. appeared first on The MidnightDBA… Read more

0 comments, 292 reads

Posted in SQL Awesomesauce on 29 July 2017

Celebrate! Second Anniversay Giveaway (is now over)

Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a few days, we're giving it away.

The post Celebrate! Second Anniversay Giveaway (is now over) appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 169 reads

Posted in SQL Awesomesauce on 18 July 2017

There’s no substitute for mentoring

There’s no substitute for mentoring. We’ve heard it before, and in various ways, but I think we tend to largely ignore it. Americans, at least, aren’t used to a mentor system, and we’re not in the habit of asking for mentors. But mentors can be great. You can stop them… Read more

0 comments, 160 reads

Posted in SQL Awesomesauce on 18 July 2017

Employees, encourage work from home

The discussion around the last article I wrote on work from home (WFH) has been wonderful, but there is one aspect that drives me nutty-freaking bonkers: “But, I don’t want to work from home!“ Oh, my stars and grasslands. Techies: I don’t want to force work from home.  I’m not… Read more

4 comments, 210 reads

Posted in SQL Awesomesauce on 22 May 2017

Employers, let your people work from home

Work from home is, astoundingly, still not the norm in United States IT offices. This is ludicrous, because employees want it, employers can provide it, and the objections to work from home do not hold up. Let's talk.

The post Employers, let your people work from home appeared first on… Read more

6 comments, 251 reads

Posted in SQL Awesomesauce on 17 May 2017

I’m going to make you love backups

On April 12, I'm going to show you about two dozen ways to make your backups better, easier, faster, and more complete...using Minion Backup, of course.

The post I’m going to make you love backups appeared first on The MidnightDBA Star-Times.

Read more

0 comments, 216 reads

Posted in SQL Awesomesauce on 4 April 2017

The Public Speaking Roadmap

So you look around, and all the cool kids are speaking at SQL Saturdays and PASS Summit and the like. You want to be the cool kids too, so how do you start public speaking? Here in four simple steps, is your roadmap.

The post The Public Speaking Roadmap appeared… Read more

0 comments, 179 reads

Posted in SQL Awesomesauce on 25 March 2017

Compare column names for case sensitivity

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

3 comments, 533 reads

Posted in SQL Awesomesauce on 25 January 2017

Webinar: Introducing Minion CheckDB!

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

0 comments, 550 reads

Posted in SQL Awesomesauce on 19 January 2017

Database snapshots for everyone!

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.

The post Database snapshots for everyone! appeared first on… Read more

0 comments, 462 reads

Posted in SQL Awesomesauce on 5 January 2017

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, 401 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, 464 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, 667 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, 296 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, 462 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, 398 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, 341 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, 494 reads

Posted in SQL Awesomesauce on 29 August 2016

Older posts