Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Issues and opinions on the PASS anti-harassment policy (#sqlpass)

PASS just published an anti-harassment policy reminder, quickly followed by a  blog by Wendy Pastrick (about a bad experience at last month’s conference, and why it took a while to report it). We’ve had some conversation on Twitter about it all, and a couple of jokes, and some back and…

Read more

2 comments, 128 reads

Posted in SQL Awesomesauce on 25 November 2015

A Data Age proclamation

Twice in two days now, I’ve gotten in discussions with people about the state of data usage…the idea that we have absolutely massive amounts of data at our disposal – especially us, as if you’re reading this, you’re likely a DBA or at least an IT professional – but that…

Read more

0 comments, 175 reads

Posted in SQL Awesomesauce on 12 November 2015

Improved #MinionBackup and #MinionReindex – new versions!

We released Minion Backup 1.1 and Minion Reindex 1.2 this week! We’ve got a some great new features, and a number of bug fixes. New features in brief: Minion Backup can now back up to NUL. Minion Reindex has improved error trapping and logging, and new statement prefix and suffix…

Read more

0 comments, 164 reads

Posted in SQL Awesomesauce on 23 October 2015

Attending PASS Summit? Take a great Tuesday precon!

We’re just two weeks away from the PASS Summit in Seattle,  and there is most definitely still time to get into our Tuesday pre-conference session, “The Enterprise Scripting Workshop“. That’s a full day of training with 100 of your closest friends* for just $495. SESSION DETAILS Abstract: The database administrator…

Read more

1 comments, 154 reads

Posted in SQL Awesomesauce on 12 October 2015

You DO have outstanding, free backup and maintenance, right?

It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on, or that you read about it on (or one of our newsletters). Or it’s possible that you’ve missed the news. So, ahem. Index Maintenance We have created…

Read more

0 comments, 181 reads

Posted in SQL Awesomesauce on 7 October 2015

Today at 12pm Central: #MinionEnterprise Talk – Backup Management!

Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how “ME” can help you with your database enterprise. Specifically, this month we’ll show off enterprise backup management. Configure, manage, and report on all backups from a…

Read more

0 comments, 149 reads

Posted in SQL Awesomesauce on 6 October 2015

SQL Saturday San Diego tomorrow! (September 18)

This weekend we’re going to hit SQL Saturday San Diego for the first time ever! We are the excited. Come and see us at our MinionWare booth (yes we’re vendors woooo!!), and at our sessions and especially at our lunch session: 11:15am: Monster Text Manipulation: Regular Expressions for the DBA…

Read more

0 comments, 233 reads

Posted in SQL Awesomesauce on 18 September 2015

The #TSQL2sday #70 roundup

Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully. Here we go. Rob Farley : Superhero powers for managing the enterprise. Rob talks about  what his consulting company looks for when talking to a customer. Specifically, things that are…

Read more

5 comments, 247 reads

Posted in SQL Awesomesauce on 10 September 2015

PASS Summit 2015: Recommendations and Invitations (#sqlpass #Summit15)

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 – “this is the highlight of most SQL Server speakers’ years…a sort of educational, Christmassy nerdfest, with a feel of a class reunion…

Read more

2 comments, 723 reads

Posted in SQL Awesomesauce on 9 September 2015

Time for T-SQL Tuesday #70!

Here is your invitation for T-SQL Tuesday #70, and the topic is: Strategies for managing an enterprise We define “enterprise” in a number of ways, but I tend to default to two definitions: “the things I’m in charge of” and “anything I don’t want to do manually”.  In other words,…

Read more

6 comments, 345 reads

Posted in SQL Awesomesauce on 1 September 2015

I am not a “wogrammer”

So apparently the COO of Facebook is trying to make the word “wogrammer” – a woman programmer – a thing.  (Thanks to Vicky Harp for pointing out this infuriating thing.) I cannot stress how fundamentally opposed I am to this, new, stupidest of ideas. Why? Let’s delve into a little…

Read more

6 comments, 259 reads

Posted in SQL Awesomesauce on 27 August 2015

Assigned reading: FREEPROCCACHE

I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one of those days. I’d like you to read Grant Fritchey’s excellent piece, “Targeted Plan Cache Removal“, for this reason: the more people have learned about parameter sniffing, the more popular…

Read more

0 comments, 196 reads

Posted in SQL Awesomesauce on 25 August 2015

To AutoGrow or not?

Note: This is a repost of an older blog by Sean that’s still applicable. We’ve updated it with a note or two on how Minion Backup – our free backup solution – and Minion Enterprise – our management solution – can help. I just got this question in the user…

Read more

1 comments, 227 reads

Posted in SQL Awesomesauce on 10 August 2015

Beginning T-SQL slide deck and recording – #SQLSatBR

I had a great time in my Beginning T-SQL presentation here at SQL Saturday Baton rouge! Here is the BeginningTSQL slide deck (PDF). Here is an older recording of the class, as I haven’t yet had time to process today’s recording. Thanks to those who attended! Remember: SQL Server Books…

Read more

3 comments, 205 reads

Posted in SQL Awesomesauce on 1 August 2015

Minion Backup intro webinar June 3!

Minion Backup 1.0 is up and available for download as of now! Minion Backup by MidnightDBA is a stand-alone database backup module.  Once installed, Minion Backup automatically backs up all online databases on the SQL Server instance, and will incorporate databases as they are added or removed. Join the Minion…

Read more

1 comments, 284 reads

Posted in SQL Awesomesauce on 2 June 2015

Coming soon: Minion Backup, featuring table based scheduling!

The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup arrives on June 1! Minion Backup by MidnightDBA is a stand-alone database backup module.  Once installed, Minion Backup automatically backs up all online databases on the SQL Server instance, and will incorporate…

Read more

1 comments, 271 reads

Posted in SQL Awesomesauce on 20 May 2015

Precon this week! The Enterprise Scripting Workshop #SQLSaturdayBR

You are cordially invited to a fantastic precon event before SQL Saturday Baton Rouge! The Enterprise Scripting Workshop is on Friday, July 31, and if you register before June 30 you’ll get the Early Bird rate of $99…it’s $125 to attend: not bad at all for a full day’s training.…

Read more

3 comments, 218 reads

Posted in SQL Awesomesauce on 18 May 2015

Announcing Minion Enterprise: the new SQL Server Management Solution

A company with more than one SQL Server instance has no built-in way to gather and report on maintenance, backup, and configuration data across those instances. Even more, there is no good way to push standardized settings out to the enterprise. The database administrator must spend a large amount of…

Read more

4 comments, 782 reads

Posted in SQL Awesomesauce on 1 May 2015

SQL Server 2014 SP1 released, and revoked

Just a brief note today to point to an article by Time Ford on announcing that SQL Server 2014 SP1 has been released, and then pulled almost immediately: The problem is there was a problem with the patch. I can’t go into details until there is something formally announced…

Read more

1 comments, 311 reads

Posted in SQL Awesomesauce on 16 April 2015

SSMS regular expressions: format text into a block

Sean’s RegEx for DBAs class must be finally sinking in for me. Today I was able to figure out a RegEx thing in SQL Server Management Studio. Here’s the problem: Sometimes I document an SP in MS Word, then copy-paste the paragraph into a comment block in the SP. Of…

Read more

2 comments, 246 reads

Posted in SQL Awesomesauce on 7 April 2015

Older posts