Event Location:
British Columbia Institute of Technology (BCIT)
3700 Willingdon Avenue
Burnaby, British Columbia, Canada
Abstract:
Have you ever wanted to create a recursive query, but didn't see how to do it. With the Common Table Expressions class you will learn everything needed to start using CTE's for recursive queries, as a temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE's. One of the most overlooked features of SQL Server is the CTE which no only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. This presentation is targeted for database programmers and administrators who are familiar with TRANSACT SQL, Subqueries, and advanced join techniques.
Speaker(s): Steve Stedman,
Abstract:
A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we will gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.
Speaker(s): William E Pearson III,
Abstract:
As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker(s): William E Pearson III,
Abstract:
Create a highly-visual reporting experience in SharePoint with SQL Server Reporting Services integrated with SharePoint 2010. See how to use BI report design elements like sparklines, KPI indicators, gauges and maps to make important business information jump off the screen and get users’ attention. Create highly-interactive reports with dynamic drill-down, drill-through and super reports that morph as users interact with the data. Build an interactive dashboard using PerformancePoint/Insights and Reporting Services together.
Speaker(s): Paul Turley,
Abstract:
We are going to walk through major topics of T-SQL programming, from simple select statement, joins, transaction controls to the coding of TSQL modules, caveats, and best practices.
Speaker(s): John Huang,
Abstract:
We all complete a full design document prior to coding, don’t we? What elements should be included in the design document? This session will explore a number of techniques for producing a solid design document and obtaining buy-in from the end users.
Speaker(s): Michael Lato,
Abstract:
Did you know that when SQL encounters an error of Severity 11 (or higher), there a 4 different ways it can react? Learn how to predict the Error Action or control it. This is possible with or without structured error handling. See both ways to control the outcome. This is a very common workplace faux pas and a Microsoft Certification topic for Dev and Admins. We will use lessons from SQL Programming Joes 2 Pros Vol4.
Speaker(s): Rick Morelan,
Abstract:
Trent will discuss everything you need to know about baselines: why they’re important, how to use them and ways to create them using native SQL Server tools. He will also introduce you to Quest’s tools that can make all of this so much easier!
Speaker(s): Michael Lato,
Abstract:
Forget Profiler for a second, I have seen one poorly placed index bring an enterprise database to its knees. We will cover the basic tips of performance which always work and the ones which always fail. What can you do – and what should you do –when it comes to the most common types of indexes so you always make the right move. We will use lessons from SQL Architecture Joes 2 Pros Vol3.
Speaker(s): Rick Morelan,
Abstract:
The next-generation analytic, self-service reporting tools will knock your socks off! The Power View reporting experience in SQL Server 2012 and SharePoint 2010 takes user reporting to the next level and makes data exploration fun without writing queries and code. Come see the impressive performance capabilities of BI Semantic Tabular models used with high-volume, enterprise data. Two great things that go great together!
Speaker(s): Paul Turley,
Abstract:
The VertiPaq storage engine has moved out of PowerPivot and out to standalone AS instances. Learn how to build and develop tabular models for these corporate scenarios. You will learn basic modeling techniques, partitions, security, and administration.
Speaker(s): Cathy Dumas,
Abstract:
Reserved for Microsoft
Speaker(s): Michael Lato,
Abstract:
Tabular models use DirectQuery to connect to data sources and fetch data in real time. Learn how DirectQuery works, see how to build DirectQuery models, and learn security and troubleshooting techniques.
Speaker(s): Cathy Dumas,
Abstract:
Raffle Draws
Speaker(s): Michael Lato,
Abstract:
This is an introduction session of MCM/MCA certification on behave of MCM program for senior SQL professionals. I will talk about current MCM status, new advanced certificates, and preparation of MCM from my past experience. Bring all your questions.
Speaker(s): John Huang,
Abstract:
Assessing the health of your SQL Server with Several SQL Server Report Server reports designed for DBA’s and database developers to diagnose, and locate common pitfalls of SQL Server. This includes reports for Duplicate Indexes, Index Fragmentation, Big Indexes, Backup Status - backup log, Big One Time Use Queries, Queries Needing Parameters and more.
Speaker(s): Steve Stedman,
Abstract:
Does your company use agile development? It can deliver more value to customers with lower project risk. However, it can also make the system design change rapidly, and require frequent software rollouts. This session will focus on best practices for DBAs and developers to make design, testing and deployments easier. Keep your systems agile, not fragile!
Speaker(s): Dev Nambi,
Abstract:
PowerShell is cool. And powerful. Don’t believe me? See it for yourself. Come to this session, and I will show you cool things we can do with PowerShell – ranging from backing up your servers, working with BLOBs and XML, to automating SSRS report deployments and downloads, and even integrating with SSIS. We’ll work with different facets of SQL Server from a PowerShell perspective.
Speaker(s): Donabel Santos,
Abstract:
You’ve heard of the term “ETL” before, but you’re not quite sure what it really is and how to do it. In this session we’ll demystify this so-called ETL. Don’t worry, no previous experience required. We’ll work our way from getting your data from your sources, to cleaning and reformatting them, and loading them to your data warehouse. We will also look at some standards and conventions you should consider when doing ETL to simplify your process, and save you some headaches in the future. Of course, our go-to ETL tool is SSIS.
Speaker(s): Donabel Santos,
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.sqlnotes.info
Contact: http://www.sqlnotes.info
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.
LinkedIn: http://www.linkedin.com/in/stevestedman
Contact: http://SteveStedman.com
Steve Stedman is the Leader of a PASS Local Group in Bellingham WA USA. Steve runs his own SQL consulting firm Stedman Solutions, LLC. He has 29 years of programming and SQL experience. He has written the book on SQL Common Table Expressions. He teaches, speaks at conferences, writes, and has taught SQL server classes at Western Washington University. Steve has previously spoken at PASS Summit, TechEd, DevTeach Vancouver, many SQLSaturdays, and more.
Michael Lato has more than 10 years of experience consulting on various database systems with a special focus in the CRM (Customer Relationship Management) field. Michael’s roles have included project manager, system designer and trainer. He is currently the senior SQL Server developer and database administrator for an international in-building wireless company.
Michael Lato has more than 10 years of experience consulting on various database systems with a special focus in the CRM (Customer Relationship Management) field. Michael’s roles have included project manager, system designer and trainer. He is currently the senior SQL Server developer and database administrator for an international in-building wireless company.
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.
Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.
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.
Contact: http://www.sqlmusings.com
Donabel Santos (MCITP, MCT) is a SQL Server MVP and is the senior SQL Server Consultant/Trainer at QueryWorks Solutions in Vancouver, BC. She has worked with SQL Server since version 2000 in numerous development, tuning, reporting, and integration projects with ERPs, CRMs, SharePoint, and other custom applications. She is the author of SQL Server 2012 with PowerShell V3 Cookbook from Packt Publishing.
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
LinkedIn: http://www.linkedin.com/in/stevestedman
Contact: http://SteveStedman.com
Steve Stedman is the Leader of a PASS Local Group in Bellingham WA USA. Steve runs his own SQL consulting firm Stedman Solutions, LLC. He has 29 years of programming and SQL experience. He has written the book on SQL Common Table Expressions. He teaches, speaks at conferences, writes, and has taught SQL server classes at Western Washington University. Steve has previously spoken at PASS Summit, TechEd, DevTeach Vancouver, many SQLSaturdays, and more.
Michael Lato has more than 10 years of experience consulting on various database systems with a special focus in the CRM (Customer Relationship Management) field. Michael’s roles have included project manager, system designer and trainer. He is currently the senior SQL Server developer and database administrator for an international in-building wireless company.
Rick has worked more than 12 years at Microsoft and has attained over 30 Microsoft technical including certifications in applications, networking, databases and .NET development (MCDBA, MCTS, MCITP, MCAD, MOE, MCSE, MCSE+I). He has also provided training for NW University, Volt Technical Education, The DigiGirlz, and Microsoft. Rick is the Author of the 5 volume SQL Joes 2 Pros book series.
Contact: http://devnambi.com
I am a SQL Server Developer/Architect and involuntary DBA at Microsoft and have worked with SQL Server for 7+ years. I specialize in performance tuning, agile development, VLDBs, and relational data warehousing. I blog at www.devnambi.com and on Twitter at @devnambi .
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Michael Lato has more than 10 years of experience consulting on various database systems with a special focus in the CRM (Customer Relationship Management) field. Michael’s roles have included project manager, system designer and trainer. He is currently the senior SQL Server developer and database administrator for an international in-building wireless company.
LinkedIn: http://www.sqlnotes.info
Contact: http://www.sqlnotes.info
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.
Contact: http://www.sqlmusings.com
Donabel Santos (MCITP, MCT) is a SQL Server MVP and is the senior SQL Server Consultant/Trainer at QueryWorks Solutions in Vancouver, BC. She has worked with SQL Server since version 2000 in numerous development, tuning, reporting, and integration projects with ERPs, CRMs, SharePoint, and other custom applications. She is the author of SQL Server 2012 with PowerShell V3 Cookbook from Packt Publishing.
The following is a list of sponsors that helped fund the event.