Monthly Archives: August 2014

Pass parameters from TeamCity to nuspec files

Aim: Pass parameters from TeamCity to nuspec files in order to set the solution configuration from TeamCity. In TeamCity, create a new system parameter in the Parameters page of project. In this case, the parameter DatabaseConfiguration sets which solution configuration will be built (e.g. Full = all projects, Partial = only newly updated projects). In […]

“SQL71508: The model already has an element that has the same name” error when building SSDT solution

I recently came across this error when attempting to build an SSDT solution that had been handed over to me by another developer. The database references within the solution were quite complicated for a couple of reasons: Due to the large number of objects in some of the databases, the solution included composite projects. This meant […]

SQL Server 2014 Features Part 2: Durable vs Non-Durable Memory Optimized Tables

Aim: Test speed of durable memory optimized tables against non-durable. In the previous post, I tested the speed of memory optimized tables & natively-compiled stored procedures against disk-based tables & stored procedures. In this post, I will perform a similar test of durable & non-durable memory optimized tables. The previous post outlines the difference between durable […]

SQL Server 2014 Features Part 1: Memory Optimized Tables

Aim: Test speed of memory optimized tables & natively-compiled stored procedures against disk-based tables & stored procedures. There are a couple of examples available from Microsoft to demonstrate the performance benefits of Memory Optimized Tables: http://msdn.microsoft.com/en-us/library/dn530757.aspx http://msftdbprodsamples.codeplex.com/releases/view/114491 I roughly followed the first code example but I found the naming of the objects quite abstract so […]

Run VirtualBox On An Azure Virtual Machine

I’m currently doing a Data Science on Coursera (https://www.coursera.org/course/datasci) that requires me to complete assignments using a provided virtual machine. The easiest option for playing the VM seems to be VirtualBox however I can’t install it on my PC. So I’m going to try to get it running on an Azure VM instead (essentially running a VM […]

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!