Archive

SQL Server: Automatic index compaction in Azure (preview) – Part 2

Why does index fragmentation matter less than before ? Logical fragmentation was a problem on spinning disks: an ordered scan on a fragmented index broke the read-ahead into smaller I/Os and each jump cost a disk head movement.

SQL Server: Automatic index compaction in Azure (preview) – Part 1

For years, we have all scheduled the same thing on our SQL Server environments: a nightly or weekly index maintenance job. We check the fragmentation level, we run a REORGANIZE between 5% and 30%, a REBUILD above 30% and(…)

Learning Azure by having fun with ChatGPT

Learn Azure with ChatGPT to get a story around all the concepts and components of Azure. It becomes visual and you'll get some fun with it.

Install NeuVector 5 on OpenShift Local 4.14

I’ve been playing around with 2 applications recently: OpenShift from Red Hat and NeuVector from SUSE. At some point I’ve wondered if I couldn’t play with both at the same time. Read on as I’ll share some tips &(…)

Test OpenShift 4 at low cost in Azure

If you want to learn and test OpenShift 4 (the last release is 4.14 at this time of writing), you may not want to go straight with the installation of a full cluster. Using the OpenShift Service of a(…)

Microsoft Flexible Server Compute V5

Today I had the chance to move forwar with performance testing and some checks on two Flexible Server – Azure Database for PostgreSQL, one with 8vCPU, 64GB RAM and 512GB Storage (2300 IOPs) and another one with the same(…)