Blocking when missing Permissions – The strange case of the blocked index rebuild
/in Locking & Blocking, Schemas, SecurityTime for a new challenge: Senior Program Manager Microsoft SQL Server Security Team
/in Conferences, Security, SeminareFull day PreCon Practical Performance Analysis in Melbourne at Asia & Australia Tour 2018
/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?
/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
/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
/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 […]
One day of “In-Memory Technologies in SQL Server”
/in Conferences, HADR, AlwaysOn, In-Memory OLTP/XTP, HTAP, SecurityIt 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: […]
Where is that Preemptive Wait coming from?
/in Extended Events, In-Memory OLTP/XTP, HTAP, Performance, Security, SQL Server 2016, Tracing & MonitoringIn this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.
