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
Full day PreCon Practical Performance Analysis in Melbourne at Asia & Australia Tour 2018
/0 Comments/in Azure, Conferences, HADR, AlwaysOn, Locking & Blocking, Performance, SecurityAs 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
/0 Comments/in Azure, Extended Events, Tracing & MonitoringBeing 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?
/0 Comments/in Patching, Security, Surveys/UmfragenIt 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
/0 Comments/in SecurityIntroduction 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 […]