Posts
Using Extended Events for Tracing SQL Server and Azure SQL DB in compliance with Principle of Least Privilege – Example role separation
/0 Comments/in Extended Events, Security, Tracing & MonitoringMy 7 wishes for access control in SQL Server and Azure SQL security
/1 Comment/in Miscellaneous, SecurityTime for a new challenge: Senior Program Manager Microsoft SQL Server Security Team
/0 Comments/in Conferences, Security, SeminareFull 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 […]
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 […]
The No Good, Terrible Processor Flaw and SQL Server Deployments
/0 Comments/in Patching, SecurityYou can find this article by Allan Hirt at its original location: http://sqlha.com/2018/01/04/no-good-terrible-processor-flaw-sql-server-deployments-nearly-everything-need-know/
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 […]
Sarpedon Quality Lab presenting SQL Server 2016 In-Memory and Security Features in Arabia at SQL Gulf 3
/in Columnstore Index, Conferences, In-Memory OLTP/XTP, HTAP, Security, SQL Server 2016مرحبا (“MARR-hah-bah”, Arabic: Hello) This year takes me to yet another part of the world: I have been invited to speak at THE SQL Server Conference in the Middle East: at SQL Gulf 3 taking place in Riyadh, Saudi Arabia on April 23rd.
Sessions submitted for major conferences 2016. Topics: Security – Performance – In-Memory
/in Conferences, Extended Events, In-Memory OLTP/XTP, HTAP, Performance, Security, SQL Server 2016, SQLPASS, Tracing & MonitoringAfter the great success of the German SQLKonferenz in February, where I had the honor of presenting the new security features of SQL Server 2016 together with Joachim Hammer, the Program Manager of the security teams of the relational SQL Engines at Microsoft in Redmond (more info), I finally found time to go about the […]