Welcome

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 . Microsoft Data Platform MVP

"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
http://www.bradmcgehee.com/2010/07/free-sql-server-dmv-starter-pack/

The Periodic Table of DMVs
http://www.brentozar.com/dmvs/

Performance Tuning with SQL Server Dynamic Management Views by Louis Davidson and Tim Ford
http://www.simple-talk.com/books/sql-books/performance-tuning-with-sql-server-dynamic-management-views/
Scripts
http://www.simple-talk.com/redgatebooks/davidsonford/dmv_code.zip

Recap of April 2010 DMV a Day Series
http://sqlserverperformance.wordpress.com/2010/05/02/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
http://www.mysql.com/products/cluster/

Information on MySQL Cluster and MySQL Replication blog
http://www.clusterdb.com/

MySQL Cluster Manager 1.1.2 – creating a Cluster is now trivial
http://www.clusterdb.com/mysql-cluster/mysql-cluster-manager-1-1-2-creating-a-cluster-is-now-trivial/

MySQL Cluster 7.1 Cheat Sheet
http://www.clusterdb.com/mysql-cluster-7-1-cheat-sheet/

MySQL Cluster 7.2: NoSQL, Key/Value, Memcached
http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2.html
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
http://www.oracle.com/uk/education/eblast/uk-mysql-training-230811-ol-459574-en-gb.html?sc=WWOU11036077MPP003C015

Oracle University Free Summer learning on MySQL Part II
http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=9799792&src=7297607&Act=8

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. "
http://www.theregister.co.uk/2011/08/16/scalebase_database_sharding/

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?