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,815 reads
Use Powershell to query AD for Users, Groups and GroupMembers
2019-09-19 (first published: 2016-03-31)
29,815 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
16,225 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)
7,858 reads
Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.
2016-03-07
4,055 reads
2014-08-13
2,013 reads
How to reverse engineer or script a trace for disaster recovery, or simply scripting for enhance and adjustment.
2010-03-23
2,015 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)
817 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,770 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)
886 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,244 reads
By Daniel Janik
The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...
By Chris Yates
In today’s data-driven economy, organizations are no longer asking if they should invest in...
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Life's Little Frustrations
Comments posted to this topic are about the item When INCLUDE Columns Quietly Inflate...
I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge (CustomerID INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) ) GOIf I check the columns_updated() function return in a trigger, what is the data returned? See possible answers