Added my note. I hadn't considered the restore/dbcc/drop of databases on a dev machine. I've done this, but usually in places where I had an Enterprise agreement. I suspect, or...

Late, but I'll agree with

#1 - Not allowed

#2 - allowed

#3 - Not allowed.

If you verify the integrity of the backup, you're doing production work. You are checking, actively, how...

Ed Wagner (1/31/2016)

---

WayneS (1/31/2016)

---

How many Threadizens are going to SQL Saturday Cleveland this upcoming weekend? I'll be flying in Thursday night; I'd love to meet up with you (even better......

Apologies, I think I published the wrong version. I'll go dig out the original on my machine and get the rest up, or I'll just rewrite it. It's not too...

Yes. Haven't found a way...

Rich, you've commented out the second column.

You might look at SQL# for regex functionality

http://www.sqlsharp.com/

Are you 2008? There is a try_convert, but it's only in 2012+ (https://msdn.microsoft.com/en-us/library/hh230993.aspx)

I think you'd need more checking of the substring returned to see if things were in bound. Even...

Are you restoring on the same instance or a different/new one?

The SMK and DMK do not need to match. SQL creates the SMK for the instance, and this can be...

There are a lot of jobs that have SSIS as a part of them. I wouldn't let this scare me, though I think you should work through the skills and...

Phil Parkin (1/27/2016)

---

Just expanding on this discussion a little: if there are people here who know both AWS and Azure, it would be nice to hear their views on pros...

Articles on Azure, and/or AWS, are very welcome. I'm looking for people, but having a hard time.

Plus Grant seems to avoid writing on it here 😛

BrainDonor (1/28/2016)

---

I've just discovered Redgate's 'Tab History' button.

Where was that at my last place of work? That little gem could have saved me hours of agony.

Hunting through tabs, closing tabs...

You will probably need to post this at an MSDN forum, but I did find this: https://support.microsoft.com/en-us/kb/884974

If you're using Messaging Queueing v1, then only in domain mode. It's possible that...

I'll admit my wording is simple. Perhaps semantics, but the check constraint is evaluated, not skipped, but the evaluation isn't false, so the row is allowed.

The value is ambigious, as...