Author Archive for: Andreas Wolter
About Andreas Wolter
Andreas Wolter has been specialized in SQL Server for more than 16 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
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 […]
Optimal Cluster sizes for SQL Server on SSDs – are 64K still important?
20. November 2017 /0 Comments/in Performance, Storage Engine /by Andreas WolterLately, with the advance of SSDs, more and more administrators are wondering: Is the old rule to use a 64K Cluster size (aka “File Allocation Unit size”) for SQL Server still applicable on today’s hard drives, especially SSDs or even Flash? And: Does it apply to all RAID-types equally? This summer I took some time […]
Optimizing workflows with In-Memory and Natively Compiled Objects – or how it does not work
9. August 2017 /0 Comments/in In-Memory OLTP/XTP, HTAP, Locking & Blocking, Performance, SQL Server 2016, Storage Engine /by Andreas WolterDuring the course of optimizing data-access-code with the In-Memory-functionalities in Microsoft SQL Server (memory optimized tables + indexes, memory optimized table valued parameters and natively compiled stored procedures), you may often realize that sometimes you go one step forward and then another one backwards.
One day of “In-Memory Technologies in SQL Server”
11. July 2017 in Conferences, HADR, AlwaysOn, In-Memory OLTP/XTP, HTAP, Security /by Andreas WolterIt is no secret that I have been very active in the Asian region the last years – mainly in Singapore, Malaysia and India. So, it may not be a surprise that this summer I will be giving a full day PreCon at the now called “Data Platform Summit” in India’s hub for information technology: […]
The new SQL Server Master-Class in – why SQLSentry Bootcamp
2. May 2017 /0 Comments/in Extended Events, Seminare, Tracing & Monitoring /by Andreas WolterFirst off, the most important information in a nutshell: From 26-28 June, I am conducting a new SQL Server Master-Class: The Performance Troubleshooting Bootcamp with SQLSentry (shorthand: PSS*). For those in a hurry, the link for registration right below: http://sql-server-master-class.com/#PSS