Logging Schema-changes in a Database using DDL Trigger
/0 Comments/in Miscellaneous, Scripts, Security, Tracing & MonitoringBlocking when missing Permissions – The strange case of the blocked index rebuild
/2 Comments/in Locking & Blocking, Schemas, 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 […]
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 […]
