String Shrinking

Getting started with the SQL MERGE statement

This article is focused on beginners who have already started writing SQL queries and are now diving deep towards more data processing and complex queries in SQL. When we talk about data processing, an important concept that comes to our mind is performing ETL workloads to a data warehouse. ETL is a very complex topic […]

Strange Code

What hasn't changed?

How to Batch Updates A Few Thousand Rows at a Time

In this post, Brent explains how to use a combination of two separate topics that he has blogged about recently.

Multiple Regression Model Enhanced with Bagging

This article explains what bagging is relative to a basic decision tree model and demonstrates how to apply bagging for better multiple regression model fits to data from SQL Server.

The Time Zone Range

The Strict Replace

Spoofing Data Convincingly: Text Data

Learn how to generate some convincing data for your development databases.

Can I create this view?