Event Location:
University of Portland
5000 North Willamette Blvd
Portland, Oregon
Abstract:
Data Architecture – a “Corner Stone” of Enterprise Architecture -As the organizations across the globe, aggressively pursues their strategic objectives; a key strategy and method is required in this pursuit, and that is ‘Data/Information Availability’. Accurate, reliable and available information enables the organization to make timely and better business decisions. We have seen many differing methodologies over the years with CRM, Portals, B2B efforts and score carding capabilities. The need for well structured and quality information is more important than ever. As a result, we are seeing a significant acceptance and synergy relative to the importance and value having a robust Data Architecture. Most organizations today have a co
Speaker(s): Atul Borkar,
Abstract:
Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to use Analysis Services to incorporate these complex algorithms seamlessly into your databases, from transactional processing to integration, data analysis and performance management. Attendees will be shown how to create a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample application that seamlessly uses the mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications.
Speaker(s): Carlos Bossy,
Abstract:
Many DBAs are thrust into a data warehouse project with little training and no experience, or they are forced to take over the existing Data Warehouse. Designing or fixing a Data Warehouse model that supports the full range of BI functions can be a challenge for the OLTP DBA. This session will reveal the essential components that you should put in place for a successful implementation, including concepts such as the Importance of Transformation, Redundancy and why Reuse can be Detrimental, and one of his favorite topics, Ease of Query. Additionally, the significance of Integration, Metadata, and Governance towards creating a rock-solid, sometimes brilliant, foundation for your Business Intelligence Data Architecture will be presented.
Speaker(s): Carlos Bossy,
Abstract:
SQL Server Integration Services is Microsoft’s Extract Transform Load/Data Integration (ETL/DI) tool, replacing DTS. SSIS is a very powerful and complex tool that can read data in from virtually any source, transform and mash that data however you like, then send it out to virtually any type of destination. Understand how SSIS can be used to do just that – from the basics. Find out how to get started using SSIS, hear what it’s really good at, and figure out what things you need a hacker’s spirit to accomplish with it. This session is demo heavy; Tasks, expressions, precedence constraints, text files, Excel, SQL, data type conversions, performance, scripts, configurations, scheduling, and more will be covered with examples.
Speaker(s): Todd McDermid,
Abstract:
Your CIO's top priority in 2010 is probably Business Intelligence. If you don't know what BI is, or are trying to deliver it directly from your OLTP database, you need to find out what you're getting into. BI is all about helping your business users make better decisions, faster. Find out what it will take to deliver what your CIO is asking for. BI from your OLTP database has problems - it requires technical knowledge of your data model, compromises your line of business application responsiveness, and won't perform well. The solution to all of those issues is to construct a Data Warehouse based on Dimensional Modeling. I'll show you why normalized OLTP databases have problems supporting BI, and how Kimball method Data Warehouses don't.
Speaker(s): Todd McDermid,
Abstract:
"R2"? What does THAT mean? Is this a "full" release or not? Buck Woody, Microsoft's real-world DBA and all around Gadfly will regale you with the explanation of such acronyms as "DAC", "UCP" and "MDW", and he'll explain what StreamInsight, Master Data Services and PowerPivot can really do for you. You'll take a quick tour of the features you should know about in SQL Server 2008 R2, the version of SQL Server that just couldn't wait for another year.
Speaker(s): Buck Woody,
Abstract:
Learn the fundamentals of MDX query design for Analysis Services cubes. Migrate your SQL skills to this simple and elegant language that will enable you to unlock the awsome power of a cube and to gain deep insight from a single version of the truth. Learn to develop dynamic, advanced reports by parameterizing MDX queries using expressions and custom code.
Speaker(s): Paul Turley,
Abstract:
Visual Studio Database Edition (VSDB) offers many benefits for the deployment process as well as the development of database updates. You may know it by its nickname - the "Data Dude". It provides for declarative style of approaching updates in a collaborative environment. This tool has been undergone significant enhancements recently and has many compelling features. We'll view some the key functional areas of the tool, discuss best practices, and take a look at what features companies could take advantage of. VSDB is free to download for use with Visual Studio 2008 Developer and Team Suite Edition. It is also included as part of the Visual Studio 2010 Premium edition.
Speaker(s): Tim Giorgi,
Abstract:
The secret to designing compelling report solutions is in the ingredients and the technique. Learn to apply proven design patterns and best practices to create a reporting solution masterpiece. These techniques employ expressions, parameters, custom programming and years of field experience. This presentation is based in-part from our forthcoming Wrox Press Book: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports.
Speaker(s): Paul Turley,
Abstract:
In this session, learn how to set up standard and data-driven subscriptions using Report Manager. We discuss creating file-share, email, and null subscriptions; and how to deal with potential issues with parameters and security. We also demonstrate a sophisticated Microsoft ASP.NET-based application that creates subscriptions by calling the SSRS Web Services API.
Speaker(s): Paul Litwin,
Abstract:
A look at the basic Nested Sets versus Adjacency List models. Why Nested sets model hierarchies and Adjacency List model trees. This will stress the need for constraints to prevent cycles in either model. The problems of hierarchical aggregation -- Nested Sets requires one set-oriented query and Adjacency List requires iterations or recursion.
Speaker(s): Joe Celko,
Abstract:
In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2008 databases. We will also be looking into the new indexing features that are available in SQL Server 2008 (and SQL Server 2005) and how you the .NET developer can make the best use of them to get your code running its best.
Speaker(s): Denny Cherry,
Abstract:
Interpreting SQL performance counters and OS related counters is an essential skill for a SQL DBA. In this session, we will discuss most relevant OS and SQL performance counters, vital signs, and preferred threshold values.
Speaker(s): Joshua Jin,
Abstract:
We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money. There are some other times when you will be shooting yourself in the foot and shouldn’t. We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.
Speaker(s): Denny Cherry,
Abstract:
The SCD Wizard included in Integration Services is easy to use, and has all the features you need for smaller, simple dimension processing. However, it is not the easiest component to adjust, and doesn't perform very well with larger dimensions. This session will cover three alternative techniques for processing changes to dimension tables within SSIS: "rolling your own SCD" with Lookups and Conditional Splits, using the T-SQL MERGE statement, and the Kimball Method SCD component. The strengths and weaknesses of each technique will be described and demonstrated.
Speaker(s): Todd McDermid,
Abstract:
Come hear Buck Woody, Microsoft's "Real World DBA" give a marketing-free introduction to SQL Server for the Oracle professional. No experience in SQL Server is necessary - we'll cover the basics of SQL Server Architecture using Oracle concepts as a guide. If you're an Oracle professional and you want to add SQL Server to your "knowledge arsenal", come hear this overview. You'll also get a list of resources that will enable you to research further.
Speaker(s): Buck Woody,
Abstract:
Use the right tool from your SQL toolbox to maintain those indexes, determine which indexes are being used (and more importantly which ones are NOT being used), and get recommendations on indexes to create all from Dynamic Management Views. Walk away with scripts you can use in your environment IMMEDIATELY.
Speaker(s): Tim Ford,
Abstract:
This session is targeted for those who have found themselves accidentally responsible for the SQL Server databases where they work, or are generally new to SQL Server. We'll cover the basics of Backup and Restore processes as well as a high overview of HA architectures available including Database Mirroring, Clustering, Replication, and Log Shipping. Scripts will be provided for immediate use in your own environment as a take-away from this presentation.
Speaker(s): Tim Ford,
Abstract:
Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process I use with great success and it will include topics such as: SQL diagramming, wait type data, column selectivity, and others that will help you succeed on future tuning projects.
Speaker(s): Dean Richards,
Abstract:
This session will cover T-SQL coding best practices. The basics on how to code T-SQL statements to optimize your queries will be covered. In this session, you will discover some of the common pitfalls that can cause T-SQL statements to run slow. A number of demos will be done to show how by making slight changes in your code will minimize the resources used to process your queries. From this session, you will be able to take home a list of T-SQL coding guidelines to help your code more efficient T-SQL statements.
Speaker(s): Greg Larsen,
Abstract:
This session will show how to achieve 99.9999 High Availability of SQL Server database on physical cluster and on Cloud.• SQL Server 2008 cluster Deployment• SQL Server 2008 Mirroring• Sql Server cloud deplyment.
Speaker(s): Munir Ghamrawi,
Abstract:
Solid-state technologies are changing the way that SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies. Solid state is changing the way datacenters look and how SQL performs. 1) On overview of solid state technology options for SQL Server 2) Why solid state makes a difference? 3) An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each: 4) Customer proof: Wine.com case study
Speaker(s): Sumeet Bansal,
Abstract:
Microsoft SQL Server 2005 and 2008 include a fantastic feature that few people understand or use. That feature is the Microsoft SQL Server Service Broker. The SQL Service Broker is one of the least used features within the database engine, and that lack of use is simply from last of knowledge about the feature. In this session we’ll dig into how to configure the service broker for not only intra-database message queuing, but database to database queuing as well as server to server database queuing. We will also dig into a real life scenario where the SQL Server Service Broker was used to do ETL from an OLTP database to an OLAP database in near real time for near real time reporting.
Speaker(s): Denny Cherry,
Abstract:
High volume contiguous ETL is always problematic, and even more so when near-real-time is desired. This presentation goes through a solution collects and aggregates security audit data for nearly 400000 machines, a contiguous 24x7 stream of nearly 200 events per second, using a budget tight solution that involves SQL Express, Service Broker and Database Mirroring.
Speaker(s): Remus Rusanu,
Abstract:
This session will explore different DMV and how they can be used to obtain information about your SQL Server environment. There will be a number of demo's. In these demos different DMV's will be used provide different infomation about how your SQL Server instance is running. Peeking under the covers is now only a DMV away.
Speaker(s): Greg Larsen,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
LinkedIn: http://www.linkedin/in/carlosbossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Contact: http://thesqlagentman.com
Tim Ford is a Microsoft SQL Server MVP and co-founder of SQL Cruise (sqlcruise.com). He is currently a Senior DBA and the SQL Server SME with Spectrum Health, a major healthcare system located in West Michigan. He is the leader of the West Michigan SQL Server Users Group (westmisql.org) and is a community speaker and author. His book with Louis Davidson: Performance Tuning With SQL Server Dynamic Management Views is now widely available.
Over 25 Years of Information Technology experience mainly with various relational database technologies and business capabilities. I am currently working in Intel Corporation as an Enterprise Architect, with having expertise in Business (B), Data (D), Application (A) and Technology (T) areas. I am also an active board member of Local DAMA Chapter for Portland, OR. Currently I am actively involved in using, practicing and advocating Lean Six Sigma Methodologies (Black Belt) across Intel.
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.
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.
LinkedIn: https://www.linkedin.com/in/pturley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
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.optsolutions.com
Tim Giorgi is in his 15th year as an independent consultant, specializing in custom software development. He has worked in many different roles on software teams ranging from architecture, design, development and project management. Tim gets jazzed out of reviewing technology and finding ways to integrate it efficiently for organizations. He is active in the tech community with the Portland SQL Server User’s group, the Scoutmaster of a Boy Scout Troop, and a Damascus City Planning Commissioner.
Contact: http://www.deeptraining.com
Paul Litwin is a developer specializing in ASP.NET, C#, SQL Server, SQL Server Reporting Services, and related technologies. Paul is a Programmer Manager with Fred Hutchinson Cancer Research Center in Seattle. He is also the owner of Deep Training. Paul has authored a number of books and training courses on ASP.NET, SQL Server Reporting Services, and Micrsoft Access. Paul is the conference chair of Microsoft ASP.NET Connections, a Microsoft MVP, and a member of the INETA Speakers Bureau.
LinkedIn: http://www.linkedin/in/carlosbossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
LinkedIn: https://www.linkedin.com/in/mrdenny
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
LinkedIn: https://ca.linkedin.com/in/toddmcdermid
Contact: https://toddmcdermid.blogspot.com
Todd McDermid is a local BC developer who’s turned into a data warehouse and business intelligence evangelist. He started out programming DBase, VB6, and C# - but is now passionate about the SQL Server BI stack. He’s concentrated on using Integration Services to build the backbone of BI delivery – a dimensional warehouse. Todd has been known to blog, forum troll, code open-source extensions, and present on BI topics across the continent.
Sumeet Bansal is Principal Solutions Architect for Fusion-io. He designs architectural solutions with Fusion-io products that deliver unprecedented levels of scalability, performance and simplicity. Sumeet has more than 11 years IT and database-infrastructure experience, including work as vice-president of information technology at MS SQL-based Internet retailer Wine.com, senior database architect for MS SQL-based eVineyard inc., and systems analyst for Akiba Bank Limited.
LinkedIn: https://www.linkedin.com/in/mrdenny
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
Contact: http://rusanu.com
Remus Rusanu is a developer working with Microsoft SQL Server team in Redmond, WA. He blogs about his interest in SQL Server at http://rusanu.com and answers many sql-server tagged question on stackoverflow.com.
LinkedIn: https://www.linkedin.com/in/mrdenny
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
LinkedIn: https://ca.linkedin.com/in/toddmcdermid
Contact: https://toddmcdermid.blogspot.com
Todd McDermid is a local BC developer who’s turned into a data warehouse and business intelligence evangelist. He started out programming DBase, VB6, and C# - but is now passionate about the SQL Server BI stack. He’s concentrated on using Integration Services to build the backbone of BI delivery – a dimensional warehouse. Todd has been known to blog, forum troll, code open-source extensions, and present on BI topics across the continent.
LinkedIn: http://www.linkedin.com/pub/dean-richards/6/167/a90
Dean Richards is a Senior DBA for DBMS Insights and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize and move databases to the cloud.
Munir Ghamrawi is a Sr Database Architect . He is one of contributing engineers for a private Cloud computing architecture with respect to Database technologies. Currently he is working on achieving 99.99999 high availability of SqlServer database applications include patching, maintenance.
Joshua Jin is a frequent speaker at SQL PASS local chapter in Portland, Oregon. He holds MCITP Business Intelligence Developer, Database Administrator, and Database Developer certifications for SQL Server 2005. Joshua is one of contributing authors of “Professional SQL Server 2005 Performance Tuning” book by Wiley/Wrox. At Intel IT, currently he is the development lead of a large SQL BI project for a private Cloud.
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.
Contact: http://thesqlagentman.com
Tim Ford is a Microsoft SQL Server MVP and co-founder of SQL Cruise (sqlcruise.com). He is currently a Senior DBA and the SQL Server SME with Spectrum Health, a major healthcare system located in West Michigan. He is the leader of the West Michigan SQL Server Users Group (westmisql.org) and is a community speaker and author. His book with Louis Davidson: Performance Tuning With SQL Server Dynamic Management Views is now widely available.
LinkedIn: https://www.linkedin.com/in/pturley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
LinkedIn: https://ca.linkedin.com/in/toddmcdermid
Contact: https://toddmcdermid.blogspot.com
Todd McDermid is a local BC developer who’s turned into a data warehouse and business intelligence evangelist. He started out programming DBase, VB6, and C# - but is now passionate about the SQL Server BI stack. He’s concentrated on using Integration Services to build the backbone of BI delivery – a dimensional warehouse. Todd has been known to blog, forum troll, code open-source extensions, and present on BI topics across the continent.
The following is a list of sponsors that helped fund the event.