Event Location:
University of Iowa - University Capitol Centre
201 S Clinton St
Iowa City, Iowa
Abstract:
So you've gathered the requirements, made sure the ETL is perfect, the model queries in milliseconds, and the report is both functional AND fashionable. There's always that one person(and usually a few) that wants to see the data with a different visual, or with filters applied a certain way. In this session, we will go in depth on the bookmarking feature in a live demo using the framework of four business cases. Power BI Pagination I'll take an existing dataset previously used for a SSRS report and add Page forward and backward buttons to it in Power BI Change and Reset ALL filters and slicers I'll reset/update filters and slicers across multiple tabs in a report with a single button Swapping out visuals with one click The director wants to see the visual but the VP wants to see the table Executive Presentation Create a finely tuned presentation with nothing but Power BI Bring your own dataset and build out these scenarios with me as I demonstrate each one live from scratch.
Speaker(s): Eric Fait,
Abstract:
Oh! ASYNC_NETWORK_IO just went through the roof! What just happened? Ever wonder how common tasks such as how servers communicate, how cross-subnet Availability Group failover to your disaster recovery site work, or why ‘they’ always recommend a dedicated network adapter for your WSFC? What do I need to know to better manage my databases in the cloud? De-mystifying the networking underneath your databases makes you a stronger database professional. This deep dive technical session will cover many of the critical aspects of enterprise-level networking and how your database servers communicate with the rest of the world. Topics and demonstrations include networking technologies, quality of service, VLANs, routing, firewalls, monitoring, and trending. By the end of this interactive session, you will be able to check your own networks for their performance and know how to converse with the networking admins to help improve the overall performance.
Speaker(s): David Klee,
Abstract:
If your boss asked you for the list of the five most CPU-hungry databases in your environment six months from now for an upcoming licensing review, could you come up with an answer? Performance data can be overwhelming, but you can make sense of the mess. Twisting your brain and looking at the data in different ways can help you identify resource bottlenecks that are limiting your SQL Server performance today. Painting a clear picture of what your servers should be doing can help alert you when something is abnormal. Trending this data over time will help you project how much resource consumption you will have months away. Come learn how to extract meaning from your performance trends and how to use it to proactively manage the resource consumption from your SQL Servers.
Speaker(s): David Klee,
Abstract:
For years, those of us who wanted to use a Mac and do .NET or SQL Server development have been caught in a "worst of both worlds"-type of situation. We have had to use some sort of Windows VM, which negates the relative advantages of using a Mac (notably the battery life). The good news is that thanks to Microsoft's efforts, we can now do full stack .NET development without ever touching a Windows VM on our Macs! In this talk, I'll live code a simple service with database backend while introducing Mac-native tools such as Visual Studio Code, SQL Operations Studio and SQL Server for Docker. Along the way, I'll discuss key differences and limitations between the Windows tools and their Mac counterparts paying particular attention to the differences between SQL Ops Studio and SSMS. I'll also touch on the difference between Visual Studio Code and Visual Studio for Mac.
Speaker(s): Dan Mallott,
Abstract:
Multi-user systems are affected by how SQL Server locks resources to manage concurrent transactions. Understanding how SQL Server uses locks to isolate transactions from one another is important for both writing code and running maintenance tasks. In this session, we will discuss lock modes in SQL Server and how they impact your queries. We will show how different isolation levels change which locks are taken and for how long they are held. We will look at ways to avoid unnecessary blocking for maintenance tasks like index rebuilds. Assertions will be backed up with demo-based evidence. After this session, you will have the understanding you need to start writing application code and maintenance jobs suitable for concurrent systems by anticipating blocking issues due to locking.
Speaker(s): Jake Manske,
Abstract:
Your Always On Availability Group just failed. Quick! What do you do? Many of us go straight to the SQL Server log and the Availability Group dashboard. That makes sense - both are great troubleshooting tools, and the answer is often found in one of them. However, they don't always have the answer we seek. What then? As a consultant, I've been able to troubleshoot a number of less-common scenarios first-hand. Join me as we walk through some of these scenarios to show you how to detect and correct them. Along the way, we'll also discuss alerts you can put into place on your servers to give you immediate feedback when something in your availability group goes wrong.
Speaker(s): Ed Leighton-Dick,
Abstract:
This presentation will briefly go over the history of OLAP and Microsoft's contribution to the technology. The bulk of the conversation will then be an introduction to Azure's analysis services implementation - how to use it, how much it may cost, a comparison to on-premises implementations, and how to migrate from on-premises. Then more intermediate subjects will be discussed, such as analysis of best practices and automation techniques, future features Microsoft is working on, and future research considerations for a more advanced look at Azure Analysis Services. Demos are included during several parts of the presentation.
Speaker(s): Turner Kunkel,
Abstract:
Many times users or management ask for something that they've heard about but don't quite understand, in hope of solving a problem that doesn't quite make sense. It is possible to put a SQL Server database in memory, and memory is faster than disk, so this has just got to be a good idea! This session looks at what you can do to put a database in memory, at what problems that can help, and at what problems it won't affect noticeably. It also looks at the recommended way to put tables into memory and the problems that will solve.
Speaker(s): Pat Phelan,
Abstract:
You've read all the Books Online articles about Columnstore indexes for data warehouses, but everything sounds too good to be true. Can you really get the promised 10X query performance without changing any code? In this demo-packed session, you'll learn real world lessons from deploying Columnstore indexes in production, and how you can avoid many query performance issues by following four simple rules. This is an advanced session recommended for attendees who already know the basics of Columnstore technology.
Speaker(s): Joe Obbish,
Abstract:
When it was introduced way back in SQL Server 2005, the lowly ROW_NUMBER() function at first seemed to have little functionality other than simply counting rows. However, over time we have come to see this humble function is actually surprisingly useful in often unexpected ways. In this session we will discover the creative uses of ROW_NUMBER() in ways that you may likely not have yet considered. This session will be filled with little goodies that can you can use, whether you are a writing SQL for application code or for administrative functionality.
Speaker(s): Brian Hansen,
Abstract:
The cardinality estimator in SQL Server is a massively complex piece of software that is responsible for calculating the estimated number of rows for query plans. We will derive some of the simplest and most important rules for cardinality estimation. Armed with that knowledge, we will address errors in cardinality estimates which can cause poor query performance. Demos include filtering on multiple columns, using local variables, dealing with ascending keys, and more.
Speaker(s): Joe Obbish,
Abstract:
Are you interested in learning how to leverage Azure Functions to create an app that can scale to demand? In this session, we will walk through the architecture and components of creating an Azure-facing video processing application that can scan videos for text and provide that information in CSV files for analysis. We will cover the architecture, data flow, and Azure technology pieces including Azure Functions, Blob Storage, Storage Queues, Azure Data Lake Storage Analytics, and Power BI.
Speaker(s): Joshuha Owen,
Abstract:
In this session of Getting Started with Azure Data Lake Analytics, we will learn about fundamental concepts and considerations for designing a Data Lake, how that fits into your organization, and then spend most of the time processing data with Data Lake Analytics using Microsoft's new Big Data language, U-SQL.
Speaker(s): Sean Forgatch,
Abstract:
In this session you will learn the basics of statistics and what they are used for. You will learn how to gather information about the statistics and how to use the information to improve performance. It is important the statistics are maintained to work properly. We will discuss what on going maintenance should be done on statistics.
Speaker(s): Dave Bland,
Abstract:
Unit testing is an important part of application development and maintenance. Knowing that your latest change is not only providing the desired results but also is free from side-effects is critical to the rapid pace expected by your customers. This session will provide an introduction in to how you can easily create a library of unit tests around your database and its programmable objects.
Speaker(s): Kevin Trojanowski,
Abstract:
Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!
Speaker(s): Dave Bland,
Abstract:
Unleashing the Power of SQL Server 2017. We will discuss many useful features that SQL 2017 offers. We will primarily discuss on Resumable online index rebuild, Automatic database tuning, graph database capabilities and other features. Will also touch base upon few of the other features on SQL Server 2017 SSIS and SSRS as well.
Speaker(s): Sourav Mukherjee,
Abstract:
If you've never queried an XML column you definitely want to attend. While targeted to beginners this isn't a "Just do this" session. After this session I'd like you to truly understand even subtle nuances of basic query syntax. Seasoned veterans stand a fair chance of learning something new.
Speaker(s): Rick Bielawski,
Abstract:
Many DBA's have the same outlook on Powershell - we all know we should use it, but we don't think we have time to learn one more tool that isn't even really part of SQL Server anyway. I was one of these DBA's for many years, but recently I have come to respect the *power* of Powershell. Come learn the basics of Powershell, how Powershell and SQL Server interact with each other, and finally how to use Powershell to automate common SQL Server tasks such as maintenance and SQL Server installations. If you need to interact with Windows or Active Directory, odds are Powershell is the right tool for the job - come learn how to use it!
Speaker(s): Andy Galbraith,
Abstract:
There are a lot of impressive out of the box capabilities with Azure Data Factory. Also, just like in SSIS, you can extend these capabilities using custom code (.Net in V1 or any executable in V2). We’ll discuss the prerequisites for Azure needed to implement these activities, as well as step through some code examples in C#, including how to setup your development environment. Prior experience with Azure Data Factory is highly recommend for this session.
Speaker(s): Jared Zagelbaum,
Abstract:
Have you ever setup a new instance and realized later that you skipped a configuration step? Did you get handed a database from another team and want to see how much work you have to do to clean up it’s configuration? Don’t you wish there was an easy way to validate that every instance in your environment was configured correctly? In this session we’ll be learning about an exciting new powershell module called dbachecks which seeks to solve these problems. Built upon the backbones of dbatools and pester, this is a unit testing framework with over 100 predefined checks to validate your instances.
Speaker(s): Frank Henninger,
Abstract:
Come to this session to get your toes wet with machine learning. What are the types of questions it can answer? What are the types of models it can produce? What are some the of techniques used? There will be practical demos using Azure Machine Learning as well. Enough info to get you started, or enough to quit while you're ahead, either way, you'll come out with some concrete ideas of what ML is all about.
Speaker(s): Jared Zagelbaum,
Abstract:
Having a good understanding what security features are available and what configurations are considered best practice can be crucial to your company's data security. Learn to view security differently and how key builtin security features can be leveraged to make your systems both more maintainable and more secure. This is very much a HOW TO session, both in terms of how to decide what feature combinations work best for your environment and how to implement those features.
Speaker(s): Rick Bielawski,
Abstract:
Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren't on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away ... and possibly even after 2016 SP1.
Speaker(s): Rick Lowe,
Abstract:
In this session, we'll discuss ways to manage execution plans inside the plan cache of busy and unpredictable SQL Servers. The plan cache keeps SQL Server healthy, but all it takes is one bad execution plan to decrease server performance. Just like gardening, keeping a database healthy requires pruning. Techniques to manage, remove, and improve execution plans will be shown. The Query Store gives us power tools for this work, but it's not the entire solution.
Speaker(s): Arthur Daniels III,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/danielmallott/
Contact: https://www.danielmallott.com
Dan Mallott is a Chicago-based consultant for West Monroe Partners in their Technology Practice. His passion is for service-layer development, particularly database technologies, including Microsoft SQL Server and Apache Cassandra. Recent projects have included designing a new integration architecture for a mid-sized health insurer, designing a full technical architecture for a large health insurer, building a new member portal for a healthcare-related association, and developing threat hunting software for use by West Monroe. In his spare time, Dan can be found writing his own libraries instead of using package solutions, or on the ice as a hockey player and referee.
LinkedIn: https://www.linkedin.com/in/dave-bland-sql-server
Contact: https://www.davebland.com
Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQL Saturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics
LinkedIn: https://www.linkedin.com/in/ericfait/
Eric cut his data teeth in finance doing ledger reconciliations and incentive compensation calculations. Always the data geek, the opportunity to join the Business Intelligence Analytics department of a Fortune 100 company came along and he dove right in. Now with Talavant, Eric enjoys working closely with clients to help them execute their Business Intelligence visions. Eric’s wife, Jamie, and his three boys, Eli, Miles, and Gavin take up most of his free time(and he likes it that way!)
LinkedIn: https://www.linkedin.com/in/fhenninger/
Contact: https://osirismedia.biz
Frank has been a database adminstrator most of the last 10 years. In that time he's managed Oracle on Linux, DB2 on AIX and SQL Server on Windows.
Contact: https://concurrencyexchange.com
Jake has been a T-SQL developer since 2013, starting after he jumped ship from an academic life as a mathematics professor to the software industry. He focuses on solving difficult concurrency problems, large scale data warehouse ETL processes, data conversions, and understanding SQL Server optimizer behavior.
IT Professional with over 25 years experience across a range of technologies, specializing in data and databases including SQL Server and Redis.
LinkedIn: https://www.linkedin.com/in/dave-bland-sql-server
Contact: https://www.davebland.com
Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQL Saturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: • Microsoft Certified Trainer • MCTS: SQL Server 2008, Implementation and Maintenance • MCTS: SQL Server 2008, BI Development and Maintenance • MCSA: SQL Server 2008 • MCSA: SQL Server 2016 • MCSE: SQL Server 2016 - BI • MCDBA: SQL Server 2000 • MCSD • MCSE: Data Management and Analytics
LinkedIn: http://www.linkedin.com/pub/rick-lowe/a/228/441/
Contact: http://dataflowe.wordpress.com/
Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated... eventually specializing more on performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.
LinkedIn: http://www.linkedin.com/in/davidaklee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQL Saturday events, and many SQL Server User Groups.
LinkedIn: https://www.linkedin.com/in/joshuha
A Data and AI Premier Field Engineer by day and tech geek at all times. I enjoy working with data technologies as well as dabbling in other areas such as VR programming.
LinkedIn: https://www.linkedin.com/in/jaredzagelbaum?
Contact: https://jaredzagelbaum.wordpress.com
With over 10 years of experience using the Microsoft Data Platform suite, Jared’s main areas of focus include data lake architecture, machine learning, and application embedded analytics. Jared regularly speaks at user groups and events across the Midwest, as well as blogs and provides technical review for SQL Server publications.
Contact: https://orderbyselectnull.com
Joe Obbish has nearly a decade of experience with SQL Server and other database platforms. He works as a query tuning, columnstore, and scalability expert within Epic, a large EHR and analytics vendor in Madison, WI. In less than two years, he became one of the top contributors for SQL Server on the DBA StackExchange community. Joe blogs about advanced columnstore and query tuning topics on his blog, http://www.orderbyselectnull.com. In his spare time, Joe enjoys baking and sharing these treats with his coworkers.
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.
LinkedIn: http://www.linkedin.com/in/davidaklee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQL Saturday events, and many SQL Server User Groups.
LinkedIn: http://www.linkedin.com/in/eleightondick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
LinkedIn: http://www.linkedin.com/pub/andy-galbraith/5/149/98b
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.
LinkedIn: https://www.linkedin.com/in/jaredzagelbaum?
Contact: https://jaredzagelbaum.wordpress.com
With over 10 years of experience using the Microsoft Data Platform suite, Jared’s main areas of focus include data lake architecture, machine learning, and application embedded analytics. Jared regularly speaks at user groups and events across the Midwest, as well as blogs and provides technical review for SQL Server publications.
Contact: https://orderbyselectnull.com
Joe Obbish has nearly a decade of experience with SQL Server and other database platforms. He works as a query tuning, columnstore, and scalability expert within Epic, a large EHR and analytics vendor in Madison, WI. In less than two years, he became one of the top contributors for SQL Server on the DBA StackExchange community. Joe blogs about advanced columnstore and query tuning topics on his blog, http://www.orderbyselectnull.com. In his spare time, Joe enjoys baking and sharing these treats with his coworkers.
LinkedIn: https://www.linkedin.com/in/richardbielawski
Rick has 35 years experience as a systems, applications and database architect having designed major systems for such institutions as NASDAQ, Bank of America, Blue Cross Blue Shield, Ecolab and Emperex. He holds multiple certifications including MCITP and MCSE in Business Intelligence and Data Platform. Rick currently designs database systems for custom software applications and likes speaking at local user groups and SQL Saturday events.
Contact: https://www.DBA-Art.com
Arthur Daniels is a Premier Field Engineer (PFE) at Microsoft. He has focused on diagnosing and optimizing performance on very large databases in mission critical environments.
LinkedIn: https://www.linkedin.com/in/richardbielawski
Rick has 35 years experience as a systems, applications and database architect having designed major systems for such institutions as NASDAQ, Bank of America, Blue Cross Blue Shield, Ecolab and Emperex. He holds multiple certifications including MCITP and MCSE in Business Intelligence and Data Platform. Rick currently designs database systems for custom software applications and likes speaking at local user groups and SQL Saturday events.
LinkedIn: https://www.linkedin.com/in/sourav-mukherjee-46b0a015/
Sourav Mukherjee is a Senior Database Administrator based out of Chicago. He has more than 12 years of experience working with SQL Server Platform. His work focus in Microsoft SQL Server started with SQL Server 2000. Being a Consultant worked with different Chicago based client projects. He has helped many companies in designing and maintaining their high availability solutions and providing query performance tuning to improve the overall SQL Server performance. He holds a bachelor's degree in Computer Science, Master's Degree in Project Management. He is an MCT (Microsoft Certified Trainer) and TOGAF, PMP and ITIL Certified. He writes articles and blogs in LinkedIn and other social media sites.
LinkedIn: http://www.linkedin.com/in/turner-kunkel-7954237
Consulting with Talavant since September 2017. President of the Fox Valley, WI PASS chapter. Degrees in computer science and management sciences. Experienced in SQL, SSIS, DevOps strategies, Azure Data Factory, Databricks, and Snowflake. Also, beer maker, music lover, code tinkerer.
LinkedIn: https://www.linkedin.com/in/phelanp
Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.
LinkedIn: https://www.linkedin.com/in/seanforgatch/
Contact: https://www.modern-dataengineering.com
Sean Forgatch is a Manager in Data Engineering consulting Avanade\Accenture based out of Chicago, IL focusing on Data Strategy, EIM , and Data Archtiecture. Serving multiple Fortune and Global 500 companies he has helped push the limits of Azure and is working on some of the largest Azure Data Lake and Analytics implementations in the industry. He has spoken at over 25 conferences across the United States since 2016, was the President of the Northeast Wisconsin PASS, and served on the board for SQL Saturday Madison. Originally from Southern Illinois, Sean enjoys running and lifting, as well as casual conversations with coffee, and spending time with his dog Sailor, an all white Siberian Husky.
The following is a list of sponsors that helped fund the event.