Delete Data from SQL Server Table in Batches

In this tip we cover a T-SQL script that allows you to batch delete older data from tables and save the deleted records to an archive table.

Collections: Computed gaps for continuous numbers

Problem Finding the hole for continuous sequences of numbers could be a discouraging task even for advanced programmers. This article presents a new solution based on usage of geometry data type and on a unknown function (if not, maybe less used function) specific designed for geometry objects. Sample: Given the following sequence of [dis]continuous numbers […]

Streamline and Acclerate SQL Server Data Warehousing

In this presentation we’ll discuss the aspects of data automation and focus on the central goal of extracting the data that is locked in several operational systems, normalizing it to the enterprise's standards and sharing it with the business.

Tagging SQL Server Changes in SQL Monitor

How to use RAISERROR() in T-SQL to send annotations to SQL Monitor, so you can observe the direct impact of application tasks, or server changes, on the SQL Server metrics.

Analyzing Formula 1 results in R

Using R to scrape data from the web, prepare and visualize it

Making SQL Server Function Changes Backwards Compatible

Tagging SQL Server Changes in SQL Monitor

How to use RAISERROR() in T-SQL to send annotations to SQL Monitor, so you can observe the direct impact of application tasks, or server changes, on the SQL Server metrics.

Evaluating SQL Data Catalog using Docker Containers

Richard Macaskill shows how to use Docker Compose to get SQL Data Catalog up and running in a container, in your SQL Server test lab, and then use it to evaluate its data discovery and categorization capabilities on a containerized SQL Server instance.

Virtual Reality

While we are centuries away from the Holodeck experience, we can take advantage of today’s technology for fun or education.

Storage 101: Understanding the NAND Flash Solid State Drive

Today, most organization are using solid-state drives for everything from laptops to enterprise database storage and virtual machines. In this article, Robert Sheldon explains how NAND flash solid-state drives work.