SQLSaturday #885 - Sacramento 2019

Event Date: 08/17/2019 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: One key to rule them all - how to effectively destroy data consistency, and ruin query performance

Abstract: Every beginner knows that every table has an identity primary key, supported by a clustered index. If I told you that these keys that you take for granted, are the primary factor that destroy your database’s consistency, performance, scalability, and modularity, you’d probably think I’m crazy. But what if I can prove it, scientifically, and beyond any reasonable doubt? “It ain’t what you don’t know that gets you into trouble. It’s what you know that just ain’t so…” Join me on this fascinating journey down the rabbit hole, where we will shed new light on some of the most fundamental aspects of database design. You will experience hands-on how you can drastically improve your database consistency, simplify your queries, improve performance by orders of magnitude, allow for unprecedented scalability, and modularity. Prepare for a paradigm shift. By the end of this session, you will chant with me: “The key, the whole key, and nothing but the key, so help me Codd”.

Speaker(s):

Ami Levin

Track and Room: Application Database Development - 3. San Joaquin

Title: SQL DevOps Simplified with Production Databases

Abstract: DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. “Near production data” is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than “built” databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.

Speaker(s):

Paul Stanton

Track and Room: Cloud Application Development Deployment - 1. Snowflake (Placer)

Title: Making Sense of the Power BI Ecosystem

Abstract: Power BI adoption growth has been astonishing. And with growing demand we also have growing needs. The service started as an end user driven data visualization tool, but is now heading to an enterprise grade semantic layer. In this session, we will go through, and dive into, the Power BI pieces and service parts. We’ll make sense of them together and when to apply and deploy each one.

Speaker(s):

Armando Lacerda

Track and Room: BI Platform Architecture, Development Administration - 5. San Mateo

Title: Big Data, Big Dupe: A little session about a big bunch of nonsense.

Abstract: If data is the new oil, then Big Data is the new snake oil. For over a decade, Big Data has managed to delude far too many smart, honest, hard-working data practitioners, with nothing but the best intentions. This session is a plea for your common sense and decency. Together, we will use history, facts, authority, and logic to expose it for what it really is. Layer by layer, we will peel off the Confusion, Illusion, Deception, Distraction and the Regression that is “Big Data”. You will realize just how much progress and value Big Data has bestowed on us over the past decade. But more importantly, we will see what we can and must do to make data practice, and consequently the world, a better place. Brace yourself for a thought-provoking session, filled with “Aha” moments. I promise that after this session, you will never look at big data the same way as you did before you stepped into the room.

Speaker(s):

Ami Levin

Track and Room: Strategy and Architecture - 1. Snowflake (Placer)

Title: Azure Lift and Shift Best Practices

Abstract: Going to the Cloud can be a very scary proposition for most companies, but a lot of your fears can be mitigated as long as you prepare for the experience. Come learn with me and learn from my experiences as we cover the preparatory steps that can be taken to improve the initial experience. After that, we will be listing out the general tasks that need to be setup in order to maintain an expected level of performance. Next, we will be working on how to improve performance on an existing hybrid VM running SQL Server. Finally, we will discuss some of settings and roles that you will want to have in the Azure Portal to allow you to monitor your well-performing Azure instance. Bring your questions!

Note, this session will exclusively deal with issues on a hybrid VM running SQL Server in Azure. We may cover general issues that affect SQL Azure instances such as storage issues.

Speaker(s):

Michael Wall

Track and Room: Strategy and Architecture - 2. SentryOne (SF)

Title: Monitor Power BI

Abstract: Monitoring Power BI means having knowledge of all the content currently hosted in your Power BI tenant. What datasets and reports have been published? What users have access to these resources? How often are they looking at these reports? How have data refreshes been performing?

By monitoring, you will truly understand what makes you an Administrator of Power BI. You’ll see the different screens it takes to monitor everything in your tenant. Plus, you’ll discover if there’s a better way to monitor your tenant through collecting API data and analyzing it to derive some actionable insights for improved data governance in your companies.

BI expert Angel Abundez will demo the Power BI administrative screens you use today to monitor your tenant. Then he’ll do some PowerShell development in VS Code to collect API data and see if it’s possible to use that data in Power BI for added insights.

Speaker(s):

Angel Abundez

Track and Room: BI Platform Architecture, Development Administration - 2. SentryOne (SF)

Abstract: Is there a gap between your advanced technical skills and your social-emotional intelligence? Are you or your employees experiencing challenges communicating effectively with others, participating as part of a team, managing emotional reactions, or socially connecting at work? Is this impacting your ability to get promoted, retain employees, or establish positive workplace morale or relationships? Do you want to increase your “likeability” factor for your professional growth and overall well-being?

If you answered yes to any of these questions, then this session is for you! For many people, “social” does not come naturally and has to be explicitly taught. In this presentation, you will learn about the mindset that is required for developing new competencies, key cognitive skills needed for social success, and tools and strategies that you can use immediately with your team. This session is for people who have difficulty navigating the social world, as well as for their managers.

Speaker(s):

Linda Groszyk

Track and Room: Professional Development - 5. San Mateo

Title: What to Do When SQL Server is Unusually Slow

Abstract: “Is something going on with the SQL Server right now?” You hear those words, and your heart starts to race a little faster. You try to connect to the SQL Server, and it responds, but you can tell it’s a little slow. You open up Activity Monitor, look at recent expensive queries, and maybe open up the Windows event logs to see if anything’s happened recently.

There’s gotta be a better way, right?

Good news – there is, and you’re about to learn how the pros do it. In one all-demo session, you’ll watch Brent Ozar use sp_WhoIsActive, sp_BlitzFirst, and sp_BlitzCache to solve several common emergencies. You’ll walk away with a written checklist to solve typical performance emergencies.

Speaker(s):

Brent Ozar

Track and Room: Enterprise Database Administration Deployment - 1. Snowflake (Placer)

Title: Automating Power BI Creations

Abstract: Since Power BI was released four years ago, Power BI, Office 365, and Azure have added significant automation capabilities. To stay informed, you need to learn about the most recent capabilities and what they mean to you.

Angel Abundez will present a wide-ranging overview of the data refresh setups common to Power BI data sources, going from DIY to more advanced scenarios that need IT support. Whether you’re automating reports for your department or for the enterprise, there’s something here for you.

You’ll learn how to:

Set up your datasets in Excel and Power BI to be automated
Refresh data from files hosted on SharePoint, One Drive, and REST APIs (CSV, Excel, JSON, etc)
Pull data from on-premises and cloud data sources using the latest capabilities of Power Apps, the Power BI Service, and Azure
Automate your Power BI analysis in PowerBI.com, One Drive, or even your O365 mailbox
Work with cloud databases such as Amazon Redshift, Azure SQL DB, and Snowflake

Speaker(s):

Angel Abundez

Track and Room: BI Platform Architecture, Development Administration - 4. Alameda

Title: Reporting Services: A Smart Migration Strategy

Abstract: With Power BI Report Server, you can host traditional paginated reports alongside Power BI analytical reports, KPIs and mobile reports. This session will show how to use the data in the ReportServer database to determine a smart migration strategy for upgrading to a new SSRS or Power BI Report Server. Starting with the new features of Report Manager, Mobile reports, KPIs and the Mobile Report Publisher app. The session will then focus on how to utilize the report meta data in the ReportServer database, combined with the transaction log table, to show how to determine which reports, data sets and data sources are being used and determine what objects to migrate. Learn how to use PowerShell to extract the reports and data sets from the database, instead of downloading them, to facilitate an easy migration to a new implementation. Also discover a way of determining all TSQL used by the reports. This session is particularly useful for migrating from 2008 but applicable to any migration.

Speaker(s):

Ted Stathakis

Track and Room: BI Platform Architecture, Development Administration - 1. Snowflake (Placer)

Title: How to Query the Tabular Data Model using DAX

Abstract: Have you implemented Power BI in your work to build powerful dashboards and want to encapsulate complex business logic? Do you struggle writing MDX queries in the multidimensional model? If your answer is yes, then join me in this DAX presentation to see how to create measures that make use of the DAX language. I will go over the DAX (Data Expression Language), powerful functions such as SUMMARIZECOLUMNS(), HASONFILTER(), CALCULATE(), USERELATIONSHIP(), RELATED(), FILTER(), ALL() and many more. I will go over the use of variables to make your DAX expression self-documenting and create additional columns in the dimension Date table that slicers or parameters can use to detect the years/months with actual data in Fact Tables.

Speaker(s):

Christian Chanco

Track and Room: Analytics and Visualization - 4. Alameda

Title: Database Corruption! Preventing Disaster to your Database.

Abstract: Every DBA should know about database corruption because it can be a resume generating event. A corrupt database can ruin your day, affect system stability, lead to unnecessary downtime, and possibly data loss.

In this presentation we will explore database corruption, learn how to diagnose, and see what we can do to fix it. We will discuss the causes, dispel some myths, and learn what questions to ask. After this, we dive into discovering the root cause and putting a plan in place to stop it in the future. Demos will illustrate diagnosing, troubleshooting, and fixing database corruption. Prepare to break a database and go through the steps to return it back to a usable state.

Beginners will benefit along with others who may one day find themselves with a corrupt database. By the end of the session, you will have the tools and understanding necessary to take corrective action and prevent your databases from corruption!

Speaker(s):

Jeff Mlakar

Track and Room: Enterprise Database Administration Deployment - 2. SentryOne (SF)

Title: Environmental SQL Server Troubleshooting

Abstract: When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!

Speaker(s):

Jeff Mlakar

Track and Room: Enterprise Database Administration Deployment - 4. Alameda

Title: Environment Setup using automation tools like Docker, Powershell and Chocolatey

Abstract: Environment setup in some organizations can take days and even then it is not consistent and has components missing or configured incorrectly. These problems can be solved and this session will cover several techniques for doing just that. In this session we will use Docker to create 3 SQL environments. The first is a production like environment for UAT. In the second environment will redact the confidential data and in the third environment reduce the dataset by 90%.

This three tiered environment setup can work with or without Docker. In this session we will also cover using Chocolatey NuGet’s, which sounds tasty, but it is also a very powerful method of installing software on Windows.

Speaker(s):

Adam Anderson

Track and Room: Application Database Development - 3. San Joaquin

Title: SentryOne: Beyond Monitoring with SentryOne (Alec Pickup)

Abstract: SentryOne – Beyond Monitoring

Hopefully you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I’ll show you how SentryOne provides environment-wide visibility and aids in managing cross-server activities. I’ll showcase how alerting can be tuned to be effective and not noise. And you’ll discover how SentryOne can give you both operational and business value to address your application challenges.

Alec Pickup

Speaker(s):

SQLSatSac Sponsor

Track and Room: Other - 2. SentryOne (SF)

Title: CosmosDB - Understanding the main factors for successful deployment

Abstract: Let’s face it: Microsoft Data Platform is not just SQL Server anymore. Azure has added a dozen of other data related products to the menu. Being a cloud DBA means dealing with these new options when needed. In this session packed with demos you will see how to cross the bridge between SQL Server and Cosmos DB back and forth; how to related items from both sides and what is required to design a CosmosDB deployment.

Speaker(s):

Armando Lacerda

Track and Room: Application Database Development - 3. San Joaquin

Title: Cosmos DB was the missing piece to my Data puzzle!

Abstract: Cosmos DB is one of the fastest growing Azure Services, we all have questions about this new database system. In this session, I am going to answer some of the common questions about Azure Cosmos DB by using SQL API. Join me to see Cosmos DB in action with many demos! Don’t miss it.

Speaker(s):

Hasan Savran

Track and Room: Cloud Application Development Deployment - 3. San Joaquin

Title: Moving Databases to the cloud

Abstract: Your company is moving to the cloud? Are you ready? No matter if it is Azure, AWS, or Oracle you will have many options and services to chose from, and In this session we will discuss lessons learned and roadblocks you will face moving your databases to the cloud.

Speaker(s):

Eric Courville

Track and Room: Cloud Application Development Deployment - 3. San Joaquin

Title: PoSh on SSRS - Essential Skills to manage your RS with PowerShell

Abstract: Learn how powerful the new PowerShell tools for SSRS are and how they can help you administer your reporting environment! This presentation will give a brief overview of the new tools that are being actively supported by Microsoft and then show many many ways to use them in your daily life. Come away with scripts to help you implement the tools in any environment!

Speaker(s):

Michael Wall

Track and Room: Enterprise Database Administration Deployment - 2. SentryOne (SF)

Title: A dive into Dimensional Modeling

Abstract: A dive into the basics and some advanced dimensional modeling concepts and design patterns. Topics covered will be introduction to dimensional modeling and difference from transaction vs analytics consumptions, primary and foreign keys, different types of facts and dimensions, slowly changing dimensions and various types, common design patterns for handling date, time, product, inventory etc.

Speaker(s):

Soumya Banerjee

Track and Room: BI Platform Architecture, Development Administration - 3. San Joaquin

Title: Database Testing

Abstract: Database testing takes many forms ranging from server setup validation to stored procedure functionality testing and many areas in between. In this session we will cover how to get started when you have existing systems or are designing a new system from the ground up. This is a demo heavy session that all ability levels can get something from.

Speaker(s):

Adam Anderson

Track and Room: Application Database Development - 5. San Mateo

Title: Tips, Tricks and Secrets for the SQL Professional

Abstract: Ever heard the term, “work smarter, not harder”. A mantra to live by in my book. Over the years, I have seen, forgotten, seen again and forgotten again all of the shortcuts, tips and tricks we all take for granted. SO like a good DBA, I started to document and share all of these commands and shortcuts to share. Come see and learn many of the everyday shortcuts in SQL Server Management Studio (SSMS) that will help make your life easier on a daily basis.

Speaker(s):

Mitchell Bottel

Track and Room: Enterprise Database Administration Deployment - 1. Snowflake (Placer)

Title: Lightning Talks 1: Dan Hess, Dilip Nayak, Saru Radhakrishnan

Abstract: Dan Hess: SSRS Reports in SSMS Dilip Nayak: Use Cases for Availability Groups Saru Radhakrishnan: Set Operations Using Inline Table-Valued Functions

Speaker(s):

Dan Hess

Track and Room: Other - 4. Alameda

Title: Improving the Performance of Functions

Abstract: Functions are stored blocks of code that can be reused in order to create simpler, more stable, and cleaner code. Functions can be great to have; however, they can also become a royal pain. Scalar and table valued functions can cause serious performance issues and the root cause may not be easy to find. In this session we will go over: (1) How to identify if a function is causing poor performance (with examples); (2) Methods that can be used to modify the function to greatly improve performance; (3) Improvements that come with SQL Server 2019 that may make you want to upgrade sooner rather than later.

Speaker(s):

Eric Freeman

Track and Room: Application Database Development - 2. SentryOne (SF)

Title: How to use GeoSpatial Data in SQL Server

Abstract: If you would like to learn about Spatial Data but don’t know where to start, this session is for you. We will begin by focusing on what Spatial Data is through examples and interactive demo’s. The goal is to show how Spatial Data can improve your professional experience and serve as an asset to your business.

I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.

Speaker(s):

Hasan Savran

Track and Room: Analytics and Visualization - 5. San Mateo

Title: Possibilities Limitations of System-Versioned Temporal Tables

Abstract: This technical presentation shows how to manipulate data with versioning switched off, what to consider when building queries referencing multiple temporal tables and building views.

Speaker(s):

Reinhard Flügel

Track and Room: Application Database Development - 5. San Mateo

Title: Snowflake: The Future of Data Warehousing (Zach Oxman Gabe Mullen)

Abstract: Snowflake: The Future of Data Warehousing - Snowflake Cloud Data Warehouse Architecture Review Demo with Zach Oxman Gabe Mullen (Event Sponsor).

Speaker(s):

SQLSatSac Sponsor

Track and Room: Other - 1. Snowflake (Placer)

Title: SQL Query 101

Abstract: A beginner level session to cover table creation and various usage of data types. Query techniques to cover single and multiple tables covering inner, left, right, and outer joins. Usage of functions like Max, Min, Sum, and Having in queries. We will wrap up the session with some items to beware of.

Speaker(s):

Robert Muir

Track and Room: Application Database Development - 2. SentryOne (SF)

Title: Data Encryption for DBAs

Abstract: It seems more lately than not, there are daily stories of a data breach somewhere. Data security is one of the most critical things a data professional should be aware of. Now, there are several ways of implementing data security in today’s world. SQL Server comes with several native data encryption methods that you can use. In this session, we will explore the basics of data encryption, how to implement some of them, some gotchas as well as some of the newer features of data encryption in newer versions.

Speaker(s):

John Morehouse

Track and Room: Enterprise Database Administration Deployment - 1. Snowflake (Placer)

Title: Data Preparation with Power BI Desktop M – Strategy, Tactics and Tips

Abstract: In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. Mashups of data from corporate, partner, commercial and public sources are the new normal. In this presentation we will review traditional strategies for data cleanup, explore Power BI Desktop features for data exploration and look at Power BI Desktop configuration tips. Building readable, reusable and shareable cleanup scripts in M using the Power Query Advanced Editor will also be covered.

Speaker(s):

Phil Robinson

Track and Room: Analytics and Visualization - 5. San Mateo

Title: Lightning Talks 2: Ted Stathakis, Glenn Burnett, Alex Purice

Abstract: Ted Stathakis: ProperCase - My Favorite UDF Glenn Burnett: Monitoring Failed Queries in SQL Server Alex Purice: SQL Server Replication 101

Speaker(s):

Ted Stathakis

Track and Room: Other - 4. Alameda

Title: Temporal Tables – The New Hotness in Data Auditing

Abstract: A common issue database administrators face is data auditing. Many use triggers, CDC, third-party tools, or roll their own type of auditing tool. In SQL Server 2016, a new feature called Temporal Tables was introduced and helps to simplify this common need. In this session, we will take a look at what temporal tables are, how they work and how you can implement them into your environment.

Speaker(s):

John Morehouse

Track and Room: Application Database Development - 4. Alameda

Speakers

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

Jeff Mlakar

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

LinkedIn: Jeff Mlakar

Contact: http://www.mlakartechtalk.com/

Jeff Mlakar is a database professional specializing in Microsoft SQL Server. He has worked the past 15 years as a database developer and administrator (admini-loper or develo-strator…take your pick), analyst, and with Business Intelligence. A technology enthusiast – he is interested in data security and privacy topics. Jeff lives in the Raleigh-Durham area of NC.

Hasan Savran

Twitter: - Savranweb

LinkedIn: Hasan Savran

Contact: http://h-savran.blogspot.com/

Hasan Savran is a BI Architect at Progressive Insurance Company. He spends his days architecting cutting edge business solutions by using the latest Web and Database technologies. He is a Microsoft Data Platform MVP, Microsoft Certified Solutions Developer. Hasan has spoken at many SQLSaturdays, Code Camps and User groups. He is an active member of the HTML5 and WebAssembly W3C groups. He likes to write about SQL, CosmosDB, C#, and Front End development on his blog.

Michael Wall

Twitter: - michaelDwall1

LinkedIn: Michael Wall

Contact: http://www.becomingamaster.com

Michael Wall has been an IT professional going back to when he had his own software store and worked with his customers with their “dose” problems. Originally hired by a small consulting firm to write web pages, he was thrust into the SysAdmin world when their lead consultant changed the passwords of all of the servers at a major pulp and paper company’s systems to 100%s$%t and walked out the door. He was sent down with a copy of UNIX for Dummies and 50 cents for the bus ride back. Fast forward a few years, he was asked if he wanted to be a DBA after successfully managing a fifty server Y2K upgrade. Since then, he’s never looked back and has survived a number of data and system challenges. When not wrangling cats at home, he currently

Reinhard Flügel

Started as an application developer in the early 90’s using C++, Access and SQL-Server. Since around 2010 focusing on Database Development mainly SQL-Server. Holding several Microsoft certifications such as: MCSE Data Platform, Business Intelligence and Data Management and Analytics (Charter).

Paul Stanton

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

LinkedIn: Paul Stanton

Contact: https://www.windocks.com/blog-2

Co-founder of Windocks, Paul is a former Microsoft engineer who is focused on delivering solutions for SQL Server development and test, including SQL Server containers and database cloning.

SQLSatSac Sponsor

SQLSatSac Sponsor

Linda Groszyk

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

LinkedIn: Linda Groszyk

Linda Groszyk, M.S., CCC-SLP is a nationally certified Speech-Language Pathologist who specializes in social communication, emotional regulation, and accent modification. Developing her expertise over the past 19 years, Linda provides individualized coaching services for people to achieve their professional and social goals through increased self-awareness, confidence, and communication competencies. Linda is also a certified PESL (Pronouncing English as a Second Language) Instructor. She graduated from Boston College with a BA in Human Development and earned her masters in Communication Disorders at Pennsylvania State University. Linda currently resides in San Francisco and serves a global clientele. Find out more at prosocialcoach.com.

Mitchell Bottel

Twitter: - SACSQLDude

LinkedIn: Mitchell Bottel

Mitchell Bottel is a Senior Database Administrator and Operations Team Lead with Sutter Health, owner of Innovative IT Consulting and President of the Sacramento SQL Server User Group. He has 19 years of IT experience, focusing on SQL Server for the last 16 years with an emphasis on database administration and high availability solutions.

Brent Ozar

Twitter: - BrentO

LinkedIn: Brent Ozar

Contact: https://www.BrentOzar.com

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.

Soumya Banerjee

Advanced Analytics architect working in data, analytics and cloud space for last 15 years, consulting for many and diverse clients in multiple geographies. Skills include everything related to data - data engineering, cleansing, profiling, governance, modeling, data warehouse, data science and visualization. Implemented multiple end to end data warehousing projects on diverse platforms like SQL Server, Oracle, Teradata, Netezza, Azure DW etc. Strong experience with entire Azure data stack(Data Lake, Blob, Data Bricks, DW, Data Factory, Data Flow, AAS etc.) and many ETL products like Ab Initio, Informatica, DataStage, Talend etc.

Jeff Mlakar

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

LinkedIn: Jeff Mlakar

Contact: http://www.mlakartechtalk.com/

Adam Anderson

Twitter: - sqlpioneer

LinkedIn: Adam Anderson

Contact: https://sqlpioneer.wordpress.com/

Adam Anderson is a Microsoft Certified Solutions Associate in Database Development, and an ICAgile Certified Agile and DevOps professional with over 2 decades of experience in IT processes. Currently, he works at American AgCredit in Santa Rosa California on their software integrations team.

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.

SQLSatSac Sponsor

SQLSatSac Sponsor

Hasan Savran

Twitter: - Savranweb

LinkedIn: Hasan Savran

Contact: http://h-savran.blogspot.com/

Michael Wall

Twitter: - michaelDwall1

LinkedIn: Michael Wall

Contact: http://www.becomingamaster.com

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.

Adam Anderson

Twitter: - sqlpioneer

LinkedIn: Adam Anderson

Contact: https://sqlpioneer.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.

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.

Armando Lacerda

Twitter: - arlacerda

LinkedIn: Armando Lacerda

Over 30 years in the computing field as a developer and system integrator; over 20 years working with SQL Server since version 6; cross platform experience with Oracle and IBM SQL/DS and DB2; Microsoft Certified Trainer for over 20 years.

Ami Levin

Twitter: - ami_levin

LinkedIn: Ami Levin

Contact: http://www.amilevin.com

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

Armando Lacerda

Twitter: - arlacerda

LinkedIn: Armando Lacerda

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.

Ted Stathakis

Twitter: - fishheadted

LinkedIn: Ted Stathakis

Contact: http://fishheadted.com

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.

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.

Angel Abundez

Twitter: - AngelStreamline

LinkedIn: Angel Abundez

Contact: http://angelstreamline.com

Robert Muir

Robert works as a Database Developer with the San Joaquin County Office of Education. Optimizing queries and procedures is his focus now. He has been developing software applications with .NET and other languages for over 20 years.

Christian Chanco

LinkedIn: Christian Chanco

Christian Chanco is a Business Intelligence Developer at Dignity Health Medical Foundation (now part of Common Spirit Health) and promotes the use of Microsoft business intelligence products to find robust business solutions. Lately, he replaced manually ETL processes and reports and automated them with Power BI and DAX for Dignity Health Medical groups in the California Market.

SQLSaturday #885 - Sacramento 2019

Sessions

Title: One key to rule them all - how to effectively destroy data consistency, and ruin query performance

Title: SQL DevOps Simplified with Production Databases

Title: Making Sense of the Power BI Ecosystem

Title: Big Data, Big Dupe: A little session about a big bunch of nonsense.

Title: Azure Lift and Shift Best Practices

Title: Monitor Power BI

Title: Breaking the Social Code: How to be Socially Intelligent at Work

Title: What to Do When SQL Server is Unusually Slow

Title: Automating Power BI Creations

Title: Reporting Services: A Smart Migration Strategy

Title: How to Query the Tabular Data Model using DAX

Title: Database Corruption! Preventing Disaster to your Database.

Title: Environmental SQL Server Troubleshooting

Title: Environment Setup using automation tools like Docker, Powershell and Chocolatey

Title: SentryOne: Beyond Monitoring with SentryOne (Alec Pickup)

Title: CosmosDB - Understanding the main factors for successful deployment

Title: Cosmos DB was the missing piece to my Data puzzle!

Title: Moving Databases to the cloud

Title: PoSh on SSRS - Essential Skills to manage your RS with PowerShell

Title: A dive into Dimensional Modeling

Title: Database Testing

Title: Tips, Tricks and Secrets for the SQL Professional

Title: Lightning Talks 1: Dan Hess, Dilip Nayak, Saru Radhakrishnan

Title: Improving the Performance of Functions

Title: How to use GeoSpatial Data in SQL Server

Title: Possibilities Limitations of System-Versioned Temporal Tables

Title: Snowflake: The Future of Data Warehousing (Zach Oxman Gabe Mullen)

Title: SQL Query 101

Title: Data Encryption for DBAs

Title: Data Preparation with Power BI Desktop M – Strategy, Tactics and Tips

Title: Lightning Talks 2: Ted Stathakis, Glenn Burnett, Alex Purice

Title: Temporal Tables – The New Hotness in Data Auditing

Speakers

Sponsors