Alex Kuznetsov Lessons Learned from Six Years of Agile Database Development Alex Kuznetsov describes the agile principles, techniques and tools that allowed his development team to make frequent database refactoring a... 19 November 2013 26 min read
Michael Sorens Acceptance Testing with FitNesse: Debugging, Control Flow, and Tracing FitNesse is an automated testing tool for software. based on Ward Cunningham's Framework for Integrated Test. It is designed particularly... 15 November 2013 12 min read
Robert Sheldon SQL Server SQLCMD Basics Sqlcmd makes many SQL Server tasks, such as automating test runs and maintenance tasks, easier and quicker. The sqlcmd command-line... 15 October 2013 15 min read
Nigel Rivett The ETL from Hell – Diagnosing Batch System Performance Issues Too often, the batch systems that underlie a lot of database processing just grow without conscious design. When runs start... 15 October 2013 17 min read
Mark S Rasmussen SQL Server Storage Internals 101 This article is an extract from the book Tribal SQL. In this article, Mark S. Rasmussen offers a concise introduction... 09 October 2013 32 min read
Robert Sheldon DAX Statistical Functions Following on from his first four articles on using Data Analysis Expressions (DAX) with tabular databases, Robert Sheldon dives into... 23 September 2013 22 min read
Richard Morris Developing for Delivery, a Practical Example Richard Morris interviewed Michael Stoop, a database developer at Calvi, Europe's leading provider of Telecom Invoice Management software. The discussion... 17 September 2013 8 min read
Joe Celko Databases and Dominoes A Dominoes game of Texas 42 inspires Joe to explore unusual uses for check constraints and views. Sometimes, the best... 09 September 2013 14 min read
Robert Sheldon Using DAX to create SSRS reports: The Basics You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires... 27 August 2013 15 min read
Grant Fritchey Database Administration as a Service A DBA should provide two things, a service and leadership. For Grant Fritchey, it was whilst serving a role in... 14 August 2013 11 min read
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
