Enumerate Windows Group Members
Here a quick script showing how to get all the Active Directory users in a AD group.
2017-02-24 (first published: 2016-03-17)
4,279 reads
Active Directory
SQL Authentication Via AD Groups Part II: Who has what access?
In a previous article, we discussed how to liberate the DBA from SQL Logins with AD Groups. A good point was raised: How can the DBA know who has what access? Here is a solution.
2018-08-03 (first published: 2016-02-18)
6,462 reads
Azure Active Directory - Schema Extensions
The Azure Active Directory Graph API enables some interesting scenarios that you can implement in your applications by enabling you to query and manipulate directory objects in Azure AD. In this article, Rick Rainey provides a clear walkthrough of its implementation.
2015-04-03
6,836 reads
How To Get Active Directory Users and Groups Using SQL Server Integration Services SSIS 2005
We would like to update the user, role, and user role tables automatically from Active Directory. Ideally we'd like an SSIS package that we could schedule and/or run on demand to take care of the update. Can you provide an example of how to do this?
2009-01-08
4,369 reads
Blogs
Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)
I am very passionate about having a disaster recovery architecture, plan and strategy. This...
I Presented with Live Captioning and Sign Language Interpreters
I had the pleasure of presenting a full-day pre-conference session on the Friday before...
What's New in SQL 2019? at the Santa Fe SQL Server User Group
By Will Assaf
Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG...
Forums
tempdb shrinking
Hi, Need some quick help here. I am unable to shrink tempdb files. There...
Query to fetch quarter & year from date
Hi, I am having the following query to fetch day & year of a...
Convert column values into single row comma separator
Team My requirement is to convert column values into single row comma separator along...
Ask SSC