We are testing and trying out a few different plugins. Sometimes licensing for a few of these is strange and we've had some issues with them working in QA, and...

No worries. Juggling projects can get confusing. I wish that they supported refreshes of some sort, but they really didn't architect this in and not likely going to in the...

Yeah, my fault. Didn't check the WHERE clause box as the answer. This new interface is a little tricky as I don't have a validation check and I can't see...

IaaS is often the way to go when you want to lift and shift, but if the workload is not steady and you have to overbuy hardware for peaks, better...

Thanks, I think every time I try to get something done in Azure, I learn something. Between the complexity and pace of change, I'm always learning something.

Thanks, Frank. Glad you enjoy them

I enable it rarely. We do use it for deployments from Redgate products, but overall I think I worry about accidentally doing something strange in a script. Also, since I...

You are welcome

I like Matt's solution. Once you decide on ordering and know what item you want, row_number() gives you a value that you can use in the WHERE clause.

Here are versions and features supported: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureSupport

Unsupported items: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureNonSupport

In general, when I looked at this before, and you are like a dbowner for a database(s), but not exactly. There are...

You are very welcome

That's the report, but I have to find the issue in Github for tracking. Didn't see one, or someone named it strangely. I just added a new one.

Thought there was an issue for this, Luis, but don't see one in the various code style items. Added this.

Grant is correct. You're trying to think about this incorrectly, according to what MS has built.

Azure SQL DB <> SQL Server database on premise

In fact, the version of Azure SQL...

A bit more code to check

SELECT a.PharmNo, a.ClaimNo, a.ClaimDate, b.PharmNo, b.ClaimNo, b.ClaimDate
FROM Claim AS a
    INNER JOIN Claim AS b ON a.PharmNo = b.PharmNo...