Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

Database Refresh Sync

Sync users and roles after restore/refresh

The Proliferation of Roles

Using roles for security is a best practice that Steve Jones espouses.

What Kind of DBA Are You?

Are you a do-it-all DBA, or do you specialize in one aspect of database work?

Changing roles

Move DB roles

This script will script the role members for all roles on the database.

Data Mining Part 23: Security

In this chapter we will talk about security recommendations for SQL Server Data Mining.

Data Mining Part 23: Security

In this chapter we will talk about security recommendations for SQL Server Data Mining.

View My Definition

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.