james_anderson

Working on a database compatibility tool. So your app works on SQL Server 2022 on-prem, but does it work on Azure SQL DB, AWS RDS, GCP CloudSQL, etc?

These cloud flavours have a compatible SQL dialect, but it's often details like missing features (CDC and Auditing on RDS are good examples) or differences in system objects that make it difficult to support your app on these platforms.

I capture all sql statements, run them through multiple SQL parsers to find all the system objects your app is using (tables, functions, stored procedures, etc). I then check them all against a catalog I have built of all system objects for every version of SQL Server on every platform.

I then give a report to see which platforms your app will work on, which ones it wont work on and which system objects are the problem.

Other database engines will be added once I get it working end to end (almost there).

I really hope so

Same. When I started running 5 years ago, I started with under 1km runs. Slowly built up to 5km runs over a 3 or so years. The hardest bit is getting out bed, once that habit is in the rest is easy.

I also found that not timing myself worked really well. Too many times I would finish a run feeling good, check my time and then feel bad that I didn't beat my pb. Stopped that and every run was positive.

TLDR; A time traveller, named Besso, came back to push Einstein to formulate his theory General Relativity earlier than he would have done on his own. This accelerated the technological growth of humanity over the next two centuries to such a degree that they were ready for the alien invasion in the year 2122.

This was my first thought. My guess is the team making the app are all about it's potential and fb are happy to give it a go because of the potential for improved data capture

Reminds me of the castle in Gormenghast

The controller in the top left is for the SNES (sorry). Really nice work though!

Yeah, I like the idea of treating SQL Server like it's just a process and not the entire server.

Are you planning to do that in production?

Haha, thanks for your answer Brent. I think you're right about VMs. SQL Server on docker in prod is kind of a thought experiment of mine at the moment.

I'd love to hear from anyone who is even just thinking of doing this.

> dynamically adding Always On Availability Group read-only replicas

Yeah I doubt scaling SQL Server out dynamically will ever make monetary sense, but it might be cool to just get it working.

I'm thinking of creating a Helm chart for K8s that allows you to dynamically scale the SQL Server pod up and down. I think I'll need to use some undocumented DBCC commands (or call the API) to freeze IO, so I can replicate the data files to the new secondary as it spins up.

Horizontally scaling SQL Server would be cool. Maybe if the hosts were licensed so we could run as many containers as we wanted, it could make sense...

I really like AGs but I'm not sure I will love them on Linux. It still feels like it's early days for SQL Server's HA on Linux.

That's a new reason, I like it. Books Online has got better over the years to be fair to it.

I've been doing similar stuff with docker in my CI pipelines. So are you testing your app on Linux SQL Servers and then deploying to Windows SQL Servers? Should be OK...