Nirmal Sharma Hosting SQL Server in Hyper-V Replica Environment A Hyper-V replica will provide a rapid disaster-recovery by simply replicating to a standby site a VM running at the... 04 February 2014 26 min read
Dev Nambi Agile Database Development Agile methodologies work well with database developments only if great care is taken to do things right. It requires good... 03 January 2014 28 min read
Robert Sheldon The SQL Server Sqliosim Utility The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It doesn't... 02 January 2014 14 min read
Sergei Dumnov Creating a Business Intelligence Dashboard with R and ASP.NET MVC: Part 3 By introducing R libraries into an ASP.NET MVC application, it is possible to broaden its analytical and visualization power immensely.... 21 October 2013 16 min read
Scott Murray SQL Server Reporting Services Advanced Charting SQL Server Reporting Services (SSRS) has evolved over the years to incorporate many new data visualization capabilities. In this article,... 08 October 2013 21 min read
Dino Esposito Aiming for a Truly Responsive Web Experience Responsive Web Design (RWD) is starting to take off as a lightweight way to adapt websites for different screen sizes... 26 September 2013 11 min read
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
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
Joseph Moody Group Policy and WMI, A Wonderful Combination If you're faced with having to deploy software to those PCs that are, say, from a particular manufacturer, are laptops... 25 July 2013 9 min read
Sergei Dumnov Creating a Business Intelligence Dashboard with R and ASP.NET MVC: Part 2 Continuing the project to build a Business Intelligence (BI) application using R, Visual Studio 2012 and Twitter Bootstrap, Sergei introduces... 23 July 2013 15 min read
Tom Fischer Fluent Code in C# In LINQ, the 'fluent' method syntax flows logically and intuitively, and allows them to be combined simply, because each method... 11 July 2013 14 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
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
Dino Esposito Auto-completion in HTML-Based Input Forms Are there ever times when the best practice for a GUI is to let the user type-in information using the... 13 June 2013 13 min read
Hugo Kornelis Painless management of a logging table in SQL Server Tables that log a record of what happens in an application can get very large, easpecially if they're growing by... 11 June 2013 26 min read
Phil Factor SQL Server CREATE TABLE syntax diagrams Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough... 06 June 2013 8 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
Phil Factor The Art of the One-Pager In which Phil finds himself in a place of work where, despite his penchant for insulting or upsetting senior managers,... 02 April 2013 11 min read
Nirmal Sharma Hyper-V Migration Technologies Hyper-V has become far more sophisticated since the release V3 of Windows 2012, but it means that there are now... 21 March 2013 29 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
