Robert Sheldon in MongoDB Building MongoDB Aggregations in MongoDB Compass In the previous article in this series, I demonstrated how to build and run an aggregate statement in MongoDB Shell.... 02 April 2024 22 min read
Theory and design Joe Celko in Theory and design SQL Logic In this article, I will discuss the history and thinking behind several types of logic that are typically associated with... 29 March 2024 13 min read
T-SQL Programming Aaron Bertrand in T-SQL Programming Pagination and ordering by large values Pagination is a technique for limiting output. Think of Google search results, shopping the electronics category on Amazon, or browsing... 25 March 2024 9 min read
Web Aneesh Lal Gopalakrishnan in Web Cloudfare Turnstile, A New Way To Prove You Are Real This article describes the recommended way to integrate Cloudflare Turnstile into a React application. When I first heard... 21 March 2024 9 min read
Theory and design Joe Celko in Theory and design Department of Redundancy Department Ever wonder all the reasons that we use databases instead of file systems? While we don’t think of it too... 18 March 2024 12 min read
Containers and Virtualization Bravin Wasike in Containers and Virtualization Kubernetes For Complete Beginners Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment... 14 March 2024 32 min read
PostgreSQL Ryan Booz in PostgreSQL Transforming and Analyzing Data in PostgreSQL In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued... 12 March 2024 20 min read
Database Administration Aaron Bertrand in Database Administration Get the most out of SQL Server Agent logs If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent... 11 March 2024 6 min read
Goodness Woke in Cloud Serverless Authentication methods in web apps. Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional server-based authentication systems.... 05 March 2024 24 min read
Career Jason Romans in Career The Value of Conference Speaking Editor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, so join Jason... 04 March 2024 9 min read
Robert Sheldon in MongoDB Building MongoDB Aggregations In the previous article in this series, I discussed how to use a find statement to retrieve data from a... 01 March 2024 20 min read
T-SQL Programming Edward Pollack in T-SQL Programming Find and Replace Text in Strings in T-SQL String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases,... 29 February 2024 17 min read
Database Administration Aaron Bertrand in Database Administration Upgrade SQL Server on your workstation Lately, I’ve seen many people struggling to upgrade their workstation to the latest version of SQL Server. The main source... 26 February 2024 6 min read
Web Benedict Ampea-Badu in Web Making Accessibility Part of the Design Process – Part 3 Naviagation, flow, and testing it all In this last segment of the series, we’ll delve into the crucial elements of... 22 February 2024 14 min read
Software Delivery Phil Factor in Software Delivery Database Feature Toggles In software development the concept of feature toggles are used to selectively turn on and off features. They are, for... 19 February 2024 15 min read
PostgreSQL Grant Fritchey in PostgreSQL Functions and Procedures: Learning PostgreSQL with Grant One of the most useful constructs in SQL Server is the stored procedure. It gives you a way to do... 15 February 2024 9 min read
Database Administration Aaron Bertrand in Database Administration Leave it better than you found it This is for the folks who still have to log into remote machines and do work manually on the box.... 12 February 2024 8 min read
PowerShell Laerte Junior in PowerShell Automating BCP with PowerShell I was talking with a good friend that has an environment with terabytes of information and to create a homolog... 09 February 2024 8 min read
Opinion Pieces Dennes Torres in Opinion Pieces The Fashionable Truth About AI Over the past year, the topic of AI has really blown up in the general public. However, AI was already... 06 February 2024 14 min read
Testing Alex Bunardzic in Testing Why Test-Driven Development? (Part 2) As discussed in Part 1, by segregating our focus on developing code that behaves as expected from the focus on... 01 February 2024 11 min read
