Monthly Archives: August 2013

Auto-discovery of data relationships minus referential integrity

Posted on August 30, 2013 by Bob L

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

Posted on August 26, 2013 by Bob L

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)

Posted on August 24, 2013 by Bob L

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