PostgreSQL Ryan Booz in PostgreSQL Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2 In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming... 08 April 2024 13 min read
Editorials Louis Davidson in Editorials Giving Feedback on Microsoft Data Platform Tools As a data professional, there is a set of tools that you use on pretty much a daily basis. Before... 08 April 2024 3 min read
Ben Johnston in Culture Building a Culture of Data One of the major trends in enterprise computing, and really in enterprises themselves is an increased emphasis on data. My... 04 April 2024 19 min read
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
