Introduction 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 […]
Since SQL Server 2005, the server wide permission CONTROL SERVER has been existing. In principle being an alternative to sysadmin-membership, it did not turn out to be much more than a shelf warmer. – Little known and even less used. One of the main reasons for this was the absence of an option to grant […]
Almost a year ago I discovered an issue with SQL Server (all Versions from 2005 – 2008 R2, haven’t tested 2000) regarding the usage of the guest-account and impersonation. It also was presented by Ralf Dietrich and me at the SQL Server PASS Summit 2009 in Seattle where we informed Microsoft about it. – Thanks […]
1 day Practical SQL Server Performance Analysis at SQLSaturday Melbourne on 29 June.
Azure Community Singapore (ACS) on 25 June.
Presentation: Azure SQL Database Managed Instance – The Better Alternative to Azure SQL Database or SQL Server in a VM?