Editorials Kathi Kellenberger in Editorials Machine learning, both exciting and scary The 2002 movie Minority Report is about a police unit called PreCrime, which can predict when people will commit a... 25 August 2021 2 min read
Learn SQL Server Joe Celko in Learn SQL Server A UNIQUE experience A properly designed table must have a key to uniquely identify each row. In this article, Joe Celko explains unique... 23 August 2021 14 min read
Learn SQL Server Greg Larsen in Learn SQL Server SQL Server identity column The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg... 23 August 2021 13 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
.NET Julio Sampaio in .NET Getting started with Jamstack Jamstack is not a toolset; it’s a development methodology that can improve performance, productivity, and flexibility while keeping maintenance simple.... 05 August 2021 7 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
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
.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
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
BI Dennes Torres in BI Embed Power BI in Jupyter Notebooks Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres... 14 June 2021 12 min read
BI Adam Aspin in BI Introduction to generic Power BI themes Formatting Power BI visuals can be tedious. In this article, Adam Aspin explains custom Power BI themes that will save... 11 June 2021 17 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
.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
.NET Julio Sampaio in .NET Documenting and testing APIs with Postman Postman can be used to automate API tests. In this article, Julio Sampaio demonstrates documenting and testing APIs with Postman.… 10 May 2021 14 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
