What the heck is a DTU?

Andy Mallon explains DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.

Display SSIS package version on the Control Flow design surface

In this article I will show a simple trick to display version information on the Control Flow surface, so we immediately see which version and build we are modifying.

Getting Started with Azure SQL Data Warehouse - Part 3

Microsoft introduced Azure SQL Data Warehouse, a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just few minutes. In this article, Arshad Ali discusses the different types of tables you can create in SQL Data Warehouse, how they impact performance and the best practices around them.

Doing Fuzzy Searches in SQL Server

A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.

How to setup a tabular data model in SSAS Azure

Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure.

Building Dynamic React Apps with SQL Server Data

This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.

6 shades of masking your data

The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, Toby Smyth runs through all six.

The right way to approach a legacy code base

Andrea Angella shares what he learned from attending Michael Feather's workshop on working effectively with legacy code.

Byte Me: Functional Fashion

Package Parts – First Impressions

This article gives an overview of some good and not-so-good features of SSIS package parts.