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.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

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.