An introduction to U-SQL – SQL and C# combined!

I just returned from SQLBits 2016 and had a fantastic time. They really put on a great conference, with brilliant speakers on a variety of SQL topics (and increasingly NoSQL/Big Data). Throw in good catering and an amazing , all for a very reasonable price and you have a conference I really can't recommend enough! The talk that excited me most this year was...

Continue reading →

Gulp and Visual Studio: Code quality

This is Part 4 is my series on using Gulp with Visual Studio. So far we've covered setting up Visual Studio for use with Gulp, processing SASS, and getting the files ready for deployment. Part 1: Setting up Gulp with Visual Studio Part 2: Getting SASSy Part 3: Deployment: minification and concatenation Part 4: Code quality: tests and linting Part 5: Thoughts on Gulp In...

Continue reading →

Gulp and Visual Studio: concatenation and minification

In my previous blog I wrote about how we can use Gulp to compile SASS. This time it's all about how we can use Gulp in Visual Studio to prepare files for a release by minifying and concatenating them. I've put up a project using the standard MVC 5 template for this series of posts here Part 1: Setting up...

Continue reading →

Gulp and Visual Studio: Getting SASSy

Getting SASSy with Gulp in Visual Studio In my previous blog I showed you how to set up Visual Studio for use with Gulp. Now I want to show you how you can use it in everyday development, including processing SASS, running tests, linting your code and getting ready for deployment. In this series of posts I'll talk about how you...

Continue reading →

Getting started with Gulp in Visual Studio 2013 and 2015

In the last few years a rich set of front end development tools has emerged for building complex web applications. Gulp in particular has taken off in a huge way. However, .NET development is lagging when it comes to adoption of these tools. This is all set to change, especially with the release of ASP.NET 5 where Gulp will become part of the standard...

Continue reading →

Know exactly what you’re about to deploy with Git, TeamCity and Octopus Deploy

In my last post I showed how we can use Git, TeamCity and Octopus Deploy to include the commit id in an Octopus Deploy release, and therefore find out exactly what code is running in your system. In this post I want to show you can use the commit ids to do a diff between what you've already got...

Continue reading →

Know exactly what you’ve deployed with Git, TeamCity and Octopus

Having a fully automated build and release process is, in my opinion, one of the best things you can do as a development team. We've spent the last 2 years moving to a fully automated build and release process and it has had an enormous impact on the way we develop and, more importantly, release software. Releasing has gone...

Continue reading →

Re-usable, informative validation error messages in Angular

A while ago (at NDC London) I attented a two day course on Angular by the great K. Scott Allen, who spoke about using the ngMessages directive to provide re-usable validation on forms. While ngMessages is good, there is no way of providing detail on validation failures. For example, if a text input has to be at least 5...

Continue reading →

SQL DATETIME with slashes or hyphens returning incorrect data

I’ve just spent a fun hour wondering why two seemingly identical queries were returning different data. It turned out to be an issue with DATETIME in SQL Server. SQL interprets a DATETIME of the format “yyyymmdd” differently to “yyyy/mm/dd” or “yyyy-mm-dd”. The former is "unseperated" while the latter is "seperated", and the "seperated" format depends on the current language and...

Continue reading →