http://ozziemedessql.blogspot.com/

http://ozziemedessql.blogspot.com/
Name: http://ozziemedessql.blogspot.com/
Score: 720.04
Last Seen: 639 days, 33 minutes ago
Member Since: 11 January, 2010
SqlServerKudos
atom rss
1
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Data Infrastructure Architecture [2/2]
published 629 days, 15 hours, 5 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 639 days, 33 minutes ago
Wednesday, September 01, 2010 5:38:20 PM GMT Monday, August 23, 2010 8:10:05 AM GMT
Ozziemedes on SQL Server: Data Infrastructure Architecture [2/2]
Yesterday I wrote a fairly long blog post which started to delve into some of the questions addressed by data infrastructure architecture.  After writing more than 2000 words I decided it was time to give you all a break and for me to have some time away from the keyboard. So here’s the second instalment in which I’ll outline the remaining concerns for the data infrastructure components of data architecture.Data platform performance management One of the key success factors for a stable DBMS is that it... (more)
category: Community | clicked: 0 | comment | | source: ozziemedessql.blogspot.com
tags: Data Architecture, Infrastructure, licensing, Performance, Security, SQL Server
1
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Data Infrastructure Architecture [1/2]
published 630 days, 15 hours, 10 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 639 days, 22 hours, 15 minutes ago
Tuesday, August 31, 2010 5:33:23 PM GMT Sunday, August 22, 2010 10:28:33 AM GMT
Ozziemedes on SQL Server: Data Infrastructure Architecture [1/2]
Yesterday I wrote a blog defining Data Architecture as a field of endeavour.  Today’s entries is the first of several that will drill down into the individual concerns that data architecture addresses.  I’m going to start with Database Infrastructure Architecture, as it probably has the fewest dependencies on other areas of data architecture.Defining The Challenge What is database infrastructure architecture?  The short answer is that it’s all about the platform, and not about the content.  Database inf... (more)
category: Community | clicked: 1 | comment | | source: ozziemedessql.blogspot.com
tags: Data Architecture, Data Platform Architecture, Infrastructure, Service Delivery, System Design
1
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Data Architecture Defined
published 630 days, 15 hours, 10 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 640 days, 13 hours, 43 minutes ago
Tuesday, August 31, 2010 5:33:23 PM GMT Saturday, August 21, 2010 7:00:31 PM GMT
Ozziemedes on SQL Server: Data Architecture Defined
Over the last few weeks I’ve been working with the PASS organization to start up a SQL Server Data Architecture Virtual Chapter (or “DArcVC” as it is starting to be known).  Data Architecture has basically been my job for the last 12 years.  I may have been paid as a DBA, or SQL developer, or BI consultant, or Microsoft Application Solutions consultant, but at the end of the day, what I’ve DONE in all of those roles has really revolved around data architecture. For those of you not familiar with what da... (more)
category: Community | clicked: 0 | comment | | source: ozziemedessql.blogspot.com
tags: Data, Data Architecture, Information, Insight, knowledge, SQL Server
1
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Musings on Good Data Architecture
published 640 days, 15 hours, 49 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 650 days, 10 hours, 37 minutes ago
Saturday, August 21, 2010 4:53:56 PM GMT Wednesday, August 11, 2010 10:06:23 PM GMT
Ozziemedes on SQL Server: Musings on Good Data Architecture
I was at a user group meeting tonight where a couple of developers were presenting on Entity Spaces.  It was interesting to see the tool in action, but I can’t help but feel a little cautious about the kind of strong typing that’s going on in the myriad of class files that are getting built by the code generation framework.  To me, it seems risky from a complexity perspective.  In my opinion, a good ORM should be able to abstract the schema from the object-level implementation and provide a software-fa... (more)
category: Community | clicked: 4 | comment | | source: ozziemedessql.blogspot.com
tags: Archtiecture, Data Architecture, Entity Spaces, ORM, SQL Server, sqlpass
1
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Perfect Information vs. Chaos
published 675 days, 18 hours, 21 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 685 days, 6 hours, 43 minutes ago
Saturday, July 17, 2010 2:22:37 PM GMT Thursday, July 08, 2010 2:00:14 AM GMT
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
spam Kudos Remove

Ozziemedes on SQL Server: Three Things That Got Me Here
published 836 days, 8 hours, 22 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 845 days, 17 hours, 29 minutes ago
Sunday, February 07, 2010 12:21:05 AM GMT Thursday, January 28, 2010 3:14:45 PM GMT
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
spam Kudos Remove

Ozziemedes on SQL Server: Mastering the Metadata Part 1 (Tables #2)
published 838 days, 8 hours, 28 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 847 days, 17 hours, 24 minutes ago
Friday, February 05, 2010 12:15:12 AM GMT Tuesday, January 26, 2010 3:19:06 PM GMT
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
spam Kudos Remove

Ozziemedes on SQL Server: Goals, Themes, Memes and Mayhem
published 849 days, 9 hours, 18 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 859 days, 4 hours, 44 minutes ago
Sunday, January 24, 2010 11:25:16 PM GMT Friday, January 15, 2010 3:59:17 AM GMT
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: 4 | 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 850 days, 9 hours, 23 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 859 days, 14 hours, 59 minutes ago
Saturday, January 23, 2010 11:20:19 PM GMT Thursday, January 14, 2010 5:44:23 PM GMT
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
spam Kudos Remove

Ozziemedes on SQL Server: A Brief Diversion on Database Design
published 850 days, 9 hours, 23 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 859 days, 15 hours, 29 minutes ago
Saturday, January 23, 2010 11:20:19 PM GMT Thursday, January 14, 2010 5:14:13 PM GMT
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
spam Kudos Remove

Ozziemedes on SQL Server: Mastering The Metadata: Part 1 (Tables #1)
published 855 days, 9 hours, 47 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 861 days, 16 hours, 3 minutes ago
Monday, January 18, 2010 10:56:27 PM GMT Tuesday, January 12, 2010 4:39:51 PM GMT
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
spam Kudos Remove

Ozziemedes on SQL Server: Metadata Basics – The Great DBA Koan
published 858 days, 9 hours, 58 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 862 days, 20 hours, 33 minutes ago
Friday, January 15, 2010 10:45:37 PM GMT Monday, January 11, 2010 12:10:06 PM GMT
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: 2 | 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 858 days, 9 hours, 58 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 862 days, 20 hours, 37 minutes ago
Friday, January 15, 2010 10:45:37 PM GMT Monday, January 11, 2010 12:05:55 PM GMT
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