Monthly Archives: August 2013

Auto-discovery of data relationships minus referential integrity

My experience is that unfortunately far too many databases lack referential integrity in the schema. There are a few reasons for this, almost all of them bad. One of the worse is the “our application controls integrity” rationale with a … Continue reading

Posted in SQL Server | Tagged | Leave a comment

Relational State Sequences and SQL Server CLR Aggregate functions

My research on continuous improvement problem solving frameworks has convinced me that a problem system must possess complete data about the processes it is trying to learn from including how all the items within a solution attempt have changed. I … Continue reading

Posted in Artificial Intelligence, Machine learning, Problem Solving | Tagged | Leave a comment

Concept for a High-Performance Database (HPD)

Recently, I’ve been studying Microsoft PDW as part of an ETL integration project. This got me thinking about the distributed database computing paradigm and scaling out performance for SQL Server for OLTP purposes. PDW utilizes multiple compute nodes that are … Continue reading

Posted in Fusion-io, SQL Server | Tagged | Leave a comment