SQL Clone
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 31    Older >>
 

Developing Metadata Design Patterns in BIML

You may have already experienced ETL Hell, where you have a large number of similar of SSIS tasks, and a small change, such as an alteration to the network topology, means that they all need to be altered with the correct connection details. Perhaps you should consider creating design patterns for all the standard components of integration tasks in BIML, and generating the SSIS packages from these? Amarendra walks you through the process.  Read more...
By Additional Articles 2017/08/04 | Source: SimpleTalk | Category: biml
Rating:  Rate this |   Briefcase | 3,850 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...
By Raul Gonzalez @SQLDoubleG 2017/03/24 (first published: 2015/12/01) | Source: SQLServerCentral.com | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,535 reads

SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.   Read more...
By Phil Factor 2017/02/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 870 reads

Using Power BI Desktop to Visualize SQL Server Metadata

You can easily use PowerBI Desktop to show graphically how your database is growing, which tables are taking the most space, how various parts of SQL Server is consuming memory, its use of indexes and so on. Sure, you can create graphs in SSMS, but with PowerBI, you can create reports that you can then publish to others, and which allow drill-down. It is a great way to get familiar with PowerBI Desktop as well. Rob Sheldon shows how simple it is to do.  Read more...
By Additional Articles 2017/01/16 | Source: SimpleTalk | Category: power bi desktop
Rating: (not yet rated)  Rate this |   Briefcase | 3,520 reads

Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6

Idempotence is the property of certain operations in mathematics and computer science, that can be applied multiple times without changing the result beyond the first time they are run. When you are making changes to a database to deploy a new version, you need to be sure that certain changes aren’t made twice, or in the wrong order.  Read more...
By Phil Factor 2016/12/21 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 949 reads

Exploring Facts About SQL Server Tables: Stairway to Exploring Database Metadata Level 5

Now that we've explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.  Read more...
By Phil Factor 2016/12/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,212 reads

Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3

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 | 1,596 reads

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

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 | 1,278 reads

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

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 | 2,330 reads

SQL Server Metadata Functions: The Basics

To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article.  Read more...
By Additional Articles 2016/03/28 | Source: SimpleTalk | Category: metadata
Rating: (not yet rated)  Rate this |   Briefcase | 6,512 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...
By Raul Gonzalez @SQLDoubleG 2017/03/24 (first published: 2015/12/01) | Source: SQLServerCentral.com | Category: sql server internal storage
Rating: |  Discuss |   Briefcase | 5,535 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,362 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 | 3,128 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,501 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,567 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,781 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,830 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,650 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,165 reads
   Items 1 to 20 of 31    Older >>