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
Camilo Reyes C# Cancellation Tokens in AWS A colleague of mine once asked about cancellation tokens in AWS. This question got me thinking about this problem and... 29 January 2024 11 min read
BI Dennes Torres in BI Top-Down and Bottom-Up Approaches in Microsoft Fabric Nikola Ilic, best known as Data Mozart, published a great article and video about how to make semantic model data... 25 January 2024 9 min read
Louis Davidson in Career State of the Database Landscape Results 2024 Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This year’s question was... 23 January 2024 3 min read
Robert Sheldon in MongoDB Querying MongoDB Documents MongoDB provides an efficient environment for storing document data at scale. However, most of your interactions with MongoDB will not... 22 January 2024 25 min read
Database Administration Edward Pollack in Database Administration The Importance of Retention It is always an afterthought. New objects are created that start off small and current. New feature development takes over... 19 January 2024 24 min read
Web Benedict Ampea-Badu in Web Making Accessibility Part of the Design Process – Part 2 Introduction to the concepts of accessibility in designs We live in the height of the digital age, where the digital... 15 January 2024 19 min read
Database Administration Aaron Bertrand in Database Administration Optimized locking in Azure SQL Database I don’t think I’ve ever had a great impression of Azure SQL Database as a place for production applications. In... 08 January 2024 8 min read
PowerShell Laerte Junior in PowerShell PowerShell Dynamic Parameters and SQL Server Have you ever been in a situation that you want to call a cmdlet or a function with a parameter... 05 January 2024 6 min read
