Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Thursday, 22 September 2011

Dynamic Management View (DMV)

Useful Dynamic Management View (DMV) resources

Free SQL Server DMV Starter Pack
A free eBook  that describes 28 different ways that DMVs can be used with SQL Server

The Periodic Table of DMVs

Performance Tuning with SQL Server Dynamic Management Views by Louis Davidson and Tim Ford

Recap of April 2010 DMV a Day Series

Wednesday, 21 September 2011

MySQL Clustering

For MySql clustering a few useful articles about providing high availability are below

MySQLCluster 7.1

Information on MySQL Cluster and MySQL Replication blog

MySQL Cluster Manager 1.1.2 – creating a Cluster is now trivial

MySQL Cluster 7.1 Cheat Sheet

MySQL Cluster 7.2: NoSQL, Key/Value, Memcached
This provides a new option for multi-site clustering.
MySQL Cluster 7.2.1 is integrated with MySQL Server 5.5. You have all the benefits of an ACID RDBMS, combined with the performance capabilities of Key/Value store.This allows schema-less data storage.
Oracle University Free Summer learning on MySQL Part I

Oracle University Free Summer learning on MySQL Part II

ScaleBase shatters MySQL for scalability
The article explains "it is a proxy server that sits in front of the actual database and in this case, the tool breaks a monolithic relational database into chunks and spreads it out across multiple physical servers. "

Wednesday, 7 September 2011

Research Question Revised

After various iterations my research question stands as 

How can the complex interactions, both extrinsic and intrinsic to the database, lead to a better understanding of database systems and their management?

In what ways could this lead to the emergence of improvement and innovation?