Services and Training
SQL Server 路 .NET 路 Azure 路 PowerShell 路 Monitoring 路 Consulting & Training
Practical engineering support for SQL Server and related technologies
I work with existing production environments where availability, predictable operations, and evidence-based decisions matter. My work includes reviewing configurations, diagnosing problems, and preparing actionable recommendations. I also deliver hands-on technical training.
Consulting and assessments
01 路 Performance
SQL Server Health Check & Performance Review
Review SQL Server performance, configuration, and possible bottlenecks.
- Wait statistics, CPU, I/O, and memory
- Query Store, execution plans, and expensive queries
- Indexes, statistics, tempdb, blocking, and deadlocks
Deliverable: a diagnosis with prioritized recommendations.
02 路 High Availability
High Availability & FCI Review
Assess SQL Server availability architecture and operational processes.
- Failover Cluster Instances, Windows Server Failover Clustering, and Availability Groups
- Quorum, storage, networking, service accounts, and patching
- Failover procedures, single points of failure, and operational risks
Deliverable: technical and operational HA recommendations.
03 路 Recovery
Backup, Recovery & Disaster Recovery Assessment
Review whether backup and recovery procedures can meet business recovery requirements.
- FULL, DIFF, and LOG backups; retention and log-chain continuity
- RPO/RTO targets and restore testing
- Integrity checks, recovery scenarios, and monitoring
Deliverable: a recovery plan review and an identified list of gaps and risks.
Hands-on training
The following subjects are covered in the existing Polish training catalogue. Scope, delivery language, schedule, and commercial terms should be agreed for each engagement.
- SQL Server & T-SQL: Fundamentals of T-SQL (5 days), Advanced T-SQL (5 days), SQL Server administration (5 days), SQL Server High Availability & Disaster Recovery (5 days)
- Application development: EF Core Through the Eyes of a DBA (3 days), C# and .NET 10, ASP.NET Core Web API in .NET 10, Azure Cloud Developer
- Administration & observability: IIS on Windows Server 2022 Core, PowerShell automation, Zabbix, and Grafana
Training uses demonstrations, practical laboratories, troubleshooting exercises, and real-world scenarios. Exact agendas and prerequisites depend on the selected course.
How I work
First we establish the technical context, symptoms, metrics, constraints, and expected outcome. Next comes analysis and a prioritized plan. Changes should be validated with evidence rather than assumptions.
For the full course catalogue and detailed Polish descriptions, see the original offer (in Polish).
Discuss your environment or training needs
Share the technology stack, the problem you want to solve, and the expected outcome. We can then discuss an appropriate scope.