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.
2020-03-31
Additional Articles
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.
2020-03-30
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.
2020-03-30
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.
2020-03-27
299 reads
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.
2020-03-26
Virtual Reality
While we are centuries away from the Holodeck experience, we can take advantage of today’s technology for fun or education.
2020-03-26
426 reads
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.
2020-03-25
816 reads
Using SQL Monitor Groups in PowerShell
Not only are SQL Monitor Groups probably the neatest and most maintainable way of ensuring that all your SQL Servers have the best possible configuration of alerts, but they represent a powerful way of categorizing your SQL Server estate. In this article, I'll show how to use the SQL Monitor PowerShell API to export these groups, save their settings onto a configuration management system, or compare groups of settings to see the differences between them.
2020-03-25
795 reads
Avoid using constants in an ORDER BY clause
Phil Factor explains why an ORDER BY clause should always specify the sort columns using their names, or aliases, rather than using an integer to specify the position of a column in the SELECT list.
2020-03-24
Power BI Dashboard vs Report vs Workbook
There are many different ways to present data using Power BI and this tip looks at these different methods such as Power BI Dashboards, Power BI Workbooks and Power BI Reports.
2020-03-24
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers