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

Content with tag Metadata Rss

   Items 1 to 20 of 28    Older >>
 

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,358 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 | 14,699 reads

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED

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...
By Chris Morton 2013/01/08 | Source: SQLServerCentral.com | Category: autogenerate parameters
Rating: |  Discuss |   Briefcase | 3,008 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,479 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,721 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,523 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,292 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,592 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 | 14,699 reads

List all Columns in Server Part 2

Generates a list of Server, Database, Table , Column Names and properties  Read more...
By shanu hoosen 2011/02/08 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 1,304 reads

Object Explore

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...
By Robin van Schaik 2010/08/24 | Source: SQLServerCentral.com | Category: data exploration
Rating: |  Discuss |   Briefcase | 1,022 reads

Encrypt All Stored procedures at once

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...
By Chris Morton 2009/09/10 | Source: SQLServerCentral.com | Category: with encryption
Rating: |  Discuss |   Briefcase | 3,179 reads

Table Index Store and Create

Query to save all index metadata  Read more...
By Jorge Novo-@ETLDEVDBA 2009/07/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 849 reads

Loop Through every table in a DB

This Script has been build to list all the tables in a database without using a cursor.   Read more...
By Chris Morton 2009/01/20 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 1,996 reads

Truncate Referenced Table

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...
By Chris Morton 2009/01/19 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,241 reads

search every database on server from a single sp

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...
By Chris Morton 2008/12/19 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 948 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 | 282 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 | 425 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 | 442 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 | 506 reads
   Items 1 to 20 of 28    Older >>
 
Tags
extended properties (4)    
sqlservercentral (4)    
stored procedures (4)    
tagging (4)    
chris morton (2)    
codrakon (2)    
dynamic sql (2)    
foreign keys (fk) (2)    
insert (2)    
integration services (ssis) (2)    
select (2)    
update (2)    
alter table (1)    
autogenerate (1)    
autogenerate parameters (1)    
biml (1)    
business intelligence (1)    
columns (1)    
data exploration (1)    
data mart (1)    
databases (1)    
delete (1)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
empty columns (1)    
encryption (1)    
etl (1)    
execute  statement (1)    
fmtonly (1)    
indexing (1)    
information_schema (1)    
kurtosis (1)    
loop (1)    
master database (1)    
merge (1)    
metrics (1)    
object_id (1)    
parameters (1)    
quartiles (1)    
range (1)    
redundant columns (1)    
referenced tables (1)    
relationship (1)    
remove empty columns (1)    
remove redundant columns (1)    
search (1)    
skew (1)    
sql server 2005 (1)    
sql server 7 (1)    
standard deviation (1)    
statistics (1)    
sysobjects (1)    
table (1)    
temp tables (1)    
temporary tables (1)    
truncate table (1)    
t-sql (1)    
user (1)    
views (1)    
while loop (1)    
with encryption (1)