Grant Fritchey in PostgreSQL PostgreSQL extensions: why the FUD is wrong PostgreSQL extensions get blamed for maintenance risk, abandonment, and poor cloud support. Here's why that reputation is mostly FUD -... 13 November 2026 11 min read 2
John Kerski in Data Analytics How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault Learn how to pass API secrets into Microsoft Fabric Gen2 dataflows using Azure Key Vault, pipelines, and public parameters (no... 30 October 2026 15 min read 11
Greg Low SQL Server 2016 end of support: how to choose your upgrade path SQL Server 2016 support has ended. Compare SQL Server 2022 vs 2025, in-place vs side-by-side upgrades, Azure and ESUs, with... 23 October 2026 15 min read 42
Chisom Kanu in Cloud What is cloud database vendor lock-in? The 3 types explained (and how to audit yours) Cloud database lock-in takes three forms: engine, feature, and operational. Learn which type you're accumulating, and what it would actually... 27 August 2026 12 min read 11
Joydip Kanjilal in Big Data Big data: what it is, why projects fail, and how to get value from it Big data projects fail not because of technology, but strategy. Learn the 6 Vs, 5 reasons initiatives fail, and key... 14 July 2026 9 min read 2
Sachin Pawar in Cloud DMS migration failing? How to debug Oracle to Cloud SQL network errors, layer-by-layer (OSI model guide) Debugging Google DMS failures for Oracle to Cloud SQL migrations? Use the OSI model to pinpoint network errors layer by... 01 July 2026 13 min read 21
Grant Fritchey in Cloud Why even the best teams struggle with cloud migrations Cloud migrations fail not from incompetence, but from unknown unknowns. Discover the most common challenges teams face in 2026 —... 10 June 2026 7 min read 11
Edward Pollack in T-SQL Programming Demystifying PIVOT and UNPIVOT in T-SQL Learn how to use T-SQL PIVOT and UNPIVOT operators with clear examples — from basic row-to-column transforms to dynamic SQL... 20 May 2026 12 min read 4
Grant Fritchey in Databases Why database ownership is so fragmented in 2026 – and what you can do about it Learn why database ownership is so fragmented in 2026 - and how best to overcome this challenge, with proven methods... 12 May 2026 7 min read 1
Pat Wright in Cloud How to ensure success following a cloud migration Learn how to optimize performance, reduce costs, improve security, and ensure long-term success after moving from on-prem to the cloud.… 11 May 2026 5 min read 11
Pat Wright in Cloud How to ensure successful deployment of a cloud migration Practical cloud migration go-live tips: planning, team readiness, rollback strategy, testing, and post-migration checks for a smooth deployment.… 06 May 2026 3 min read 11
Greg Low in SQL Server What are managed identities in SQL Server 2025? A complete guide Learn how managed identities in SQL Server 2025 enhance security by eliminating passwords and enabling seamless Microsoft Entra authentication for... 05 May 2026 6 min read 1
Pat Wright in Databases How to utilize testing to ensure a successful cloud migration Learn how to ensure successful migrations by testing applications, tracking bandwidth, and fixing issues before going live.… 04 May 2026 3 min read 1
Pat Wright in Cloud Why over-communication is critical to the success of a cloud migration Cloud migration success depends on clear, consistent communication. Learn how dashboards, targeted updates, and regular check-ins keep teams aligned and... 30 April 2026 3 min read 21
Pat Wright in Databases What should you move first in a cloud migration? 5 key guidelines Learn how to choose which application to move first in a cloud migration with five practical guidelines covering risk, impact,... 24 April 2026 3 min read 2
Pat Wright in Cloud How to minimize downtime in a cloud migration Plan cloud migration with minimal downtime. Learn key cutover strategies, testing methods, and critical questions to avoid data loss and... 03 April 2026 3 min read 2
Pat Wright in Cloud How to migrate from on-prem to the cloud: uncovering legacy system ‘skeletons’ Learn how to identify hidden risks in legacy applications before moving to the cloud. Practical tips to avoid migration failures... 18 March 2026 3 min read 21
Umair Shahid in Cloud Why the cloud is not a disaster recovery strategy for your critical databases Cloud isn’t a disaster recovery plan. Learn why multi-AZ and managed services aren’t enough, and how RTO, RPO, backups, and... 13 March 2026 8 min read 21
Fabiano Amorim in Security, Privacy & Compliance SQL Server security vulnerabilities you weren’t aware of: DBaaS system code decryption & user data exfiltration A SQL Server DBaaS privilege bypass exposed system tables and vendor-protected code on AWS, GCP, and Alibaba. This explains the... 05 November 2025 30 min read 43
Ben Johnston in SQL Server A complete guide to Azure SQL Managed Instance server and database configuration options A tested reference of sp_configure, ALTER DATABASE, and tempdb options that aren't supported in Azure SQL Managed Instance -plus the... 13 May 2025 10 min read