Skip to main content
  • About
  • Archive
  • Tags

Szołkowski's Blog

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

Posts tagged ‘database’

Posts about databases for Optimizely projects — SQL Server index and statistics maintenance, scheduled cleanup jobs, and tooling for routine DBA work.

3 posts · earliest: September 2025 · 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.

  • September 04, 2025: How to automatically remove orphaned Opti jobs from the DB

    Automate cleanup of orphaned Optimizely scheduled jobs left behind in tblScheduledItem — a small scheduled job that keeps your CMS database tidy at startup.

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.