SQLSaturday #540 - Sacramento 2016
Event Date: 07/23/2016 00:00:00
Event Location:
- Patrick Hays Learning Center
- 2700 Gateway Oaks Drive, Suite 2600
- Sacramento, California
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: Dimensional Modeling Design Patterns: Beyond the Basics
Abstract: Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements. In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.
Speaker(s):
- Jason Horner
Track and Room: BI Platform Architecture, Development Administration - San Mateo
Title: The Business Intelligence Side of SQL Server
Abstract: This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft’s top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.
Speaker(s):
- Sayed Saeed
Track and Room: BI Platform Architecture, Development Administration - Microsoft
Title: Tools and Tips: From Accidental to Efficient Data Warehouse Developer
Abstract: You have probably heard about the Accidental DBA, but what about the Accidental Data Warehouse developer? We stumbled into the world of data warehousing, learned dimensional modeling and work with T-SQL and SSIS daily. We are masters of googling solutions to our problems and make sure our ETL processes run without errors. We deliver data to business users… but we rarely deliver data as fast as we want.
You might not be able to rewrite your entire Data Warehouse or change your team’s processes over night, but there are many things you can do to increase your own productivity and become a more efficient Data Warehouse developer.
In this session I will show you some of what I have learned and discovered that has made me exclaim “Oh wow! Why did I not know this yesterday!?” - including SSMS features, tools for query analysis and tuning, free tools and scripts, Biml for SSIS and even a couple of things I used to think were only useful for those scary DBAs.
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: BI Platform Architecture, Development Administration - Tintri
Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source
Abstract: Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. “Virtualize First” is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too “critical” to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring it!
Speaker(s):
- Deji Akomolafe
Track and Room: Strategy and Architecture - San Joaquin
Title: Partitioning Basics: Treating Your Tables Like Legos
Abstract: Do you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!
With partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and full blown table partitioning. We’ll also look at how partitioning affects things under the hood. Finally you’ll see some cool demos/tricks around index maintenance and data movement. At the end of this session you’ll have a firm understanding of how partitioning works and know how to make decisions on how and when to implement.
Speaker(s):
- Brandon Leach
Track and Room: Enterprise Database Administration Deployment - San Joaquin
Title: Biml for Beginners: Speed Up Your SSIS Development
Abstract: Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?
Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.
In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.
Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: BI Platform Architecture, Development Administration - Dell
Title: SQL Server R Services in SQL 2016
Abstract: One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we’ll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We’ll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We’ll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we’ll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!
Speaker(s):
- Chris Hyde
Track and Room: Analytics and Visualization - Dell
Title: The Life Cycle of a Query in Virtual Reality
Abstract: How would you like to learn about using Virtual Reality (VR) to present information? The ability to become immersed and walk around inside of a VR environment is a new and unique way to present and look at information. As data professionals we need to be open to novel displays of data and explore what VR can do that for us that we have not been able to do in the past. VR can provide a way for people to see relationships and interact among data sets which can be difficult for computers to display visually on a flat screen.
The Life Cycle of a Query in Virtual Reality is built using Epic Games video game engine called Unreal Engine 4 (UE4). With native support for VR, UE4 has been used for applications beyond just video games. With the commercial availability of affordable VR headsets, data professionals can now create visually compelling environments that were almost impossible or extremely expensive just a few years ago on both PC and mobile devices.
Speaker(s):
- Todd Kleinhans
Track and Room: Enterprise Database Administration Deployment - San Joaquin
Title: Life of a Lead DBA - How to explain to your boss ‘what you do’
Abstract: When you are a lead Database Administrator, you can almost be guaranteed that your boss will not know more about databases then you do.
It will be your job to explain to your boss (customers, clients, etc.) what it takes to operate and maintain a well-running database environment. You have to justify why there is work and spending necessary for reactive support and maintenance. No organization can stand still, so you will also need to demonstrate the need for proactive work: research, training and planning for new architecture. By doing so, you can demonstrate the value you are adding as a Lead DBA.
In this session, you will see some frameworks and templates for explaining your responsibilities to your boss. Get some ideas reporting your workload in business terms, and presenting your database environment and concepts to non-technical audiences.
Speaker(s):
- Christopher Anderson
Track and Room: Professional Development - Microsoft
Title: Consolidated Essential Performance Health Check using PowerShell
Abstract: Standardizing essential performance health check is the key in responding quickly to production issues and can cut down initial evaluation phase to 1/3rd of the time, whether you have been requested to do health check or you may want to run these due to an alert. These sets of essential checks can be the first major checkpoint for a DBA, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. This will cut down on time and effort while responding to Production issues.
First part of the email shares some key observations about SQL Server performance which can be the key to quick resolution of the issue. Rest of the email shows different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance which could lead to the slowness observed in the application. This consolidated email can be shared with technical stakeholders to give a snaps
Speaker(s):
- Prakash Heda
Track and Room: Enterprise Database Administration Deployment - Tintri
Title: Be Friendly to SQL Server with TSQL Best Practices
Abstract: TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring. I will go over 5 key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. This is a beginners session but the concepts in this session are a great foundation to begin with. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.
Speaker(s):
- Ben Miller
Track and Room: Application Database Development - Microsoft
Title: Protecting SQL Data for Availability and DR
Abstract: This session provides a comparison of SQL High Availability Disaster Recovery options, presented by a practitioner who has implemented and managed all the SQL High Availability and Disaster Recovery approaches (and various combinations thereof). We will provide an overview of all the various HA DR options, then compare trade-offs for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.
Speaker(s):
- Tim Plas
Track and Room: Enterprise Database Administration Deployment - Tintri
Title: Intro to DAX Patterns
Abstract: Whether you are an Excel Pro, BI Developer, or Data Architect, sooner or later you’re going to find it helpful to know a little DAX and a few DAX Patterns. DAX, the Data Analysis Expression Language is the future of insight development in tools such as: Excel, Analysis Services Tabular, and the Power BI Desktop. Using DAX and these DAX Patterns, you’ll be able to define both centralized and ad hoc metrics for blazing fast data analysis!
Speaker(s):
- Eric Bragas
Track and Room: Analytics and Visualization - San Joaquin
Title: What is Biml and why are SSIS developers excited about it?
Abstract: This session is designed for you, the experienced SSIS developer who’s been hearing about the Business Intelligence Markup Language, Biml, but has not taken the plunge. We will cover what the Biml language is and how using your familiar development tools, SQL Server Data Tools, SSDT, and BIDS Helper, you will be able to streamline the creation of SSIS packages.
We will work through progressively more complex examples from a “Hello World” equivalent to a to a full fledged, audited, truncate and reload pattern based on an external metadata repository.
You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.
Speaker(s):
- Bill Fellows
Track and Room: BI Platform Architecture, Development Administration - Dell
Title: Level Up Your Biml: Best Practices and Coding Techniques
Abstract: Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing - you do not want to waste all that saved time on future maintenance!
Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code with include files and the CallBimlScript method. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.
Start improving your code today and level up your Biml in no time!
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: BI Platform Architecture, Development Administration - Dell
Title: Introduction to Data Science with R
Abstract: Data Science is the gaining popularity but what does it really mean? Discovering useful patterns and insight in the enterprise has become more challenging without a new set of tools. Big data has taken center stage in the data warehouse community and with data sets so large and complex that traditional data processing applications are becoming inadequate. Learn about the R language that is at the center of most advanced analytics conversations. R is an open source statistical language that is rapidly gaining popularity due to a robust set of machine learning functionality and a never-ending set of R packages that are used to increase functionality of the core R language. In this session, we will introduce the R language and review some of the features of the highly interactive environment that are available with just the base install. We will also review some of the upcoming features in the SQL Server 2016.
Speaker(s):
- Reeves Smith
Track and Room: Analytics and Visualization - San Mateo
Title: Performance Monitoring AlwaysOn Availability Groups
Abstract: Have you deployed Availability Groups in your data center? Are you monitoring your Availability Groups to ensure you can meet your recovery objectives? If you haven’t this is the session for you. We will discuss the importance of monitoring and trending Availability Group Replication, how AGs move data between replicas and the impact replication latency can have on the availability of your systems. We’ll also give you the tools and techniques to go back to the office and get started monitoring and trending right away!
Speaker(s):
- Anthony Nocentino
Track and Room: Enterprise Database Administration Deployment - Microsoft
Title: Recovery Models Made SIMPLE
Abstract: SQL Server always logs every change to a database. But exactly what is logged can vary based on a number of factors. Some operations are referred to as “minimally logged,” but even those operations can log a different level of detail depending on your recovery model. This session looks inside the transaction log to see exactly what is logged for minimally logged operations. First, we look at some background information regarding how the log is used and managed, and then we introduce a tool that can help you actually see your log records. When you can query the log, you can determine how logging for operations such as index rebuilds and SELECT INTO differs depending on whether you are using the FULL or BULK_LOGGED recovery model. We also look at other factors in our SQL Server operations that can affect what is actually written to the log. In addition, I’ll describe the benefits and caveats for each of the recovery models.
Speaker(s):
- Kalen Delaney
Track and Room: Enterprise Database Administration Deployment - Tintri
Title: Who needs SSAS when you have SQL?
Abstract: Analysis Services may seem foreign or unnecessary for SQL and .NET developers. However, it can offer many advantages for reporting and data exploration, even with the SQL engine’s latest indexing and in-memory analytics capabilities. In this session, we will cover useful features of SSAS and discuss conditions where it is beneficial. Next we’ll compare the two types of Analysis Services databases (Multidimensional and Tabular) and identify requirements that should influence your decision of which type is right for your solution. Then we will explore common ways to retrieve data and browse your SSAS database, such as Power BI and Excel, reporting tools like SSRS, and custom .NET applications.
Speaker(s):
- Meagan Longoria
Track and Room: BI Platform Architecture, Development Administration - Dell
Title: Changing Your Habits to Improve the Performance of Your T-SQL
Abstract: Do you dread handing your t-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your t-SQL? In this demo heavy session, we’ll take a look at various ways to improve your t-SQL. You’ll learn why top down design is not always the best pattern as well as why implicit conversions can slow down your queries. You’ll learn how to rewrite most cursors as well as finding out how user defined functions affect performance. You’ll learn some simple ways to troubleshoot these types of issues using execution plans and extended events. Finally we’ll take a look at how standards can help quicken turnaround time when refactoring t-SQL. By changing some of your t-SQL writing habits you can improve performance of queries from the very beginning.
Speaker(s):
- Mickey Stuewe
Track and Room: Application Database Development - Microsoft
Title: Overcoming Chartaphobia with Power BI
Abstract: Do reports in your organization consist mostly of giant tables of data? Perhaps you have gotten as far as adding KPI indicators or conditional highlighting to the tables. Maybe you have charts, but they are hideous and distracting. Although tables of data presented as reports are commonly found in many organizations, they may be doing you and your users a disservice. We’ll discuss why cognitive psychological studies tell us that graphs and pictures are more effective at communicating trends and comparisons and how to prepare to create good data visualizations. Then we’ll explore how to employ purposeful data viz designs to help users achieve their goal of making informed decisions, using a fun and useful Power BI dashboard. You’ll leave with guidance on how to take boring or unreadable tables of data and turn them into useful and visually appealing reports.
Speaker(s):
- Meagan Longoria
Track and Room: Analytics and Visualization - San Mateo
Title: Window Functions- Get OVER it!
Abstract: Window functions can be powerful and simple to use. In this session we will go over many practical uses of window functions to provide powerful analytics while performing extremely well compared to traditional methods of pulling data. First we will cover the syntax and use of ranking window functions (ROW_NUMBER, RANK, DENSE_RANK, and NTILE). Next we will cover aggregate window functions and offset functions (LAG, LEAD, FIRST_VALUE, and LAST_VALUE). Finally we will cover window analytic/distribution functions (PERCENT_RANK, CUME_DIST, PERCENTILE_DISC, and PERCENTILE_CONT).
This session will be filled with examples and practical applications of window functions in analytics.
Speaker(s):
- Eric Freeman
Track and Room: Analytics and Visualization - San Joaquin
Title: AWS Command Line and Working with RDS
Abstract: AWS Command Line and Working with RDS
Speaker(s):
- Eric Courville
Track and Room: Enterprise Database Administration Deployment - Dell
Title: Dell: Manage SQL Server Performance with Spotlight on SQL Server
Abstract: Grab your lunch and join Trent Mera of Dell Software in the Dell room for an informative presentation while you eat!
Trent will show you to get real-time notification and rapid diagnoses of your SQL Server performance problems using Dell Software’s Spotlight on SQL Server. Spotlight on SQL Server gives real-time alerts and brings together all of your critical SQL Server metrics onto a single dashboard-type screen, color-coded for problem severity and clickable for drilling down to the details and root causes of problems.
Speaker(s):
- SQLSAT540 Sponsor
Track and Room: Enterprise Database Administration Deployment - Dell
Title: NoSQL for SQL DBA
Abstract: You have heard a lot about NOSQL databases. In this session you will learn about MongoDB database from a SQL Server DBA’s perspective. Come see the commonalities and differences between the two.
Speaker(s):
- DIlip nayak
Track and Room: Enterprise Database Administration Deployment - San Mateo
Title: You Don’t Have to be in Leadership to be a Leader
Abstract: Even though we as database professionals focus training almost exclusively on our technical skills, our ability to create and implement database solutions depends a great deal on our people skills as well. Our people and leadership skills play a heavy role in our ability as database professionals to deliver timely and robust solutions for our businesses. Let’s discuss ways in which we can improve our soft skills, and become the leaders our businesses need.
Speaker(s):
- Jonathan Amen
Track and Room: Professional Development - Tintri
Title: Power BI Desktop – A BI developer’s view
Abstract: Power BI Desktop is the new self-service entry in the Microsoft BI development landscape but what does it offer the professional BI developer? This session will explore Power BI Desktop features for data accusation and manipulation, sample some of the visualization provided and review the deployment options.
Speaker(s):
- Phil Robinson
Track and Room: Analytics and Visualization - Microsoft
Title: PoShDBA: Practical PowerShell for the DBA
Abstract: This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some outside modules created to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and “I have to have it now” stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour and never try to reuse a click again.
Speaker(s):
- Ben Miller
Track and Room: Enterprise Database Administration Deployment - Tintri
Title: Build ETL efficiently (10x) with Minimal Logging
Abstract: This session is designed to teach DBAs and developers the best strategy to transfer large data.
We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.
Speaker(s):
- Simon Cho
Track and Room: BI Platform Architecture, Development Administration - Dell
Title: Tintri: I/O Whack-a-Mole
Abstract: Grab your lunch and join Christopher Slater Dylan Thieu of Tintri in the Tintri room for an informative presentation while you eat!
Disk I/O for a virtualized SQL Server database takes a mysterious journey. In this session we will take the mystery out of virtual disk I/O. Using common infrastructure tools we will explore the path of a disk I/O and share repeatable methods that can be used to quickly identify the cause of a performance bottleneck. Along the way we will explore SQL Server, the Virtual Machine, the hypervisor, virtual switches, physical switches, and the storage.
Speaker(s):
- SQLSAT540 Sponsor
Track and Room: Enterprise Database Administration Deployment - Tintri
Title: Stump the MCM Studs
Abstract: Got a question you want to ask the Microsoft Certified Masters (MCM)? Bring it to this session and lets see if we can make them squirm in this chairs a little bit. Nothing is off limits!
Speaker(s):
- Mitchell Bottel
Track and Room: Enterprise Database Administration Deployment - San Mateo
Title: Power BI Embedded
Abstract: Power BI Embedded
Speaker(s):
- Angel Abundez
Track and Room: BI Platform Architecture, Development Administration - Dell
Title: OWN your SQL Servers with PBM CMS
Abstract: In this session, you will learn how to setup and implement Central Management Server (CMS) to run queries against multiple SQL servers in your environment. Mitch will also cover Policy Based Management (PBM) and how to use out of the box best practices and create custom policies to maintain your environment. He will then look at using both CMS and PBM in conjunction with each other to monitor your environment.
Speaker(s):
- Mitchell Bottel
Track and Room: Enterprise Database Administration Deployment - San Mateo
Title: DBA Cheat Sheet
Abstract: Do you have trouble remembering common administrative T-SQL commands? Remember when you created a cheat sheet in school to help you study for an exam? Use that same principle with the DBA Cheat Sheet! The DBA Cheat Sheet is a document filled with some basic administrative TSQL commands you’ll need in your daily work. During the session I’ll show you a few SSMS tricks and review some of the topics in the DBA Cheat Sheet document. You’ll leave the session with a document that you can use as a reference every day. This is geared for developers or Junior DBAs.
Speaker(s):
- Elizabeth Block
Track and Room: Enterprise Database Administration Deployment - San Joaquin
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Glenn Burnett
Twitter: - SQLGB
Glenn Burnett is a Sacramento, California-based SQL Server professional working as a database administrator. A technical professional for over 25 years, he’s worked with SQL Server for over 20 years. Active in the Professional Association for SQL Server (PASS) and a board member of the Sacramento SQL Server User Group, he was recognized by PASS as an Outstanding Volunteer in December, 2013. He has spoken at Sacramento SQL Server User Group meetings and SQLSaturday events in Sacramento and Silicon Valley, and was the primary organizer for SQLSaturday 312 in Sacramento and assistant organizer for SQLSaturday 222, 399, 540, 650, 757 and 885, also in Sacramento. You can find him on Twitter as @SQLGB.
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
Dan Hess
Twitter: - @SQLDCH
LinkedIn: Dan Hess
Contact: http://www.expressnetsolutions.com/sqldch
Dan has been in IT for the last 18 years, graduating from California State University, Chico with a computer science degree. He#39;s been focused on SQL Server since 2007 when he was given the quot;accidental DBAquot; title. After learning to swim in the deep end and moving jobs to Sacramento, he saw the need to help others who were in a similar position and helped to form the Sacramento SQL Server user group. Database administration is his primary focus.
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
Reeves Smith
Twitter: - SQLReeves
LinkedIn: Reeves Smith
Contact: http://reevessmith.wordpress.com
Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively.
Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local conferences and user groups.
SQLSAT540 Sponsor
SQLSaturday 540 Sponsor
Prakash Heda
Twitter: - @prakashheda
LinkedIn: Prakash Heda
Contact: http://www.sqlfeatures.com/
Prakash Heda works as Manager (Data-IT) at SSC Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.
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.
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.
Jonathan Amen
Jonathan Amen is a SQL Server Business Intelligence and DBA professional with 11 years experience. Jon had been solving complex business questions for 8 years as a business analyst before transitioning to business intelligence. Currently Jon is working at Sutter Health in Sacramento where his duties include both development and administration of data warehouses, ETL processes, data cubes, and various reporting front ends.
Tim Plas
Twitter: - tjplas
LinkedIn: Tim Plas
Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.
SQLSAT540 Sponsor
SQLSaturday 540 Sponsor
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
Todd Kleinhans
Twitter: - @toddkleinhans
LinkedIn: Todd Kleinhans
Contact: https://toddkleinhans.wordpress.com/
Todd Kleinhans has been using SQL Server since the last millennium. He has served in different roles across many industries but he’s mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group. He is on Twitter: @toddkleinhans and blogs at https://toddkleinhans.wordpress.com/
Eric Courville
Contact: http://www.organicit.org
Eric Courville has been with Verizon for 15 years supporting and implementing Large Enterprise Resource Planning Applications from vendors such as Oracle, Microsoft and SAP. Specializing in application monitoring, and integrating SSO with third party applications. Eric is Also the founder of the Northern California PowerShell User Group with locations in San Francisco and the Sacramento area.
Simon Cho
LinkedIn: Simon Cho
Contact: http://simonsql.com
Simon Cho is one of the founders of SQLAngeles.com, which is a Los Angeles Korean Tech PASS community group.
As a Local Group leader, he is a Microsoft SQL community speaker. He has presented many times at SQLSaturdays and to PASS Local Groups.
He moved his passion to VISA Inc, the largest credit card provider in the world, where he used database technology to build a strong solution and a secure environment, with new strategies and features to maintain thousands of SQL Servers.
He has now joined the Nowcom Corp, as a Director of DevOps, where he leads the DevOps team and DBA team.
He is pretty much working on SQL server running on kubernetes.
Phil Robinson
Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using Microsoft Reporting Services and Power BI. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQLSaturday – San Diego.
DIlip nayak
Dilip works as a Senior DBA at a financial services company. His specialization is in SQL performance tuning, high availability, and database administration. He has over 18 years of IT experience starting as a VB/.NET developer and has been working with SQL for the past 9 years.
Eric Bragas
Twitter: - @ericbragas
LinkedIn: Eric Bragas
Contact: http://ericbragas.io
Business Intelligence Consultant passionate about leveraging new and cutting edge technologies to discover new data insights.
Eric Freeman
Twitter: - sqlelf
LinkedIn: Eric Freeman
Contact: http://sqlelf.blogspot.com/
Eric Freeman works as a Lead Business Intelligence Architect at John Burns Real Estate Consulting. He has 15+ years of experience working with Microsoft SQL Server and holds an MCTS in Business Intelligence with a strong emphasis on Performance Tuning, ETL and Data Warehousing. Former President of the Sacramento SQL Server User Group, and actively speaks at SQL Server events.
Brandon Leach
Twitter: - SQLServerNerd
LinkedIn: Brandon Leach
A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.
Mickey Stuewe
Twitter: - @SQLMickey
LinkedIn: Mickey Stuewe
Contact: http://www.MickeyStuewe.com
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.
She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events.
When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.
Meagan Longoria
Twitter: - mmarie
LinkedIn: Meagan Longoria
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
Kalen Delaney
Twitter: - sqlqueen
Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.
Meagan Longoria
Twitter: - mmarie
LinkedIn: Meagan Longoria
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
Sayed Saeed
LinkedIn: Sayed Saeed
Contact: http://www.plusconsulting.com/blog/
Sayed Saeed is the Business Intelligence Practice Director at Plus Consulting. He is highly proficient in developing targeted BI solutions for clients and offers solid knowledge and experience in BI products that help organizations better leverage information to effectively manage business. He is a Microsoft Certified Solutions Expert in Business Intelligence as well as Oracle Certified Professional.
Anthony Nocentino
Twitter: - nocentino
LinkedIn: Anthony Nocentino
Contact: http://www.centinosystems.com/blog/
Anthony Nocentino is the founder and President of Centino Systems as well as a Pluralsight author, Microsoft Data Platform MVP, Linux expert, and corporate problem solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.
Tim Plas
Twitter: - tjplas
LinkedIn: Tim Plas
Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
Chris Hyde
Twitter: - ChrisHyde325
LinkedIn: Chris Hyde
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
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.
Elizabeth Block
Twitter: - @sqlservermama
LinkedIn: Elizabeth Block
Elizabeth Block is passionate about using database technologies to solve business problems. Currently a Senior DBA at PeaceHealth in Springfield, Oregon, she’s on a team managing over 300 SQL Servers. Extensive experience in database design and analysis has helped her in her roles as database consultant, developer, and DBA. She’s worked with SQL Server for over 10 years.
Deji Akomolafe
Twitter: - @dejify
Contact: http://blogs.vmware.com/apps
Deji Akomolafe (a member of the Office of the CTO Ambassador Program and Staff Solutions Architect within VMware#39;s Global Field and Partners Readiness Group) specializes in the virtualization of Microsoft Business Critical Applications on VMware#39;s vSphere platform. Deji is a regular speaker at VMworld, Partners Exchange Conference, VMUG, SQLSaturday and EMCWorld, presenting technical subject matters related to Microsoft Applications virtualization and providing technical guidance to help clients enhance their expertise and ability to optimally virtualize and operate their critical applications.
Angel Abundez
Twitter: - AngelStreamline
LinkedIn: Angel Abundez
Contact: http://angelstreamline.com
Angel leads the Solutions Architecture team at DesignMind, helping design and build world class data-related systems. His expertise includes Microsoft SQL Server BI tools, Power BI, Azure-based database services, and Tableau. His team develops Proofs of Concept, Pilots, and highly scalable production systems. Angel co-leads the Bay Area Microsoft Business Intelligence User Group and the San Francisco Power BI User Group. He speaks at Data Analytics events throughout the U.S. and writes for SQL Server Central. He is a graduate of Cal Poly SLO with a BS in Mechanical Engineering.
Christopher Anderson
Twitter: - @realworldis
Chris works as a Database Architect for the California Department of Corrections. In this role, he provides lead support for a large environment of SQL Server and Oracle database and plans the architecture of new systems. In past roles, he worked on COMPSTAT, a performance management method, by building out a Business Intelligence solution using the entire SQL Server stack. Chris has managed IT projects and developed applications.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
Sponsors
The following is a list of sponsors that helped fund the event: