Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Where in the world are Jen and Sean?

Updated with more SQL Saturdays! Well hi there, folks. A month slips by so very fast. Here is your January report on what we’re up to, and where we’re going to be in the near future. What are we up to? Minion, of course! Also, Minion, and some Minion. In…

Read more

0 comments, 187 reads

Posted in SQL Awesomesauce on 28 January 2016

Fun with Operator Precedence

Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause says “WHERE This AND That OR Something AND that”, without any clarifying parenthesis? Let’s play around with this. The simplest test scenario is a SELECT 1. If I get…

Read more

2 comments, 1,800 reads

Posted in SQL Awesomesauce on 31 December 2015

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

4 comments, 290 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, 286 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

1 comments, 269 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, 263 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 MidnightSQL.com, or that you read about it on MinionWare.net (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, 289 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, 267 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, 351 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, 364 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, 853 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, 464 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, 363 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, 306 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, 338 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, 319 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, 411 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, 390 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, 331 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, 899 reads

Posted in SQL Awesomesauce on 1 May 2015

Older posts