An Experiment in Building Culture
Redgate has done something this month to try and create culture for its employees during the pandemic.
Load Extended Events via Powershell
Learn how you can load Extended Events with PowerShell, nice and fast.
How to Configure Amazon RDS SQL Server for Windows Authentication
This article will show how to use Windows authentication for AWS RDS SQL Server by setting up an AWS Managed Active Directory and integrate it with an AWS RDS SQL Server instance.
Whitepaper: Enabling fast and easy database migrations with Flyway
High performing teams must implement a common approach to database migrations so that the database can be included in Continuous Delivery. This ‘kernel’ of Database DevOps leads to better alignment between developers and Ops teams, and increases the throughput of high quality releases. The key for many is Flyway, and this whitepaper explores how this highly configurable migrations tool enables a bespoke migrations-based deployment strategy that is easy to adopt and scale across teams
Join the New Stars of Data
There are plenty of opportunities to grow your career by sharing knowledge. Steve points out a few today.
Using Azure Synapse Link for Azure Cosmos DB
Learn how you can query CosmosDB data from Azure Synapse in this walkthrough.
Developing a backup plan
Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should be considered when developing a backup plan.
Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages
In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.
Your User Group Goals
Today Steve asks what you might want out of your local organization devoted to the data platform.
Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.
Blogs
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers