Ozziemedes
Name: Ozziemedes
Score: 11
Last Seen: 186 days, 4 hours, 41 minutes ago
Member Since: 11 January, 2010
SqlServerKudos
atom rss
2
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Mining Metadata

published 196 days, 21 hours, 21 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 201 days, 8 hours, 1 minute ago
Friday, January 15, 2010 10:45:37 PM GMT Monday, January 11, 2010 12:05:55 PM GMT
One thing that I have found especially useful in my career working with databases is keeping up with the structure of metadata available in system databases, and with metadata stored in user database system catalogs. For those of you unfamiliar with the term, metadata is often described as “data about data”.  I prefer a slightly less simplistic explanation: “Metadata describes the format, structure and behaviour of data and code in computer systems.”  The first definition catches situations where metada... (more)
category: Community | clicked: 0 | comment | | source: ozziemedessql.blogspot.com
tags: Definition, Metadata, MSSQL, SQL Server
2
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Metadata Basics – The Great DBA Koan

published 196 days, 21 hours, 21 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 201 days, 7 hours, 57 minutes ago
Friday, January 15, 2010 10:45:37 PM GMT Monday, January 11, 2010 12:10:06 PM GMT
So… you just got your new shiny SQL Server DBA Deputy’s badge, and moved your crap over to a new desk, next to the resident SQL Expert in your office, all keen for the Great Imparting Of Wisdom (GIOW), and he’s handed you a diagram full of coloured regions, annotated boxes and connecting lines.  “First things first, get yourself up to speed with the system catalog for SQL Server,” he says, then turns back to his own screen to fix whatever just got broken for the third time today. About now, many young D... (more)
category: Community | clicked: 1 | comment | | source: ozziemedessql.blogspot.com
tags: Metadata, MSDB, MSSQL, SQL Server, System Catalog, User Schema
2
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Mastering The Metadata: Part 1 (Tables #1)

published 193 days, 21 hours, 10 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 200 days, 3 hours, 27 minutes ago
Monday, January 18, 2010 10:56:27 PM GMT Tuesday, January 12, 2010 4:39:51 PM GMT
In this post, I’m going to outline the core metadata SQL Server 2008 uses for Tables, and how you might be able to use this metadata in a useful manner.  In this post, I’ll only go as far as outlining the potential for using table metadata to discover storage characteristics of the table.  I’ll provide more detailed examples in my next post of how you can put this to work.  Before we begin, a brief history lesson to do some context setting. Once upon a time in the distant past, a relational database... (more)
category: Query | clicked: 5 | comment | | source: ozziemedessql.blogspot.com
tags: Metadata, MSSQL, SQL Server 2008, System Catalog, T-sql