PowerShell To Get Active Directory Users And Groups into SQL

Use Powershell to query AD for Users, Groups and GroupMembers

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.

Enumerate Windows Group Members

Here a quick script showing how to get all the Active Directory users in a AD group.

Deep Dive into Changing Database Collation

Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.

sp_rename and the procedure definition

Reverse Engineering a Server Side Trace

How to reverse engineer or script a trace for disaster recovery, or simply scripting for enhance and adjustment.

Get DDL for any SQL 2000 table

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.

Get DDL for any SQL 2005 table

returns CREATE TABLE script for any table. including schema name,calculated columns,
indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.

TEXT/NTEXT Find and Replace

Find And Replace any string, in the entire table with this function. Parameterized for easy use.

Default Trace Load of All 5 Files

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.