Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Metadata Rss

Search for any content tagged metadata

   Items 1 to 20 of 20   
 

Stairway to Exploring Database Metadata Level 3: Exploring Indexes

This level of the Stairway to Exploring Database Metadata focuses on indexes and all the information you can gather about them.  Read more...
By Phil Factor 2016/09/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 825 reads

Stairway to Exploring Database Metadata Level 2: Using the Dynamic Online Catalog to Solve Problems

In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.  Read more...
By Phil Factor 2016/09/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 992 reads

Stairway to Exploring Database Metadata Level 1: Why Should You Care About the Dynamic Online Catalog?

In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.  Read more...
By Phil Factor 2016/08/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,452 reads

The Mysterious Case of the Missing Default Value

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.  Read more...
Rating: |  Discuss |   Briefcase | 4,239 reads

Dealing with the Evil of FMTONLY from SSRS

SSRS continues to use SET FMTONLY ON even though it has many problems. How can we cope?  Read more...
By David Rueter 2014/12/23 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 4,322 reads

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,965 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,446 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,558 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,770 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,814 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,591 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 | 7,055 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,446 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 | 313 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 | 579 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 | 603 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 | 658 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,728 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,375 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,792 reads
   Items 1 to 20 of 20