Michael Sorens Acceptance Testing with FitNesse: Documentation and Infrastructure FitNesse is a popular general-purpose wiki-based framework for writing acceptance tests for software systems, including databases. It is intended to... 02 August 2013 11 min read
Michael Sorens Acceptance Testing With FitNesse, The Overview FitNesse is an open-source framework for supporting user-acceptance testing. The aim is to make the construction of the individual tests... 31 July 2013 17 min read
Buck Woody Data Science Laboratory System – Key/Value Pair Systems Though the Key/Value pair paradigm is common to almost every computer language, there is no clear agreement yet for the... 17 July 2013 17 min read
Robert Sheldon Using Microsoft Excel to Retrieve SSAS Tabular Data Although it is well-known how to create a tabular database in PowerPivot, it is less obvious that there are several... 16 July 2013 19 min read
Sergei Dumnov Creating a Business Intelligence Dashboard with R and ASP.NET MVC: Part 1 It is possible to use the R statistical package to extract Business Intelligence from the data in a SQL Server... 08 July 2013 22 min read
Feodor Georgiev Collecting the Information in the Default Trace The default trace is still the best way of getting important information to provide a security audit of SQL Server,... 02 July 2013 14 min read
Rob Garrison Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1 The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you... 25 June 2013 12 min read
Robert Sheldon Using DAX to retrieve tabular data Data Analysis Expressions (DAX), originally the formula language for PowerPivot workbooks, can also be used within the MDX query window... 24 June 2013 17 min read
Ambily Kavumkal Kamalasanan Different Approaches of Entity Framework Entity Framework provides three different approaches to deal with the model, and each one has its own pros and cons.... 20 June 2013 11 min read
Buck Woody Data Science Laboratory System – Relational Database Management Systems There is no better way of understanding new data processing, retrieval, analysis or visualising techniques than actually trying things out... 14 June 2013 19 min read
Jonathan Allen Preparing to Upgrade your SQL Server It isn't a problem to use deprecated TSQL features until it comes to the time to move the database to... 12 June 2013 17 min read
Alexander Karmanov Automating SQL Server Database Deployments: Scripting Details To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted... 06 June 2013 30 min read
Tools Michael Sorens in Tools MySQL Data Compare: The Manual that Time Forgot MySQL Data Compare can both compare the data in MYSQL databases and also synchronise them. It is handy for a... 28 May 2013 16 min read
Robert Sheldon Getting Started with the SSAS Tabular Model SSAS Tabular models are in-memory databases that model data with relational constructs such as tables and relationships, in order to... 22 May 2013 16 min read
Grant Fritchey The DBA Detective: The Case of the Missing Index When problems arise in SQL Server, we're faced with a server full of suspects, including disk I/O, memory, CPU, incorrect... 15 May 2013 12 min read
Tools Michael Sorens in Tools MySQL Compare: The Manual That Time Forgot, Part 1 Although SQL Compare, for SQL Server, is one of Redgate's best-known products, there are also 'sister' tools that allow you... 03 May 2013 14 min read
Grant Fritchey Custom Metrics for Monitoring Database Mirroring SQL Monitor comes with plenty of metrics, but there are always going to be things that you want to measure... 16 April 2013 7 min read
Robert Sheldon Getting Started Testing Databases with tSQLt There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is... 08 April 2013 22 min read
Michael Sorens TortoiseSVN and Subversion Cookbook Part 11: Subversion and Oracle It is only recently that the tools have existed to make source-control easy for database developers. Although entire build-scripts for... 03 April 2013 17 min read
Kat Hicks Diagnosing Common Database Ails When a database starts showing signs of an illness, it's up to the DBA to get to the root of... 25 March 2013 13 min read
