+1 for simple mode

I am aware of that now, having gone from 15-20C temps in May in Colorado to 4-15C in ANZ in June. I have an appreciation for time and weather down...

Turbo does this for apps on...

Looks like svn -> git shouldn't be hard. Convert it, then load to Bitbucket

https://blokspeed.net/blog/2010/09/converting-from-subversion-to-git

Git is better, way better, IMHO, but it's just a repo. Comments need not be lost.

What are you thinking with Azure? Be careful about talking about servers in the cloud without specifying what you're thinking. The nomenclature gets confusing, and there are lots of options.

If...

Migration is what I'd do, as outlined above, but why 2016? If you have the 2016 license, but if you're upgrading with new licenses, why not 2017?

I think we have some language issues. You have a VM in Azure, which runs SQL Server, is that right? Inside here, you have a backup policy for SQL Server?...

The WHERE clause runs before the COLUMN list, despite being coded later. Your WHERE clause needs to have the same calculation, or you need a CTE to do this ahead...

Actually, sys.time_zone_info has an is_dst_enabled column you can use here. SQL Server should match this up correctly.

Time zones are tricky, but this might help you:

DECLARE @t DATETIMEOFFSET...

What's the benefit to moving to Python?  I might ask that. Python is really good at handling some complex string things, and with SQL 2017+, you could do the Python...

Which "file"? The database file?

Once the switch and delete is logged, AFAIK, you cannot recover this data from the partitioned table without a full restore. What I might do instead...

Enjoy the movie. I hope we'll go see it as well. No fireworks for us, but we did lightly hike and go to the mountains for the weekend. Working today,...

Exactly. These people need access, they aren't affected by least privilege. They also can't all be fired all the time, though perhaps a few terminations would slow this down.

Ha, everything takes hours on the ranch. Cutting the property takes about 40-44 hours. Do it once a year, but behind this year.

The CEK isn't stored on the client, though maybe we could argue this is accessed by the client. I used accessed because the CMK can be stored in a cert...