Jeff Moden (4/30/2014)

---

SQL Server needs to have the privs to write to whatever UNC you're using. I STRONGLY recommend that you NEVER have SQL Server writing to UNCs that...

you haven't said what you're doing, and what's unpredictable. Don't forget, we can't see what you're...

Don't have the trigger do this. Have the trigger insert the data you want to write out to a new table. Use a date, clear the table, something, but store...

You'd have to be able to extract the value of the node reliably, with something like XQUERY, take that and encrypt it. However, the result would be binary, and I'm...

This article should help you: http://technet.microsoft.com/en-us/library/ms178117.aspx

It describes the role switching. Note that there's manual work to move the jobs from one to the other, but once they are moved, you...

Agree with Giancarlo. Log ship directly to 2012. If this may have to work as DR, log ship to both 2005 and 2012, but when you switch, just switch to...

I'm open here. This could be a couple of pieces, but technical. Written for someone that's used SQL Server, but never done dimensional modeling. Imagine their boss told them to...

Alex,

You can tackle it.

yes

Alex Gay (4/29/2014)

---

There is no way that we in the NHS could use cloud computing in general, or Azure in particular, especially for databases that contain patient data. The...

I'm going to award back points for this one. I've reworded the question, as I implied that I might use memory optimized tables and want the old CE in the...

Log shipping isn't deprecated, though I suppose the wizard and jobs could be at some point. However LS does something different than AlwaysOn/mirroring/other HA stuff. Even if it were,...

Excellent. Thanks, Louis

Along with Lowell's suggestions, I'd take a look at what files are changing day to day. Search on updated files, see if you can track what is using more space...

I'm usually in and out quickly that I don't mind it much.