Monthly Archives: October 2016

Value creation checklist

It is pretty amazing some of the ideas we come up with here through the myriad of idea generating avenues we have – swimtank, hackathon, R&D, etc.  Everyone truly wants to be part of solving great problems. Currently we are...
Continue Reading →

The Value of Naming Constraints

In certain designers, such as SQL Server Management Studio table designer, when you create certain constraints (Primary and foreign keys, defaults, and check constraints) they will be given a name that contains a GUID to verify the name is unique. This...
Continue Reading →

Performance Troubleshooting without Data? Enter DBCC Clone Database

With SQL server 2014 SP 2 Microsoft added a new feature that sounds pretty sweet for troubleshooting some performance problems. It is called Clone Database. In a Nutshell Clone database gives you a copy of the specified databases without any...
Continue Reading →

Improve data quality by addressing non-stated requirements

I read an article by David Poole a few weeks ago where he talks about addressing non-stated requirements. I believe this is an area that is quite often overlooked when data modeling; at least up front.  He sums it up...
Continue Reading →