Security

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

  • Article

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.

5 (2)

2020-06-30

4,145 reads

Jumping Air Gaps

  • Editorial

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 […]

5 (1)

2020-05-27

73 reads

Blogs

When do Statistics get updated?

By

Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...

Power BI: Making Date & Time Keys

By

Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...

Daily Coping 18 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Intermittent "nesting level exceeded" error

By julian.fletcher

We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...

Selecting last 6 months

By sqlErik

Hi, I need to select rows from the last 6 months prior to the...

Nested loop/HashJoin and left/right/full join

By 892717952

1. What is the difference among nested loop?hash join and merge join? 2. what...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers