PowerShell To Get Active Directory Users And Groups into SQL
Use Powershell to query AD for Users, Groups and GroupMembers
2019-09-19 (first published: 2016-03-31)
29,412 reads
Lowell Izaguirre
Create Table DDL via TSQL
A stored procedure from longtime community member Lowell Izaguirre, returns the CREATE TABLE definition for any table, including PK, UQ, Identity, FK, Defaults, and more.
2019-04-16
15,995 reads
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)
7,439 reads
Deep Dive into Changing Database Collation
Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.
2016-03-07
3,951 reads
Reverse Engineering a Server Side Trace
How to reverse engineer or script a trace for disaster recovery, or simply scripting for enhance and adjustment.
2010-03-23
2,007 reads
Blogs
Who are you? Building an identity map.
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Call a Fabric REST API from Azure Data Factory
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
Forums
How to update a history table with changes.
Good morning to all. I am a novice when it comes to SQL so...
How to check if credential password for TDE matches the secret key of Key Vault
Hi all, In my company we have many databases encrypted with TDE and there...
Create Raw Zone Tables using Generative AI: Data Engineering with Fabric
Comments posted to this topic are about the item Create Raw Zone Tables using...
Question of the Day
Replacing a NULL II
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers