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
Lee Asher in Databases First Normal Form (1NF): Breaking the ‘unbreakable rule’ in database design Learn what First Normal Form (1NF) means in database design, why repeating groups are discouraged, and why it can be... 31 March 2026 9 min read 4
Grant Fritchey in PostgreSQL How User-Defined Types work in PostgreSQL: a complete guide Learn PostgreSQL User-Defined Types (UDTs) with clear examples of DOMAIN, COMPOSITE, ENUM, and RANGE types, plus practical SQL code for... 27 March 2026 13 min read 2
Greg Low in SQL Server Everything you should know about the SQL Server Resource database Learn what the SQL Server Resource database is, why it exists, how it affects patching/ upgrades, and what to do... 25 March 2026 5 min read 11
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 11
Greg Low in SQL Server How to determine the last value used by a sequence in SQL Server Learn how SQL Server sequences work, how they differ from IDENTITY columns, and how to track the last value with... 17 March 2026 6 min read 11
Greg Low in SQL Server IDENTITY vs SEQUENCE in SQL Server – which should you use? A practical guide to IDENTITY vs SEQUENCE in SQL Server - what’s different, what matters, and which to use.… 09 March 2026 6 min read 5
Lukas Vileikis in Security and Compliance How to secure MySQL and PostgreSQL in the world of AI Learn how AI is transforming database security and discover best practices to secure MySQL and PostgreSQL against AI-driven threats, faster... 04 March 2026 11 min read 11
Lee Asher in Databases What are database keys? A practical guide A practical guide to database keys: natural vs surrogate, UUIDs, performance tradeoffs, and best practices for scalable schema design.… 02 March 2026 12 min read 331
Greg Low in SQL Server Why disabling the SQL Server sa account still matters in 2026 Disabling the SQL Server sa account isn’t outdated advice. Learn why attackers still target sa and what modern SQL Server... 26 February 2026 5 min read 51
Grant Fritchey in PostgreSQL Learning PostgreSQL with Grant: Data Storage Learn how PostgreSQL stores data on disk, including page architecture, TOAST storage, file structure, tablespaces, and I/O performance optimization strategies.… 23 February 2026 12 min read 11
Aaron Bertrand in SQL Server How to optimize planned availability group failovers in SQL Server Learn how to perform fast and predictable SQL Server planned Availability Group (AG) failovers. Discover tips to reduce downtime, optimize... 20 February 2026 15 min read 21
Lukas Vileikis in MySQL How to safely use MySQL 8.0 post end-of-life (and alternatives to consider) MySQL 8.0 reaches End of Life in April 2026. Learn the risks, upgrade paths, migration options, and how to stay... 18 February 2026 5 min read 11
Edward Pollack in SQL Server How to Find and Monitor Slow/Long-Running Queries in SQL Server Learn how to detect long-running queries in SQL Server using dynamic management views and T-SQL scripts to monitor performance in... 16 February 2026 19 min read 32
Rodrigo Ribeiro Gomes in SQL Server SQL Server 2025 CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS Commands Explained Learn about the new CREATE EXTERNAL MODEL and AI_GENERATE_EMBEDDINGS commands in SQL Server 2025.… 09 February 2026 29 min read 31
Lukas Vileikis in Security How to keep your databases secure in 2026: a complete guide Learn top strategies for securing your databases against emerging security threats. Discover best practices for access control, encryption, monitoring and... 27 January 2026 10 min read 2
Aaron Bertrand in SQL Server How to fix the Invalid Length error in SQL Server Learn why SQL Server throws the invalid length error in functions like LEFT, SUBSTRING, and RIGHT, and discover practical fixes... 12 January 2026 5 min read 42
Fabiano Amorim in SQL Server Exploiting SQL Server Date Correlation Optimization: How Tampered Backups Enable Cross‑Database Data Leaks This article reveals a critical SQL Server flaw: attackers can weaponize Date Correlation Optimization (DCO) views in restored backups to... 07 January 2026 19 min read 2
Greg Low in Databases How to Create a SQL Server Linked Server to Oracle 26ai Free Easily move data from SQL Server to Oracle 26ai Free with this step-by-step guide. Learn how to set up a... 05 January 2026 4 min read 2
Rodrigo Ribeiro Gomes in SQL Server How to View SQL Server Object Code Easily with sp_showcode Discover how sp_showcode improves SQL Server code viewing compared to sp_helptext, with better formatting, search, and decryption.… 29 December 2025 11 min read 21
1
1
