In this case, we needed to assess whether migrating to Azure's MySQL Flexible Server, Azure SQL Database or alternative offerings from AWS and Google Cloud Platform (GCP) would be the best fit.

Elastic Jobs is specific to Azure SQL Database and allows you to execute T-SQL across a group of databases. This feature is still in preview of this writing, but it was introduced in 2015, so it ...

Assess, migrate, and optimise. Migrating SQL Server to Azure SQL Database Managed Instance: A Step-by-Step Guide is a comprehensive handbook for executing a migration, with guidance on each step ...

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.

The clock is ticking on Microsoft’s Extended Support for SQL Server 2008/R2, unless you migrate to the Azure cloud. Here’s how ...

Azure SQL Database has a new feature in preview called "Managed Instances" that offers greater compatibility between on-premises SQL Server and the cloud variant, again to make workload migration ...

Due to my background working with other major database platforms such as Oracle, MySQL, and PostgreSQL, I've long been an advocate for the SQL Server Migration Assistant (SSMA). This powerful and easy ...

Joey on SQL Server. Hands-On with Copilot for Azure SQL Database. I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do.