2010 Meetings

Dec 9/2010 – Jim Houchin – SQL Server Denali

Abstract:
Jim Houchin has been playing with the recent CTP release of the new version of SQL Server, Denali. He will be giving us a brief overview of the new features he has discovered, as well as features that have been removed.

Bio:
Over nine years of experience in software design, development, implementation of web and database applications with a touch of QA methodology. My current focus is as a DBA at NYK concentrating on SQL administration and maintenance. Most of my development experience is in ColdFusion and database experience in SQL 2000 2005 and 2008 with DTS and SSIS. Being a creative problem solver with excellent research and troubleshooting skills, has served me well in all my previous positions. I also have a strong desire to learn new technologies and am eager to share information.


Nov 11/2010 – Rob DeMotsis – Performance Tuning

Abstract:
Rob DeMotsis will walk us through some of the techniques he uses to check and improve the performance of SQL Server queries. If time permits, Rob will go into troubleshooting blocking problems and how that affects performance as well.

Bio:
Rob DeMotsis was born about a hundred miles north of Memphis in Dyersburg, Tn. His family moved around a lot due to his father’s job demands. His father, brother, and him, moved to Dallas-Fort Worth when Rob was 11. At age thirteen, Rob received his first computer for Christmas. This would lead to the first of 2 incidents that lead him to a computer career. The first was when he was at his Dad’s place of employment, a retail paint company called Jones-Blair in Dallas, Texas. They had the old dumb terminals at the store his father managed and Rob got on it one afternoon after school and found a way to extract all the inventory cost data from their corporate mainframe. His Dad was warned not to let him play on the store computer again.

About 7 years later Rob entered the workforce as an assistant manager at another branch of the same company, Jones-Blair in another part of the city. Enough time had gone by that no one remembered that earlier incident. Except as luck would have it, this store had a newer kind of computer system installed and it was also tied directly into their corporate servers. Rob was able to hack his way into their mainframe servers again. This time though the Assistant Manager of the Data processing department paid a visit to the store where Rob was working at and confronted Rob about what Rob had done. He was actually pleased to find someone that had a desire to learn about computers and asked Rob to join the Data Processing team at the corporate office in Dallas to help configure the computers at the stores to be more secure, against people like Rob.

Rob has now been in IT for 20 years. He has spent the last 11 as a true DBA although he began using SQL Server about the time it was just entering the market (SQL Server 4.2) and has used and administered every version in between up to SQL 2008. His main focus has been in performance tuning and data migration. He also incorporates most all of the additional components of SQL Server such as SSRS, SSIS, and SSAS. He still continues to roll up his sleeves though and get his hands into the guts of the server when an employer allows him.

Rob was fortunate enough to be involved in the rapidly changing computer industry and work for companies, such as Toni & Guy/Tigi Linea, Pier 1 Imports, GameStop, Dave and Buster’s, Rapp- Collins Worldwide, Dyncorp Intl., NTS/ITS Card Services, Electracash, Smith and Nephew and most recently with NYK/Yussen Logistics. During that time he helped these companies get started with database systems and/or networking systems. He has helped many of those that had a database solution already in place, configure their database servers to get the best performance possible from them and set up a maintenance routine to ensure good health of the systems as well as disaster recovery methods.

Some of Rob’s highest achievements have been when systems were critical to the core of the business and needed to be enhanced in order for the business to not lose any of its continuity. These included Failover Clustering for maintaining a 24/7 online retailer web server. Also, Rob was part of designing, engineering, and installing a massive replication environment along with clustering for interaction with a high profile and state of the art security system for airports and various restricted agencies.

Rob loves what he does and feels that he just doesn’t get enough time in a day to do everything he wants to do and to learn as much as he can.


Oct 14/2010 – Alvin Ramard – SSIS Package Configuration

Abstract:
Alvin Ramard will go over SSIS Package Configurations to answer your questions about what they are, why should we use them, and how can we use them. After a brief overview of what SSIS Package Configurations are, Alvin will go over the options that are available and how to use them. This will be followed by an example of how you can use the information you have learned to design a configuration methodology that you can use to make deploying SSIS packages a simple things.

Bio:
After working for 14 years as an electrical engineer, Alvin Ramard returned to school to obtain a Diploma in Information Technology. He then moved from his home province of Nova Scotia to Memphis, working at Memphis Manage Care for 8 years as a Systems Analyst. Since Nov 2007, Alvin has been working as a contractor for Robert Half Technology, with assignments at ServiceMaster, Vining-Sparks, and currently, NYK Logistics as a database analyst. Alvin has spent most of his IT career working mainly with SQL Server, with a strong focus on ETL and BI.

Alvin Ramard is a co-founder and Vice-President of the Memphis PASS Chapter. Until recently, Alvin was also a part of the Memphis Dot NET Users Group executive.


Sept 16/2010 – Alvin Ramard – SSIS Tips and Tricks #1

Abstract:
Alvin Ramard will demonstrate a few SSIS techniques for dealing with problems that can occur with ETL processes. For example, while loading data from a file that has duplicates, what’s a simple way to load all non-duplicate rows? When processing data in a dataflow, when dealing with data from one row, how can you refer to data from a previous row? Try processing an ANSI X12 file with just one pass through a data flow without being able to look at previous rows. Bring your ETL problems to the meeting and, if time permits we’ll if we can find a simple solution to those problems.

Bio:
After working for 14 years as an electrical engineer, Alvin Ramard returned to school to obtain a Diploma in Information Technology. He then moved from his home province of Nova Scotia to Memphis, working at Memphis Manage Care for 8 years as a Systems Analyst. Since Nov 2007, Alvin has been working as a contractor for Robert Half Technology, with assignments at ServiceMaster, Vining-Sparks, and currently, NYK Logistics as a database analyst. Alvin has spent most of his IT career working mainly with SQL Server, with a strong focus on ETL and BI.

Alvin Ramard is a co-founder and Vice-President of the Memphis PASS Chapter. Until recently, Alvin was also a part of the Memphis Dot NET Users Group executive.


August 12/2010 – Dan Evans – Creating an EPM Environment Using Microsoft SQL Server 2008 R2 and SharePoint 2010

Abstract:
Come see our own Dan Evans show us how to set up and manage an enterprise-scale performance management solution using the newest offerings from Microsoft. Establish a greater understanding of the components in SQL Server 2008 R2 and SharePoint 2010 that can enable your business to become a world competitor. Hear best practices on how to define, develop, and deploy key performance indicators, metrics, indicators, analytic charts, decomposition trees, and other useful tools to bring your EPM program to life.

Bio:
Dan Evans benefits from almost 20 years in information technology management in data analysis, design, development, testing, deployment, strategy, and consulting. Daniel’s key interests are in business intelligence, data warehousing, executive information strategy, and IT governance/compliance. His work crosses several industries such as retail, insurance, health services, manufacturing, marketing, logistics, telecommunications, and professional services. Daniel is an MCP and is a TDWI Certified Business Intelligence Professional (CBIP) with Mastery in Leadership and Manager, Business Analytics, Data Analysis and Design and Data Integration.


July 15/2010 – Charles Watkins – SQL 2008 Clustering in a Windows 2008 Environment

Bio:
Charles Watkins is a principal instructor at New Horizons CLC of Memphis. Charles’ main focus has been Microsoft Networking Technologies and Microsoft SQL Server. Charles has assisted in developing many custom courses for client including AutoZone, Hilton, FedEx, Methodist, Shelby County Government and Baxter Health Care. To complement this, he continues to lead projects as a senior consultant and technical trainer.

Charles currently holds numerous industry certifications including Microsoft Certified Trainer (MCT), Microsoft Certified systems engineer (MCSE), Microsoft certified system Administrator (MCSA), Microsoft Certified Technical Specialist (MCTS) Microsoft Certified IT Professional (MCITP), Microsoft Certified Database Administrator (MCDBA), Certified Lotus Instructor (CLI), Certified Lotus Professional (CLP) and Microsoft Office Specialist (MOS). Although his focus is currently on instructing students on Microsoft Products, He holds a BS in Criminal Justice as well as a BS in Economics/Finance from the University of Tennessee at Martin.


June 17/2010 – Frank Roche – SQL Server Projects at the Memphis-Shelby County Airport Authority

Abstract:
The Memphis-Shelby County Airport Authority is currently going through several major changes in the way is deals with its databases. Frank will explain the three projects he is currently leading at the Authority to improve database maintenance, database security, and database server consolidation. After that he will hold a discussion about how to register as a vendor or consultant to get on the contact list for any possible IT project that gets bid out at the Airport Authority.

Bio:
Frank Roche has been the Software Coordinator with the Memphis-Shelby County Airport Authority for the past 8 years. Before that he worked for Blackbaud Incorporated, a software development company for non-profit organizations. As the first internal Quality Assurance Analyst, he started their QA program writing their Quality Assurance Plan. Before that he worked at the National Customer Support Center for the post office. His work on the Fast Forward system improved the throughput of the real time mail forwarding system by 11%. The system saved the post office 13 million dollars in its first quarter of operation. He holds a BBA in Management Information Systems from the University of Memphis. Frank is a MCDBA. He holds the rank of 3rd kyu in Aikido and also practices Iaido, Batto, and Kempo. He is married with an 8 year old girl who is a published artist.


Apr 8/2010 – Dan Petit – Introduction to Data Vaults

Abstract:
Data Vaulting is a hybrid relational database DWH technique combining aspects of traditional 3NF database models and star-schemas. It is designed to provide a storage point for all data in the business domain (including historical data and “bad” data). In this presentation, we will explore the basic tenets of data vaults, learn when and why to use them (and when not to), and complete a simple transformation of a 3NF database to a data vault.

Bio:
Dan Petit is an IT consultant possessing many years of experience in software systems development and management, currently working with the Enterprise Architecture and Design Services (EADS) group at FedEx. He is the author of the book Real Visual Basic and of numerous articles on such topics as advanced VB programming, software development processes, coding standards, object-oriented analysis and design, UML modeling, WinForms programming and artificial intelligence. He hopes to finish his latest book, IT Culture, sometime before the sun goes supernova. Dan is also a frequent speaker at IT groups on topics such as requirements management, configuration management, quality assurance, project management, and analysis and design.

Prior to joining the EADS group, Dan was Vice President/Director of Application Development at Sedgwick CMS, where he had responsibility for the Enterprise Services group, including all Data Warehousing. He has also worked locally for ILS, Promus Companies, and Brother Industries.


Mar 11/2010 – Bob Hovious – Introduction to SQL Server Spatial Data

Abstract:
Bob Hovious will give us an introduction to SQL Server Spatial Data.


Feb 11/2010 – Joe Webb – SQL Server Locking & Blocking Made Simple

Abstract:
A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

Bio:
Since its inception, Joe Webb has served as Chief Operating Manager for WebbTech Solutions, a Nashville-based consulting company. He has over 15 years of industry experience and has consulted extensively with companies in the areas of business process analysis and improvements, database design and architecture, software development, and technical training.

In addition to helping his consulting clients, Joe enjoys writing and speaking at technical conferences. He has spoken at conferences in Europe and the North America and has authored books including “The Rational Guide To: SQL Server Notification Services” and “The Rational Guide To: IT Consulting”.

Joe served for six years on the Board of Directors for the Professional Association for SQL Server (PASS), an international user group with 30,000 members worldwide. Joe culminated his tenure on the board by serving as the Executive Vice President of Finance for the organization. Joe also volunteers his time by serving on the MBA Advisory Board for Auburn University and the Computer Science Advisory Committee for Nashville State Community College.

Joe is a five time recipient of the Microsoft MVP Award for demonstrating a willingness to share his expertise with the SQL Server Community. Joe may be reached at joew@webbtechsolutions.com.


Jan 21/2010 – Kevin Kline – Stored Procedure Best Practices

Abstract:
Find out the tricks and techniques needed to make SQL Server stored procedures achieve top performance. Numerous tips will show you how to make your stored procedures run faster, with fewer errors, and with better reliability. This class assumes a basic understanding of Transact-SQL. The session covers both SQL Server 2000 and 2005.

Bio:
Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software, a leading provider of award winning tools for database management and application monitoring.

Kevin is a founding board member and former President of the international Professional Association for SQL Server (PASS) and frequently contributes to database technology magazines, web sites, and discussion forums. Kevin writes monthly columns for Database Trends & Applications magazine and SQL Server Magazine.

Kevin also serves the community as an adviser to SQL Saturday education program as well as a curriculum adviser for both the University of Washington and Purdue University at Calumet in their IT and Computer Science departments.

Kevin’s most popular book is SQL in a Nutshell (now in it’s third edition) published by O’Reilly Media. Kevin is also author or co-author on seven other IT books, including Transact-SQL Programming, Database Benchmarking: A Practical Approach, and Professional SQL Server 2008 Relational Database Design and Optimization.

A top rated speaker, Kevin appears at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, SQL Connections, and the Best Practices Conference.

Beginning his career as a lowly hardware jockey working with PC’s, Digital VAX, and Intergraph Unix workstations, Kevin has worked on multiple large-scale database projects throughout his career at Deloitte & Touche, NASA and the U.S. Army.

When Kevin isn’t working on technology issues, he enjoys spending time with his wife, four kids, and three stepkids.

Kevin’s Twitter ID is kekline. Be sure to follow him!


Leave a Reply

Your email address will not be published. Required fields are marked *

19 − eighteen =