gMSA and SSL in SQL, a true journey

Info Lately when I set up a Microsoft SQL server I’ll always implement SSL and a gMSA account to run SQL from. Why? Convince yourself reading this blog post. Because this post focuses on a specific issue, I’ll not explain implementing SSL as such. Here’s the Microsoft documentation I follow for my implementations: https://support.microsoft.com/en-us/help/316898/how-to-enable-ssl-encryption-for-an-instance-of-sql-server-by-using-mi This …

Continue reading "gMSA and SSL in SQL, a true journey" »

New and preview Azure AD features for Office 365 and Premium Licensing

Since Ignite 2017 last September, we got to have more insight in new features coming to Azure Active Directory. Some (most) of them require a Azure AD premium P1 license, commonly bought in the license pack EMS P1 (Enterprise Mobility + Security). It is my and other colleagues experience that Microsoft is currently not technically …

Continue reading "New and preview Azure AD features for Office 365 and Premium Licensing" »

How to prevent man in the middle SQL injection attacks

As a SQL engineer with an interest in security I’m convinced that security is a concept that should be implemented throughout an organization. Just placing a (properly configured) firewall and forcing password policies doesn’t suffice. In light of that last statement I wondered whether or not it was possible to gain access to a MS …

Continue reading "How to prevent man in the middle SQL injection attacks" »

SCDPM 2016 VM restore troubles

Some time ago I’ve installed SCDPM 2016 and configured the backups jobs. All was going well, until we tried to restore a a test VM… I was able to restore the files on disk, copy the files to the Hyper-V cluster and import the VM again. Not really the ideal situation… When restoring the VM …

Continue reading "SCDPM 2016 VM restore troubles" »

SCVMM 2016 – vSwitch Compliancy

Hi Everyone!   First of all, my best wishes for the new year! I hope 2018 will bring you everything your hearts desire   My post today is about an issue I encountered several months ago with SCVMM 2016 and Hyper-V 2016. When creating a logical vSwitch in SCVMM and pushing it to the Hyper-V …

Continue reading "SCVMM 2016 – vSwitch Compliancy" »