@JackDouglas I think so.

Possibly having some features that other ones lack.

Like it "runs in the cloud" ;)

just wondering how to explain why SELECT POWER(2.,64.); on azure 12 works like 2014 rather than 2016

@ypercubeᵀᴹ there is no better place for your private data :)

@JackDouglas related to which SP and fixed have been applied? Not much of a help I am, I know.

the nice page with almost all versions and SPs, doesn't include Azure: sqlserverbuilds.blogspot.co.uk

I suppose that's unsurprising

shame though

this clears it all up: docs.microsoft.com/en-us/azure/sql-database/…

not.

@JackDouglas yes. So V12 means the compatibility level is 130,

Or 120.

Or 110 or 100.

it seems to suggest that Azure is a bit of a moving target

I guess they have the equivalent of service packs, but you don't get to choose when they are applied?

Yes. Looks like that.

The servers are upgraded without notice. You can then later "upgrade" each database, that continues to run in the same compatibility level as when created.

it still boils down to: "my application works today but I can't be sure it will work tomorrow"

it's a bit too Windows 10 for my liking

they supported CLR until they stopped supporting CLR

I can't imagine using it for anything serious

that must have burnt a few people

Is anyone using database source control or an automated deployment tool that diffs schemas and produces its own change script?

@ErikE sqlalchemy and alembic

but with Postgres, not SQL Server

It's Python specific, so probably useless for you

I know you hate it, but is this useful for this purpose? apexsql.com/sql_tools_source_control.aspx

I think I have a license

@ypercubeᵀᴹ We're using RedGate SQL Compare with a license for the automation of it.

I'm not exactly happy with it, but with the auditing and other rules at my company, it's all we get.

We've been using the Compare thing as a build tool for a long time, but starting a week or two ago we have a new rule: No one, ever, runs a script in prod manually.

It's been interesting. Some real gotchas in there.

Like, let's say you roll out version 1.0. Then you roll out 2.0 but it has a problem. You can't re-deploy 1.0 because it doesn't have the knowledge of how to revert the custom data changes you made as part of the 2.0 rollout script.

You have to craft a special 2.0-to-1.0 rollback script that reverses those changes.

Was simply curious what others are using and how well they work.

@PaulWhite Haha!!!

The one we use (alembic) does a not bad job at creating scripts (both front and back). Occasionally we need to modify them.

And sometimes, the reverse scripts are too hard to write, so we do the changes without a reverse script.

@PaulWhite I noticed in the video that they used "dogfed". That is not the past tense of "dogfood" (verb). It's "dogfooded" if you really must.

But we don't need rollback scripts, as Postgres allows almost all DDL to be inside a transaction.

So if the script fails for whatever reason to move 1.0 to 2.0, it just rolls back the transaction.

@ypercubeᵀᴹ The rollback script isn't for a failure of the script itself--it's after the transaction is committed. Like, the next day when you discover that you did something Real Bad (much worse than simply "really bad").

@ErikE Yes, I understand. In these cases, you need a reverse script.

@ypercubeᵀᴹ Right, I may have used a term that was misleading. At work they call it a rollback script, but that's distinct from a transaction rollback.

No, your description was clear.

Sometimes changes are just impossible to be done in reverse. Say, you change a column from text to binary. Existing values are converted. Then new (binary) values are inserted. If you try to change the type back to text, some of the new values fail the conversion.

So the script has to take care of that.

(impossible -> impossible without losing data)

@MaxVernon I thought you were on the pub...

lol, I was. Now I'm at home waiting for some people to come by for drinks. Just thought I'd help someone out with an answer, even if it is 4 months late!

presumably that was your upvote; thanks if so!

;)

Just arrived, I deserved a tequila today.

I love tequila. Might have some tonight!

Jose Cuervo Special

My favorite

my current favorite is 1800 Reposado - 1800tequila.com/products/reposado

Have you ever taste Herradura? I don't. bodegasalianza.com/tequila/bodegas-alianza/herradura