SQLSaturday #997 - Salt Lake City – Virtual 2020
Event Date: 08/29/2020 00:00:00
Event Location:
- Karen G Miller Conference Center
- 9750 S 300 W Sandy, UT
- Salt Lake City, Utah
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: Database DevOps with Containers
Abstract: Unlike CI/CD pipelines for applications, we can’t just delete the database and pop up a new one with each new version. Let’s start with the production database, and get SQL Server content to developers in containers, and then flow schema and lookup data back into production with migration tools. You can bring the reliability and automation of CI/CD pipelines to Database DevOps with containers.
Speaker(s):
- Rob Richardson
Track and Room: Cloud Application Development Deployment - Room 1
Title: Tracking Logins with an Extended-Events-Driven Data Warehouse
Abstract: Using Extended Events, Powershell, TSQL, MDX, DAX and Excel we will build a SSAS MD and Tabular Cube that allows you to track SQL Server Logins that can be sliced and diced per Hour, Server, User, Host, Connection String and Database.
This session touches on multiple advanced topics that you can use individually, but together, make for a powerful SQL Security Auditing Tool not found anywhere else.
Speaker(s):
- George Walkey
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Query Store for SQL Server 2019 from zero to an hero lessons learned from the fields .
Abstract: Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Query Store helps to identify queries that aren’t performing well, or that have regressed in their performance. Query Store provides detailed information and wait stats that you need to resolve root causes, and it allows you to force the use of a known good execution plan. With SQL Server 2017 and later you can automate the correction of regressions in performance.
You’ll Learn • Best practices in implementing Query Store on production servers • Detect and correct regressions in query performance • Lower the risk of performance degradation following an upgrade • Use tools and techniques to get the most from Query Store • Automate regression correction and other uses of Query Store. This is a demo session only with minimum theory lessons from the fields !
Speaker(s):
- Itshak David
Track and Room: Application Database Development - Room 1
Title: AWS vs. Azure: What’s The Difference For A DBA?
Abstract: Everyone has strong opinions and reactions to which cloud database platform companies should be using but how different are they, really? What features does one cloud provider support that the other might not? How will normal DBA activities, such as backups and restores, change depending on the cloud provider your company uses? Join me in this session as I share my migration stories and discuss the results of my research about how AWS and Azure are different and how many of my daily tasks and tools changed as our company migrated to AWS. Come and listen as I share what I have learned on this journey from on-premises to the cloud. Join me and find out which platform I would use.
Speaker(s):
- Corey Hambrick
Track and Room: Enterprise Database Administration Deployment - Room 4
Title: Climbing the SQL Server B-Tree
Abstract: You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially when it comes to indexes. Some of the things you have probably heard are:
• keep clustered index width small • unique indexes perform better • keep non-clustered index width small • compressed indexes have fewer logical reads • add one index for each column
But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice.
Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.
Speaker(s):
- Mike Byrd
Track and Room: Application Database Development - Room 4
Title: Code Smells - How to Keep Your Code From Stinking!
Abstract: Maybe you’ve had some experience writing SQL, but no one’s ever told you what not to do. Or maybe you’re aware of some bad habits to avoid when writing SQL, but no one has ever shown you why a bad practice can hurt your query – or SQL Server. Perhaps you feel a little more confident with your TSQL, but don’t understand why your queries aren’t running as quickly as you would like.
Bad SQL coding practices are known in the SQL community as “code smells”. Sign up for this hour-long workshop where you will work with me through five common coding mistakes that can make performance stink. By the time we’re done, you’ll have a better idea of how to freshen up some problem queries.
Speaker(s):
- Pamela Mooney
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: The Countless Benefits of Mentoring
Abstract: Mentoring offers countless benefits to the mentee, mentor and the organization as a whole. In this session, we will map out the benefits to each participant as well as talk about how to find a mentor or how to start a mentorship program in your organization.
Speaker(s):
- Mark Runyon
Track and Room: Professional Development - Room 1
Title: Azure Synapse back to back
Abstract: Azure Synapse provides a complete platform to ingest and process data at scale in the cloud. In this workshop we will be learning and applying its features to all stages of data processing and understanding some best practices and pitfalls. From ingesting to data lakes to transform data in big data services to apply machine learning models, including data remodeling, this workshop will guide to through a full implementation of Azure Synapse all the way to presentation and reporting.
Speaker(s):
- Armando Lacerda
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: A Tour of Azure DevOps
Abstract: The popularity and push for adopting DevOps as a way of developing software continues to grow. Do you wonder how to get started and what tools are out there? TFS and Azure DevOps are the way that more and more Microsoft developers look to try and automate parts of their software development process. Join this session for a look at how the capabilities of Azure DevOps/TFS are integrated together to help you track your code and automate the process of getting it to your production environment.
Speaker(s):
- Steve Jones
Track and Room: Application Database Development - Room 2
Title: Notebooks 101 for SQL People
Abstract: Are you a database developer, a DBA or a data analyst? Do you find spending quite a bit of time trying to reproduce analysis or reproduce issues and the troubleshooting techniques? This Notebooks 101 session is for you!
The lack of rigor in being able to reproduce analysis in business context or to reproduce data troubleshooting can lead to confusion and time wasted on work that had been previously done. With Notebooks, Data Professionals can share their techniques and data sources used for the data analysis or troubleshooting for code review and reproducible insights/troubleshooting.
Azure Data Studio Notebooks support SQL and KQL natively with intellisense; with easy to use charting capabilities. With Notebooks and Jupyter Book (collection of Notebooks) in Azure Data Studio, it’s also easy now for your team to build an onboarding guide (user manual) / documentation on data sources, useful sample scripts and tutorials.
Speaker(s):
- Julie Koesmarno
Track and Room: Enterprise Database Administration Deployment - Room 1
Title: SQL Server Configuration with dbatools and dbachecks
Abstract: Automating the configuration of SQL Server instances and being able to check the configuration for standard configuration is an important role for any DBA when you have lots of instances. But how can we automate the configuration easily? How can we check to make sure the proper configuration is in place and hasn’t changed?
In this session, we will look at how to configure your SQL Server Instances using PowerShell and the dbatools module. Then we will look at how to use dbachecks to confirm the configuration of our instances and how to check for changes in the future of the configuration.
Attendees will see how easy it is to use PowerShell via dbatools to configure their SQL Server instances. Attendees will see how easy it is to use PowerShell via dbachecks and PowerBI to see if their servers are configured properly. Attendees will be given a set of scripts that take back to use to configure and test the configuration of their SQL Server instances.
Speaker(s):
- Tracy Boggiano
Track and Room: Enterprise Database Administration Deployment - Room 1
Title: Basic Data Modeling for BI Reporting
Abstract: We all start using business intelligence tools by using a single dataset, like a flat file. Then, we hit a plateau in our learning curve, or we add a second flat file into our BI product, and we get incorrect results. One reason is that we haven’t modeled our solution correctly.
In order to move to the next level of our journey along the BI learning curve, we need to understand how a tool like Power BI works. Only then will we understand why we design our data models the way we do.
In this session, we will review how tools like Power BI work under the covers and how that impacts the way we construct our data models. This is an introductory level course, so we will not get too technical, just enough to get us to the next level and moving back up that learning curve!
Speaker(s):
- Michael McKinley
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: Intro to Power BI
Abstract: For anyone new to Power BI, we’ll cover all the main features and walk through getting data into the tool (using both the desktop and online versions), creating visualizations, turning them into reports and adding them to dashboards. When we’re through we’ll have several BI components available to share via the Cloud!
Speaker(s):
- David Patrick
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: SSAS 101
Abstract: Basic walk-through of creating a tabluar cube, deploying the cube and querying the data using Power BI.
Speaker(s):
- Matt Horton
Track and Room: BI Platform Architecture, Development Administration - Room 4
Title: How to Troubleshoot a Slow Running Query in SQL Server
Abstract: You always wanted to troubleshoot a slow running query. But you just don’t know where to begin. In this demo-heavy session, I will show you how to troubleshoot a slow running query. You will see an end-to-end query tuning example with a slow running workload. We will capture important metrics while the workload is running and then use the captured data to troubleshoot query performance issues. The technique you will learn can be applied to production straight away. This will be a 100% demo session.
Speaker(s):
- Amit R S Bansal
Track and Room: Enterprise Database Administration Deployment - Room 1
Title: Data Warehousing Top 10 Tips
Abstract: During a recent SQL Server User Group meeting the question came up, “How do I get my data team to create a data warehouse that is more than just another database with DW in the name?” During this session we will discuss 10 tips to successfully create a data warehouse with an emphasis on having a data warehouse that will be consumed by your organization.
Speaker(s):
- Scott Cameron
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: It’s Not Your Fault, It’s the SQL Server Default
Abstract: When you see those little green checkmarks, then you know your new SQL Server instance is ready to go, right? Not exactly. Your fresh installation has some questionable default settings that could cause headaches and heartburn in the future. In this session, we identify several instance and database defaults that could lead to disaster, and discuss how you can modify them to improve performance and avoid unnecessary problems.
Speaker(s):
- Jeff Iannucci
Track and Room: Enterprise Database Administration Deployment - Room 4
Title: Azure Data Studio – Way Cool for Azure and On-Prem SQL
Abstract: Azure Data Studio (ADS) cross-platform database development tool which runs on Windows, Linux, and MacOS. ‘ADS’ supports SQL Server and Postgres (with more DB platforms soon) and works both on-prem and in the cloud. ADS is highly extensible, open source, and can dramatically change the way you approach SQL coding.
In this session, we will cover ‘ADS’ features and capabilities such as
- Connections
- Code Snippets
- Notebooks
- Extensions And demonstrate why Azure Data Studio is in fact Way Cool.
Speaker(s):
- Jim Miller
Track and Room: Application Database Development - Room 4
Title: Intro to PowerShell for the DBAs
Abstract: In this demo-filled session, we will go through everything you need to start using PowerShell to automate your day-to-day tasks as a DBA. We will go through the tools you need such as PowerShell IDE Visual Studio Code. We will be using the Microsoft SqlServer PowerShell module and the very popular and powerful community-driven, DBATools module. We will walk through the process of building a script to do a simple task from start to finish. By the end of the session, you will have the confidence, knowledge and tools to start your journey in automating your day-to-day tasks using PowerShell.
Speaker(s):
- Harry Chandra
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: Building a Strong Foundation for Data Analysis
Abstract: We are living in a world full of data but what we need is information. What is required to transform data into information? What are the foundational activities your organization needs to do in order to produce analytics that you are confident in sharing? In this session we will discuss what is needed for your organization to convert data into information, the basics of: Data Governance, Data Modeling and how to have an immediate impact using tools like Power BI to deliver value; and, Data Visualizations and telling stories with the data.
Speaker(s):
- Leslie Andrews
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: A Deep Dive into Execution Plans How to Use Them!
Abstract: The SQL Server Query Optimizer creates an execution plan for every statement running in the database. Since SQL is a declarative language, we describe what data we want to see, then the SQL Server Optimizer figures out a plan to retrieve that data efficiently. However, sometimes the Optimizer chooses a bad query plan which not only makes the query run slow, but eats up resources so other processing can’t get done.
This presentation will show how to read and fine tune the query plan for better performance. We’ll quickly go over the different types of execution plans and when to use them. We’ll examine the different operators, their statistics and costs, then determine which steps to focus on tuning. Finally, several trouble shooting techniques will be shown so you can increase your tuning skills.
Speaker(s):
- Janis Griffin
Track and Room: Application Database Development - Room 4
Title: Power BI: Advanced development techniques
Abstract: Power BI usage and report development is quite simple to get started. You can produce fantastic reports in a relatively short amount of time.
How about extending the available functionality? How to achieve consistent look and feel? These are important topics, as we get deeper into creating more than couple of views and PBIX files.
In this session, I will show you how you can use database queries, custom theme files, custom visuals, parameters and other techniques to make your development efforts easier and keep your users happier.
Speaker(s):
- Sunil Kadimdiwan
Track and Room: BI Platform Architecture, Development Administration - Room 3
Title: Remember Back When? Temporal Tables in SQL Server 2016 and 2017
Abstract: SQL Server 2016 and later come with their own version of a Wayback Machine: temporal tables. With this new feature, it is easy to store and query the history of changes to data. We will discuss the fundamentals and creating, storing data in, querying from, and maintaining these tables. We will also take a quick look under the hood to see how they work, and we’ll also consider the current limitations that are in place. Find out how temporal tables can benefit your system!
Speaker(s):
- Brian Hansen
Track and Room: Application Database Development - Room 4
Title: Interviewing for a DBA job and how to Wow your new company.
Abstract: We are really really smart but can we show our best side when we interview? I’ll show you how to interview and a few tips and tricks to get over the interview jitters.
Speaker(s):
- Steve Peterson
Track and Room: Professional Development - Room 2
Title: Understanding NULLs in SQL Server
Abstract: SQL Server follows three-valued logic (3VL) (instead of Boolean logic) to evaluate any condition to True or False or Unknown. Unknown value in SQL Server is represented as NULL. NULLs in SQL Server are often misunderstood and causes data inconsistency issues. In this session, we will try to go through different test cases to understand NULLs properly.
Speaker(s):
- Ramesh Satya
Track and Room: Application Database Development - Room 4
Title: Advanced Plan Explorer Usage for Tuning Execution Plans
Abstract: In 2010, SentryOne gave the community a completely free execution plan analysis tool: Plan Explorer, that is widely used today. But many users only utilize basic features and only scratch the surface of its capabilities.
Join me to learn how you can go beyond the basics. This demo-heavy (and marketing free) session will teach you advanced use of Plan Explorer by exploring practical T-SQL anti-patterns.
Speaker(s):
- Andy Yun
Track and Room: Application Database Development - Room 1
Title: Let’s take PowerBI on an adventure
Abstract: For the past few years I have been collecting data on various adventures. This data takes many forms and is disperse. Some comes from my calendar, while other from a Garmin gps device tracking my data points as I traverse the land, the snow, the water. Let’s collect all this data and present it in a way to compare between years and activities. To relive the adventures and plan for more.
Speaker(s):
- TJay Belt
Track and Room: BI Information Delivery - Room 3
Title: How I Cut My Maintenance Window by 80%
Abstract: As DBAs we oversee the safety and security of our databases. Integrity, Backup and ability to restore in a timely fashion are most important responsibilities. In addition to Microsoft’s own Maintenance Plans and Ola Hallengren’s awesome scripts, there are many tweaks available that can be exploited for our success; we will learn about those too. I will share with you my own experiments that I conducted over a period of one month. I will share supporting data, to show how I helped save several hours of downtime for my company. We’ll also some of the best practices to help you cut down the maintenance window and give max up-time for your discerning customer.
Speaker(s):
- Paresh Motiwala
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: “DAX” the way to do it
Abstract: Love it or hate it, you just can’t ignore DAX, the amazing language of Power BI. In this session, I’ll show you it’s true power and how knowing it can even make you completely rethink your data models. No more hundreds of columns and weird aggregations in the database. With the Power of DAX, you can now achieve much more sophisticated and powerful calculations, while keeping it simple at its core. I’ll show you real-world applications of DAX and lots of tips and tricks that you will be able to use quickly and with little effort!
Speaker(s):
- Pedro Reis
Track and Room: Advanced Analysis Techniques - Room 3
Title: Isolation Levels: Improving Performance Through Concurrency
Abstract: Support for multiple simultaneous operations is a key feature of database systems, but there are many ways this can be implemented. This session explores the different isolation levels supported by SQL Server, Azure SQL Database, and Azure SQL Database Managed Instance. It will cover what they are, how they work, the issues they address, and how they differ. We will also investigate In-Memory OLTP and what it offers. Demonstrations will show how isolation level configuration can affect both the performance and result set returned by a query. Additionally, attendees will learn how to choose the optimal isolation level for a given workload, and will see how easy it can be to improve performance by adjusting isolation settings. Proper use of isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address - attend this session and gain Senior DBA-level skills on how to maximize your database’s ability to process transactions concurrently.
Speaker(s):
- Bob Pusateri
Track and Room: Enterprise Database Administration Deployment - Room 2
Title: 14 T-SQL Functions You May Not Know
Abstract: Newer releases of SQL Server have introduced many new functions developers may not know or use. This includes functions for type conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, in addition to some best practices for using these functions.
Speaker(s):
- Sam Nasr
Track and Room: Application Database Development - Room 1
Title: All About Temporary Objects
Abstract: Database development and administration require temporary objects for ETL, staging, data processing, and many other common tasks.
In this session, we will delve into temporary tables, table variables, and memory-optimized table variables, as well as memory-optimized TempDB metadata, discussing their differences, how they work, and the optimal scenarios for using each of them.
Speaker(s):
- Edward Pollack
Track and Room: Application Database Development - Room 2
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Mike Byrd
Twitter: - ByrdNest_TX
LinkedIn: Mike Byrd
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.
Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
Ramesh Satya
Twitter: - satyaramesh230
LinkedIn: Ramesh Satya
will update soonSatya Ramesh has credible experience working with SQL Server. As a Senior Consultant for SQLMaestros (a business unit of eDominer Systems), he has worked on countless projects involving SQL Server Azure SQL Database. He has presented numerous webinars and delivered multiple sessions as part of his community work with DataPlatformGeeks. He was also a speaker at Data Platform Summit 2018 2017 edition. Other than DataPlatformGeeks, his also got selected in New Stars Of Data 2020. Satya frequently records SQL videos for the community and hosts them on SQLMaestros YouTube channel.
Leslie Andrews
Twitter: - landrews5807
LinkedIn: Leslie Andrews
Contact: https://www.lace.technology/blog
Leslie Andrews is an IT professional with almost 20 years of experience working with databases, designing databases, as well as designing and developing applications against those databases. 2018-2019 Idera ACE.
David Patrick
Twitter: - DavidEPatrick
LinkedIn: David Patrick
Contact: http://www.madsharepoint.com
Dave has been developing database applications for over 25 years. An MCT since 2001, he has taught many classes from Intro to Visual Interdev to Advanced SharePoint Development. Dave runs two user groups, the Maryland and Pennsylvania Microsoft Developers User Group, www.mapamdug.com, and MAD SharePoint, www.madsharepoint.com. Dave does SharePoint training and development for DSA, Inc., a DoD contractor that does great work for the Army over at Aberdeen Proving Ground. Dave is also an MVP.
Sam Nasr
Twitter: - SamNasr
LinkedIn: Sam Nasr
Contact: http://samnasr.blogspot.com/
Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. He’s a Sr. Software Engineer with NIS Technologies where he consults and teaches clients about the latest .Net technologies. Sam has achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, MCT), and is the leader of the Cleveland C#/VB.Net User Group since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.
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.
Paresh Motiwala
Twitter: - pareshmotiwala
LinkedIn: Paresh Motiwala
Paresh Motiwala a Azure/Big Data enthusiast, Manager of Database Platform teams has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He has also been a Sr. SQL DBA and a Solutions Architect in Fortune 100 companies. He helps/organizes and speaks at many SQLSaturdays, Azure Bootcamp, Azure Datafests and User Groups(Boston BI UG, NESQL, PASS PD VG and PASS DBA VG).
He is certified in Big Data Analytics, FinTech, PMP, Public Speaking, Business Communications. He is a avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills and mentors children around the globe via www.circlesofgrowth.com
Edward Pollack
Twitter: - EdwardPollack
LinkedIn: Edward Pollack
Contact: https://www.sqlshack.com/author/edward-pollack/
Ed Pollack has over 20 years of experience in database and systems administration, which has developed his passion for performance optimization, database design, and making things go faster. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize SQLSaturday Albany, which has become an annual event for New York’s Capital Region. Sharing these experiences with the community is a top priority, and encouraging everyone to take the leap into public speaking and engaging others, a passion. In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
Steve Peterson
Twitter: - @SQLFitness
I have worked in ASP.NET and C# for a number of years before turning to SQL Server and T-SQL where Steve has been a SQL Server DBA for over 12 years with a focus on up time and performance. MCP MCTS Steve also likes photography.
Rob Richardson
Twitter: - rob_rich
Contact: https://robrich.org/
Rob Richardson is a software craftsman building web properties in ASP.NET and Node, React and Vue. He’s a Microsoft MVP, published author, frequent speaker at conferences, user groups, and community events, and a diligent teacher and student of high quality software development. You can find this and other talks on https://robrich.org/presentations and follow him on twitter at @rob_rich.
Mark Runyon
Twitter: - https://twitter.com/aspprogrammer
LinkedIn: Mark Runyon
Contact: http://markrunyon.com
Mark Runyon works as a principal consultant for Improving Atlanta. He focuses on systems architecture and development of enterprise web and mobile applications. As a full stack programmer, he primarily works with Microsoft technologies, leveraging the cloud through Azure and AWS. He is a contributing writer at InformationWeek, The Enterprisers Project and Business2Community.
Pamela Mooney
Twitter: - PamelaMooney
Contact: https://thenonclutteredindex.com/
Hi there! My name is Pam Mooney. The road to IT was a long and winding one for me, but I fell in love with SQL Server and knew that I wanted to be a DBA after my first database class in college.I was fortunate enough to be hired in as a Junior DBA straight out of school, and I have never looked back. I’m now a Senior DBA who loves to mentor and teach – as well as to continue to learn. A one-time, part-time professional musician and songwriter, I have a medical background and am a passionate history nerd. In my spare time, I like to hike, bike, read, go to the Ren Faire, write, and talk to you.
George Walkey
Twitter: - sqlbytehd
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Harry Chandra
Twitter: - HarryChandraPDX
Contact: http://www.HarryChandra.com
Harry Chandra is a SQL Server, VMWare and PowerShell enthusiast working with various releases of SQL Server for over 10 years. His main focus is in Administration and High Availability for SQL Server, although he has always strived to expand his knowledge into other area of SQL Server.
Sunil Kadimdiwan
Twitter: - @skadimdiwan
LinkedIn: Sunil Kadimdiwan
Contact: http://www.infotrove.com/events.html
Sunil Kadimdiwan Sunil Kadimdiwan has 25+ years’ experience in architecting and implementing database solutions. He has deep knowledge of the Microsoft SQL Server and Business Intelligence technology stack. He is a frequent speaker at SQLSaturdays, Code Camps, User Group meetings
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Pedro Reis
LinkedIn: Pedro Reis
Contact: https://www.aboutpowerbi.com
Pedro is a Microsoft BI Stack Professional and enthusiast. Co-Founder and Leader of the Power BI Portugal Meetup group and the Porto Power BI User Group. Speaker at events like Power Platform World Tour, SQLSaturday, Porto Data and meetups. Key areas of expertise and passion: Power BI, SSAS, Excel and DAX.
Bob Pusateri
Twitter: - @SQLBob
LinkedIn: Bob Pusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
Jim Miller
LinkedIn: Jim Miller
Contact: https://https://www.bitracks.com/blog
Jim has worked in various facets of the IT business for over 30 years, with a primary focus on data warehousing, reporting and analytics, business intelligence, data modeling (relational, multi-dimensional), ETL frameworks, database architecture, as well as database performance tuning. In previous engagements, Jim has fulfilled roles as Data Architect, DBA, IT Director, and Senior Consultant. He also has experience in account management, marketing/technical support, and software application training. Jim has also had some extraordinary opportunities to lead IT organizations, with multinational participants, on reconstruction projects based in Bosnia and Iraq.
Amit R S Bansal
Twitter: - A_Bansal
LinkedIn: Amit R S Bansal
Amit R. S. Bansal is a SQL Server Specialist at SQLMaestros. He leads the SQL Server practice with a focused team providing consulting, training, and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences on SQL Server performance tuning, which is his core expertise. Amit is also honored with Microsoft Regional Director status, MVP award, and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission-critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. To learn more about Amit, visit http://sqlmaestros.com/amit-bansal.
Matt Horton
Twitter: - GoDataNinjaGo
MS SQL Professional with 15+ years of experience. I enjoy everything data! I also an adjunct professor for Weber State University. I have lived in Utah almost my whole life. I love spending time with my family traveling, playing video games or watching movies.
Julie Koesmarno
Twitter: - @mssqlgirl
LinkedIn: Julie Koesmarno
Contact: http://www.mssqlgirl.com
Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.
Itshak David
David Yitzhak has over 24 years of experience with SQL Server, Oracle, and Sybase. He is an applicative infrastructure DBA for relational and Nosql solutions (MongoDB, Redis), Hadoop CDH and Spark. David is a specialist in HA and DRP solutions, tuning, Machine learning , security, High Performance Computing, replication (Oracle SQL Server), BI infrastructure and system engineering. David Yitzhak holds 3 Degrees from Technicon (Israel Institute of Technology): BSC Information System , MBA and ME (System engineering) and research associate in one of the enterprise Organizations. He presents in Oracle open world 2010, Organize Oracle ILOUG for 3 years , SQL Server forums, Microsoft BI forums, Sqlsaturday Israel 2016/17/18/19 , 3rd Israeli
Tracy Boggiano
Twitter: - TracyBoggiano
LinkedIn: Tracy Boggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.
Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.
Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
Andy Yun
Twitter: - SQLBek
LinkedIn: Andy Yun
Contact: http://sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.
Michael McKinley
Twitter: - https://twitter.com/Mike_L_McKinley
LinkedIn: Michael McKinley
Contact: https://www.mckinley.consulting/blog
Michael McKinley is the founder of McKinley Consulting. Michael has managed projects and workstreams in consulting for the last five years, in areas including data analytics, change management, operations excellence, and supply chain transformation.
Most recently, Mr. McKinley helped HCA build an enterprise-wide analytics model for their Human Resources Group, providing insights into how to retain and promote top talent. He is currently engaged on his fourth project with HCA.
TJay Belt
Twitter: - @tjaybelt
LinkedIn: TJay Belt
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can’t be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
Jeff Iannucci
Twitter: - DesertDBA
LinkedIn: Jeff Iannucci
Contact: https://desertdba.com/
Jeff Iannucci is a Senior Database Administrator for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both a DBA and Developer in diverse environments such as health care, finance, retail sales, and government. He writes about solving problems for database professionals on both twitter (@DesertDBA) and his blog (desertdba.com), and has been chosen as an IDERA ACE for 2020.
Scott Cameron
Scott Cameron is an experienced senior business intelligence architect who has worked with organizations to design, develop, and implement high quality data warehouse and business intelligence solutions. He has helped multiple companies with their initial SQL Server BI implementations. Mr. Cameron has taught classes in the United States and Europe, presented at the SQL PASS Community Summit, Microsoft Business Intelligence Conference, Microsoft World-Wide Partner Conference, and the SAP SAPPHIRE NOW conference. He was a contributing author of Microsoft SQL Server 2005 Analysis Services Step by Step, co-authored Microsoft SQL Server 2005 Integration Services Step by Step, and authored Microsoft SQL Server 2008 Analysis Services Step by Step.
Corey Hambrick
Twitter: - HamboneDBA
Corey Hambrick is a Database Administrator for Cafepress. He has been working in IT for over 20 years, using SQL Server since 2000. He has worked on SQL Server since SQL 7.0. He enjoys learning and sharing his knowledge with others in the user community. When he is not being a geek, he can be found with his family, at his church and helping in the local jail ministry with those involved in the substance abuse program getting their lives back on track.
Brian Hansen
Twitter: - tf3604
Contact: http://www.tf3604.com
Brian is a database administrator at Children International in Kansas City. He has been working with SQL Server technologies since 1998, including roles in report development, application development and database administration.
Sponsors
The following is a list of sponsors that helped fund the event: