SQL Server

August 13th, 2016

PolyBase import and export between Azure SQL Data Warehouse and Blob Storage

SQL Server Polybase makes it easy to load data into Azure SQL Data Warehouse by letting you define groups of files held in Azure blob storage as relational data tables.

July 29th, 2016

Designing an event store for scalable event sourcing

Event sourcing can scale very nicely, though this does depend on a number of key design decisions for the underlying event store.

October 3rd, 2014

The problem with GUIDs…

GUIDs do solve an important problem. It’s just rarely the problem that developers are trying to address…

June 26th, 2014

Optimising bulk inserts with Entity Framework 6

There are some techniques for improving the performance of bulk inserts in the entity framework, but the most optimal approach will always be to use a different library altogether.

July 18th, 2012

Stored procedures vs ad hoc or inline SQL in SQL Server 2012

The importance of using stored procedures for all your data access used to be the first thing you would learn at database development school. Although performance is no longer a selling point for stored procedures there’s still a strong case for using them over inline or ad hoc SQL.

May 6th, 2012

Micro ORMs demonstrate that less is usually… less

Micro ORMs such as Dapper, Massive and PetaPoco are an increasingly fashionable solution to the problem of bridging the databases and object world. However, it’s important to understand the trade-offs involved in using a micro ORM as opposed to something “heavier” with a more advanced feature set.

January 8th, 2012

Entity Framework anti-patterns: How not to use an ORM with SQL Server

The Entity Framework has come a long way since its earliest incarnations prompted a vote of no confidence from the development community. However, like any data access technology, there are still a number of traps for the unwary – particularly if you’re using it in a tiered application.

November 10th, 2010

ORM wars: Comparing nHibernate, LINQ To SQL & the Entity Framework

Ted Neward described ORM as the “vietnam of computer science” in that it’s a quagmire that starts well, gets more complicated as time passes and ends up as an open-ended commitment with poorly-defined goals and no clear exit strategy.

September 13th, 2009

Identity over-use: Surrogate vs Composite keys in SQL Server

The SQL Server ‘Identity’ column is a handy way of ensuring a unique primary key, but I have noticed a tendency for some database designs to over-use it.

February 12th, 2008

Improving ASP.NET Performance: SQL Server Database access

Your database interactions are among the most expensive operations you’ll perform in an web application.There are a number of best practices that you should be following when coding a scalable application for SQL Server – here are some of the rules that I swear by.