With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

-- Instal as a temp stored proc on any SQL edition RAISERROR ('Wrong database context. Please USE [master] to allow sp_generate_merge to be installed as a system ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

I’ve installed an AX Client installed on the AOS machine. I’ve installed SSIS on the AOS machine. I’ve installed the DIXF Service on the AOS machine. I’ve configured an AG Listener called AXLSN. This ...