How to Install SSIS in Visual Studio 2019

This tool has always been an integral part of the Visual Studio. However, the name of this tool as well as the method of its installation varies from version to version of Visual Studio (VS). In this article, we are going to illustrate how to install SSIS in Visual Studio 2019.

Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD

This article covers examples of how some larger companies have successfully implemented CI/CD practices to transform their development processes.

Deciphering Data Architectures

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

• Printed book:
  • US
• Kindle book:
  • US

T-SQL Fundamentals

Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

• Printed book:
  • US
• Kindle book:
  • US

The Ebb and Flow of AI

Everybody’s coasting and looking back. Let’s kick our heels up, get comfortable, and talk big picture industry stuff.

Five changes to SQL Server I’d love to see

I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my dreams ever come true. Still, it’s fun every once in a while, to be whimsical about the way I wished SQL Server worked. Especially in January because, you know, new beginnings.

Partitioning Data in Microsoft Fabric to Improve Performance for Lakehouses, Warehouses, and Pipelines

Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.

Comparing Groups for Similarities in Power Query – Using Cosine Similarity

Recently, my skills were put to the test when I needed to compare hundreds of Active Directory and SharePoint Groups to find similarities in their memberships.

SQL Server OPTION RECOMPILE for Simple Queries

Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.

Data Documents and Common Sense

What can be so difficult in creating a sensible standard for Structured Data Documents? To understand why they tend to get improved into unusable complexity, I’ll need to explain a bit of background.