SQLSaturday #399 - Sacramento 2015

Event Date: 07/25/2015 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.

Sessions
Speakers
Sponsors

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: Performing a SQL Server Health Check

Abstract: How often do you review your SQL Servers for basic security, maintenance, and performance issues? If you say never, I’m not surprised - many of the servers I “inherit” as a managed services provider have many gaping holes. It is not unusual to find databases that are never backed up, constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that have too much!)

Come learn how to use freely available tools to check your servers for basic issues like backups and CheckDB as well as for more advanced issues like page life expectancy and indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!

Speaker(s):

Andy Galbraith

Track and Room: Database Administrator - N/A

Title: Query Processing in In-Memory OLTP (Hekaton)

Abstract: In-Memory OLTP (code name: Hekaton) is the most important new feature in SQL Server 2014, and this session will teach you how query processing and optimization work with this new database engine. After explaining the basics, we will discuss how the query optimizer is used in In-Memory OLTP by both natively compiled stored procedures and by traditional stored procedures accessing memory-optimized tables through the query interop functionality. We will also take a look at how the new hash and range indexes are used, as well as how their performance implications are also covered along with the process of translating the plan created by the query optimizer into C code. Finally, some limitations with the current release will also be explained.

Speaker(s):

Benjamin Nevarez

Track and Room: Professional Development - Profisee

Title: Getting Started with Extended Events

Abstract: Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) than Extended Events. Many DBA’s continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?

Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.

Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!

Speaker(s):

Andy Galbraith

Track and Room: Database Administrator - Dell

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.

Speaker(s):

Deji Akomolafe

Track and Room: Other - Microsoft

Title: SQL Server Mythconceptions and Mythteries

Abstract: There are a lot of misconceptions and mysteries in SQL Server due in large part to there be no single right answer for just about any question you have. How many times have you heard, ‘It Depends’ as the answer to a complex SQL Server question? So often that it has almost become a joke. When it’s your SQL Server, it’s no joke.

Why won’t that query go parallel? Why won’t the optimizer use that index? Why did rebuilding that index improve performance 10 times over?

Sometimes misconceptions become accepted as fact, and they spread. Occasionally, these mistold tales come from very reliable sources. It can be extremely difficult to tell what is fact and what is fable.

In this session, we will explore some of these misconceptions and mysteries turned myths and bust out the truth. We will prove the right answer and free you from these myths that have taken on a life of their own.

Speaker(s):

Robert Davis

Track and Room: Other - Microsoft

Title: SQL Server Backups and Restores A to Z

Abstract: Have you become the de facto DBA? Have you been tasked with the responsibility of backing up your databases? Do you feel that your database maintenance plan is adequate, but may be lacking in what it can do? If these scenarios sound familiar, you’ll want to join this session, where Microsoft Certified Master (MCM) Keith Tate will walk you through the basics of backup and restore options. The session will begin with the reasons why databases must be backed up (hint: to restore them). Then, discuss the different recovery models and how they affect your backup strategy. Next, explore ways to automate backup and restore strategies, and review ways to improve the speed of your backups and restores. Finally, put it all together and you’ll be on your way to a disaster proof backup and restore strategy.

Speaker(s):

Keith Tate

Track and Room: Database Administrator - Tegile

Title: Techniques for Dynamic SSRS Reports

Abstract: Do you need a navigation system within your reports? Do you suffer from report sprawl, having hundreds of reports written once and disappearing into the reporting services catalog never to be executed again? Would you like to see one report take the place of fifty?

If you answered yes to any of these questions, then join me in this demo heavy session. Not only will we address the questions above, but we’ll talk about providing different layouts to the data in the same report, minimizing data based on the user’s credentials, and even techniques for colorizing various parts of a report using VBA code. These techniques will help make your reports user friendly and help you look like a reporting superhero.

Speaker(s):

Mickey Stuewe

Track and Room: Business Intelligence - Tegile

Title: Take your Reporting Services Implementation to a New Level

Abstract: Are you already using Reporting Services (SSRS) but just not loving it? Has it become clumsy, hard to manage or just plain not great? In this session designed for intermediate users with some SSRS knowledge you will see how you can simplify and unify your implementation making your reports pop with polish while shortening your development time and maintenance efforts. An exploration of Shared Data Sets will show how to reduce data discrepancies and improve performance. Learn how to leverage the power of Linked Reports to reduce the number of reports needed and to streamline report publication. Come discover how the ultimate Report Footer can tell you all you need to know about that report, its performance and the users who are running it.

Speaker(s):

Ted Stathakis

Track and Room: Business Intelligence - Dell

Title: Standardized SQL Installations – Script Review Demo

Abstract: This session is mostly demo-focused. I will cover prerequisites for scripts and show how to do multiple SQL Server installations using scripts and demonstrate how to Streamline SQL Server implementations.

You’ll take-away script to install different versions of SQL Server on supported OS systems. This script allows anyone in IT to install SQL systems with best practices baked into it which ensure all SQL installation can be streamlined.

You’ll see PowerShell scripts where a single line script can install any of these combinations: • Windows 2008R2/2012/2012R2 • SQL 2014/2012/2008R2 (Enterprise/Standard/Developer editions) • Implement best practices and configuration based on available resources for dedicated SQL Server environments

Speaker(s):

Prakash Heda

Track and Room: Database Administrator - Micron

Title: Best Practices for Excel Pivot Tables

Abstract: The benefit of a direct-connected pivot table for the SQL Admin/Developer is: you no longer have to write and constantly tweak reports! Just give your users permission to run a stored procedure, and they can satisfy all their reporting needs through self-service.

Benefits for your business user: they can always drill down to the detail, be confident that it was not changed after retrieval from the database, and change parameters and refresh whenever they want, even after rearranging the report.

It requires no client software besides Excel, and has worked similarly since Excel 97. Nothing is required on the server except any version of SQL. (You can also connect to any data source with an ODBC driver!)

Although the concept is straightforward, there are some stumbling blocks to avoid. I will cover all the important points for setting up this solution, including: 1) Making the Connection 2) Configuring and Arranging the Table 3) Allowing Users to Change Parameters

Speaker(s):

Tom Keller

Track and Room: Business Intelligence - Profisee

Title: Getting Started with Reporting Services

Abstract: Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL: You’ve already paid for it, so put it to use! In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services. From building a dataset through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort. Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.

Speaker(s):

Ted Stathakis

Track and Room: Business Intelligence - Micron

Title: Azure Machine Learning: From Design to Integration

Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. In this session, learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, and then finally to the integration and integration of predictive insights.

This session has been specifically designed to describe machine learning fundamentals, and to help enable and inspire existing developers taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease in which it can be accomplished.

Speaker(s):

Peter Myers

Track and Room: Other - Profisee

Title: Are You Maintaining Your SQL Servers?

Abstract: Are you performing all of the regular maintenance you should on your servers? Do you not run CHECKDB because “it takes too long”? How about Index Maintenance - does that take too long? Do you really have the appropriate backups in place?Do you have benchmark numbers in place to compare when your server is “slow”? Come discuss the answers to these and other questions - we will discuss the free Maintenance Solution scripted tools from Ola Hallengren and how they can help you fix these and other problems with a little easy coding you can do yourself. We will also discuss other tips and tricks to help you maintain and troubleshoot your SQL Server instances.

Speaker(s):

Andy Galbraith

Track and Room: Database Administrator - N/A

Title: Powershell and the Art of SQL Server Deployment

Abstract: In today’s tech world, IT professionals are being driven to perform tasks faster and more consistently. Automation is the watchword for our success, whether we are deploying SQL Server to private virtual clouds or public platforms such as Azure IaaS. This session will focus on rapidly creating and configuring SQL Servers using Powershell and Desired State Configuration. You will see practical examples of how you can create repeatable builds of SQL Server that can be deployed in a matter of minutes. We will also review how these techniques can be applied to both public and private cloud platforms, ensuring your success for any situation.

Speaker(s):

Michael Fal

Track and Room: Other - Micron

Title: Master Data Management - Getting Started with SQL Server MDS

Abstract: This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we’ll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We’ll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we’ve set the stage for what, how and why you need MDM, we’ll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS

Speaker(s):

John McAllister

Track and Room: DB Developer - Tegile

Title: Dell: How SharePlex Replicates from Oracle to SQL Server 8 Other Targets

Abstract: Grab your lunch and join Trent Mera and Susan Wong in the Dell room for an informative presentation while you eat!

How SharePlex Replicates from Oracle to SQL Server and Eight Other Targets

Replicate from Oracle to a more economical and potentially easier-to-manage platform like SQL Server and experience less frustration when support is required. Offloading database activities to a SQL Server replica will leave more processing power and faster response times for your Oracle users. Users on the SQL Server target will enjoy near-real-time data on an instance that is tuned specifically for the purpose of reporting, analytics and other database activities while the Oracle production system remains tuned for online transaction processing (OLTP). In addition, SharePlex can be used to completely migrate an Oracle database to SQL Server without taking users offline during the migration process. A SQL Server target replica could be used to accomplish archiving or serve as a data warehouse

Speaker(s):

SQLSAT399 Sponsor

Track and Room: Lunch - Dell

Title: Big Data Analytics with Excel

Abstract: This introductory session describes and demonstrates how to create a big data analytics solution with structured data by using Azure HDInsight and Excel 2013. This session will be of interest to those new to the concept of big data, new to self-service data modeling with Power Pivot, and for those interested to understand how big data can play a role in a self-service BI solution. Demonstrations will reinforce the introductory theory by showing how to store data files, and how to use Pig to transform data, and Hive to query data. The “big data” will then be retrieved and queried by using Power BI add-ins in Excel 2013, including Power Query, Power Pivot and Power View.

Speaker(s):

Peter Myers

Track and Room: Business Intelligence - Dell

Title: Profisee: Accelerate SQL Server Master Data Services with Profisee Maestro

Abstract: Grab your lunch and join John McAllister in the Profisee room for an informative presentation while you eat!

Accelerate SQL Server Master Data Services with Profisee Maestro

SQL Server Master Data Services (MDS) is a robust platform for master data and hierarchy management that provides master data capabilities such as business rules, a managed schema, hierarchies, versioning, workflow, and Excel Integration. Profisee Maestro slashes your time to deployment on MDS by providing an alternate UI for data Stewards and Application owners. Maestro adds data modeling, a first-rate user experience, ER-Win Integration, Simplified Import/Export to simplify getting MDM in the hands of your users. Maestro also adds data quality, matching, harmonization, address corrections, an API, web parts and CRM integration.
Come see how Profisee Maestro can take your MDS implementation from the department to the enterprise.

Speaker(s):

SQLSAT399 Sponsor

Track and Room: Lunch - Profisee

Title: Diagnosing Performance with Wait Statistics

Abstract: Wait statistics get more complaints about a lack of documentation than just about anything in SQL Server. The documentation that is available is not always very clear. Let’s clear up these gray areas once and for all.

This session will cover what you need to know about wait stats like the best way to investigate them, how to interpret their meanings, and which wait types are important and which can be ignored.

Speaker(s):

Robert Davis

Track and Room: Database Administrator - Microsoft

Title: Automating Power BI Creations

Abstract: Come learn how to build and automate data sets and data models in Excel using the Power BI toolset. We’ll pull data from a variety of on-premise and cloud data sources to familiarize yourself with the latest capabilities of Power Query and Power Pivot. Then we’ll review the software required to automate your Power BI analysis whether you are trying to refresh your Excel workbooks on a file server, in SharePoint Online, or SharePoint on-premise.

Speaker(s):

Eric Bragas

Track and Room: Business Intelligence - Tegile

Title: TSQL Best Practices for SQL Engine Kindness

Abstract: This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.

Speaker(s):

Ben Miller

Track and Room: DB Developer - Micron

Title: Intro to PowerShell by example

Abstract: We will review the bear minimum PowerShell CmdLets you should learn when you start learning PowerShell which will give you a good primer for exploring other more specific CmdLets. You will learn what makes up PowerShell CmdLets, and basic syntax for using them, and how to dissect the .NET Objects that are returned by them.

Speaker(s):

Eric Courville

Track and Room: Other - Tegile

Title: Power BI Hands-On Micro-Workshop

Abstract: Bring your laptop and let’s build a BI solution using the components of Power BI! You’ll need Office 2013 ProPlus (you can install the trial) and the Power Query add-in. I’ll provide everything else. This 95% demo and uber-fast hands-on lab session will show you how to cleanse and transform data from multiple sources with Power Query, model data for reporting with Power Pivot and then explore the model and build interactive dashboards with Power View. You’ll leave with a working BI solution. Office ProPlus 60 day trial: http://www.microsoft.com/en-us/evalcenter/evaluate-office-professional-plus-2013 Power Query add-in: http://www.microsoft.com/en-us/download/details.aspx?id=39379

Speaker(s):

Paul Turley

Track and Room: Business Intelligence - Tegile

Title: Microsoft

Abstract: Grab your lunch and join us in the Microsoft room for an informative presentation while you eat!

Speaker(s):

SQLSAT399 Sponsor

Track and Room: Lunch - Microsoft

Title: Flash Disk Alternatives for SQL Server Databases

Abstract: Flash disk and/or SSD technology options have been creeping into SQL Server database deployments more frequently. Knowing what options are out there and how they differ is key to successful deployments because the flash revolution is here to stay, and not all flash is created the same. Oracle ACE Bert Scalzo will present the many significantly different alternatives for utilizing flash disk and/or SSD in SQL Server deployments. Additionally, he will review SQL Server 2012 and 2014 features that support or best utilize flash.

Speaker(s):

Bert Scalzo

Track and Room: Other - Dell

Title: Are You Optimistic About Concurrency?

Abstract: What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012’s SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency?

In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!

Speaker(s):

Kalen Delaney

Track and Room: Database Administrator - Dell

Title: Data Pages, Allocation Units, IAM chains… Oh My!

Abstract: Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions. We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.

Speaker(s):

Brandon Leach

Track and Room: Database Administrator - Profisee

Title: Micron: Choosing the Right SSD for Your Application

Abstract: Grab your lunch and join Justin Strong in the Micron room for an informative presentation while you eat!

Choosing the Right SSD for Your Application

This presentation is a case study of an IT manager’s decision process in choosing SSDs for server side storage to run Microsoft SQL.

Speaker(s):

SQLSAT399 Sponsor

Track and Room: Lunch - Micron

Title: Powershell Tips and Tricks for SQL Server Administration

Abstract: Have you dipped your toe into the Powershell pool, but are still lost on how you can make it work for you? Maybe you’re just looking for a few more tools to help you better manage SQL Server administration? In this session, we will cover a handful of useful scripts and patterns in Powershell that will ease your management of SQL Server. Backups, file management, instance configuration, and several other areas will be covered. By attending this session, you will learn more about how you can use Powershell effectively in your environment.

Speaker(s):

Michael Fal

Track and Room: Other - Profisee

Title: Introduction to Wait Types and Response Time Analysis

Abstract: Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.#160;

Speaker(s):

Jonathan Shaulis

Track and Room: Database Administrator - Microsoft

Title: Physical Join Operators

Abstract: SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer’s decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.

Speaker(s):

Ami Levin

Track and Room: DB Developer - Profisee

Title: CTE’s and Recursion in T-SQL

Abstract: In this session you will learn various uses of Common Table Expressions, how to declare, stack CTE’s, and how to use recursive CTE’s. Examples will be shared of how they can be used in useful and not so useful (but informative) ways. This session is intended for those comfortable using T-SQL but wanting to learn more about what is available. My intention is to heavily cover recursive CTE’s in this session. We will also go over windowed functions which will be used in some CTE examples.

Speaker(s):

Eric Freeman

Track and Room: DB Developer - Micron

Title: SSAS: Zero to Cube in Sixty Minutes

Abstract: For data sets ranging from a few gigabytes to tens of terabytes, Microsoft’s SSAS can be the tool of choice. In this session, we start off by covering basic terminologies and the usage of the SSAS tool to build cubes, analyze datasets and build up to the usage of SSAS on terabyte sized datasets. We further focus on some of the surprisingly straightforward techniques while dealing with such large datasets. Finally, we cover the ease of use of the SSAS tool and its inherent advantages while interoperating with reporting tools.

Speaker(s):

Pravina Parthasarthy

Track and Room: Business Intelligence - Microsoft

Title: Big Data Data Science, How to Get Past the Hype and Into a Team

Abstract: Big Data and Data Science are two of the most hyped areas in high tech today. But what do Big Data and Data Science really mean, and how can you move into these hot career paths? In the discussion we will: Discuss the different roles in Big Data and Data Science teams; talk about the qualifications around each of the roles. Andrew will also provide starting points and pointers on how to get started in these fields.

Speaker(s):

Andrew Eichenbaum

Track and Room: Professional Development - Microsoft

Title: SQL Server Encryption

Abstract: What encryption is available in your version of SQL Server? This session will cover how to set up the Encryption Hierarchy and the requirements for the new Backup with Encryption in SQL 2014. We will also cover end to end Transparent Database Encryption (TDE). This session will go over all the steps and caveats that go with this technology. Encryption is here to stay so jump on and let’s take it for a ride.

Speaker(s):

Ben Miller

Track and Room: DB Developer - N/A

Title: Becoming Certified In Microsoft SQL Server

Abstract: Becoming certified in SQL Server is a great career enhancement for a database professional. This session will provide you with an overview of the SQL Server Certification program, including the numerous changes made to the program for SQL 2012. You’ll discover several reasons why you should become certified, and some of the best ways in which to do so. You’ll also leave the session armed with some tips and tricks for passing the exams that the presenter has used over the last thirteen years.

Speaker(s):

Chris Hyde

Track and Room: Professional Development - Dell

Title: Everything SQL Server - Lightning Talks with Sacramento SQL UG

Abstract: Come see the Sacramento SQL Server User Group board present their lightning talks. We will be different features of SQL server in this fun, quick paced, multi session of SQL goodies. It is promised to be entertaining and enlightening! Agenda Dan Hess talking about Signing stored procedures with certificates: Server security groups before SQL Server 2012 Dilip Nayak Discussing Auditing your actions using SQL Audit Glenn Burnett talking about SQL Server Query Store in SQL 2016 Mitch Bottel will be talking SQL Server Management Studio Tips and Tricks

Come have fun with this session!

Speaker(s):

Mitchell Bottel

Track and Room: Database Administrator - Micron

Title: Event Registration

Abstract: Event Registration

Speaker(s):

Mitchell Bottel

Track and Room: Non-Session - Microsoft

Title: Tabular Models: Easier Faster Than Cubes; Really?

Abstract: The future of data analysis is the new, in-memory xVelocity Tabular analytic engine but is this new product ready for enterprise solutions? Is it easier to build Tabular models than multidimensional cubes in SQL Server 2012? Maybe… It depends on what you need to do. Is it faster? Heck, yea. Taking off the Microsoft BI marketing hat, let’s take a tabular journey together and learn some lessons from the first generation of real, enterprise-scale solutions: The Good, the Bad, the Ugly and the Beautiful.

Speaker(s):

Paul Turley

Track and Room: Business Intelligence - N/A

Title: Raffle

Abstract: End of Day Raffle

Speaker(s):

Mitchell Bottel

Track and Room: Non-Session - Dell

Title: Tegile

Abstract: Grab your lunch and join us in the Tegile room for an informative presentation while you eat!

Speaker(s):

SQLSAT399 Sponsor

Track and Room: Lunch - Tegile

Title: Registration

Abstract: Registration

Speaker(s):

Mitchell Bottel

Track and Room: Non-Session - Dell

Title: Lunch Sessions

Abstract: Lunch Sessions from Event Sponsors

Speaker(s):

Mitchell Bottel

Track and Room: Non-Session - Dell

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

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.

Peter Myers

LinkedIn: Peter Myers

Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.

He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.

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.

Michael Fal

Twitter: - @Mike_Fal

LinkedIn: Michael Fal

Contact: http://mikefal.net

Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.

Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.

Mitchell Bottel

Twitter: - @SacSQLDude

Contact: http://www.mitchespitch.com

Benjamin Nevarez

Contact: http://www.benjaminnevarez.com/

Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.

Peter Myers

LinkedIn: Peter Myers

Pravina Parthasarthy

LinkedIn: Pravina Parthasarthy

Pravina Parthasarthy now a Senior BI Consultant at DesignMind, started off as an electrical engineer before realizing her true passion was data and its analysis. She has held various positions in the software industry over the last eleven years, mainly focused around data analysis. Pravina#39;s specific interests include SSAS, SQL and the use of these technologies while dealing with ultra large datasets. While not working on data, Pravina loves travelling and watching movies.

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.

Bert Scalzo

Contact: http://www.toadworld.com/members/bert_5f00_scalzo/blogs/default.aspx

Bert Scalzo is a renowned database expert, Oracle® ACE, author, and Chief Architect at HGST. With three decades of database experience, Bert’s webcasts garner high attendance and participation rates. Bert has an extensive academic background that includes a BS, MS, and Ph.D. in computer science, as well as an MBA. He wrote two books for SQL Server users: Introduction to SQL Server: Basic Skills for Any SQL Server User Database Benchmarking: Practical Methods for Oracle SQL Server.

Peter Myers

LinkedIn: Peter Myers

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.

Mitchell Bottel

Twitter: - @SacSQLDude

Contact: http://www.mitchespitch.com

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.

Deji Akomolafe

Contact: https://blogs.vmware.com/apps

Deji Akomolafe (a Staff Solutions Architect at VMware’s Global Center of Excellence) specializes in the virtualization of Microsoft Business Critical Applications on the VMware vSphere platform. Deji is a regular speaker at VMworld, PEX and EMCWorld, presenting technical subject matters related to virtualization and providing technical guidance to help customer enhance their expertise and ability to optimally virtualize and operate their critical applications.

Mitchell Bottel

Twitter: - @SacSQLDude

Contact: http://www.mitchespitch.com

Ben Miller

Twitter: - DBAduck

LinkedIn: Ben Miller

Contact: https://dbaduck.com

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

Andrew Eichenbaum

Contact: http://www.designmind.com

Andrew is a former physicist who realized that data mining and the understanding of systems is his real passion. That lead him from his PhD in Physics to the realm of web analytics where he has worked on problems in: search, personalization, NLP, reporting, product design/road-map, and basic RD. With over 10 years of industry experience, he has managed multiple projects and teams across a wide range of topics ranging from advanced analytics to BI and marketing.

Mitchell Bottel

Twitter: - @SacSQLDude

Contact: http://www.mitchespitch.com

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.

Tom Keller

Twitter: - @tomkeller02

LinkedIn: Tom Keller

Contact: http://tomkellerconsulting.com

Tom Keller is an independent SQL and .Net consultant in the Sacramento area. He has worked with Microsoft SQL Server as an administrator, integrator and developer since 1995. He is a member of the PASS Sacramento Chapter (Sacramento SQL Server User Group), and holds a Bachelor of Electrical Engineering.

Mitchell Bottel

Twitter: - @SacSQLDude

Contact: http://www.mitchespitch.com

Michael Fal

Twitter: - @Mike_Fal

LinkedIn: Michael Fal

Contact: http://mikefal.net

Andy Galbraith

Twitter: - https://twitter.com/DBA_ANDY

LinkedIn: Andy Galbraith

Contact: http://nebraskasql.blogspot.com/

I’m a forty-something Microsoft SQL Server DBA of 18+ years, a devoted husband, and a father of three young boys (all aged eight and under!) I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.

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.

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

Ted Stathakis is a data professional passionate about the presentation layer. He has worked with SQL Server since the turn of the century, has mastered Reporting Services since he began working with it when it was released in 2004, and is super excited about Mobile Reports and Power BI. Ted hosts the local PASS user group, is the organizer of SQLSaturday Orange County and presented on SSRS at Summit in 2019. As a 40+ year veteran of the restaurant industry, he is been an advisor, speaker and panelist at national trade shows. When he isn’t consulting on Business Intelligence projects he can be found presenting at a conference, enjoying some live music or teaching kids, both young and old, fishing and archery at a nearby Scout camp.

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a freelance consultant, senior SQL instructor at O’Reilly Media, as an author for PluralSight and LinkedIn Learning.

Andy Galbraith

Twitter: - https://twitter.com/DBA_ANDY

LinkedIn: Andy Galbraith

Contact: http://nebraskasql.blogspot.com/

SQLSAT399 Sponsor

Proud sponsor of SQLSaturday 399 in Sacramento on July 25, 2015.

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

John McAllister

Twitter: - @jmcallis64

LinkedIn: John McAllister

Contact: http://www.profisee.com

John McAllister co-founded Stratature, an Independent MDM software vendor, in 2001. Following Microsoft’s acquisition of Stratature in 2007 John served as Group Program Manager for MDS and oversaw the incorporation of MDM into SQL Server. John now serves as the Regional Sales Director for Profisee, Inc. which provides enterprise-class MDM Solutions built on top of Microsoft’s MDS offering. John has worked with 100’s of organizations around the world in all phases of MDM projects.

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

SQLSAT399 Sponsor

Proud sponsor of SQLSaturday 399 in Sacramento on July 25, 2015.

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.

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.

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.

SQLSAT399 Sponsor

Proud sponsor of SQLSaturday 399 in Sacramento on July 25, 2015.

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.

Mitchell Bottel

Twitter: - @SacSQLDude

Contact: http://www.mitchespitch.com

Andy Galbraith

Twitter: - https://twitter.com/DBA_ANDY

LinkedIn: Andy Galbraith

Contact: http://nebraskasql.blogspot.com/

Jonathan Shaulis

Robert Davis

Twitter: - @SQLSoldier

LinkedIn: Robert Davis

Contact: http://www.sqlsoldier.com

SQLSAT399 Sponsor

Proud sponsor of SQLSaturday 399 in Sacramento on July 25, 2015.

Keith Tate

Twitter: - https://twitter.com/keith_tate

LinkedIn: Keith Tate

Contact: http://thesqlchef.com

Keith Tate is a Senior Database Administrator with over 17 years of experience as a data professional. During Keith#39;s professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.

SQLSAT399 Sponsor

Proud sponsor of SQLSaturday 399 in Sacramento on July 25, 2015.

Paul Turley

Twitter: - paul_turley

LinkedIn: Paul Turley

Contact: http://www.sqlserverbiblog.com