Student, you've been a great fan and a great friend for so, so many years. So I know you'll appreciate it when I say: dangit, dude, don't scare us like...

Peter Schott (9/16/2016)

---

OK, Jeff. Write your article(s). I'd love to see the "securing xp_cmdshell" article and the "how to use xp_cmdshell in a proc securely" article at the minimum. 🙂

I'd...

Eric M Russell (8/21/2015)

---

We already have the SSMS Template Browser to cover commonly used commands and DMV queries.

However, the MERGE statement is complicated enough that it could use a GUI...

-- Just a handful...

SELECT ROW_COUNT() OVER (PARTITION BY col1 ORDER BY col1) as RowNum, ...

DBCC SQLPERF(LOGSPACE);

RESTORE FILELISTONLY FROM DISK='c:\backup\xyz.bak';

RESTORE DATABASE xyz FROM DISK='c:\backup\xyz.bak'

WITH MOVE 'file1' TO 'D:\sql\xyz.mdf',

...

We're working out a better license wording right now. But, even with the existing wording, Minion Reindex is free to use as much as you want, all over the place:...

As a side note, we DO have over 60 pages of documentation on http://www.midnightsql.com/Minion/[/url] for Minion Reindex in DOC, PDF, and RTF formats, plus in-product documentation via the Minion.Help SP.

-Jen...

That error was my fault. I posted the wrong package to MidnightSQL.com. I've updated the package, so we should be golden now. Very sorry for the inconvenience!

-Jen

Hey Jeff, just a few answers (bold) while Sean's otherwise occupied:

1. Does it handle Partitioned Tables and Indexes without having to manually identify such things?

Currently it doesn't do anything special...

That's always one of the first questions, so we put together an...

Hi Jo,

There are a number of benefits to Minion Reindex over other solutions. I personally love the Live Insight feature, which lets you see what's happening while index maintenance is...

Grant Fritchey (1/24/2011)

---

I'd be interested in attending. I do think it's slightly vague on what the attendee will be taking home. That's my one personal bugaboo. You've told me what...

Roy Ernest (1/24/2011)

---

The abstract is pretty good. It states your intention quite well.

But in the abstract, you are stating that you are going to provide how to reverse the...

Thanks! I have a recorded Code Sins session up on my blog (http://www.midnightdba.com/Jen/articles/) but the 2011 version is much...

mister.magoo (1/6/2011)

---

The DATEPART function has a WEEK datepart that displays the week...

Steve,

Both in person and in your editorial today, you directly addressed the elephant in the room, the subject we all skirted: sex, and the issues surrounding it. This...