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

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, 202 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, 204 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,508 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

20 comments, 1,366 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

15 comments, 178 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,095 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, 225 reads

Posted in SQL Awesomesauce on 16 March 2016

Well that’s just neat: Row Level Security, new in SQL Server 2016

SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while, but the on-prem version is getting it, now. Securing Rows Okay, so: row level security (or RLS as the MSDN article so groovily puts it). What’s that, then? In short,…

Read more

4 comments, 369 reads

Posted in SQL Awesomesauce on 25 February 2016

Shrink a log file…AUTOMATICALLY?

Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together. First things first: why would you want to shrink a log file in the first place? Haven’t we heard that shrinking files is bad? Well, no and yes.…

Read more

1 comments, 2,202 reads

Posted in SQL Awesomesauce on 22 February 2016

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, 392 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, 2,032 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, 485 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, 454 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, 440 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, 431 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, 465 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, 432 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, 529 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, 545 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, 1,025 reads

Posted in SQL Awesomesauce on 9 September 2015

Older posts