Data Lineage Scripts for Microsoft SQL Server and Azure SQL

Learn how you can easily analyze the data lineage in your SQL Server database.

The Work of Work

Meeting are work, even though we sometimes don't think of them as a productive part of our job.

Join the Redgate pre-con at PASS Data Community Summit

Take on the challenge of deploying database changes every 30 minutes in Redgate's Summit pre-con 'The Journey from Manual Deployments to Database DevOps' on November 15.

Hosted by Steve Jones, Grant Fritchey and Redgate DevOps experts, you'll start with a manual process and slowly implement changes that allow you to reap the benefits of automation.

The Basics of Inserting Data into a SQL Server Table

Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement. One row or multiple rows can be inserted with a single execution of an INSERT statement. You can even use the output of a stored procedure to insert rows. In this article, I will explore the basics of inserting data into a SQL Server table using the INSERT statement.

Manage Your Business Rules in T-SQL Query

Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]

Database Deployment with Terraform - The Basics

Learn the basics of using Terraform to declaratively specify how to configure resources in infrastructure.

The Digital World Remaking the Analog One

Software can change the way the real world works.

Load Data Asynchronously to SQL Server via an API and Python

Learn how to consume multiple API calls to load data to a SQL Server database using Python.

SQL Server Internals: Reading Pages

The I/O from an instance of the SQL Server Database Engine includes logical and physical reads. A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read first copies the page from disk into the cache.

Evolving Yourself

Growing and changing the way we work helps our careers advance and move forward.