David Morrison
tsqlninja.wordpress.com
Dave Morrison is a Principle Consultant for Coeo. Having worked in the IT industry for around 16 years his main area of expertise is SQL Server, BI and analytics technologies
SQLBits 2014
SQL Tips, Tricks and Misconceptions
In this session we'll take a look at some nice bits of TSQL coding to resolve troublesome coding problems. We'll also look into writing code to make use of some TSQL features that are under used in daily coding.
This session will cover a range of SQL coding and approaches to various problems faced by anyone writing complex TSQL every day. We'll look at using some under appreciated features and syntax and also some alternate approaches to solving various problems such as unpivoting data and also working with dates.
Finally we'll examine some misconceptions around TSQL & SQL server and look at how they came about and the best way around them