Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Smiling DBA

Thomas LeBlanc is a Business Intelligence Consultant/Data Warehouse Architect in Baton Rouge, Louisiana. He uses his 25+ years in IT to help develop OLTP systems with normalized databases for high-performing T-SQL and end-to-end dimensional data marts using SSIS, SSAS, PPS, and Excel. His SQL Server certifications include MCSA 12, MCITP 08 BI and DBA, MCITP 2005 DBA, and MCDBA 2000. As a PASS volunteer, he is current chair of the Excel BI virtual chapter, past chair of the Data Architecture virtual chapter, and past virtual chapter mentor. He has helped the Baton Rouge SQL Server User Group with SQLSaturdays and speaks at local IT meetings.

PASS Data Arch VC presents: Neil Hambly’s Think You Have The Right Data-Type?

Please join this Thursday Feb 24th 2013 at noon central for Confio SQL Server expert Neil Hambly talking SQL Server Data-Types. This seemingly simply feature is the heart of tables and data in SQL Server, so you do not want to miss Neil sharing implications of not knowing the details to Data Types.

Online Meeting URL: https://www.livemeeting.com/cc/UserGroups/join?id=7BTR84&role=attend&pw=s%26Q2H%2B%3A%263
RSVP URL: DataArch.SQLPass.org

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.

When

iCal
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: 2/28/2013 12:00 - 13:00

Think you have the right Data-Type?

Speaker: Neil Hambly, Database Administrator Confio Software

Summary: 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

About Neil: 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.

Comments

Leave a comment on the original post [thesmilingdba.blogspot.com, opens in a new window]

Loading comments...