You are creating a database from scratch for an application This application will have multiple siloed environments (PROD, TST, INT, DEV) Data from PROD will nightly be moved to the other environments ...

Within IT, testing has matured as an industry. Many tools exist, and many IT shops have testing groups. But, often those testing groups are unable to assist on data-related projects. The heart of the ...

Whether you’re generating data from scratch or transforming sensitive production data, performant test data generators are critical tools for achieving compliance in development workflows.

How to use the InMemory provider in Entity Framework Core to test your methods without hitting the database or using fakes and mocks The InMemory database provider is an exciting feature in newer ...

Unfortunately, not every SQL database is always available when we expect it to be. When you're creating automation scripts to discover, add, update or remove records from a remote SQL database, you ...

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 ...

A study led by scientists at Johns Hopkins Bloomberg School of Public Health suggests that advanced algorithms working from large chemical databases can predict a new chemical's toxicity better than ...