Event Location:
Olympia Center
222 Columbia St NW
Olympia, Washington
Abstract:
Using established relational database principles can help us decide when and how to use the XML feature in SQL Server 2005 / 2008. Contrary to typical technology presentations, this focuses on what we _should_ do over just a list of features and their syntax. The audience will learn what's missing from the typical understanding of "first normal form," how a correct understanding helps guide design decisions, and how to apply this to the design of databases where XML or other complex types are
Speaker(s): Eric Wilson,
Abstract:
This sessions highlights the major changes in the SSAS designer from 2005 to 2008. We will highlight many of the new design best-practices that are embedded in the designer and walk through the process of designing and customizing a cube.
Speaker(s): Rushabh Mehta,
Abstract:
SQL Server Integration Services is an essential part of a company's data process. Used for ETL and control flow, SSIS can be a boon for many enterprise solutions. Because this product offers such a steep learning curve for the uninitiated, take advantage of my experience by hearing some tips to get the most out of your packages. This session will offer tips for both SSIS 2005 and show some new features of SSIS 2008.
Speaker(s): Jessica Moss,
Abstract:
A look at recent extensions to the GROUP BY clause in Standard SQL, which will cover 1) Grouping sets and the GROUPING() function 2) ROLLUP 3) CUBE 4) ROW_NUMBER(), RANK() and DENSE_RANK()functions 5) the OVER() window clause not yet implemented in SQL Server.
Speaker(s): Joe Celko,
Abstract:
We will elaborate on our successful implementations of business intelligence in the private sector and in the government arena. We can share our challenges and successes on a couple different ETL (Extract Transform Load) approaches, data staging, data marts, creating Cubes and reporting and analysis. The technology we will cover is SQL Server 2005 and how we leveraged (SSAS) SQL Server Analysis Services (SSIS) SQL Server Integration Services and browsing with Excel 2007 to help drive dec
Speaker(s): Joe Horton,
Abstract:
Using the new Data Collector and Management Data Warehouse features in SQL Server 2008, learn how to create a baseline of your systems and monitor them for performance issues, and how to use the reports feature to show trends and analysis.
Speaker(s): Buck Woody,
Abstract:
This session will explore SQL Server 2005 DMV's. During this session will explore what DMV's are, and how they can be used to obtain information that SQL Server has collected about your SQL Server environment. Thing we will explore is how to identify indexes that have not been used, or indexes that SQL Server has identified that are missing. Other thing we will explore is how to use DMV's to identify your most expensive queries by CPU, I/O and elpased time.
Speaker(s): Greg Larsen,
Abstract:
In today’s world the role of the DBA is fast changing from been task orientated trouble shooter to the pro-active DBA who is monitoring the activities and resolving issues before the become apparent to the end user. Through the use of better tools both from with in SQL Server Management Studio and Third Party Vendors the ability of the DBA to monitor all the activities of a SQL Server makes the role of the DBA more pro-active. The metrics that a DBA uses requires an increase in skill level of th
Speaker(s): Bryan Oliver,
Abstract:
Using SQL Server Reporting Services can simplify designing reports, but how do you handle complex report requirements? This session will discuss how to handle these complex scenarios by using the new features of SSRS 2008. We will walk through building reports to showcase these situations. This session will be friendly to people who have experience in either SSRS 2005 or SSRS 2008.
Speaker(s): Jessica Moss,
Abstract:
Table partitioning can be a very way to manage very large tables and their indexes. In this presentation, you will learn about the practical issues of table partitoning, including choosing range direction, schema file placement, sliding and revolving windows, and partitioned indexed views. Partitioning features of both SQL Server 2008 and 2005 will be covered, and typical usage of the partiton-related DMVs and DMFs illustrated.
Speaker(s): Greg Larsen,
Abstract:
Most of the time, the SQL Server query optimizer does a great job of selecting an optimal query plan. On a rare occasion it does not, and when it does not, then hints are sometimes needed to help the query optimizer create an optimal query plan. In this session we will: • Learn when to use, and not to use hints • Learn how to implement commonly used hints • Learn hint best practices
Speaker(s): Brad McGehee,
Abstract:
Newbies coming from procedural languages whose procedures and functions allow non-scalar (i.e. non-1NF) parameters try to mimic familiar constructs in SQL by writing parsers for character strings or using proprietary XML extensions. The result is that they immediately lose all the power of declarative coding, parameter validation and performance. Then the maintenance of the code becomes a problem. SQL Server cam easily handle a long list of parameters. The code is not only safer but easy t
Speaker(s): Joe Celko,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/buckwoody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases. He is author of eight books on SQL for Morgan-Kaufmann: SQL FOR SMARTIES (1995, 1999, 2005, 2010), SQL PUZZLES ANSWERS (1997, 2006), DATA DATABASES (1999) and TREES HIERARCHIES IN SQL (2004), SQL PROGRAMMING STYLE (2005) and ANALYTICS OLAP IN SQL (2005) and THINKING IN SETS (2008). Mr. Celko's past columns include: Columns for Simple-Talk (Redgate Software); "CELKO" in INTELLIGENT ENTERPRISE magazine (CMP); BMC's DBAzine.com e-magazine; "SQL Explorer" in DBMS (Miller-Freeman); "Celko on SQL" in DATABASE PROGRAMMING DESIGN (Miller-Freeman); "WATCOM SQL Corner" in POWERBUILDER DEVELOPERS' JOURNAL (SysCon); "SQL Puzzle" in BOXES ARROWS (Frank Sweet Publishing); "DBMS/Report" in SYSTEMS INTEGRATION (Cahner-Ziff); "Data Desk" in TECH SPECIALIST (RD); "Data Points" in PC TECHNIQUES (Coriolis Group); "Celko on Software" in COMPUTING (VNC Publications, UK), "SELECT * FROM Austin" (Array Publications, The Netherlands), and he was editor for the "Puzzles Problems" section of ABACUS (Springer-Verlag) and he ran the CASEFORUM section 18, "Celko on SQL", on CompuServe.
Contact: http://www.bradmcgehee.com
Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master's in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years' SQL Server experience. He has been involved in the industry since 1982. Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.
LinkedIn: https://www.linkedin.com/in/grlarsen/
Greg Larsen has been working with SQL Server since 1999. He has authored 100's of articles related to SQL Server. He holds a MCSE Data Management and Analytics. Greg also a SQL Server Consultant, adjunct professor and technical writer.
Bryan Oliver has over 20 years of industry experience, 11 of which were spent working primarily with SQL Server. Bryan is a lead developer at Quest Software for a number of solutions, including LiteSpeed for SQL Server. Bryan’s position allows him to work with some of the largest and most recognizable SQL database environments in the world. He is also a valued speaker at conferences such as SQL PASS and SQL Server Summit. Born and raised in Australia, Bryan graduated from RMIT University in Melb
Joe Horton came from the private sector about 6 years ago and has worked for LNI, DSHS and now CTED (Community Trade Economic Development). Joe has been a developer for some 15 years and works mostly in SQL Server and in data warehousing. Sergio Nava has been private contracting for many years at DSHS. He has many SQL certifications. Sergio has been a part of 3 successful data mart implementations and is expert level.
LinkedIn: https://www.linkedin.com/in/grlarsen/
Greg Larsen has been working with SQL Server since 1999. He has authored 100's of articles related to SQL Server. He holds a MCSE Data Management and Analytics. Greg also a SQL Server Consultant, adjunct professor and technical writer.
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Contact: http://www.datazulu.com
Eric has 15 years experience designing and implementing database solutions in financial, publication, e-commerce, and manufacturing industries. Although a self-proclaimed relational bigot, he emphasizes how to mix pure theory with pragmatic trade-offs to achieve stable long-term systems. Eric has educational backgrounds in Economics and Statistics and recently completed a master's degree in Software Engineering. He currently works at FEI Company in Portland, Oregon.
LinkedIn: https://www.linkedin.com/in/rushabhbmehta
Contact: http://blogs.solidq.com/RushabhMehta
Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term. Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases. He is author of eight books on SQL for Morgan-Kaufmann: SQL FOR SMARTIES (1995, 1999, 2005, 2010), SQL PUZZLES ANSWERS (1997, 2006), DATA DATABASES (1999) and TREES HIERARCHIES IN SQL (2004), SQL PROGRAMMING STYLE (2005) and ANALYTICS OLAP IN SQL (2005) and THINKING IN SETS (2008). Mr. Celko's past columns include: Columns for Simple-Talk (Redgate Software); "CELKO" in INTELLIGENT ENTERPRISE magazine (CMP); BMC's DBAzine.com e-magazine; "SQL Explorer" in DBMS (Miller-Freeman); "Celko on SQL" in DATABASE PROGRAMMING DESIGN (Miller-Freeman); "WATCOM SQL Corner" in POWERBUILDER DEVELOPERS' JOURNAL (SysCon); "SQL Puzzle" in BOXES ARROWS (Frank Sweet Publishing); "DBMS/Report" in SYSTEMS INTEGRATION (Cahner-Ziff); "Data Desk" in TECH SPECIALIST (RD); "Data Points" in PC TECHNIQUES (Coriolis Group); "Celko on Software" in COMPUTING (VNC Publications, UK), "SELECT * FROM Austin" (Array Publications, The Netherlands), and he was editor for the "Puzzles Problems" section of ABACUS (Springer-Verlag) and he ran the CASEFORUM section 18, "Celko on SQL", on CompuServe.
The following is a list of sponsors that helped fund the event.