Comparing multiple rows insert vs single row insert with three data load methods

The performance of 'extract, transform, load' (ETL) processes for large quantities of data can always be improved by objective testing...

21 February 2013 15 min read

Robert Sheldon

Some Books on Programming SQL Server 2012

It is a measure of the range of facilities that are available to the database developer nowadays that three different...

21 February 2013 12 min read

Edward Charbeneau

Using SASS and Compass in ASP.Net MVC with Web Workbench

The Designers of CSS never envisaged the demands that we make of styles. However, preprocessors such as SASS can provide...

19 February 2013 22 min read

Dino Esposito

Multiple Views and DisplayMode Providers in ASP.NET MVC 4

Display modes in ASP.NET MVC 4 provide a neat way of separating page content from the way it is rendered...

18 February 2013 11 min read

Buck Woody

Data Science Laboratory System – Instrumentation

It is sensible to check the performance of different solutions to data analysis in 'lab' conditions. Measurement by instrumentation makes...

18 February 2013 18 min read

Louis Davidson

My New Year’s Goals 2013

So, I have completely given up on my new year starting on Jan 1 where blogging/writing/community is concerned. I love...

17 February 2013 7 min read

Michael Williamson

Lightning talk: David Simner – Security 101

In one of our recent lightning talk sessions, David Simner explained one of the many reasons why security is hard:...

15 February 2013 1 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

Joseph Moody

Getting Better Mileage by Extending Active Directory Users and Computers

Active Directory has more uses than it is usually credited with. The 'Active Directory Users and Computers' console can even...

15 February 2013 8 min read

Louis Davidson

What Counts for a DBA: Realism

“I need a database designed, which will not only clear up our current order processing issues, but will make our...

14 February 2013 4 min read

Feodor Georgiev

Full Text Searches on Documents in FileTables

SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex...

14 February 2013 11 min read

Nirmal Sharma

Microsoft Hyper-V Networking and Configuration – Part III

A configuration of Hyper-V networking across two or more Hyper-V Hosts is the most complex type. It needs to be...

14 February 2013 17 min read

Jonathan Lewis

Compression in Oracle – part 4: Basic Index Compression

In the first three parts (Part 1: Basic Table Compression, Part 2: Read-Only Data, Part 3: OLTP Compression) of this...

13 February 2013 13 min read

Phil Factor

Microsoft Marketing Man wakes up

On waking up this morning, I re-imagined the idea of having a bath, which turned out to be a deeply...

12 February 2013 4 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