How to use fn_builtin_permissions SQL Server Security Function

Learn how to find all securable objects in SQL Server and the permissions for each securable object using the system function fn_builtin_permissions.

Reducing Debt and Increasing Security

DevOps is often thought of as bringing more features to customers, but it can also help security.

SQL Server vs Oracle: Data Masking

In this article, we look at how to mask/hide data for users using Dynamic Data Masking in SQL Server and Data Redaction in Oracle

How to grant PowerBI Service Workspace access using PowerShell

Learn how to more easily manage permissions in the Power BI service using PowerShell.

Creating AAD Users in Azure SQL Database

SQL Server vulnerabilities and assessment

SQL Server has many features to keep the database secure, but you must implement them to benefit. In this article, Priyanka Chouhan describes how to do a vulnerability assessment of SQL Server.

Project Zero for Better Security

Project Zero from Google aims to study zero day vulnerabilities. Steve hopes it leads to better security.

Creating Azure SQL Databases

Advanced Incident Response

Having a known and documented incident response plan is important these days, as more and more companies are having security incidents.

Would You Want to be on the Red Team?

A red team might be a fun job for some, but not for Steve.