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 1
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 Data Security, Privacy, and 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
Dennes Torres in Blogs Azure Function & API Rate Limits: How NAT Gateway Helps You Stay Under the Radar Rate limit is common when consuming API’s: They control how many calls you can make in an interval of time.... 23 April 2025 4 min read 1
Kellyn Pot'Vin-Gorman in Oracle Oracle’s Limited Cloud Vendor Licensing It’s nothing new for vendors to find ways to lock in customers to their products and cloud services. Oracle recently... 15 April 2025 3 min read 21
Ben Johnston in Databases 5 key problems from a SQL Server to Azure SQL Managed Instance migration (and how to avoid them) Planning an Azure SQL Managed Instance migration? Here are five surprises a real transactional SQL Server move uncovered - and... 31 March 2025 10 min read 2
John Kerski in Cloud The complexity of using Power BI in US Sovereign Clouds “I hate to tell you this, but it’s not available for us yet.” This is an all-too-common phrase I find... 13 March 2025 7 min read 1
Padmaja U.K in Cloud Beyond Single-Cloud: A Peek into Multi-Cloud The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology to how to... 25 February 2025 11 min read 4
Dennes Torres in Blogs Azure SQL Serverless: Discover What’s new and Increase Your Savings Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure SQL Serverless? The... 22 January 2025 3 min read 21
Koen Verbeeck in Azure How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing... 22 October 2024 27 min read