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.

Jumping Air Gaps

There are all sorts of viruses, worms, and malware out in the world, and some of us have had to deal with them at different points in our career. SQL Slammer was particularly memorable for me, but there were plenty of non data related virus issues I've had to work on at various employers. To […]

Defending Against Ransomware

Many more companies that you have heard about have been attacked by ransomware. Steve suggests you get prepared before this happens to you.

Remote Data Challenges

While working remotely, we still need good security practices and strong data protection.

A Security Regression

Marriott has had another security breach. Does this mean they aren't taking security seriously? Steve has a few thoughts.

Mongodb Encryption

MongoDB adds encryption to protect data from the DBA.

BYOD Fingerprint Concerns

Fingerprints provide some security, but a research suggests not necessarily much. Steve has a few thoughts.

Don't Lose Data Without a Hacker

Data loss shouldn't come from simple misconfiguration. As Steve notes, if no hacking is involved, you shouldn't lose data.

The Original Database

Is 100% Security Possible?

A security breach at Microsoft is disconcerting, especially when they don't share details.