SqlServerKudos

1
kudos

Kudos

Ozziemedes on SQL Server: Perfect Information vs. Chaos

published 14 days, 5 hours, 42 minutes ago posted by

http://ozziemedessql.blogspot.com/ 23 days, 18 hours, 5 minutes ago

Ozziemedes on SQL Server: Perfect Information vs. Chaos

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

Kudos

Ozziemedes on SQL Server: Three Things That Got Me Here

published 174 days, 19 hours, 44 minutes ago posted by

http://ozziemedessql.blogspot.com/ 184 days, 4 hours, 50 minutes ago

Ozziemedes on SQL Server: Three Things That Got Me Here

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

Kudos

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/ 186 days, 4 hours, 46 minutes ago

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

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

Kudos

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

published 187 days, 20 hours, 40 minutes ago posted by

http://ozziemedessql.blogspot.com/ 197 days, 16 hours, 6 minutes ago

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

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

Kudos

Buck Woody : The Database Design Process

published 188 days, 20 hours, 45 minutes ago posted by

http://ozziemedessql.blogspot.com/ 198 days, 2 hours, 21 minutes ago

Buck Woody : The Database Design Process

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

Kudos

Ozziemedes on SQL Server: A Brief Diversion on Database Design

published 188 days, 20 hours, 45 minutes ago posted by

http://ozziemedessql.blogspot.com/ 198 days, 2 hours, 51 minutes ago

Ozziemedes on SQL Server: A Brief Diversion on Database Design

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

Kudos

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/ 200 days, 3 hours, 25 minutes ago

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

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

Kudos

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

published 196 days, 21 hours, 19 minutes ago posted by

http://ozziemedessql.blogspot.com/ 201 days, 7 hours, 55 minutes ago

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

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

Kudos

Ozziemedes on SQL Server: Mining Metadata

published 196 days, 21 hours, 19 minutes ago posted by

http://ozziemedessql.blogspot.com/ 201 days, 7 hours, 59 minutes ago

Ozziemedes on SQL Server: Mining Metadata

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

Welcome!

http://ozziemedessql.blogspot.com/

Ozziemedes on SQL Server: Perfect Information vs. Chaos

Ozziemedes on SQL Server: Three Things That Got Me Here

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

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

Buck Woody : The Database Design Process

Ozziemedes on SQL Server: A Brief Diversion on Database Design

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

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

Ozziemedes on SQL Server: Mining Metadata

Open ID Login

Standard Login

Forgot Password?

Sign up