In this article we look at the similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.
The post Choosing Between SQL Server Integration Services and Azure Data Factory appeared first on SQLServerCentral.

Read what Grant, Steve and Kathi predict will be the biggest challenges for data professionals to overcome this year.
The post The Redgate Advocates Predict… 3 Key Challenges to Overcome in 2022 appeared first on SQLServerCentral.

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
The post Playing popular game of Wordle using T-SQL appeared first on SQLServerCentral.

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
The post Playing popular game of Wordle using T-SQL appeared first on SQLServerCentral.

Phil Factor demonstrates some PowerShell tasks that will produce a high-level overview, or narrative, of the main differences in the metadata between two versions of a database, during Flyway Teams migrations.
The post Reporting on Changes Made by Flyway Migration Scripts appeared first on SQLServerCentral.

Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
The post SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL appeared first on SQLServerCentral.

Introduction This article will introduce you to the SQL Server Dacpac in Azure Data Studio. We will also learn about the Bacpac. In the Azure Data Studio, we have an extension named SQL Server Dacpac which allows us to deploy, extract Dacpacs, create a database from a Bacpac and export a schema and data to […]
The post SQL Server Dacpac in Azure Data Studio appeared first on SQLServerCentral.

Got wanderlust? We thought it would be fun to look at where the best place to live in the world is as a DBA. Find the winners and weigh in on the debate here!
The post Where's the best place to live as a DBA? appeared first on SQLServerCentral.