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)
23,930 reads
Use Powershell to query AD for Users, Groups and GroupMembers
2019-09-19 (first published: 2016-03-31)
23,930 reads
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
14,562 reads
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)
5,847 reads
Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.
2016-03-07
3,156 reads
2014-08-13
2,002 reads
How to reverse engineer or script a trace for disaster recovery, or simply scripting for enhance and adjustment.
2010-03-23
1,879 reads
a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.
2009-07-28 (first published: 2009-07-11)
783 reads
returns CREATE TABLE script for any table. including schema name,calculated columns,
indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.
2009-07-11
1,595 reads
Find And Replace any string, in the entire table with this function. Parameterized for easy use.
2009-02-26 (first published: 2009-02-09)
878 reads
The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.
2009-02-25 (first published: 2009-02-07)
1,227 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
backup log to int run every hour. If a log init backup is run...
Comments posted to this topic are about the item Speakers Are Normal People