Rob Garrison is a Data Architect for Nike in Beaverton, Oregon. He has over twenty years of IT experience, as well as having had a number of articles published and speaking regularly at user groups and other events. His immediate family includes his wife, Karen, and his son Tanner. Outside of work, much of their time is spent in activities and service projects involving their church (http://pfcn.org).
The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you to migrate the most-used tables in an existing database to memory-optimised 'Hekaton' technology, but how you balance between disk tables and in-memory tables for optimum performance requires judgement and experiment. What is this technology, and how can you exploit it? Rob Garrison explains.… Read more
The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to any down-side.… Read more