Add and Subtract Dates using DATEADD in SQL Server

Date manipulation is a common scenario when retrieving or storing data in a Microsoft SQL Server database. There are several date functions (DATENAME, DATEPART, DATEADD, DATEDIFF, etc.) that are available and in this tutorial, we look at how to use the DATEADD function in SQL queries, stored procedures, T-SQL scripts, etc. for OLTP databases as well as data warehouse and data science projects.

Oracle Architecture Overview

In this document I will share an overview of Oracle’s architecture that isn’t complete, but it will give you a basic understanding of how the architecture works, especially if you are coming from other database platforms.

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

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.