security

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2020-06-30

6,511 reads

External Article

SQL Server Machine Learning 2019: Working with Security Changes

  • Article

SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was released, Microsoft enhanced the security for this functionality, but it caused some existing code writing to the file system to to break. In this article, Dennes Torres explains the security enhancement and describes three ways to work with it.

2020-03-11

Blogs

Simple Talks Episode 9–Data masking and subsetting

By

The episode on data masking and subetting is out. You can see it here:...

T-SQL Tuesday #180: Avoid Perfect for Good Enough

By

I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...

Book Review – Humanizing Data Strategy by Tiankai Feng

By

This book was making its rounds on social media, and the concept seems interesting...

Read the latest Blogs

Forums

Moss Trim Gummies zur Gewichtsabnahme: Eine umfassende Übersicht

By mosstrimgummies

Moss Trim Gummies sind eine köstliche und praktische Möglichkeit, Ihre Gesundheit und Ihr Wohlbefinden...

DBATools in a agent job

By tuokek

Hi Dbatools is used to copy table data from domain a to domain b...

SQL server help (converting rows to columns)

By don075

I am using the following sql to convert rows into columns for each pid,...

Visit the forum

Question of the Day

The Hash Join I

What are the two inputs called to a hash join operation in SQL Server? (choose 2)

See possible answers