It’s 5:47AM and two things woke me up. The dogs at the dairy next door. Like clockwork except driven by the sun and not adjusted for human convenience. Rumour has it that no “foreign” non-Homo sapien has ever made it half way down the drive-way.
Read more →
After my series on implementing relational operators on.NET DataTables, I received several requests to post the whole code library. I was reluctant to do it for 2 reasons 1.
Read more →
I thought I would pimp my latest article...
http://www.sqlteam.com/item.asp?ItemID=26942
I am hoping to get it completed in 3 articles. The first article looks at technique, the second on modelling and finally the last article brings it all together.
Read more →
Dear Microsoft Press Writers, As a long time user of your database products, I find myself becoming increasingly aggravated by the utter nonsense that your press releases state. Specifically, the utter lack of knowledge of the theory that underpins your enterprise database engine.
Read more →
It had been nagging me for a while. When I started building this application, I reached into my code library and started copying and pasting various bits and pieces.
One in particular was an Error dialog control.
Read more →
Before I kick this one off, please remember that these measures can only be taken into consideration when the full scope of the database model and its implementation are known. The Abstraction Indicators try to measure the databases capacity to cope with change and the "profile" of the database to calling applications.
Read more →
In following from my previous post, and in the interests of a free shirt from graz, I present another metric designed to summarise the "goodness" of a physical database schema
Read more →
Over the years, several of my contracts involved analysing and critiquing third party databases.
On arrival at the client site, I would be given the business model specification, a copy of the database and a room/cubicle to work in.
Read more →
Analysing index health is a vital part of database maintenance.
Wading through DBCC SHOWCONTIG results is not fun at all.
You probably have something similar but I thought I would share.
Read more →
While I love lots of different facets of IT, there are a few downsides that I have experienced over the years and I thought I would share...
The respect! Don't you just love how the corporate machine has diminished our trade?
Read more →
Most SQL Server based apps use stored procedures exclusively, so the idea of forcing SQL Server to ignore plan caching is nasty.
According to the BOL, it is "unusual" to use this option.
Read more →
It has been over 2 years since I started my current job. That's almost a personal record for me. It has been a dream job so far.... Start from scratch, work from home, boss of all technical aspects of the project including analysis, design and coding.
Read more →
I created an article instead of a Post (what's the difference?).
I hope you find it informative...
http://weblogs.sqlteam.com/davidm/articles/12117.aspx
Legacy Comments
Jeff
2006-09-16
re: Dave's guide to the EAV David -- can you add some line breaks to some of the longer lines of code?
Read more →
This guide is intended to help programmers and DBA’s understand the considerationsand consequences associated with an EAV schema and to provide a basic framework forits implementation in SQL Server (>= 2000).
Read more →
I am using Windows Forms for my current project and with so much processing power going to waste on most users desktop, I have been trying to offload network traffic via client side caching.
Read more →
Ø The relational model can handle hierarchies with ease.
I'll give the SQL DBA's out there a moment to clean up the coffee they just spat over the keyboard.
Read more →
War & Victory
Various Academic Institutions…
“Wow!”“What Chris?”“There is a guy in California who has invented a multipurpose n-dimensional data model.”“Really! Hashtables are hard enough to work with and they only have 2 dimensions.
Read more →
Results
Rockwell Space Division The monochrome screen flickered as the data flowed. Men gathered around the monitor as if it was a shrine. The tension was real. Without fanfare a message appeared on the screen that said “IMS READY”.
Read more →
Problem
AD 1962 Stratosphere"Zarya-1, Zarya-1, I can't hear you very well. I feel fine. I'm continuing the flight.....”The encrypted VHF band they communicated on quickly became useless as the converted ballistic missile passed over the horizon.
Read more →
1) No logical model
Obvious isn’t it? But I can almost guarantee that everyone has started a DB project without one at some stage. You are lucky if you see an ERD and should buy a Lotto ticket if you see a Functional Dependency analysis.
Read more →