http://ozziemedessql.blogspot.com/
Name: http://ozziemedessql.blogspot.com/
Score: 480.03
Last Seen: 23 days, 18 hours, 5 minutes ago
Member Since: 11 January, 2010
SqlServerKudos
atom rss
1
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Perfect Information vs. Chaos

published 14 days, 5 hours, 42 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 23 days, 18 hours, 5 minutes ago
Saturday, July 17, 2010 2:22:37 PM GMT Thursday, July 08, 2010 2:00:14 AM GMT
Buck Woody recently posted an interesting blog item on the perils of expecting "perfect information" for economic modelling. My response follows. Information can theoretically be perfect, but it's existence relies on the assumption of a completely deterministic (rational) universe. I think we'd all agree that human behaviour is often so complex as to describe it as irrational, so all economic models necessarily have some sort of fuzz factor when you apply them to the real world. Asimov spoke a lot ab... (more)
category: Analysis | clicked: 0 | comment | | source: ozziemedessql.blogspot.com
tags: Chaos Theory, Information Entropy, Perfect Information, The World We Live In, Underlying Assumptions
2
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Three Things That Got Me Here

published 174 days, 19 hours, 44 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 184 days, 4 hours, 50 minutes ago
Sunday, February 07, 2010 12:21:05 AM GMT Thursday, January 28, 2010 3:14:45 PM GMT
I have been tagged by Josef Richberg (@SQLRunner on Twitter) to blog on a meme covered by several SQL Server and .NET professionals since the concept got started around the beginning of January.  Apparently being tagged means I must continue the meme, so… in three movements… here we go. Lego As a kid, my parents bought me a few bits and pieces of Lego.  The first 10 minutes of any session spent with a new Lego kit would be spent following the assembly instructions to create the train, car, castle, et... (more)
category: Community | clicked: 0 | comment | | source: ozziemedessql.blogspot.com
tags: Things That Got Me Here
2
kudos
spam Kudos Remove

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

published 176 days, 19 hours, 50 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 186 days, 4 hours, 46 minutes ago
Friday, February 05, 2010 12:15:12 AM GMT Tuesday, January 26, 2010 3:19:06 PM GMT
n the last Metadata-themed post to my SQL blog, I discussed some of the metadata used to define tables – with particular emphasis on their storage.  I didn’t go deep into what the metadata available in the storage-specific tables describes, but I did give a brief description of their purpose and the kind of information they contain.  Today, I want to focus in more on the logical structure of tables, with a view towards being able to reverse engineer DDL statements to create a copy of the table. I’ve ... (more)
category: Query | clicked: 1 | comment | | source: ozziemedessql.blogspot.com
tags: Catalog Views, SQL 2008, sys.columns, Sys.tables, sys.types, System Catalog
1
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Goals, Themes, Memes and Mayhem

published 187 days, 20 hours, 40 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 197 days, 16 hours, 6 minutes ago
Sunday, January 24, 2010 11:25:16 PM GMT Friday, January 15, 2010 3:59:17 AM GMT
Okay… still not the promised blog entry on doing nifty stuff with table metadata.  Another response to someone else’s blogging.  I just can’t help myself… call me a sucker for the #SQLPASS community, now that I know it exists.  Short, sharp and shiny will this be. There’s a meme for 2010 goal-stating blogs doing the rounds on SQL Server MVP blogs at the moment.  Luminaries such as Brent Ozar (@BrentO), Jeremiah Peschka (@peschkaj), Andy Leonard (@AndyLeonard), Kevin Kline (@kekline),  and a host of othe... (more)
category: Community | clicked: 2 | comment | | source: ozziemedessql.blogspot.com
tags: @GregLow, @Rob_Farley, Goals, MCT, Memes, mvp, SQL Server, Tag, Themes
1
kudos
spam Kudos Remove

Buck Woody : The Database Design Process

published 188 days, 20 hours, 45 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 198 days, 2 hours, 21 minutes ago
Saturday, January 23, 2010 11:20:19 PM GMT Thursday, January 14, 2010 5:44:23 PM GMT
I need your help. I know how I create databases, and I’ve watched a lot of other data professionals follow their own processes for that, but I want to know how YOU do it.   I’ve written about the process I follow for a complete database design on InformIT (use the "Next" button at the bottom of these to see them all). Beyond starting with the business requirements and REALLY hammering that out, here is the general outline I use:   1.      Pull out the nouns from the business requirements (“Client”, “... (more)
category: Community | clicked: 0 | comment | | source: sqlblog.com
tags: @BuckWoody, Data Design, Data Modelling, microsoft, SQLBlog
1
kudos
spam Kudos Remove

Ozziemedes on SQL Server: A Brief Diversion on Database Design

published 188 days, 20 hours, 45 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 198 days, 2 hours, 51 minutes ago
Saturday, January 23, 2010 11:20:19 PM GMT Thursday, January 14, 2010 5:14:13 PM GMT
My promised follow-up on the sys.tables post is still in the skunk works.  I got distracted by an interesting post by Buck Woody of Microsoft over on his Blog on SQLBlog.com.  The questions he posed are as follows: 1. What process do you follow? 2. How important are the business requirements? 3. What tool do you use to create the design, do you need it to diagram, do you even care about diagrams? 4. What’s your biggest pain-point about designing? Not with SQL Server, mind you, just the designing part... (more)
category: Community | clicked: 1 | comment | | source: ozziemedessql.blogspot.com
tags: @BuckWoody, Comment, Data Modelling, Database Design, Process, SQL Server, Tools
2
kudos
spam Kudos Remove

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

published 193 days, 21 hours, 9 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 200 days, 3 hours, 25 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
2
kudos
spam Kudos Remove

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

published 196 days, 21 hours, 19 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 201 days, 7 hours, 55 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: Mining Metadata

published 196 days, 21 hours, 19 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 201 days, 7 hours, 59 minutes 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