SQL Compare is a tool designed to identify differences between two SQL Server databases. These differences can be in tables, views, stored procedures, triggers, or even in the actual data stored in ...

MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...

We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.

This PowerShell module contains two functions that are useful for exporting large amounts of data from tables, views, or queries on an (Azure) SQL Server database into CSV files compliant with the RFC ...

SQL Data Compare is a comprehensive tool for comparing databases, quickly identifying data differences, analyzing the data, generating comparison reports, and synchronizing SQL Server data with the ...

In this post, I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases.

Procedure to move Microsoft SQL Server database to a new location, painlessly, if you’re running low on disk space, added a new drive array, or just curious.