Skip to main content
  • About
  • Archive
  • Tags

Szołkowski's Blog

Blog about Optimizely CMS development, .NET, and technical content

Posts tagged ‘sql server’

Posts about SQL Server — index maintenance, performance tuning, and database tooling for Optimizely CMS / Commerce projects. Includes a scheduled job for automated index and statistics maintenance.

4 posts · earliest: July 2022 · latest: April 2026

  • April 09, 2026: Running the Optimizely CMS 13 Alloy Site on macOS with Docker

    A working setup for the official Optimizely CMS 13 Alloy template on macOS Apple Silicon using Docker Compose — minimal adjustments, all changes on GitHub.

  • October 08, 2025: Quiet Performance Wins: Scheduled Job for SQL Index Maintenance in Optimizely

    A scheduled job that rebuilds fragmented indexes and refreshes statistics on custom Optimizely CMS tables — quiet wins for query speed and editor happiness.

  • May 26, 2025: Running full Optimizely development setup on M1 (ARM) based machine

    A 2025 revisit: running a full Optimizely Foundation dev setup on Apple Silicon (M1/ARM) — what changed in three years and what still needs workarounds.

  • July 28, 2022: Episerver Foundation on Apple Silicon (M1)!

    How to run Episerver/Optimizely Foundation on an Apple Silicon (M1) Mac with .NET 6, Docker, and azure-sql-edge — a working dev setup walkthrough.

Tags

.NET (6) OptiPowerTools (2) OptiPowerTools.Hangfire (2) apple silicon (3) application insights (1) arm (3) background jobs (4) catalog (3) ci (2) commerce (3) database (3) devops (2) docker (1) dxp (1) episerver (14) github (2) hangfire (4) indexes (1) m1 (3) maintenance (2) memory-optimization (1) nuget (2) open-source (2) optimizely (14) patterns (2) performance (2) pipeline (2) scheduled jobs (7) sonarcloud (1) sonarqube (1) sql server (4) workflow (2)

Stanisław Szołkowski — Optimizely MVP & .NET engineer. More about me →

LinkedIn · GitHub · Optimizely World

Read more articles · Browse by tag · subscribe via RSS

This site uses Google Analytics to understand which posts are useful. No ads, no tracking across other sites. You can decline and the rest of the page works exactly the same.