Next Meeting: Thu, Feb 28 2013
Neil Hambly on Think you have the right Data-Type?
Event Type: Online
Online Meeting URL: https://www.livemeeting.com/cc/UserGroups/join?id=7BTR84&role=attend&pw=s%26Q2H%2B%3A%263
This month Confio DBA Neil Hambly presents Think you have the right Data-Type? He will talk about selecting the right Data-Type (DT) for data is key to efficient data storage, retrieval and processing, with over 30 different DT to choose from this isn’t as straight forward as you might think. Join us Feb 28th 2013 at noon central for a talk about data type design and decisions.
UTC : Thu, Feb 28 2013 18:00 - 19:00
Event Time : Thu, Feb 28 2013 12:00 - 13:00 (GMT-06:00) Central Time (US & Canada)
Your Local Time: Thu, Feb 28 2013 18:00 - 19:00
Data Architecture virtual chapter
Think you have the right Data-Type?
Neil Hambly, Database Administrator Confio Software
Selecting the right Data-Type (DT) for data is key to efficient data storage, retrieval and processing, with over 30 different DT to choose from this isn’t as straight forward as you might think, have your also considered the usage pattern of the data in addition to its storage requirements
This session explores the various data-types now available, we look at conversion’s between different DT’s as well as index sizes & effectiveness, compression and other factors can that influence these decisions, we finish off by discussing different approaches on ‘migrating’ a DT to a different DT, throughout the session we consider any performance considerations, such as when implicit conversions occur and more
Neil Hambly is a SQL Server veteran of more than 14 years, with expertise in SQL Server from Version 6.5 to the latest 2012 edition. He's held database roles at major organizations, including the BBC, ABN AMRO, and Accenture, as well as at a number of market-leading companies. Currently a Senior DBA at Confio Software, he’s held prior roles as a DBA, developer, and architect. Leader of the PASS London Chapter, Neil can frequently be found speaking at UK and international events.