New Release: SQL Clone 4
Introducing the new “Teams” feature in SQL Clone. Define access to instances, images and clones for specific teams and enable devs to self-service, refreshing environments on demand.
2019-08-22
Articles
Yes and No Questions Are Not So Simple
Joe Celko explains why questions requiring yes or no answers are more complicated than you might realize in both spoken language and computing.
2019-08-22
The OUTPUT Command
SQL Server 2005 has added many new T-SQL commands, one of which is the OUTPUT command. Longtime SQL Server author Dinesh Asanka brings us a short look at how you can use this command.
2019-08-21 (first published: 2007-07-09)
16,347 reads
Integrating Redgate SQL Code Guard with SonarQube
Greta Rudžioniene provides a step-by-step guide to running SQL code analysis checks, as defined by SQL Code Guard, in SonarQube, a general-purpose code quality tool that can perform continuous code analysis on a variety of languages.
2019-08-21
A Self-Tuning Fill Factor Technique for SQL Server – Part 1
Introduction So what’s all the fuss about Fill Factor? It is a SQL Server parameter I’ve ignored for 20+ years. The main reason was/is I’ve had no idea about what value to use. There is just no documented definitive guidance. Back in April at SQL Saturday #830 - Colorado Springs, I attended two sessions by […]
2019-08-20
8,916 reads
Using SQL Monitor to manage a growing server estate
The State of SQL Server Monitoring report found that monitoring is key to managing large estates, and as estates continue to grow the need for a monitoring solution that is scalable is increasing. German IT Service Provider Fiducia & GAD IT AG implemented Redgate’s SQL Monitor to better manage the performance of its growing SQL Server estate.
2019-08-20
Memories of DR testing
With the introduction of the GDPR, a lot of our prospective clients are demanding more and more information regarding data disposal, retention and usage practices. Both our new and existing clients want to look at our internal ecosystem and understand how we manage it. This means that I finally got a budget for a disaster […]
2019-08-19
2,201 reads
Simple SQL Change Automation Scripting: The Release Object
Once you understand the SCA data objects, it can give you a certain glow of to discover, suddenly, that SCA can do some complicated and time-consuming tasks with just a few lines of code. Phil Factor demonstrates how to get the most of SCA's Release object.
2019-08-19
Vagrant and SQL Server 2017 on Linux
Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017
2019-08-16 (first published: 2017-11-14)
5,440 reads
Simple SQL Change Automation Scripting: Connections, iProjects and Builds
Phil Factor delves into some of SQL Change Automation's data objects, or artifacts, covering the DatabaseConnection, iProject and iBuildArtifact objects. He explains the useful information they contain and how to use them in a PowerShell-automated database delivery process.
2019-08-16
Blogs
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers