Sep 12, 2012: The Significance of Choosing and Using Data Types

(Note that we recently changed the Meeting Location. Check the registration page for details.)
Vern Rabe
The Significance of Choosing and Using Data Types
Download: presentation | Script
    Vern RabeIt’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. My goal in this presentation is to convince you of the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several 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 I will cover several data type related functions, and point out caveats in their usage.
Although intended to be a beginner or intermediate level presentation, I anticipate that advanced T-SQL developers and DBAs will also walk away with a useful nugget or two.
Vern Rabe (Blog | 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 almost 20 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.
Andre Tournier
Simplifying Data Import
When I went up to Microsoft for the Server v-next airlift, PowerShell was very prominent throughout the discussions. I came back from the airlift energized to work with PowerShell. A few months later I ran into an issue with SSIS and connectivity. This presentation is about how I used PowerShell to resolve the issue.
    Andre (Blog | LinkedIn | Twitter) is an accomplished team leader, having worked with both informal teams and formal management roles. As a consultant, he is prepared to use the tool sets and resources available on site, and as experienced technologist, he is adept at using available tools to solve problems. Andre’s primary focus in on the Microsoft stack and pc technologies -but he has also worked with mainframe systems. He enjoys many creative pursuits, such as cooking, playing music and photography.
Refreshments graciously provided by Apex Systems, Inc..

Jobs, Jobs, Jobs …
    The SQL Server related job market is still vibrant, and there are several open positions (Admins, Developers, BI -from entry to advanced skills) in the Oregon/SW Washington region. Check out the Oregon SQL Jobs page. Tell your friends and colleagues to regularly visit the Jobs page.
Featured Sponsor: VanderHouwen and Associates
    For over two decades, VHA has been a premier staffing provider of technology professionals in the Pacific Northwest. We have since expanded to provide professional accounting placement services. While it might seem unusual for a rapid-deploy, results-driven business like ours to take that responsibility personally, we do. Our President’s work ethic not only serves as the foundation of our company, but drives the commitment to individual attention which infuses our culture. We are dedicated to the satisfaction and success of our clients and consultants. We are committed to providing outstanding service to a uniquely demanding industry in a straightforward, ethical, highly personal, and always-responsive manner.
    View our website for more details.

We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously sponsoring the meeting venue.

This entry was posted in Announcements. Bookmark the permalink.