Rodney Landrum SSRS Reports as a Data Source in Excel 2013 DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To... 26 September 2013 11 min read
Dwain Camps The Proposals Conundrum When you work for a small software development (or any services) company, one of the major challenges is to make... 19 September 2013 11 min read
Richard Morris David Heinemeier Hansson: Geek of the Week Ruby on Rails, the open-source web application framework, grew out of David Heinemeier Hansson's work on Basecamp at 37Signals. It... 07 August 2013 9 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
Louis Davidson Baselining with SQL Server Dynamic Management Views When you're monitoring SQL Server, it is better to capture a baseline for those aspects that you're checking, such as... 02 July 2013 18 min read
Michael Sorens How To Document Your PowerShell Library PowerShell provides comment-based help for functions and scripts with Get-Help, but when you want to document modules or generate a... 25 June 2013 16 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
Nick Harrison T4 – The Insource Code Monkey T4 usually stays behind the scenes in Visual Studio, but if you find that you have a good reason to... 03 June 2013 16 min read
Joseph Moody More Advanced Deployments with Group Policy Software Installation Group Policy Software Installation (GPSI) allows for a high level of control on what can be installed where on a... 09 May 2013 9 min read
Joseph Moody Eliminating Viruses with UAC and AppLocker It is important to prevent computer viruses from infecting a network within an organisation; Joseph Moody walks us through the... 23 April 2013 10 min read
Buck Woody Data Science Laboratory System – Programming and Scripting Languages Although every computer language is suitable for data, some languages lend themselves especially well for working with certain types or... 16 April 2013 18 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
Tom Fischer Beginning Distributed Version Control with Mercurial The move from client-server version ontrol systems (VCS) to distributed version control systems can be bewildering. Tom uses his experience... 02 April 2013 14 min read
Dino Esposito Building a Public HTTP API for Data The creation of a public API for data presents something of a dilemma for the developer. Web API, with its... 21 March 2013 12 min read
Tony Davis Shawn McGehee Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth You've just become responsible for a database, only to find that the log file is growing out of control. Why... 14 March 2013 13 min read
Nirmal Sharma Book Review: Windows Server 2012 Hyper-V Cookbook Windows Server 2012 Hyper-V Cookbook is a comprehensive resource for administrators and consultants looking for practical examples of Hyper-V technology.... 15 February 2013 8 min read
Michael Sorens TortoiseSVN and Subversion Cookbook Part 10: Extending the reach of Subversion Subversion provides a good way of source-controlling a database, but many operations are best done from within your database-development environmant.... 12 February 2013 19 min read
Michael Sorens TortoiseSVN and Subversion Cookbook Part 9: Server, Repository, and Statistics In the ninth installment of his popular series on using Subversion, Michael describes how to set up a simple Subversion... 11 February 2013 13 min read
Phil Factor Database Deployment: The Bits – Versioning Although databases have no inherent way of recording their version numbers, SQL Server provides the means of doing so, and... 04 February 2013 11 min read
Edward Charbeneau Using Chrome and Visual Studio for Real Time CSS Development Although CSS editing tools exist that give you a measure of WYSIWYG, it is often more convenient to make small... 10 January 2013 11 min read
