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.
76 articles from this blog
Analysis of the Meltdown/Spectre processor flaws and their critical impact on SQL Server deployments, security, and performance.
Explains implementing Separation of Duties and role-based security in SQL Server for data protection, focusing on Least Privilege principles.
Benchmarking SQL Server cluster sizes on SSDs to determine if 64K allocation units are still optimal under various RAID configurations.
Explores performance challenges when using SQL Server's In-Memory and Natively Compiled Objects, showing they don't always provide expected speed gains.
A deep dive into SQL Server's In-Memory technologies, including Columnstore Indexes and In-Memory OLTP, presented at a tech conference.
A deep dive into troubleshooting performance issues with SQL Server's natively compiled stored procedures, focusing on unexpected preemptive waits and memory contention.
A speaker's reflections on the key factors that define a successful tech conference, based on experience attending and presenting at over 50 events worldwide.
Explores SQL Server 2016's In-Memory OLTP enhancements, including new constraints, encryption, and operational analytics capabilities.
Announcement and feature breakdown of SQL Server 2016 general availability, highlighting new security, performance, and edition-specific capabilities.
Announcement of Sarpedon Quality Lab presenting sessions on SQL Server 2016's In-Memory capabilities and new Security features at the SQL Gulf 3 conference in Riyadh.
A guide to SQL Server schema design focusing on security best practices, moving beyond the default dbo schema for better access control.
A database professional's travelogue of speaking at SQL Server and tech conferences across Asia, Europe, and America in late 2015.
Explains the hierarchy and value of retired high-level Microsoft certifications like MCM, MCSM, and MVP, detailing their exams and legacy.
Discusses critical SQL Server security patches (MS15-058) and emphasizes the importance of following security best practices like least-privilege access.
Overview of SQL Server 2016's key security and performance features, including Always Encrypted, Stretch Database, and real-time analytics.
Explains how to optimize SQL Server performance and reduce costs on Microsoft Azure using flexible IaaS configurations and storage strategies.
A technical guide on using SQL Server Extended Events to capture, import, and parse deadlock graphs for analysis and troubleshooting.
Announcing a free, open-source tool for collecting and parsing SQL Server deadlock graphs from system memory, aiding administrators and developers.
Survey results on SQL Server database ownership reveal security risks, with recommendations for best practices and secure configurations.
Explains new SQL Server 2014 permissions like IMPERSONATE ANY LOGIN and how they interact with CONTROL SERVER for security and privilege escalation.
