Azure Dennes Torres in Azure How to query blob storage with SQL using Azure Synapse How do you include blob storage in reports? In this article Dennes Torres explains how to query blob storage with... 01 July 2021 17 min read
Performance Edward Pollack in Performance SQL Server performance monitor data: Introduction and usage Monitoring SQL Server for performance is a critical part of a DBA’s job. In this article, Edward Pollack explains some... 29 June 2021 13 min read
Editorials Kathi Kellenberger in Editorials DevOps is more than continuous integration and delivery I recently presented a session about DevOps for DBAs, explaining what it is and why DBAs should care. One of... 29 June 2021 3 min read
Learn SQL Server Greg Larsen in Learn SQL Server Managing SQL Server transaction log size The SQL Server transaction log must be managed to keep a database running and performing well. In this article, Greg... 29 June 2021 14 min read
.NET Camilo Reyes in .NET Functional monads in C# Monads elevate basic C# types and unlock functional patterns, similar to containers. In this article, Camilo Reyes explains functional monads... 28 June 2021 18 min read
Azure Mahendran Purushothaman in Azure Autoscaling in Microsoft Azure The ability to scale up and down without maintaining extra hardware is one of the best cloud computing features. In... 16 June 2021 10 min read
Editorials Kathi Kellenberger in Editorials Introducing the PASS Data Community Summit Program Many of you know that Redgate purchased some of the assets of PASS, namely session recordings, domain names, and trademarks.... 15 June 2021 5 min read
T-SQL Programming Joe Celko in T-SQL Programming Data, N-Tiles & Medians Joe Celko takes a look at how SQL Server can do some of the work for you such as calculating... 01 June 2021 14 min read
Editorials Louis Davidson in Editorials What Counts for a DBA – Deadlines Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline,... 01 June 2021 4 min read
Editorials Kathi Kellenberger in Editorials PASS Data Community Summit 2021 I began attending PASS Summit in 2003. I had no idea that it would change the course of my career... 13 May 2021 2 min read
Oracle Jonathan Lewis in Oracle Oracle Sequences: RAC Using sequences when scaling up with Oracle RAC presents more issues with contention. In this article, Jonathan Lewis explains how... 11 May 2021 19 min read
.NET Diogo Souza in .NET Setting up a Kafka test environment with Kafdrop Kafdrop is n open source project that allows you to view information from Kafka brokers. In this article, Diogo Souza... 10 May 2021 9 min read
Theory and design Joe Celko in Theory and design Constraints and declarative referential integrity Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko... 06 May 2021 14 min read
Editorials Kathi Kellenberger in Editorials What is an ad hoc query? Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query... 04 May 2021 4 min read
Security Greg Larsen in Security SQL Server security – Providing a security model using user-defined roles Greg Larsen continues his series and shows how user-defined roles roles can control SQL Server security.… 26 April 2021 13 min read
Editorials Kathi Kellenberger in Editorials How different roles view database DevOps Redgate released the 2021 State of Database DevOps Report in February, and I wrote a short article talking about the... 20 April 2021 4 min read
NoSQL Robert Sheldon in NoSQL How to choose between SQL and NoSQL databases Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL... 13 April 2021 10 min read
Editorials Kathi Kellenberger in Editorials Can a monitoring tool save money? When I was a DBA responsible for 40 to 50 SQL Server instances, I didn’t have many third-party tools to... 07 April 2021 3 min read
Oracle Jonathan Lewis in Oracle Oracle sequences: The basics Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they... 26 March 2021 14 min read
Testing Julio Sampaio in Testing Load/stress testing .NET apps with Apache JMeter Since Microsoft discontinued their cloud-based load testing services, developers need a new way to test applications. Julio Sampaio demonstrates how... 26 March 2021 11 min read
