First, and I can't emphasize this enough, double, triple, quadruple check that yes, really, these servers are the same. Frequently they are not.

Then, of course, the next question is, are...

When you jump the SQL Server 2014 gap (because no one should ever upgrade to 2014), you do need to be aware of something really important. In SQL Server 2014,...

If you're just getting going, now is a great time to completely ignore trace and trace events and concentrate only on Extended Events. Instead of default trace, look to the...

p.s.  I'm not 100% sure but I don't believe they've disabled the ability to turn ANSI NULLs off yet in 2017.  It has been an advisory for many years,...

So this should be fine? select a.*, b.full_name from alt_id_view a left outer join all_clients_view b on a.people_id = b.people_id It's only bringing in the matched so it could...

I'm seeing an Unfollow link. I just followed you. Below your name, it says Unfollow on the left:

Does that work?

In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far into it,...

I didn't see the need to add a comment. The other answer is shown as accepted with multiple positive votes. The bad answer has now 2 negative votes...

Sounds like you're not logging in correctly to Azure then. You can only use Azure Active Directory, not the regular kind, or, a SQL login, which you say you don't...

Connections should be exactly the same. What's the error?

Also, look up Ola Hollengren's scripts for backups. They'll serve you well.

Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me? I'm working on a...

Since you're not at liberty to share the queries - the only input I would have is - eat the elephant one bite a t a time.  The one...

Wait. Managed instance is different. They want that to be a lift & shift location. You can run a restore there. That's different than Azure SQL Database.

Reading execution plans is fairly complicated. Follow the link below, or look it up online to find a free book I wrote on the topic. Work tables aren't bad (or...