SQLSaturday #92 - Oregon 2011
Event Date: 10/08/2011 00:00:00
Event Location:
- Portland Community College - CLIMB Center
- 1626 SE Water Ave
- 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: Cube Monitoring Load Balancing in MS-Adcenter
Abstract: The session is mainly a review of Cube Health Monitoring and Load Balancing in adCenter Enterprise Cube Environment. It is a detailed discussion and review of our process on achieving the following goals:
- Create a load balancer across the OLAP cubes
- Achieve better monitoring and alerting of our enterprise OLAP systems
- Increase our Up-time and monitor our SLA
- Increase our ROI of the HW Currently AdCenter has two major services that are integrated / connected to each other: first one does the monitoring and alerting of the OLAP cubes and the second one does load balancing across the OLAP servers. The monitoring service notifies the load balancer when a server is not available so the cube balancer does not route traffic to it
Speaker(s):
- Bilal Obeidat
Track and Room: - N/A
Title: You’re My Density: Making Sense of Statistics
Abstract: The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.
Speaker(s):
- Erin Stellato
Track and Room: - N/A
Title: Devs are from Mars, Report Servers are from Venus
Abstract: Do you remember what it was like to fall in love? Wasn’t it wonderful? Lately it just hasn’t been the same. You’ve been stuck in the same old routine, doing the same old charts and tables. Maybe Reporting Services doesn’t tell you what’s wrong. Maybe you’re even thinking about seeing other reporting products (!) In this session made for report developers with less than 2 years’ experience, Doug will re-ignite your passion for RS by showing you how to design for better performance, explaining what RS has been trying to tell you through logs (but you haven’t been listening), and demonstrating some new – and easy – tricks you may not have known RS can do. After this session, you’ll want to spend some time alone with your new old flame.
Speaker(s):
- Doug Lane
Track and Room: - N/A
Title: Troubleshooting SQL Server with SysInternals Tools
Abstract: In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended.
Speaker(s):
- Argenis Fernandez
Track and Room: - N/A
Title: So you’ve built a cube…Now what? MDX essentials
Abstract: MDX is an elegant and powerful query language for SQL Server Analysis Services but it’s not easy for most to figure out, unguided. This session is led by Microsoft BI Architect, author and SQL Server MVP, Paul Turley. We will start with a review of the basic of concepts of cubes, dimensions and hierarchies. From the ground up, you will learn how to use MDX query constructs to report business analytical data to your users with measures, calculated members, KPIs, slicers. You’ll learn to use some of the most useful MDX functions so you can take what you learn and put it to practical use next Monday morning.
Speaker(s):
- Paul Turley
Track and Room: - N/A
Title: Best Practices Every SQL Server DBA Must Know
Abstract: The focus of this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
Speaker(s):
- Brad McGehee
Track and Room: - N/A
Title: The Periodic Table of Dynamic Management Objects
Abstract: Taking the periodic table of elements into consideration I’ve created The Periodic Table of Dynamic Management Objects as a reference tool for these functions and views that have become so critical for today’s SQL Server DBA to performance tune and gain metadata insights into their various SQL instances. In navigating the table we will examine key DMVs and DMFs of interest: requests, sessions, wait stats, indexes, system information will all be covered. We will also delve into how these DMOs - just like their elemental counterparts - can be combined to yeild interesting insights into your servers. We will also look at how things can go awry as well! Like mixing vinegar and baking soda, sometimes combining DMOs can cause a big mess too!
Speaker(s):
- Tim Ford
Track and Room: - N/A
Title: Analyze and map spatial data with SQL Server 2008
Abstract: With the widespread availability of location and spatial data to both consumers and corporations (such as smartphone GPS data), there is a need to manage and analyze all this data as well. SQL Server 2008 introduces new standards-based spatial data types and associated functionality to the relational engine. Spatial data can be stored in the cloud using SQL Azure. And SQL Server 2008 R2 Reporting Services allows spatial data to be visualized as Maps.
In this session, we’ll explore both the SQL spatial data types and SSRS maps, using demos to show this functionality in action. We’ll also cover enhancements to spatial functionality in the forthcoming “Denali” version of SQL Server.
Speaker(s):
- Deepak Puri
Track and Room: - N/A
Title: Introduction to Analysis Services
Abstract: By now you have probably already heard about Analysis Services. Maybe you’ve even said to yourself that you were going to learn more about it but just haven’t found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.
Speaker(s):
- Marc Beacom
Track and Room: - N/A
Title: Working with Server Side Traces
Abstract: You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you.
First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace.
Speaker(s):
- Christina Leo
Track and Room: - N/A
Title: Exploring SQL 2008’s MERGE
Abstract: MERGE is a new capability in SQL Server 2008. This session will start with the basics of what MERGE is and then dig into how it works and how it compares to using traditional INSERT/UPDATE semantics. You should come away from this session with a good understanding of MERGE, ready to implement it in your environment.
Speaker(s):
- Rob Garrison
Track and Room: - N/A
Title: Bad Indexes
Abstract: I’m sure you’ve been told seeks are better than scans. I’m sure you’ve been told that a covering index is ideal. I’m sure you’ve been told small arrows are better than thick ones. Get the whole story.
Speaker(s):
- Rob Farley
Track and Room: - N/A
Title: Let Service Broker Help You Scale Your Application
Abstract: How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.
Speaker(s):
- Allen White
Track and Room: - N/A
Title: Hybrid Database Solutions with SQL Azure
Abstract: With so much interest in Cloud technology, where does it really fit in, and what is the role of the DBA and Database Developer? What is available in SQL Azure, as it compares to SQL Server? Can you leave some data on-premise, and put other data in the cloud? Buck shows you the ins and outs of SQL Azure, how to connect to it, manage it, what the limitations are, and real-world examples of architectures that work.
Speaker(s):
- Buck Woody
Track and Room: - N/A
Title: Extended Events – New Age of Profiling
Abstract: Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions, so we need to understand the differences it has to profiler “old guard” and why we should be using this new feature for this purposeI’ll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectivelyFollow me to the “new age” of understanding your systems activity
Speaker(s):
- Neil Hambly
Track and Room: - N/A
Title: Reporting Services 201: From Basic To WOW!
Abstract: You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from basic to “wow”, using features such as tablix, lists, images, and charts. At the end of this session, you will be familiar with: - Report properties such as headers, footers and backgrounds - Tablix properties such as ToolTip and NoRows - How to build and customize a matrix - How to effectively use lists, an often-overlooked feature - Adding charts to make reports visually appealing and easy to understand
Speaker(s):
- Jes Schultz
Track and Room: - N/A
Title: Real-time Data Warehouse and Reporting
Abstract: This session will present a Database and ETL Architecture that allows you to smoothly move data from your application databases across the enterprise in real-time to your data warehouse. Carlos Bossy will show you how to use SQL Server features such as Replication, Change Data Capture, and SSIS to extract, transform and load data fast and dependably and view a real demonstration of the system in action. Finally, Carlos will show how to use Reporting Services to present data with a minimum amount of latency.
Speaker(s):
- Carlos Bossy
Track and Room: - N/A
Title: Basic Performance Tips and Gotchas
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. The Author will use lessons from SQL Architecture Joes 2 Pros Vol3.
Speaker(s):
- Rick Morelan
Track and Room: - N/A
Title: Gather SQL Server Performance Data with PowerShell
Abstract: We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don’t always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker(s):
- Allen White
Track and Room: - N/A
Title: Self-service BI with project ‘Crescent’
Abstract: In this session Ben Muller, Practice Manager BI Productivity at CSG will discuss Microsoft’s upcoming Business Intelligence tool, ‘Crescent’. Packaged with the next release of SQL Server (currently code named ‘Denali’), ‘Crescent’ lets users of all skill levels quickly create dynamic and compelling reports and analyses which can be instantly published to SharePoint. Ben will review the features and functionality of ‘Crescent’, and talk through some common ‘Crescent’ scenarios.
Speaker(s):
- Benjamin Muller
Track and Room: - N/A
Title: Management Data Warehouse and Custom Collectors
Abstract: Management Data Warehouse and custom collectors are a potentially powerful tool set for DBAs and developers. While the feature can seem a bit rough around the edges, the hidden potential within is great. Creating Custom Collectors provides DBAs and Developers a quick, easy and powerful way to collect and store metrics and other data over time. This data can be used to answer a host of potential questions.
Speaker(s):
- Edwin Quick
Track and Room: - N/A
Title: Multi-threading TSQL
Abstract: Can T-SQL be run in multi-threaded manner? Yes, this session will explain how to use TSQL to implement multi-threading application, including process control, resource access, execution ordering, synchronization, semaphore, etc. If you are looking for a solution to turn your processes to run in parallel, you should not miss this session.
Speaker(s):
- John Huang
Track and Room: - N/A
Title: Want a promotion? It’s up to you!
Abstract: Self-promotion is often times the best promotion you can get. In this session, we will talk about how to promote yourself, your brand and your career without looking like “That Guy”. We will discuss Social Medias, communities, volunteering and other ways to get your name out… What are the first steps? Come find out.
Speaker(s):
- Mitchell Bottel
Track and Room: - N/A
Title: Scripting in SSIS
Abstract: Can’t find the component to use in your SSIS control flow or data flow? You might want to consider to script it yourself! One of the most flexible components in SSIS is the script task. This session covers the basics of the SSIS script task, what you can do with it and some tips and tricks how to use it.
Speaker(s):
- Erik Monchen
Track and Room: - N/A
Title: Models, Cubes Marts: how why to choose
Abstract: Microsoft offers three distinct platforms for data analysis and a variety of related reporting tools. When should you use BI Semantic Models, PowerPivot, tabular column storage, SSAS cubes or relational data marts? Learn about the right fit for each of these choices and what you need to know to use the next generation of BI reporting tools like Project Crescent, SSRS and SharePoint BI.
Speaker(s):
- Paul Turley
Track and Room: - N/A
Title: No More Bad Dates: Working With Dates and Times
Abstract: Dates and times seem simple at first. Kendra Little will show you there’s more to it than you think. She’ll give you five best practices that will help you select the right temporal data type, avoid common issues, and use the most effective techniques to aggregate data. She’ll also explain painful problems with query performance and how to avoid them. Choose wisely: the correct types and high performing data access logic will scale well and save development and administrative time.
Speaker(s):
- Kendra Little
Track and Room: - N/A
Title: SQL Driven Mobile Platforms
Abstract: A brief introduction and explanation of MofuMobi, a new mobile business tool developed by Aaron and his team. This mobile platform is driven by SQL Queries, enabling users to extend any internal software system to their smart phones. This session will show viewers how easy it is to create their very own custom apps within the MofuMobi portal and what kind of functionalities it is capable of, for instance updating users with new apps (reports within apps) without having to update phones. If you can write SQL Queries or views than you can develop MofuMobi apps.
Speaker(s):
- Aaron Allison
Track and Room: - N/A
Title: Looney Tuner? No, there IS a method to my madness!
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker(s):
- Janis Griffin
Track and Room: - N/A
Title: Database Design Contentious Issues
Abstract: A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? …and others. Bring your votes, your debates, and your opinions.
Speaker(s):
- Karen Lopez
Track and Room: - N/A
Title: Columnstore Indexes in SQL Server Denali
Abstract: One of the new features of SQL Server 11 (Code Name Denali) is columnstore indexes, where the storage of index data is “turned on its head”. We will look into how this feature is implemented internally, how it can greatly improve query performance in the right environment, and its current limitations.
Speaker(s):
- Vern Rabe
Track and Room: - N/A
Title: Deeper JOINs
Abstract: There’s so much more to know about joins than INNER, OUTER, CROSS. Understanding other kinds of joins, and the impact of decisions about how you write them can seriously impact your T-SQL effectiveness. A bunch of myths to dispel here too! No slides here - just demos. We’ll create slides as we go.
Speaker(s):
- Rob Farley
Track and Room: - N/A
Title: Intro to SQL Server Mirroring and Log Shipping
Abstract: In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping. We will do a brief overview of the parts and modes of database Mirroring. You will also be introduce to Log Shipping and how it works. We will have a demo part of the session where we will go through step-by-step on how to set up Mirroring and Log Shipping. By the end of this session, you should have a general understanding and ability to deploy database Mirroring and Log Shipping.
Speaker(s):
- Harry Chandra
Track and Room: - N/A
Title: Database Development: Keep It Agile, Not Fragile
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
Track and Room: - N/A
Title: 10 Things all BI System Administrators Should Know
Abstract: Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administer BI systems, you can’t apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator? Fortunately, I’ve been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.
Speaker(s):
- Robert Davis
Track and Room: - N/A
Title: SSIS Package Design: Choosing the Right Components
Abstract: You can master Integration Services to solve complex business data issues! For the SSIS beginner; learn to implement best practices and design patterns that will prove to be indispensable and easy to perform. There are multiple options to perform tasks or transformations and we will explore these choices so you can use the right tool for the job. You will also see how to use expressions for connection strings and precedence logic, and process more data in less time. Get the scoop on package configurations, deployment and package portability. Using some basic, proven design techniques; you can be an SSIS pro!
Speaker(s):
- Sopheap Suy
Track and Room: - 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!I 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, But I will also show the dangers of using too many indexes, and the tools SQL Server itself hands you to help identify just the right subset of indexes.
Speaker(s):
- Hugo Kornelis
Track and Room: - N/A
Title: Data Warehousing Best Practices
Abstract: This session will describe the best practises for designing a data warehouse to get the most out of SQL Server. Doug has worked in data warehousing for 12 years and will blend experience, with best practises and recommendations from Microsoft’s Fast Track program. Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
Speaker(s):
- Doug Barrett
Track and Room: - N/A
Title: Kama Sutra of SSIS: A guide to loving ETL
Abstract: Slow running packages? SSIS consuming all your resources? No idea what it’s doing? After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. You will also be armed with a list of transformations and perfmon counters to watch out for.
Speaker(s):
- David Eichner
Track and Room: - N/A
Title: Parallelism in SQL Server
Abstract: SQL Server 2008 R2 supports up to 256 logical processors! Intel has released CPUs that support 10 cores and hyper-threading. So a quad-socket commodity server can easily support 80 logical processors. It’s time for DBAs and Developers to understand how parallelism works in SQL Server! There are a lot of myths and misconceptions about how parallelism works in SQL Server and, more importantly, how to troubleshoot and solve parallelism problems. CXPACKET waits are not necessarily bad! In this session, Victor Isakov (MCT, MCM, MCA) will cover how parallelism works before presenting how to detect, troubleshoot and solve parallelism problems.
Speaker(s):
- Victor Isakov
Track and Room: - N/A
Title: SQL Server And Oracle
Abstract: SQL Server And Oracle: Tips, Tricks and Traps for Working In A Heterogeneous DB Environment
In this session I will present and discuss managing an environment that includes both SQL Server (our main development platform is .Net/SQL Server) and Oracle in which data moves in both directions. The session is organized in 3 major sections: Getting Data Out Of Oracle into SQL Server Getting Data into Oracle from SQL Server Managing Differences between the environments
Speaker(s):
- Steve Moss
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.
Benjamin Muller
Twitter: - @benjmuller
Ben is an accomplished business and technology professional with significant management experience and hands-on involvement in a wide variety of business areas, including Finance, Marketing, Operations, and Information Systems. He is skilled at designing, implementing, and managing complex business information systems.
Ben leads the Business Intelligence and Productivity practice at CSG Professional Services, Inc. He has overseen and participated in many DW/BI projects for clients ranging in size from small manufacturers to regional utilities and national banks.
Ben has given dozens of presentations and workshops on DW/BI and Productivity concepts and practices, and he loves to both teach and learn.
Brad McGehee
Twitter: - @bradmcgehee
Contact: http://www.bradmcgehee.com
Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master’s in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years’ SQL Server experience. He has been involved in the industry since 1982.
Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.
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.
Karen Lopez
Twitter: - @datachick
LinkedIn: Karen Lopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality.
Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Mitchell Bottel
Twitter: - @SacSQLDude
Contact: http://www.mitchespitch.com
Mitchell Bottel is a senior database administrator with Sutter Physician Services, owner of Innovative IT Consulting and President of the Sacramento SQL Sevrer User Group. He has 14 years of IT experience, focusing on SQL Server for the last ten years with an emphasis on database administration and high availability solutions. He has authored blog posts on the SQLServerPerformance website and written White Papers on using Dynamic Management Views.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
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.
Marc Beacom
Contact: http://dawabi.com/blog.aspx
Marc Beacom is President of DawaBI, a Data Warehouse and Business Intelligence Consultancy firm focusing on Making Data-Driven Decisions Possible. He has been working with SQL Server for over a decade delivering scalable solutions for organizations of all sizes. He has earned several industry certifications and degrees. Marc is an active member of the community and has volunteered for many organizations such as PASS, Denver SQL, Colorado GiveCamp, Camp To Belong, to name a few.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
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.
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.
Erik Monchen
Twitter: - erikmonchen
LinkedIn: Erik Monchen
Erik has worked with the Microsoft BI products for over 7 years at different organizations in The Netherlands, Germany and the United States, responsible in the areas of information gathering to information delivery.
Dev Nambi
Twitter: - @DevNambi
LinkedIn: Dev Nambi
Contact: http://devnambi.com
Dev Nambi is a data scientist and aspiring polymath. He uses curiosity, math, and code to solve problems. Dev currently works in the University of Washington#39;s Enterprise Data amp; Analytics group.
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.
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)
Rob Farley
Contact: http://lobsterpot.com.au/bios
Rob Farley runs LobsterPot Solutions in Adelaide, Australia. He’s delivering a precon at the PASS Summit, and has recently been appointed as an advisor to the PASS Board of Directors. He will also be performing a Lightning Talk at the Summit, and may even get his guitar out in Portland too. Hopefully by now he’s received his sixth MVP award, and hopefully SQL Server MVP Deep Dives II is about to be published.
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
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.
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.
Edwin Quick
Contact: http://edquick.blogspot.com/
Ed is currently a Senior DBA at SurveyMonkey supporting several multi-terabyte databases running on SQL Server2008 R2. He has been working with SQL Server for the past 9 years, the last 7 as a DBA. Prior to joining SurveyMonkey he worked in the healthcare and research arenas.
Steve Moss
Steve Moss is the Data Architect at Ecova, the total energy and sustainability management company whose sole purpose is to see more, save more and sustain more for our clients.
Steve has been working in IT for over 13 years as a Data Architect, Manager of Database Administration, Sr. DBA and Systems Consultant. He specializes in Microsoft data-centric techologies, including SQL Server, Analysis Services, Integration Services and other associated data technologies.
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.
Aaron Allison
Contact: http://www.mofumobi.com
With years of experience in the technology industry, the MofuMobi Team has a practical understanding of what kind of software will works for a user and what will not. Our goal is to enhance any area of product functionality and overall user experience for busy individuals. Having a few years of experience with SBI software, the parent company to MofuMobi, a unique point-of view helps bridge the gap between technology and the user.
Sopheap Suy
Sopheap Suy is a SQL Server Developer at WebMD with 14 years in SQL Server Database technologies. She enjoys making things run better and faster. She is passionate about SQL Server technologies and always looking for ways to learn and share her knowledge. She is actively involved in her local PASS chapter and her interests include SQL Server Development, Administration, and Data Architecture. She lives in Portland, OR with her husband, and 3 children.
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.
Bilal Obeidat
Bilal founded and continue to lead the AdCenter OLAP development team. He has more than eighteen years of experience in software development and delivering production quality code and analytic solutions for a wide range of enterprises.
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.
Doug Lane
Contact: http://www.douglane.net
Doug Lane (MCITP, MCTS) is a consultant with Brent Ozar Unlimited and has over 14 years’ experience with SQL Server. He blogs about SQL Server with emphasis on Reporting Services and professional development.
Doug Barrett
Douglas Barrett draws on 15 years of data warehouse experience, including 10 years as a Consultant and solution specialist for Microsoft and WhereScape, delivering data warehouse projects using agile tools and techniques. Major data warehouse projects have included Basel II Credit Risk for a Retail Bank, Airline Travel Agent, Hospital Episode of Care, Hotel Occupancy and Utility companies.
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.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
John Huang
Twitter: - @sqlnotes
LinkedIn: John Huang
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.
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.
Christina Leo
Twitter: - christinaleo
Contact: http://christinaleo.net
Christina Leo is a Cloud Solution Architect at Microsoft specialising in the Data and AI Platform. Prior to joining Microsoft in 2016, she worked as an independent consultant focusing on T-SQL and BI development, as well as database performance tuning in the finance and investment banking sector. When she isn’t sharing her 18 years of technical experience with the data community, you can find her racing around the Solent on a 40’ sailboat or often in the Thames on a little Laser.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Deepak Puri
Deepak is a SQL Server MVP and a Business Intelligence Consultant who has been working with SQL Server Analysis Services since 2000. He’s an active contributor to the MSDN Analysis Services Forum and a regular presenter at Ohio North SQL Server User Group meetings.
Harry Chandra
Contact: http://blogs.h2dclan.com
Harry Chandra is a SQL Server Database Administrator for a software company in Portland, Oregon with a Bachelor of Arts Degree in Information System from Portland State University. He’s been working with various releases of SQL Server for over 4 years. His main focus is in Administration and High Availability for SQL Server, although he has always strived to expand his knowledge into other area of SQL Server. He is a member of the Portland SQL Server User Group and SQL Pass member.
Rob Farley
Twitter: - rob_farley
LinkedIn: Rob Farley
Contact: http://blogs.lobsterpot.com.au
Rob Farley runs LobsterPot Solutions in Australia, where he’s a consultant in the Microsoft Data Platform and Analytics space. He’s been an MVP since 2006, probably because of his blogging, his presentations around the world, and his dedication to the Adelaide Data Analytics User Group which he has led since before the release of SQL Server 2005. He’s on Twitter at @rob_farley, but you can always email him using rob@lobsterpot.com.au
Erin Stellato
Twitter: - erinstellato
LinkedIn: Erin Stellato
Contact: http://www.sqlskills.com/blogs/erin
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Victor Isakov
Contact: http://www.victorisakov.com
Victor Isakov (MCA, MCM, MCT, MVP) is a Database Architect and Trainer who provides consulting and training services to various organizations in the public, private and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd, SQL Connections, PASS Summit and SQL Code Camp and authored a number of books on SQL Server. He worked with Microsoft to develop the SQL Server exams and certification. He was one of the first Microsoft Certified Masters / Architects.
Jes Schultz
Twitter: - http://twitter.com/grrl_geek
LinkedIn: Jes Schultz
Contact: https://blogs.lessthandot.com/author/jes-borland
Jes Schultz is a Software Engineer with Microsoft who has experience with a wide range of SQL Server features from version 2005 through 2019, and is on the cutting edge with Azure technologies. Since graduating Fox Valley Technical College with an IT-Programmer/Analyst degree, Jes has worked as an SSRS developer, DBA, and consultant. Before joining Microsoft, Jes was a six-time Data Platform MVP, recognized for her community work. Jes tackles every project and problem with tenacity and her enthusiasm is unmatched in the SQL Server community. In her free time, Jes never stops moving, and counts fitness, coffee, cooking, and travel as essentials in life.
Sponsors
The following is a list of sponsors that helped fund the event: