Edward Pollack in Featured How to Increase SQL Server Column Width Without IO (Input/Output) Overhead One of the most hassle-prone changes that can be made in a SQL Server database is to widen an existing... 28 July 2025 14 min read
Edward Pollack in Featured How to Use the New PRODUCT() Function in SQL Server 2025 Learn how the new PRODUCT() function in SQL Server 2025 simplifies multiplicative aggregation. See examples, performance tips, and use cases.… 21 July 2025 8 min read
Edward Pollack in Featured Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide Everything you need to know about Regular Expressions (Regex) in SQL Server 2025 - learn what it is, how to... 14 July 2025 18 min read
Bravin Wasike in DevOps DevOps vs. SRE: Bridging the Gap, Not Building Walls (Part 2 – Putting it into Practice) In Part 1 of this series, we covered the operational overlap between DevOps and Site Reliability Engineering (SRE). While DevOps... 10 July 2025 29 min read
Aaron Bertrand in Featured Common SQL Server Problems: Network Related or Instance Specific Error Occurred This is the first in a series of articles meant to provide practical solutions to common issues. In this post,... 07 July 2025 6 min read
John Kerski in Business Intelligence 13 Things I wish I knew about Power Query (when I first started) When I first started with Power Query, it was in Excel, through the Power Pivot feature. I was amazed at... 03 July 2025 11 min read
Gogula Aryalingam in Business Intelligence Unlocking Infor CloudSuite data: Making the most of it with Stream Pipelines In my experiences building end-to-end analytics solutions, I often need to connect to a variety of different systems to bring... 01 July 2025 17 min read
Goodness Woke in AI Zero-Trust Architecture Best Practices for AI Cloud Deployments The connection of artificial intelligence and cloud computing has produced previously unattainable chances for creativity while simultaneously introducing complex security... 26 June 2025 20 min read
Joe Celko in Theory and design State Transition Constraints About two decades ago, I introduced the concept of transition constraints to show Data Validation in a database is a... 24 June 2025 14 min read
Kellyn Pot'Vin-Gorman in Oracle Oracle ASM: Monitoring and Managing (Part 2) In the first part of this series, we explored the fundamentals of Oracle Automatic Storage Management (ASM)—a powerful volume manager... 20 June 2025 5 min read
Matt Gantz in Database Administration Replacing a Column in a Large Active SQL Server Table In a previous post I showed how to use a batching strategy to remove large amounts of data from a... 19 June 2025 11 min read
Robert Sheldon in PostgreSQL Getting started with Azure Database for PostgreSQL Flexible Server Along with its many other cloud services, Microsoft now offers Azure Database for PostgreSQL Flexible Server, a database-as-a-service platform based... 18 June 2025 19 min read
Bravin Wasike in DevOps DevOps vs. SRE: Bridging the Gap, Not Building Walls (Part 1) Understanding the Divide — DevOps vs. SRE Explained The conversation around DevOps versus Site Reliability Engineering (SRE) is becoming increasingly... 17 June 2025 24 min read
Mercy Bassey in MySQL Replicating MySQL databases in Docker Containers In my prior article, “Running a relational database with Docker”, I showed how to spin up a Docker container with... 13 June 2025 10 min read
Aaron Bertrand in Database Administration SQL Server 2025 : Zstandard Backup Compression Whether you are a bank or a hot dog stand, creating backups is a boring but essential part of managing... 11 June 2025 15 min read
Jagdish Mohite in PostgreSQL Securing PostgreSQL Against Injection, Misconfiguration, and Privilege Escalation PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group “takes security seriously,”... 06 June 2025 22 min read
Kellyn Pot'Vin-Gorman Oracle ASM: A Simple Solution or Another Complexity? (part 1) For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure complexity grows with... 05 June 2025 6 min read
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Date and Time Data Types Date and time data types are important because they help track and manage time-based information in databases. This includes things... 03 June 2025 21 min read
Robert Sheldon in MongoDB Moving from SQL to MongoDB’s MQL People new to MongoDB often come to the platform with a background in relational database management systems (RDBMSs) such as... 30 May 2025 27 min read
Mercy Bassey in MySQL Running a MySQL database in a Docker Container Relational databases provide a structured approach for storing and organizing large volumes of data into tables consisting of rows for... 29 May 2025 14 min read
