Create AT&T Network Hierarchy Diagrams using SQL Server Data

Diagrammatic support for large, complex hierarchical data structures in SQL Server.

What's the Lunch Factor?

DevOps is about being effective and getting work out to customers. Today Steve notes that the lunch factor might help you reexamine your software development process.

Auto Scaling Azure SQL DB using Automation runbooks

Learn how to auto scale an Azure SQL Database with Azure runbooks and using an existing runbook from the runbooks gallery.

Welcome to Redgate Deploy and Cross-platform Database DevOps

Until now, organizations wanting to introduce database DevOps have had to rely on – and purchase – different tools and solutions for different databases. A new cross-platform database DevOps solution, Redgate Deploy, changes the rules. Find out why in this latest blog post.

PowerShell Day by Day: Filtering Objects

In my last article, The Basics of PowerShell Day By Day, I covered some basics of getting started. These articles aren't intended to replace some of the getting started information in things like the Stairway to PowerShell. Instead, I am covering some of the tips, tricks, techniques, and bits of knowledge that I wish I'd […]

Pulling Together

A number of companies worked together to ensure that they could meet the challenge of the NHS. Sharing data was critical to this effort.

How We Ended up with Git

Git is used by many teams for version control. In this article, Dino Esposito takes a look back at the history of source control and how git became the popular tool it is today.

AI Data

Data is important for AI projects, but the ethics and privacy implications are complex. A new project from Microsoft aims to help users control their data and make it available for use.

Creating and Using Inline Table-Valued Functions

Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.

iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.

The Basics - Level 1 of the Stairway to Query Store

Introduction Instead of going straight into the topic of the Query Store, I would like to start this Stairway Series by mentioning a few performance tuning scenarios that are very common to production DBAs. I think most of us have been in one of these situations at some time: An application experiencing slowness after a […]