Vendors/3rd-party Products

Masking Data in Practice

  • Article

Phil Factor takes a strategic look at common SQL data masking techniques, and the challenges inherent in masking certain types of sensitive and personal data, while ensuring that it still looks like the real data, and retains its referential integrity, and distribution characteristics.


The Joy of Realistic Generated Fake Database Data

  • Article

Have you ever had to demonstrate a database-driven application, and longed to have the real data to do so? To do what, precisely? Well, so you can then scroll through the customers who have used the system, demonstrate the accounting and audit, browse through the products, maybe even demo the customer tracking system with comments, complaints and so on. All this is possible, using realistic, fake data.


Whitepaper: Enabling fast and easy database migrations with Flyway

  • Article

High performing teams must implement a common approach to database migrations so that the database can be included in Continuous Delivery. This ‘kernel’ of Database DevOps leads to better alignment between developers and Ops teams, and increases the throughput of high quality releases. The key for many is Flyway, and this whitepaper explores how this highly configurable migrations tool enables a bespoke migrations-based deployment strategy that is easy to adopt and scale across teams



2020 Advent of Code–Day 3


This series looks at the Advent of Code challenges. As one of my goals,...

Welcome to the Azure Data Community, empowered by Microsoft


After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...

Daily Coping 24 Feb 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs


SQL Server 2019 PMEM

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2019 PMEM

Query Optimizer Suggests Wrong Index and Query Plan -- Why?

By Mike Byrd

Comments posted to this topic are about the item Query Optimizer Suggests Wrong Index...

UX Matters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item UX Matters

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers