Author Archive for: Andreas Wolter
About Andreas Wolter
Andreas Wolter has been specialized in SQL Server for more than 20 years. He is not only a Microsoft Certified Master (MCM) but also one of two Microsoft Certified Solutions Masters Data Platform (MCSM) in Europe and has been awarded MVP several times.
His company Sarpedon Quality Lab, which offers its services mainly in Europe, the Middle East and Southeast Asia, is focusing on high performing OLTP Systems and big Data Warehouse Architectures with an emphasis on secure deployments.
Entries by Andreas Wolter
Logging Schema-changes in a Database using DDL Trigger
10. December 2020 /0 Comments/in Miscellaneous, Scripts, Security, Tracing & Monitoring /by Andreas WolterPrivilege Escalation to sysadmin via Trustworthy Database setting
30. October 2018 /0 Comments/in Security /by Andreas WolterFarewell to the German PASS association
25. October 2018 /0 Comments/in Conferences, Life, SQLPASS /by Andreas WolterFull day PreCon Practical Performance Analysis in Melbourne at Asia & Australia Tour 2018
16. June 2018 /0 Comments/in Azure, Conferences, HADR, AlwaysOn, Locking & Blocking, Performance, Security /by Andreas WolterAs it has almost become a habit by now for me, I will be touring Asia this summer. This year not only Asia, but for the first time also Australia. (There, however, is winter, which sometimes leads to funny confusion in agreements until you get used to this.) 1st stop: Singapore – Azure SQL Database […]
Tracing with XEvents in Azure SQL Database
30. April 2018 /0 Comments/in Azure, Extended Events, Tracing & Monitoring /by Andreas WolterBeing Developer, Administrator or simply Support for an Azure SQL Database based Application, there are those moments when the Azure-provided Dashboard-capabilities are not sufficient and you need to conduct a throughout trace of certain statements occurring.
Survey: patched for Meltdown & Spectre?
19. January 2018 /0 Comments/in Patching, Security, Surveys/Umfragen /by Andreas WolterIt has been over 4 weeks now that the very serious security bugs named Meltdown and Spectre, affecting almost any CPU made in the last decade, have been publicized and patches have been made available for various systems and software. Some patches even had to be withdrawn and recreated (AMD had not maintained its documentation). In […]
Separation of Duties (SoD) and role-based security conception in SQL Server
7. December 2017 /0 Comments/in Security /by Andreas WolterIntroduction With the upcoming implementation of the European General Data Protection Regulation (GDPR) in May 2018, having a security concept in place is essentially required by law. Microsoft SQL Server, just like other database systems, carries the main asset to protect: the data itself. Therefore, it is time for an article from a more strategic […]