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...

Gary Varga (1/26/2016)

---

Jeff Moden (1/25/2016)

---

Heh... according to the interviews I've been conducting for the last several years, people have spent way too much time crafting their resume instead of learning...

Thanks, and updated.

Need SP3

https://support.microsoft.com/en-us/kb/955725

I believe your DLL should be in

\WINNT\system32\MQOA.dll

That should be installed on your server system. Might need to add it to development.

This also might help: https://www.microsoft.com/msj/0599/msmq/msmq.aspx

I see a few posts that this should work with SP3, but can't find anything from MS about this.

Don't have a 2005 instance to check this on W2003. If you...