Are the newer, digital, internet enabled back boxes really more "advanced" ?

My assertion is that the older analog devices are probably more reliable and less prone to data hacking,...

Yes, data buffers allocated by SSIS during execution consume memory separate from that reserved by SQL Server, which is why it's reccomended that SSIS be installed on a separate server.

Here you appear to be selecting TOP X rows without an explicit sort order. I'm assuming that ORDER BY (SELECT NULL) is essentially nullifying the sort order, which could potentially...

No, you don't bring THAT up in an interview....

Querying and managing XML data is a topic for which I don't get exposure to in my day to day job, and it's a bit of a struggle to switch...

swoozie (1/7/2016)

---

This is so laughable. We all know, developers only do what they are told, and only do it with the least amount of work to accomplish the task....

If I were on that VW software team, I'd approach the CEO without an appointment, turn in my resignation, and then demand a special $500,000 severance package... with the agreement...

There...

neomerdien (1/6/2016)

---

we dont issue direct deletes, that's the thing. we have proper cleaners (SPs) based on criteria, the problem is that somehow a rogue process somehow manages to delete rows...

If all you want to do is trace delete operations on the table that match specific criteria, that is resolving the root cause of some issue caused by a user...

I'm holding out for R#.

My understanding is that you want to trace what application, login, session, statement, etc. is issueing specific types of DELETE operations against a table. You can do this using an...

I think the decision should hinge around the question: Do you need secure document storage, or is this project just for hosting public domain content?

Azure is good for cloud...

For use in an Exec Process task, perhaps the DOS command version of WinZip would be more appropriate.

http://whitemarker.blogspot.com/2006/09/dos-using-winzip-for-command-line.html

It sounds like you have substantial experience with the Microsoft technology stack, so you should have that base covered. To become more of a database architect you want to read...