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.
19 Artikel from this blog
A farewell message from a long-time member and speaker of the German PASS association, reflecting on community contributions and announcing a move to the Microsoft SQL Server security team.
An announcement for a SQL Server Master-Class on performance troubleshooting using SQLSentry tools, scheduled for late June.
SQL Server 2016 SP1 removes programming feature limits across editions, making features like In-Memory OLTP and Columnstore available to Standard and Express.
A comprehensive cheat sheet and compatibility matrix for SQL Server index types, including new types from SQL Server 2012 to 2016, available as a downloadable PDF.
Overview of new features in SQL Server 2016 Reporting Services, including Mobile Reports, a modern Web Portal, and custom branding.
An overview of SQL Server 2016 sessions submitted for major conferences, focusing on Security, Performance, and In-Memory technologies.
A SQL Server expert's 2015 conference speaking engagements covering Extended Events, In-Memory OLTP, security, and Azure deployments.
Author celebrates receiving their second Microsoft MVP award for SQL Server, highlighting contributions to the SQL community and PASS.
Overview of key Microsoft and SQL Server conferences in late 2014, including speaker sessions on SQL Server 2014, Reporting Services, and upcoming features.
Explains how SQL Server's Management Data Warehouse (MDW) works with AlwaysOn Availability Groups for performance monitoring, including setup considerations and data collection behavior.
Corrections and clarifications for the iX magazine article on SQL Server 2014's In-Memory OLTP, ColumnStore, and AlwaysOn features.
Author announces achieving the Microsoft Certified Solutions Master (MCSM) Data Platform certification for SQL Server 2012, detailing the exam process.
A survey and T-SQL script for analyzing SQL Server database owners, critical permissions, and role memberships to identify security risks.
Author explains why they don't publicly share SQL Server hacking demo scripts, focusing on security awareness over providing attack tools.
A technical comparison of Extended Events and SQL Trace in SQL Server, explaining why the older Profiler tool is obsolete.
Discusses the final opportunity to earn the Microsoft Certified Master (MCM) SQL Server certification before its retirement at the end of 2013.
A technical session exploring various SQL Server attack scenarios, including SQL injection, privilege escalation, and DoS attacks, focusing on misconfigurations and security weaknesses.
A survey asking SQL Server professionals which tracing and analysis tools they use for performance monitoring and logging.
Andreas Wolter presents two technical sessions at SQLCon 2011 on SQL Server security for developers and centralized Reporting Services design.
