Phil Factor brings us yet another lesson in Flyway and database migrations. Learn how to use PowerShell with Flyway to run SQL migration scripts that will build, fill and modify a PostgreSQL database.
The post Getting Started with Flyway Migrations on PostgreSQL appeared first on SQLServerCentral.

Introduction In my last article, Working with Azure IoT Central at SQLServerCentral, I gave an overview of Azure IoT Central. I had connected my mobile phone as a device to Azure IoT Central and collected the telemetry data. In this article, I will export the telemetry data continuously from Azure IoT Central to Azure SQL […]
The post Sending streaming data from Azure IoT Central to Azure SQL Database appeared first on SQLServerCentral.

In this article we look at solving SQL Server database restore issue when backup file does not show up in SSMS restore GUI as well as other permissions issues with backup and restore.
The post Issues with SQL Server Permissions to Restore a Database appeared first on SQLServerCentral.

During database development, as well as writing SQL, you must also write the tests that prove your SQL code meets all the requirements. The article will help you get started with database testing for your SQL Server databases, by creating and running unit tests against them, as well as static code analysis tests.
The post Testing SQL Server Databases Using SQL Test appeared first on SQLServerCentral.

SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom about one counter, SQL Compilations/sec, can sometimes be misleading.
The post SQL Compilations/sec is not what you think it is appeared first on SQLServerCentral.

Learn how to gather metadata information about the files being processed in your ADF pipeline.
The post Working with Get Metadata Activity in Azure Data Factory appeared first on SQLServerCentral.

Learn how to use the CData MySQL connector to access data across SSH.
The post Connect to MySQL Through SSH Using the CData MySQL Driver  appeared first on SQLServerCentral.

Instant file initialization can speed up database creation, file growth, and restores. Greg Larsen explains how to configure it and how it works.
The post Improving performance with instant file initialization appeared first on SQLServerCentral.