I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database  Read more...

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...

Get information about the objects in your database using these ANSI standard, multi-platform views.  Read more...

To finish this short series on extended properties a look at documenting sets of database objects  Read more...

Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties  Read more...

In this second article of a short series we look at using the Extended Properties which you have added to a database  Read more...

Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties  Read more...

Generates a list of Server, Database, Table , Column Names and properties  Read more...

summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.  Read more...

this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.   Read more...

Query to save all index metadata  Read more...

This Script has been build to list all the tables in a database without using a cursor.   Read more...

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.  Read more...

i have recently had the need to search the every database on the server for a particular string. i came up with this... it has lots of room for improvement but it works  Read more...

Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.  Read more...

Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.  Read more...

Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.  Read more...

Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.  Read more...

One of the issues I often face is the need to find views that are already established for certain tables. This maybe for other developers, end users or even for myself. I could search the system tables to find this or explore each view, but are there other ways to easily find a list of all tables that are used for a view or even a list of all views that a table is tied to?  Read more...

this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.   Read more...