Data Masking in Principle

This is the first of two articles to describe the principles and practicalities of masking data in databases. It explains why an organization sometimes needs masked data, the various forms of masked data we can use, the sort of data that needs to be masked, and the potential pitfalls.

How to Use Any SQL Database in GO with GORM

ORMs (Object Relational Mappers) are tools (libraries, modules, packages) that provide the functionality for interacting with SQL databases. This article will look at how to use any SQL Database in GO with GORM.

SQL Server 2022 Paid Editions Require a Licensing Key

For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates

Webinar | Database Monitoring: The ROI of Build vs. Buy

There are many things to consider when deciding whether to invest in a database monitoring tool or whether to use a homegrown solution. However, the business frequently wants to know one thing and one thing only: what’s the return on this investment (ROI)? In this webinar, Microsoft Data Platform MVP, Grant Fritchey, is joined by our expert panel to share the pros and cons to building a monitoring system versus purchasing one.

A Real-world Implementation of Database DevOps: People, Processes, Tools

This series of articles describes a path you can take to transforming an existing, manual and error-prone database development and release process into an automated and reliable Database DevOps 'pipeline', starting here with an overview of what we set out to achieve, and the people, processes and tools involved.

SQL RAISERROR to Better Handle Errors

Learn how and why to use RAISERROR in your SQL Server code to be able to better handle errors that may occur during code execution.

Oracle optimizer Or Expansion Transformations

The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some ways to an inverse for “Or Expansion” and “Join Factorization”. In this instalment, it’s time to take a closer look at Or Expansion and we’ll move on to Join Factorization in the next instalment.

Webinar | Test Data Management

With the average data breach costing $4.35 million, Test Data Management (TDM) is crucial. In this session, we’ll demonstrate how TDM can reduce your risk by achieving scalable compliance without slowing down your database development process. Watch on demand now.

New Flyway Course on Redgate University

SQL Server at Scale - Using an Archive Table - Part 2

In my previous tip, I explained how we are inclined to use archive tables and how they become increasingly problematic over time. This tip will focus on ways to mitigate the issues.