Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Metadata Rss

Search for any content tagged metadata

   Items 1 to 15 of 15   
 

Generate multiple SSIS packages using BIML and metadata

Although BIML is very powerful, you wouldn’t use it to generate one package at a time. Using metadata, we can generate multiple packages on the fly. Koen Verbeeck illustrates how to convert the BIML script for generating the import package to a dynamic package generating machine.   Read more...
By Additional Articles 2013/12/26 | Source: MSSQLTips.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 2,560 reads

Extended Properties Introduction

Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties  Read more...
By Adam Aspin 2013/09/27 (first published: 2011/03/17) | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 15,029 reads

Merge, Metadata and the Data Mart ETL

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...
By Christopher Ross 2012/12/27 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 4,508 reads

INFORMATION_SCHEMA.101

Get information about the objects in your database using these ANSI standard, multi-platform views.  Read more...
By Tom Powell 2011/10/04 | Source: SQLServerCentral.com | Category: information_schema
Rating: |  Discuss |   Briefcase | 5,737 reads

Industrial-strength database documentation using Extended Properties

To finish this short series on extended properties a look at documenting sets of database objects  Read more...
By Adam Aspin 2011/04/05 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 7,647 reads

Modifying and deleting extended properties

Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties  Read more...
By Adam Aspin 2011/03/29 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 4,390 reads

Extracting Extended Properties

In this second article of a short series we look at using the Extended Properties which you have added to a database  Read more...
By Adam Aspin 2011/03/22 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 6,752 reads

Extended Properties Introduction

Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties  Read more...
By Adam Aspin 2013/09/27 (first published: 2011/03/17) | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 15,029 reads

Simple Metadata

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...
By Steve Jones 2008/12/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 290 reads

Simple Metadata

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...
By Steve Jones 2008/12/14 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 449 reads

Simple Metadata

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...
By Steve Jones 2008/12/14 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 477 reads

Simple Metadata

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...
By Steve Jones 2008/12/14 | Source: SQLServerCentral.com | Category: editorial - mp3
Rating: (not yet rated)  Rate this |   Briefcase | 537 reads

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

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...
By Additional Articles 2008/12/12 | Source: MSSQLTips.com | Category: metadata
Rating:  Rate this |   Briefcase | 3,404 reads

How SSIS and Other Tools Obtain Metadata

How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.  Read more...
By Renato Buda 2008/11/03 | Source: SQLServerCentral.com | Category: fmtonly
Rating: |  Discuss |   Briefcase | 7,280 reads

Searching Objects for Text

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.  Read more...
By Solomon Rutzky 2008/05/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 6,710 reads
   Items 1 to 15 of 15