Bringing SQL Server Data Quality Tools to Your Company

Learn how and why you should be using Melissa's data quality components that fully integrate into SSIS packages to fix data problems and save your company money.

DevOps 101 Webinar: Key Concepts and Terminologies

As you embark on your own Database DevOps journey you are going to hear many new concepts and phrases, but what do they mean and why are they important to consider? Join Grant Fritchey live as he breaks down the key concepts and terminologies around Database DevOps.

Raising Exceptions and Error Handling with SQL Server THROW

Learn how and why to use THROW in your SQL Server code to be able to better handle errors that may occur during code execution.

How to Use PowerShell to Track a Network Latency Issue in an Always On Availability Group

This article tracks down a problem with Availability Groups due to network bandwidth.

Sign up to PASS Data Community Summit 2022

There's still time to register for Summit and unlock access to over 300 sessions. Join peers and industry leaders in the data community homecoming. Get $200 off on the 3-Day Conference pass (in-person) with code REDGATEVIP or 50% off on the 3-Day online pass with code RGVIPONLINE

SQL Server Data Masking with DbDefence

Data Lineage Scripts for Microsoft SQL Server and Azure SQL

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

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 […]