SQLServerCentral.com Articles tagged Metadata

Merge, Metadata and the Data Mart ETL

Thu, 27 Dec 2012 07:00:00 UT

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

INFORMATION_SCHEMA.101

Tue, 04 Oct 2011 06:00:00 UT

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

Industrial-strength database documentation using Extended Properties

Tue, 05 Apr 2011 06:00:00 UT

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

Modifying and deleting extended properties

Tue, 29 Mar 2011 06:00:00 UT

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

Extracting Extended Properties

Tue, 22 Mar 2011 06:00:00 UT

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

Extended Properties Introduction

Thu, 17 Mar 2011 06:00:00 UT

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

Simple Metadata

Mon, 15 Dec 2008 07:00:00 UT

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.

Simple Metadata

Mon, 15 Dec 2008 00:36:53 UT

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.

Simple Metadata

Mon, 15 Dec 2008 00:27:32 UT

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.

Simple Metadata

Mon, 15 Dec 2008 00:19:51 UT

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.

Using SQL Server meta data to list tables that make up views

Fri, 12 Dec 2008 07:00:00 UT

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?

How SSIS and Other Tools Obtain Metadata

Mon, 03 Nov 2008 07:00:00 UT

How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.

Searching Objects for Text

Wed, 28 May 2008 06:00:00 UT

When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.