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

When Will Privacy Matter?

by Steve Jones

SQLServerCentral

Data Privacy and Protection

Taking better care of data might just be a competitive advantage.

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

by Additional Articles

SQLServerCentral

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

by Additional Articles

SQLServerCentral

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

by Bogdan SAHLEAN

SQLServerCentral

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

by Additional Articles

SQLServerCentral

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

by Additional Articles

SQLServerCentral

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.

Now Is a Good Time for Choices

by Steve Jones

SQLServerCentral

The whole world is going through some interesting times. Chances are pretty high that you’re working from home and your principal interaction with others is through virtual means. I know I’m that way as is my company, Redgate Software. It can be challenging or rewarding, depending on how you go about it. What’s even more […]