In this post, we will go step by step into several aspects of Change Data Capture, a feature that is available on the Azure SQL Managed Instance and Microsoft SQL Server. The focus will be on the ...

SQLServer2Dictionary: generates a CSPro data dictionary from selected tables in SQL Server database SQLServer2CSPro: given a CSPro data dictionary generated by SQLServer2Dictionary, converts data from ...

This SQL Server Export-Import Utility enables fast and efficient data transfer between SQL Server instances. It allows you to export data from any SQL Server table based on specific selection criteria ...

We have an ancient AS/400 730 system that still houses some old budget/financial data. We'd like to decommission this box, and migrate the data to a SQL server. The data won't be modified or changed ...

There’s a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...