What’s New Type BlogEvents & Workshops SQL Server’s Hidden LOB Limit: Why max text repl size Breaks CDC (and How to Fix It) If your MERGE/update fails with a “replicated LOB data” error and you’re not using replication, it may actually be due to CDC. Christmas Gifts! Free tools to help you and SQL Server get on better in 2026 A selection of Martyn’s favourite free tools and where to find them. Transparent Data Encryption (TDE) with Customer-Managed Keys (CMK) or Service Master Keys (SMK) in Azure SQL A quick guide to how TDE works in Azure SQL and when to choose Service-Managed or Customer-Managed encryption keys. Making Sense of Your Data: Why Microsoft Purview Really Matters Microsoft Purview gives you the clarity and control you need over your data, read on to see why it matters for your organisation. Ola Hallengren’s Scripts – Parallelism Pitfalls These scripts are such a vast improvement over the default SQL Server maintenance plans they are used by thousands of companies around the world. Halloween special – Azure ghost NVMEs Upgrading your SQL Server Virtual Machine to one of the most recent Azure VM families? Be aware of the behaviour of the new super-fast local NVMe disks. Making the move from Power BI Premium to Microsoft Fabric Explore Microsoft’s move from Power BI Premium to Fabric and how you can plan a smooth, supported migration. Data Engineering Project Through Managed Services Eyes George Dutton shares lessons from his first greenfield Microsoft Fabric project on embracing imperfection, teamwork, planning, documentation, and smart AI use. Throttling SQL Server Maintenance with Resource Governor How to use SQL Server Resource Governor to throttle system maintenance tasks like DBCC checks in Azure environments, reducing their impact on customer-facing workloads. Why Open-Source Databases Need More Than Just Default Settings Databases like MySQL and MariaDB need more than just default settings to perform well. Extended Events – Creating Your First Session A beginner-friendly guide to safely creating your first Extended Events session in SQL Server, with tips to avoid common performance pitfalls. Configuring a Spark Cluster: Practical Calculation Walkthrough A practical walkthrough for configuring an Apache Spark cluster, using straightforward calculations to help you plan resources effectively. Posts pagination 1 2 … 6 >>
