Andreas Wolter, SQL Server consultant and trainer, provides expert guidance on server security, high availability, and auditing, helping organizations protect and optimize their database environments.
69 articles from this blog
Announcement and agenda for a full-day SQL Server performance analysis and tuning PreCon workshop at SQLSaturday Istanbul.
Benchmarks comparing the CPU performance overhead of SQL Server Extended Events vs. SQL Trace under high CPU load.
Explores SQL Server privilege escalation from CONTROL SERVER to sysadmin, debunking myths and comparing to Oracle's security model.
Compares file sizes between SQL Server Extended Events and deprecated SQL Trace, finding XML format adds ~29% overhead.
A database expert reflects on the 2013 Frankfurt Database Days conference, comparing SQL Server and Oracle features like isolation levels and security.
A technical guide on using SQL Server Extended Events for tracing and monitoring Analysis Services (SSAS) performance, replacing SQL Profiler.
Analyzes SQL Server locking behavior for tables on READONLY filegroups vs. READONLY databases, debunking common myths.
Author shares personal achievement of earning the Microsoft Certified Master SQL Server 2008 certification, the highest technical certification from Microsoft.
A security vulnerability in SQL Server (2005-2008 R2) allows guest account impersonation to bypass database access controls, with a fix planned for a future version.
