Graphical analysis of SSRS report usage with Grafana

Learn how Grafana can help you quickly set up dashboards to analyze the usage data of your SSRS reports.

Build and fill a SQL Server Database using SQL Compare CLI and a Batch Script

Phil Factor provides a powerful DOS batch script which, when coupled with SQL Compare CLI, allows you to build databases from source, during development, and fill them with the specific datasets required for testing.

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.