The Significance of Choosing the Right Data Types
It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. Join this session and learn the importance of choosing the proper data type, the guidelines in determining what an appropriate data type would be, and, once chosen, some tools for its usage and management. There will be several demonstrations on performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them.
In addition, we will cover several data type related functions, and the caveats in their usage. Even advanced T-SQL developers and DBAs will walk away with a useful nugget or two.
Vern (LinkedIn ) is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases for 23 years, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and consulting contracts.
Oregon SQL for 2015
Instead of our typical, short, “beginner” session, this month we’re going to take some of this time to plan what the next 11 months of meetings will look like. Are there specific technical areas that haven’t been sufficiently addressed? Are there career advancement concerns or questions? The bottom line is what do YOU – our OregonSQL members – want from these meetings? Come prepared with ideas, desires, and a readiness to discuss.
SQL Server Trivia Quiz, Jeopardy Style
Do you consider yourself good at Jeopardy? How about a SQL Server specific Jeopardy category? Come compete in Paul’s Jeopordy style trivia game, and see how your SQL Server knowledge holds up against other OregonSQL members. Based on knowledge needed for MCSE certification, it should be fun!
Paul Turley – a Microsoft SQL Server MVP – consults, writes, speaks, teaches, and blogs about business intelligence and reporting solutions. A Mentor with SolidQ, he works with companies around the world to visualize and deliver critical information for informed business decisions. He is the lead author of “Professional SQL Server 2012 Reporting Services” and 11 other titles from Wrox and Microsoft Press.
Refreshments graciously provided.
Featured Sponsor: Red Gate
Visit our website for more details.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.