SQLSaturday #172 - Oregon 2012
Event Date: 11/03/2012 00:00:00
Event Location:
- Mittleman Community Center
- 6651 SW Capitol Highway
- Portland, Oregon
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: The Cloud is Coming for Your Career - Buwahahahaha
Abstract: Oh noes! Everyone tells me to throw away all my servers, and just move everything to the cloud! What will happen to my job? How will my children go to college? Buck Woody, Senior Technical Specialist on Windows Azure will answer these other questions, including: Why do they call something technical a “cloud”, since a cloud is something with undefined borders made of vapor? Isn’t this just the latest hype, a new buzzword that will soon be gone? Is anyone really using it for production? Are there real reasons to do that? If it’s real, how does it affect my job as a technical professional? What do I need to learn, and where can I learn it? This isn’t sales or marketing - a technical discussion on architectures and how they affect what you do.
Speaker(s):
- Buck Woody
Track and Room: - N/A
Title: PowerShell for Data Professionals
Abstract: You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker(s):
- Aaron Nelson
Track and Room: 4 -Powershell - N/A
Title: Understanding Indexes
Abstract: We all know indexes can speed up queries. But why? And how? Why is “index on every column” not a good indexing strategy, why is your shiny new index not used, and why can adding indexes even hurt performance? The key to answering this is understanding how SQL Server lays out your data on disk, how this changes when you add an index, and how SQL Server uses these indexes to find the information required for your queries. In this presentation, Hugo explains (with animated visualization) how heaps, clustered indexes, and nonclustered indexes are organized on disk, and used for scans, seeks, and lookups. Armed with this information, you should be able to find just the right set of indexes for your workload.
Speaker(s):
- Hugo Kornelis
Track and Room: 1 -Indexes - N/A
Title: Powershell Smoke for SQL Server Mirrors
Abstract: SQL Server mirrors are a great way to maintain highly available, fast-failover systems that run on independent disk sets. While it is easy enough to work through the GUI or T-SQL to manage your mirrors, if you have a lot of them, the processes can become tedious. Also, there is not a fast easy way to tear down and build up a mirror after something goes wrong. I’ll show how I leveraged some of the SMO mirroring objects, so that I could not only build and tear down database mirrors efficiently, but to also monitor their health. These same objects can be used to build mirror-aware applications, or ones that could automate the provisioning of highly available databases for critical applications.
Speaker(s):
- Ed Snajder
Track and Room: 4 -Powershell - N/A
Title: The Accidental Programmer
Abstract: Most people in the database world have heard of the term, “The Accidental DBA”, those programmers who have to work with databases. How about the other side of the coin? What about DBA’s an Dev’s who have to write code or have to work closely with programmers? This presentation is a best practices guide for working with SQL Server in a .Net environment. You will learn how to recognize when bad code is written that interacts with the database, how to track it down, and most importantly how to fix it. On top of that you will also receive an introduction to object oriented programming concepts such as data abstraction, encapsulation, tier architecture, and class objects so that you can better communicate with your programmers.
Speaker(s):
- Jason Kassay
Track and Room: 2 -SQL Dev - N/A
Title: Troubleshooting SQL Server with PowerShell
Abstract: It is normal for us to have to face poorly performing queries or even complete failure in our SQL server environments. This can happen for a variety of reasons including poor Database Designs, hardware failure, improperly-configured systems and OS Updates applied without testing. As Database Administrators, we need to take precaution to minimize the impact of these problems when they occur, and so we need the tools and methodology required to identify and solve issues quickly. In this Session we will use PowerShell to explore some common troubleshooting techniques used in our day-to-day work as s DBA. This will include a variety of such activities including Gathering Performance Counters in several servers at the same time in async mode.
Speaker(s):
- Laerte Junior
Track and Room: 4 -Powershell - N/A
Title: Rapidly Deploying SQL Server with PowerShell
Abstract: As much as you love SQL Server, do you cringe anytime you hear that you’ll need to stand up yet another SQL Server instance? Sure it’s fun, but who has the time? Maybe you’ve thought there must be a better way of doing this? Sure, you have the ability to generate an unattended install file, but what about all the other things that will need to be done? In this talk, we will explore a process that was created to truly automate not just the SQL Server install, but all of the configurations and the deployment of your organizations standard objects, all using a set of PowerShell scripts that you can download and use today. This session will review the process that has saved hundreds of hours for one organization and can do the same for yours.
Speaker(s):
- Michael Wells
Track and Room: 4 -Powershell - N/A
Title: Killer Techniques for Database Performance
Abstract: No matter how much you tune your code, if the database is slow your application will be slow. While there are as many ways to make a database faster as there are databases, there are universal principles to apply that make the performance tuning process easier. Learn how to identify indexes, understand execution plans, and configure storage.
The database the most critical piece of any environment; performance problems in the database cascade outward to effect everyone. This talk will cover tried and true techniques to ease the pain of growing a database while improving application performance from the perspective of both a large enterprise and a small business.
Speaker(s):
- Jeremiah Peschka
Track and Room: 6 -Performance - N/A
Title: Running SQL Server 2012 on Server Core: Why How
Abstract: Security and Performance are always two of the top issues for SQL Server DBAs. Until recently the cost of the Operating System was something that you had almost no control over, but with SQL Server 2012 (Denali) you now have the option of running on the Core edition of Windows Server. While Core edition has been used primarily for infrastructure servers like Domain Controllers and DNS servers, SQL Server 2012 now brings support for running the database engine on it. This session will talk about when you may want to consider running SQL on Server Core and will guide you through the task of installing and configuring your server when you no longer have most of the Windows configuration tools that you may be used to.
Speaker(s):
- Michael Wells
Track and Room: 5 -On/Off Prem - N/A
Title: Introducing SQL Server Data Tools. (Project Juneau
Abstract: Your final scripts deployed to the live database a few months ago and almost everything went perfectly. Since then you have heard there were few index patches needed maybe even a new column in one or the tables. The live database has drifted just a little from your deployed SQL scripts. How would you like to update your next baseline code to already resemble the current state of the production database? This is just one of the incredible features you can do with SSDT. Take the statefull nature of your database to create and test your code automatically and declaratively. Database developers can use the SQL Server Object Explorer in VS to easily. See how the new scripting and automation tools are used in SQL 2012 with SSDT.
Speaker(s):
- Rick Morelan
Track and Room: 2 -SQL Dev - N/A
Title: Unleashing Common Table Expressions in SQL Server
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 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 not 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. Learn how recursive CTE’s perform better than other methods to create hierarchical results. See how CTE’s compare to SQL Server 2012 offset and fetch paging techniques.
Speaker(s):
- Steve Stedman
Track and Room: 2 -SQL Dev - N/A
Title: Performance Enhancing Laziness
Abstract: Walk-up work. New database requests. Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps.Surprise SQL instances created by vendors without our knowledge crashing around us!It’s enough to drive a lesser DBA crazy-insane. That’s why it’s important to take as many steps as you can to simplify, automate, tweak, and tune the tasks you can manage so you have time to deal with those situations you can’t control. In this session Tim will go over many of performance-enhancing methods he’s developed over the last dozen years as a DBA for a major healthcare concern and show you how you can give yourself some breathing room to make the difficult seem easy.
Speaker(s):
- Tim Ford
Track and Room: 6 -Performance - N/A
Title: The Significance of Choosing and Using Data Types
Abstract: It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. My goals in this presentation are to show you 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 proper usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of imappropriate data types or improper usage of them. In addition, I will cover serveral data type related functions and point out caveates in their usage.
Speaker(s):
- Vern Rabe
Track and Room: 7 -Getting it Right - N/A
Title: New Data Management Capabilities with SQL Server 2
Abstract: Microsoft SQL Server is one of the most commonly virtualized applications in VMware environments. With the release of SQL Server 2012, Microsoft introduces full support for SMB. Now you can install SQL Server 2012 with both system and user databases on SMB file shares. This allow you to build end-to-end NAS solutions where the data management capabilities of NAS, such as volume auto grow and the ability to shrink NAS volumes, can be taken advantage of by the SQL Server. This session will demonstrate how to install and run SQL Server over SMB and VMware NFS storage. Best practices, caveats, and performance of SQL Server database over SMB and NFS will also be discussed.
Speaker(s):
- Pat Sinthusan
Track and Room: 7 -Getting it Right - N/A
Title: What DBAs Should Know About Windows Server 2012
Abstract: Windows Server 2012 is coming! As a DBA, you should understand Microsoft’s new operating system and its important set of features that will change the way you deploy SQL Server and design high availability solutions in your environment. In this session, you’ll learn about the benefits that Windows Server 2012 brings to SQL Server, see how to install and configure Windows 8 for a SQL Server deployment, and explore new features that will affect your virtualization and high availability architectures.
Speaker(s):
- Victor Isakov
Track and Room: 2 -SQL Dev - N/A
Title: What’s New for Self-Service BI in Excel 2013
Abstract: The self-service BI capabilities in Excel 2013 are growing in leaps and bounds! This presentation describes and demonstrates the PowerPivot and Power View functionality embedded inside the Excel client. Demonstrations will focus on the new features supported by both tools in the Excel 2013 preview. This presentation is relevant to those already experienced with PowerPivot and Power View, as well as those new to each.
Speaker(s):
- Peter Myers
Track and Room: 3 -BI Treats - N/A
Title: 2012 TSQL Sweets
Abstract: The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you’ll have a taste for all the sweets they’ve packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.
Speaker(s):
- Bill Fellows
Track and Room: 2 -SQL Dev - N/A
Title: Overview of PowerPivot
Abstract: Learn how easy it is to utilize the free download from Microsoft that allows users of Excel to extract business intelligence from a variety of data sources. This introductory session will demonstrate the power of PowerPivot in analyzing large sets of data quickly and efficiently.
Speaker(s):
- David Eichner
Track and Room: 3 -BI Treats - N/A
Title: Looking to the future - Tabular Mode SSAS
Abstract: In this session, attendees will be treated to an introduction to tabular mode. Installation, configuraiton, development tips, maintance, and end user reporting options will all be introduced. A description of BISM and what it means for our beloved Multi-Dimension cubes will be discussed. Attendees wanting to know when to use tabular, and when to stick with multi-dimensional will want to attend this introductory session.
Speaker(s):
- Josh Fennessy
Track and Room: 8 -ETL Analysis - N/A
Title: Extend Your Knowledge with Extended Events!
Abstract: SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.
Speaker(s):
- Janis Griffin
Track and Room: 7 -Getting it Right - N/A
Title: READPAST Furious-Transactions,LockingIsolation
Abstract: Do you really understand SQL Servers’ Concurrency behaviour? Are you sure that Transactions are an ALL or NOTHING operation? Do you believe Read operations cannot start a Transaction? Do you really know if READ UNCOMMITTED is safe for reporting? Is being Optimistic really better than being Pessimistic? Can SQL Server 2012 be the solution to all our problems or our worst nightmare?
I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner.
Speaker(s):
- Mark Broadbent
Track and Room: 6 -Performance - N/A
Title: Introduction to SQL Server 2012 MDS and DQS
Abstract: This presentation introduces the upgraded features of SQL Server 2012 Master Data Services (MDS) and the new service, SQL Server 2012 Data Quality Services (DQS).
MDS is a solution for master data management. First released in SQL Server 2008 R2, this upgraded version includes many new features and enhancements, including a new web interface developed with Silverlight, an Excel add-in to support simplified model creation and easier data updates and management.
DQS is a new knowledge-driven data cleansing solution, and it supports building knowledge bases that provide correction and de-duplication of data.
Speaker(s):
- Peter Myers
Track and Room: 8 -ETL Analysis - N/A
Title: Recovering from Corruption
Abstract: Corruption cannot always be avoided. You can take steps to ensure early detection, and you can prepare for the eventuality of it occurring, but it’s not possible to completely prevent it. Early detection is your best protection against data lost due to corruption.
In this session, we will discuss the protections within SQL Server to help identify corruption and to help recover from it. We will look at the different types of corruption that could hit your database and the best way to deal with each type. Includes live demos recovering from different types of corrupt databases.
Speaker(s):
- Robert Davis
Track and Room: 6 -Performance - N/A
Title: Efficient On-Premise to Cloud Data Transfer
Abstract: Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just like hearing talks about data transfer performance?! Have we got the session for you! We’ll cover some common user scenarios, and describe when and how to use the latest Microsoft data transfer technologies, including SQL Server Integration Services (SSIS), SQL Data Sync (a capability of SQL Database), and more.
Speaker(s):
- Matt Masson
Track and Room: 5 -On/Off Prem - N/A
Title: SSIS Incremental Load Design Patterns
Abstract: (Note: This session will be co-presented by Tim Mitchell and Matt Masson)
In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing. Among the topics of discussion: •Deciding whether an incremental load is appropriate •Pick your tool: T-SQL or SSIS? •Methods for de
Speaker(s):
- Tim Mitchell
Track and Room: 8 -ETL Analysis - N/A
Title: Building Faster SQL Servers
Abstract: SQL Server speed boils down to how fast we can get data in and out of storage. Sooner or later, we’re going to run out of memory to cache. In this session, we take a lesson from Microsoft’s blazing-fast Fast Track Reference Architectures, look at why they work so well for the wildest queries, and explain how to build our own SQL Servers for quick queries. Brent Ozar shows you how to test your own servers and compares them to servers he’s worked with in the field.
Speaker(s):
- Brent Ozar
Track and Room: 5 -On/Off Prem - N/A
Title: The Most Ignored Best Practices
Abstract: Everyone would agree that setting up, configuring, and applying best practices to a database server environment, is always easier to do in the early stages of deployment. Yet too often, environments are built, grow, and become business critical, without such efforts completed until performance and stability become a problem. This session will discuss how this keeps occurring, how we can avoid it from continuing, and some basic standards that should be found in almost any environment.
Speaker(s):
- Michael Swinarski
Track and Room: 7 -Getting it Right - N/A
Title: Advanced Indexing
Abstract: So you know all about heaps, clustered indexes, and nonclustered indexes, but are still not satisfied? Then this is just the session for you! Hugo will explore advanced features such as included columns, indexed views, and filtered indexes. You will find out how they are stored on disk, and how SQL Server uses them to satisfy queries. Then, you will see the tools SQL Server itself hands you to help identify just the right subset of indexes. And finally, you will get an stunning demonstration of just how bad you can hurt performance by following all those recommendations and creating too many indexes.
Speaker(s):
- Hugo Kornelis
Track and Room: 1 -Indexes - N/A
Title: SSIS Patterns and Practices: Loading Fact Tables
Abstract: This session focuses on many patterns, practices, and important considerations for loading data warehouse fact tables using SQL Server Integration Services.
Speaker(s):
- Joe Salvatore
Track and Room: 8 -ETL Analysis - N/A
Title: Agile Data Warehousing with WhereScape
Abstract: This is introduction to WhereScape RED, an agile development environment – building high quality data warehouses native to SQL 2008, R2, 2012 quickly. No other toolset can beat the productivity which results in a consistent, scalable, supportable and fully documented data warehouse. Better than that though is engagement with business units during development, ensuring that the data warehouse development is correctly prioritized, relevant and up to date.
Speaker(s):
- Douglas Barrett
Track and Room: 2 -SQL Dev - N/A
Title: Schema Design: Advanced Data Validation Techniques
Abstract: Fixing bad data is a huge problem. How about if you could design your schema so that it checked the data on the way in?
The beginner-level techniques here are very important and useful: primary key, alternate key/unique index, foreign key, etc. But what else can you do to lock down the data in your database? You will leave this session with a better understanding of the normal techniques and some new ones that you probably haven’t used before.
Speaker(s):
- Rob Garrison
Track and Room: 7 -Getting it Right - N/A
Title: Isn’t that Spatial! (BI Edition)
Abstract: In this session, we will walk through the process of building a spatial data warehouse from the ground up. We will first design a basic spatial data warehouse, then identify and import a spatial data source by using Microsoft SQL Server Integration Services (SSIS), and finally write a spatial query to provide data to SQL Server Reporting Services (SSRS). We will also review basic concepts of working with spatial data in SQL Server.
Speaker(s):
- Jason Horner
Track and Room: 3 -BI Treats - N/A
Title: SSRS data driven subscription using SSIS
Abstract: SQL Server Reporting Services provides a powerful tool to render report based on information in a database table. But in order to use this feature, you are required to purchase an Enterprise license of SQL Server. In this session, we will create an SSIS package that renders reports to the file system based on values stored in the database.
Speaker(s):
- Russel Loski
Track and Room: 8 -ETL Analysis - N/A
Title: A Tour in The Indexing World!
Abstract: Hossam will be your guided tour to the indexing world! We will visits index types, know where to use them, how they work, interesting facts, and best practices. We will see how to keep our indexes healthy for better performance as well.
Speaker(s):
- Hossam Alfraih
Track and Room: 1 -Indexes - N/A
Title: SQLCAT - Building scalable cloud applications
Abstract: The SQLCAT team has successfully architected, designed and built over 50 SQL Server cloud projects. We want to share the learnings on how to design a cloud application to scale to handle large, complex workloads using Windows Azure SQL Database. Building cloud applications are different than building on premise database driven applications.
Speaker(s):
- Mark Simms
Track and Room: 5 -On/Off Prem - N/A
Title: SQL Azure - What is it and why do you need it?
Abstract: This session will take an exploratory look at Microsoft’s cloud-based relational database offering. We’ll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We’ll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA’s alike can focus on the aspects of their job they really care about.
Speaker(s):
- Scott Klein
Track and Room: 5 -On/Off Prem - N/A
Title: The Skinny on Data Compression
Abstract: SQL Server’s data compression feature can be a great tool for both getting more bang out of your storage dollar and increasing query performance. In this session we’ll cover the different types of data compression, the nitty-gritty behind how they work, and how to make sure you’re getting the most out of them.
Speaker(s):
- Bob Pusateri
Track and Room: 1 -Indexes - N/A
Title: TempDB Performance Troubleshooting and Optimizing
Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill server performance. After this session, you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.
Speaker(s):
- Eddie Wuerch
Track and Room: 6 -Performance - N/A
Title: Power View for Geographical Analysis
Abstract: Geographical Analysis is now made easy with Power View and Excel 2013. Simple yet powerful data exploration and segmentation analysis on geography can be performed, without the need of expensive hardware or software. In this session, you’ll learn how to create visually appealing and meaningful maps using Power View.
Speaker(s):
- Julie Koesmarno
Track and Room: 3 -BI Treats - N/A
Title: Index Psychiatry: The Top 5 Disorders
Abstract: Do you have the right indexes in place to make queries run faster without dragging down write performance? In this session we will diagnose and treat the top five index disorders haunting your production databases. If you’re a DBA or developer with 1 year of experience writing T-SQL queries, this session will give you the scripts and knowledge to cure your toughest indexing problems.
Speaker(s):
- Kendra Little
Track and Room: 1 -Indexes - N/A
Title: Power View and PowerPivot: High-Octane Self-svc BI
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
Track and Room: 3 -BI Treats - N/A
Title: Authorization Access Rights w/ SharePoint SQL
Abstract: You will see why you get NT Anonymous errors and learn to solve them when working with Excel Services, Reporting Services, and PerformancePoint Services when connecting to back end data sources. You will learn how to configure the Secure Store, Kerberos, the EffectiveUserName connection string, embedded credentials, RSD files and BISM files.
Speaker(s):
- Carl Rabeler
Track and Room: - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Ed Snajder
Contact: https://community.jivesoftware.com/community/developer/blog
Ed Snajder is the Database Administrator at Jive Software. When not having fun with databases, Ed is an aspiring hacker, with a 3D printer, a Raspberry Pi, and several mostly finished Arduino projects. Also an avid Portland tech community supporter, Ed has spoken at and participated in the PostgreSQL User Group, OSCON, Portland Code Camp, SQLSaturday and the Oregon SQL Developers’ Group.
Hossam Alfraih
Contact: http://www.SaudiGeek.NET
Hossam is a Senior Database Architect who is using SQL Server since version 7.0. He is a Microsoft Certified Trainer (MCT) who earned MCTS SQL Server 2005/2008 and MCITP SQL Server 2008 for Database Developer and Administrator certificates. He works as a freelancer Technical Consultant specialized in Database Systems and Performance Tuning. Moreover, he is writing and speaking about Cloud Computing since 2009. He co-founded SQLServerPath.org | Blog: www.SaudiGeek.NET | Follow him @SaudiGeekNET
Bob Pusateri
Twitter: - @SQLBob
LinkedIn: Bob Pusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Michael Wells
Twitter: - @SqlTechMike
LinkedIn: Michael Wells
Contact: http://sqltechmike.com
Michael Wells is a Microsoft Specialist at Dell EMC covering enterprise customers. He has worked in IT since 2000 and has supported all versions of SQL Server from SQL Server 2000 to SQL Server 2014. Michael has been presenting since 2007 for local user groups, CodeCamps, SQLSaturday events, IT Pro Camps, and large conferences like PASS Summit and Oracle OpenWorld.
Josh Fennessy
Senior Business Intelligence Consultant at BlueGranite, Inc., Josh Fennessy has been working with the Microsoft BI stack exclusivley for the last 5 years. He has earned MCITP in both SQL 2005 and SQL 2008 versions of the tools. Josh is also the chapter leader of the West MI SQL Server Users Group.
When he’s not building BI solutions, he enjoys spending time with his 6 year old son, slinging lead at the range, and exercising (but never in his underwear. Promise!)
Tim Ford
Twitter: - @SQLAgentMan
LinkedIn: Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Data Professional, Author and Community Leader whose technical passions lie in creative solutions for managing and presenting data. He#39;s been a healthcare DBA since 2000 and leads SQL Agent Man Consultancy and SQL Cruise. He takes 25 students and leaders in the SQL Community and places them on cruise ships for technical and professional development training without the distractions of the office and internet twice a year on SQL Cruises (www.sqlcruise.com). Currently Tim serves on the Board of Directors for PASS and is passionate about taking fellow Data Professionals to the next level in their careers. He enjoys telling stories with data.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Douglas Barrett
Twitter: - @dougy_jb
LinkedIn: Douglas Barrett
Contact: https://www.wherescape.com/blog/
Douglas has worked in the field of Business Intelligence for 20 years - concentrating primarily on data. Data Warehouse design, data processing, tuning, data quality - leading projects for Banks, Airlines, Retailers, Brewers (dim_beer anyone?), Universities etc. When not building data warehouses Douglas loves hiking in the Northwest.
It becomes abundantly clear after project 1 that agility - prototyping, iterations and collaboration with SMEs / BAs is the only way to de-risk a data project. Douglas works for WhereScape - a software company that builds agile tools for developing / managing data warehouses / vaults / hubs. The design will change - when it meets the data, when it meets the users - it is expected, lets make it easier.
Russel Loski
Twitter: - sqlmovers
LinkedIn: Russel Loski
Contact: http://www.sqlmovers.com
Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.
Mark Broadbent
Twitter: - retracement
LinkedIn: Mark Broadbent
Contact: http://tenbulls.co.uk
Mark Broadbent is a Microsoft Certified Master in SQL Server, Chapter Leader, Virtual Chapter Leader, SQLSaturday Cambridge and SharePoint Saturday Cambridge founder (the UKs first SQLSaturday) and awarded Microsoft#39;s Community Contributor award in 2011 and the PASS Outstanding Volunteer award in 2012. Mark is a regular speaker at both International and National events and is an expert in HADR solutions, SQL Server migration, and SQL Server Concurrency control.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Tim Mitchell
Twitter: - @Tim_Mitchell
LinkedIn: Tim Mitchell
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Pat Sinthusan
Contact: https://communities.netapp.com/
Pat Sinthusan is currently working for NetApp as a Reference Architect responsible for validating new SQL Server Solutions on the NetApp storage platform. In the past, he worked as a Sr. Database Administrator for 15 years with Hasbro and the City of Seattle. Pat has designed and implemented database infrastructures for the entire range of environments (development and production) using various storage technologies, and he#39;s been working with SQL Server since 4.21B.
Kendra Little
Twitter: - Kendra_Little
LinkedIn: Kendra Little
Contact: http://littlekendra.com
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
Carl Rabeler
Carl is a Senior Program Manager on the SQL Server Customer Advisory Team focusing on Business Intelligence solutions and complex topologies. Carl works closely with internal and external customers to develop solutions and validate SQL Server business intelligence best practices for working with large scale and complex BI solutions. Carl has worked with Microsoft SQL Server for over 14 years as a consultant, mentor, writer, speaker and trainer. Carl has written several SQL Server books and numerous technical white papers, has presented at many SQL Server conferences, and has provided mentoring and consulting services for numerous companies around the world.
Jeremiah Peschka
Twitter: - @peschkaj
Contact: http://brentozar.com
Jeremiah Peschka sees the magic in technology. He knows how to do things now, and he also knows how to think about possibilities. Jeremiah likes to imagine new kinds of indexes, new kinds of teams, new kinds of applications. This means that when you need to reinvent something, or get unblocked, you should talk to Jeremiah.
Scott Klein
Twitter: - SQLScott
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
Laerte Junior
Twitter: - @laertesqldba
LinkedIn: Laerte Junior
Contact: https://www.red-gate.com/simple-talk/author/laerte-junior/
Laerte Junior is a Windows PowerShell MVP Reconnect, PASS PowerShell VC Co-lead and, through his simple-talk articles, an active member of the Microsoft Community around the world. He also is a huge Star Wars fan (yes, he has the Darth Vader#180;s Helmet with the voice changer). He has a passion for DC comics and living the simple life.
Brent Ozar
Twitter: - BrentO
LinkedIn: Brent Ozar
Contact: https://www.BrentOzar.com
Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.
Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo is co-founder and RD lead of perFact BV, a Dutch company that improves analysis methods and develops computer-aided tools to generate completely functional applications from the analysis deliverable. The platform for this development is SQL Server. In his spare time, Hugo likes to share and enhance his knowledge of SQL Server by frequenting newsgroups and forums, reading and writing books and blogs, and attending and speaking at conferences. Hugo is also a SQL Server MVP since 2006.
Michael Wells
Twitter: - @SqlTechMike
LinkedIn: Michael Wells
Contact: http://sqltechmike.com
Michael Wells is a Microsoft Specialist at Dell EMC covering enterprise customers. He has worked in IT since 2000 and has supported all versions of SQL Server from SQL Server 2000 to SQL Server 2014. Michael has been presenting since 2007 for local user groups, CodeCamps, SQLSaturday events, IT Pro Camps, and large conferences like PASS Summit and Oracle OpenWorld.
David Eichner
Twitter: - @ICANSoftware
LinkedIn: David Eichner
David Eichner is a licensed CPA and is also CEO of ICAN Software Corporation, a Microsoft Dynamics amp; Acumatica ERP partner firm that sell and implements ERP and CRM software, develops software solutions and provides technology consulting. He is the host of a radio show called Business In The Cloud that airs weekly on KLAY 1180AM. He is skilled in building integrated cloud app solutions. His career spans more than 20 years in various technical/managerial positions within industries as diverse as military service, engineering/construction, municipal government, consulting and certified public accounting. Additionally, he holds various national certificates in technology (MCDBA, MCSE, CNE, CITP, Dynamics CRM and ERP, Acumatica CRM and ERP)
Eddie Wuerch
Twitter: - @EddieW
LinkedIn: Eddie Wuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
Steve Stedman
Twitter: - @sqlemt
LinkedIn: Steve Stedman
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.
Rob Garrison
Contact: http://persistencevision.blogspot.com/
Rob is a Data Architect working for Fiserv in Portland, Oregon. He has over twenty years of IT experience, with most of that time focused on transactional SQL Server. He has a number of articles published and speaks regularly at user groups and other events.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Mark Simms
Twitter: - @mabsimms
Contact: http://appfabriccat.com
Mark is a Principal Program Manager on the SQLCAT (SQL Server Customer Advisory Team), working on large-scale cloud applications. Usually found nerding out on challenging customer problems, he is currently focused on telemetry driven applications and guidance to navigation the distributed system landscape.
Robert Davis
Twitter: - @SQLSoldier
LinkedIn: Robert Davis
Contact: http://www.sqlsoldier.com
Robert is a SQL Server Certified Master, MVP, and has spent 17+ years honing his skills in security, performance tuning, SQL development, high availability, and disaster recovery. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and in various roles at Microsoft specializing in SQL Server administration, development, and architecture. He currently works as a Database Engineer at BlueMountain Capital Management where he spends a vast majority of his time tuning massively parallel queries. Robert feeds his passion for security by acting as co-leader of the PASS Security Virtual Chapter.
Michael Swinarski
Michael Swinarski is a Database Administration with 15 years of experience, and has worked with both SQL Server and Oracle platforms. While he is a technologist, he firmly believes that IT is not so much about technology, as it is about people and the relationships that are formed to create collaborative teams that are able to address the needs of businesses, communities, and our environment.
Paul Turley
Twitter: - paul_turley
LinkedIn: Paul Turley
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.
Bill Fellows
Twitter: - @billinkc
LinkedIn: Bill Fellows
Contact: http://blog.billfellows.net
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City’s eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.
Matt Masson
Twitter: - @mattmasson
Contact: http://www.mattmasson.com/
Matt Masson is a Program Manager in the Information Management and Machine Learning (IMML) organization. Matt has worked on multiple data integration products, including Power Query, SSIS, DQS, MDS, and the Data Management Gateway for Power BI. He has authored two books on SSIS (Apress, and MS Press), and is a frequent presenter at Microsoft conferences. You can find his blog at http://www.mattmasson.com/.
Victor Isakov
Contact: http://www.victorisakov.com
Victor Isakov is a Database Architect and Trainer who enjoys a reputation as one of the most knowledgeable subject matter experts on SQL Server. Victor provides consulting and training services to various organizations in the public, private and NGO sectors globally, and regularly presents at various international events and conferences. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server certification and courseware.
Joe Salvatore
LinkedIn: Joe Salvatore
Contact: http://joethebusinessintelligenceguy.wordpress.com/
Joe Salvatore, MCITP/MCTS SQL Server Business Intelligence 2005/2008, is a Business Intelligence Architect for Pragmatic Works where he designs and implements world class Business Intelligence solutions using Microsoft technologies such as SQL Server, Integration Services, Analysis Services, Reporting Services, PerformancePoint Services, PowerPivot, PowerView, Excel, and SharePoint. For over 15 years, Joe has passionately assisted companies of all sizes and all industries to better understand, and implement Microsoft solutions. Additionally, Joe gives back to the community by contributing as an author or editor to five Wiley/Wrox books, blogging about technology discoveries, and speaking at local user groups, SQLSaturdays, and Professional Association for SQL Server (PASS) events.
Jason Kassay
Twitter: - @jasonkassay
LinkedIn: Jason Kassay
Contact: http://www.JasonKassay.com
Jason Kassay is a database administrator, software engineer amp; speaker from Colorado with over 12 years of experience. He is passionate about SQL Server, programming, release process, automation amp; performance tuning. Jason is an active member of the SQL Server community amp; volunteers/presents at events such as Colorado User Groups, SQLSaturday amp; Colorado GiveCamp. When not tuning databases or coding, Jason will most likely be found spending time with his family, playing hockey or running.
Buck Woody
Twitter: - BuckWoodyMSFT
LinkedIn: Buck Woody
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.
Rick Morelan
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.
Vern Rabe
Twitter: - @VernRabe
LinkedIn: Vern Rabe
Contact: http://www.rabedata.com
Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the Oregon Data Community user group, formerly OregonSQL. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern regularly presents technical sessions at SQL Server user group meetings, SQLSaturdays, and PASS Summit.
Julie Koesmarno
Twitter: - @mssqlgirl
LinkedIn: Julie Koesmarno
Contact: http://www.mssqlgirl.com
Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.
Sponsors
The following is a list of sponsors that helped fund the event: