I'm remembering SQLSlammer.  Many SQL shops got caught out even though they had patched every SQL Server they knew about.

It was the MSDE instances they didn't know about that...

It's not even mundane things. I see some orgs that sell to other businesses and give them trials or PoCs with live data. When those companies move on without being...

That is does. Especially with all the self-services stuff in many orgs.

I think this was a place where either a redirect was incorrect or the post should have been edited.

I've manually updated the link for this one.

I think the biggest challenge, as you allude to, is the effort to track and ensure this stuff is handled well. I've been concerned about the restore/replay issues, and ensuring...

The default is NULL for columns if not specified...

Yeah, lots of people like typing. Esp technology people

Michael has some good ideas, but what I'd do is not run this on a huge table. Get 20-30 rows and work out your logic and query. Then look at...

Access works.

Best to start a separate thread for this, so people can find the answer.

You can track the sessions and look for IPs, but you can't be sure of where clients connect from, given proxies and firewalls. Not always easy to ensure what is...

They may. That is basic networking stuff. Clients need to be able to send a packet on whatever port you have the server listening on, plus the browser if you...

Nope, this should be it. Clients that connect by IP will have issues, but the server will start listening on the new IPs when it starts.

Might check that the configuration...

Python is better for handling data outside of the database. Moving files, cleaning, loading, and for general tasks. Interesting to work with python and Powershell for the same task and...

To your points:

- shut down vm at night - makes perfect sense, worth just doing this for cost reasons.

- files in XTP folder - I don't know enough about this,...