Database DevOps Robert Sheldon in Database DevOps Sharing knowledge in communities of practice Communities of practice bring people together to share ideas and learn from each other about a common interest. In this... 16 August 2021 12 min read
Editorials Devyani Borade in Editorials Negative Feedback: What is it exactly? I am trying so hard not to roll my eyes right now. I re-read the sentence. “Cherish criticism instead of... 11 August 2021 5 min read
Performance Fabiano Amorim in Performance SQL Compilations/sec is not what you think it is SQL Server perfmon counters provide a wealth of information about performance. In this article, Fabiano Amorim shows how current wisdom... 29 July 2021 24 min read
Editorials Brett Newski in Editorials Appreciating tiny victories No one is good at something right when they start. When starting something new, it’s normal to feel terrified or... 29 July 2021 3 min read
Azure Dennes Torres in Azure How to query private blob storage with SQL and Azure Synapse Azure storage can be marked Private to control access. Dennes Torres explains how to query private blob storage with SQL... 21 July 2021 17 min read
.NET Lance Talbert in .NET Using post-processing effects in Unity Changing the UI in games makes the games more fun to play. Lance Talbert demonstrates how to use post-processing effects... 20 July 2021 15 min read
Performance Edward Pollack in Performance Collecting SQL Server performance monitor data SQL Server provides information for troubleshooting performance. Ed Pollack demonstrates collecting SQL Server performance monitor data.… 20 July 2021 20 min read
Oracle Jonathan Lewis in Oracle Typical uses of Oracle sequences Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical... 14 July 2021 17 min read
Learn SQL Server Priyanka Chouhan in Learn SQL Server SQL Server High Availability and Disaster Recovery Plan Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.… 14 July 2021 26 min read
Editorials Kathi Kellenberger in Editorials How to learn about Azure SQL It was always important to me to keep up with the latest versions of SQL Server, but especially so when... 09 July 2021 3 min read
Learn SQL Server Robert Sheldon in Learn SQL Server How to enable SQL Server trace flags DBAs can control many aspects of SQL Server’s behavior with trace flags. In this article, Robert Sheldon explains how to... 07 July 2021 14 min read
Theory and design Joe Celko in Theory and design Much Ado about nothing: missing data Joe Celko explains how missing data is handled from the printing press to databases.… 01 July 2021 13 min read
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
