Nr: 682
SQLSaturday #682 - Minnesota 2017
SessionID: 67028
DBA Fundamentals - give yourself a solid SQL foundation!
Event Date: 07-10-2017 - Session time: 08:00:00 - Track: Administration
Speaker: Kevin Hill
Title: DBA Fundamentals - give yourself a solid SQL foundation!
Abstract:
This class is designed for New or Non-DBAs struggling with SQL admin tasks, and having to Google things daily.
I will teach you SQL Server fundamentals so that you will have confidence in:
• What makes up a SQL Server
• How a database is structured
• How to install and what to look out for
• Finding what you need in Management Studio
• SQL Security Basics
• How to create and manage backups
• How to create a database
• Basic performance troubleshooting
• Picking a Disaster Recovery option for your environment
These are taught from a foundational standpoint, in simple to understand terms so that you can build on them with confidence.
My teaching is heavy on interaction, with examples from years of experience/mistakes. There will be a mix of slides and demos. I will skip many advanced features that are out of scope of a beginner class, as I don't want your head to explode!
Join me for the day and you will walk out with a strong grasp of SQL Admin basics!
SessionID: 67137
The Complete Primer to SQL Server Infrastructure and Cloud
Event Date: 07-10-2017 - Session time: 08:00:00 - Track: Administration
Speaker: David Klee
Title: The Complete Primer to SQL Server Infrastructure and Cloud
Abstract:
SessionID: 67325
Azure Data Services Hands On Lab
Event Date: 07-10-2017 - Session time: 08:00:00 - Track: Cloud
Speaker: Matt Stenzel
Title: Azure Data Services Hands On Lab
Abstract:
Cloud and Data are big buzzwords these days, but how can you make the work for you? There are so many great articles out there telling you how great the cloud and data are, but now you can experience it first hand! In this pre-con you will gain hands on experience with various data technologies in Azure and how they can come together to create a practical data solution. Technologies will include Azure SQL DB, Azure SQL DW, Azure Data Factory, Azure Data Lake, and Power BI. You will go through steps to provision an environment, extract, load, transform and gain insight from the data. You will also see how AI can be connected into this solution with minimal effort.
SessionID: 68206
Powering Up with Power BI
Event Date: 07-10-2017 - Session time: 08:00:00 - Track: Business Intelligence
Speaker: Brian Larson
Title: Powering Up with Power BI
Abstract:
This day-long session will provide instruction on each aspect of Power BI. We will cover:
• Data collection using the Query Editor and the M language
• Data modeling
• Measures using DAX formulas
• Visualizations
• Deployment and management in a secure, shared environment
Along the way we will look at tips and tricks as well as best practices for each of these facets of Power BI.
Participants will leave with an understanding of the full range of capabilities of Power BI along with the confidence to use Power BI to create and securely share meaningful analytics.
SessionID: 68891
Welcome to SQLSaturday #682
Event Date: 07-10-2017 - Session time: 08:15:00 - Track: Other
Speaker: Riley Major
Title: Welcome to SQLSaturday #682
Abstract:
Welcome to SQLSaturday #682
SessionID: 67144
DevOps and the Agile DBA
Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Administration
Speaker: Todd Blatti
Title: DevOps and the Agile DBA
Abstract:
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as:
Develop, Rinse, Repeat
Test Until Your Five Year Old Can Do It
Human Intervention Creates Human Error- Automate EVERYTHING.
How the shorter development cycle build business success.
How the DBA can do more with less.
Discover the power of virtualization and powerful agile development practices providing more value to even the most senior database expert. We’ll demo different scenarios surrounding DevOps, virtualization and how to make the DBA pivotal to DevOps success.
SessionID: 67278
Reading Execution Plans Successfully
Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Development
Speaker: Arthur Daniels III
Title: Reading Execution Plans Successfully
Abstract:
If you've seen an execution plan but didn't know how to read it, this session is for you.
The goal of this session to learn how SQL Server is interpreting your query into an execution plan. We'll discuss execution plan internals, how SQL Server estimates the cost of your query, and what a graphical execution plan is displaying through its operators.
Learning to read an execution plan is a great way to begin troubleshooting performance. At the end, we will take a look at how SQL Server 2016 provides more tools for exploring execution plans.
SessionID: 67793
Advanced Analytics in Power BI
Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Business Intelligence
Speaker: Lily Vergara
Title: Advanced Analytics in Power BI
Abstract:
SessionID: 67988
Dashboard-In-An-Hour
Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Business Intelligence
Speaker: Teal Derheim
Title: Dashboard-In-An-Hour
Abstract:
SessionID: 68032
SSIS: Beyond the Basics
Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Business Intelligence
Speaker: John Thompson
Title: SSIS: Beyond the Basics
Abstract:
SessionID: 68068
Purging data in SQL 2016 using Dynamic Partitioning
Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Administration
Speaker: Kirby Richter
Title: Purging data in SQL 2016 using Dynamic Partitioning
Abstract:
Have a large or potentially large database that you would like to partition? Manually implementing table partitioning and the corresponding maintenance can be a lot of work, especially if you have many tables. In this presentation we look at how you would implement a partitioning solution dynamically for all tables with the designated partition column. We use a controller table so it's easy to change settings and set it up to keep a fixed number of file groups. The partition maintenance will recycle through the file groups over time as partitions are dropped and created. We do as much as possible through dynamic scripting. This solution can easily be extended for archiving but in this example we are using it to implement a data retention scheme. We look at new features in SQL 2014 such as managed lock priority and truncating partitions in SQL 2016. Assumes you have some understanding of SQL Server table partitioning and T-SQL coding.
SessionID: 68172
SQL Server Then and Now: Changing the State of Long-held Beliefs
Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Administration
Speaker: Maxwell Myrick
Title: SQL Server Then and Now: Changing the State of Long-held Beliefs
Abstract:
We’ve all heard the rules for SQL Server like separate your data from your log, watch for a disk queue length over 2, and a low Page Life Expectancy always means memory pressure. All of these used to be true, but on today’s hardware and SQL Server versions – they are dangerously outdated. In this session, we will take on a bunch of these old “givens” of SQL Server that everybody has heard and followed, the underlying technological reasons they were true then, how today’s technology has rendered them obsolete, and what the new rules are that you need to know. So whether you are one of the old guard looking to refresh your set of working SQL Server rules or a member of the up-and-comers looking for the facts to win over the old guard, this session is for you.
SessionID: 68964
DB Options on Azure – Which One Should I Use?
Event Date: 07-10-2017 - Session time: 09:00:00 - Track: Cloud
Speaker: Tim Plas
Title: DB Options on Azure – Which One Should I Use?
Abstract:
SessionID: 67245
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Administration
Speaker: Vern Rabe
Abstract:
When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), correlated predicates, skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.
SessionID: 67259
Getting Started with Extended Events
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Administration
Speaker: Andy Galbraith
Title: Getting Started with Extended Events
Abstract:
Few subjects in Microsoft SQL Server inspire the same amount of Fear, Uncertainty, and Doubt (FUD) as Extended Events. Many DBA's continue to use Profiler and SQL Trace even though they have been deprecated for years. Why is this?
Extended Events started out in SQL Server 2008 with no user interface and only a few voices in the community documenting the features as they found them. Since then it has blossomed into a full feature of SQL Server and an amazingly low-impact replacement for Profiler and Trace.
Come learn how to get started - the basics of sessions, events, actions, targets, packages, and more. We will look at some base scenarios where Extended Events can be very useful as well as considering a few gotchas along the way. You may never go back to Profiler again!
SessionID: 68245
A Blueprint for Success with Enterprise Power BI Solutions
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Business Intelligence
Speaker: Greg Beaumont
Title: A Blueprint for Success with Enterprise Power BI Solutions
Abstract:
This session provides a blueprint for launching and maintaining enterprise Power BI solutions. Power BI enables self-service and personal business intelligence for the masses. Launching a Power BI solution is easy. Preparing for increasing data volumes, data variety, and evolving requirements often creates challenges for solution teams. We'll review 1) Data platform considerations: When to use Analysis Services, Direct Query, Power BI Premium? 2) Data architecture considerations unique to Power BI. Design a solution optimized for end user experience, QA, Maps, Security, Mobile, and future data sources. 3) Project management considerations such as requirements gathering, change control, and proper documentation. 4) Enterprise Governance: Administrative settings, Licensing, Sharing, Workspaces, and Apps. Attendees will get documentation templates, links to best practices articles, and reference materials so they can create their own blueprints for excellence with Power BI.
SessionID: 68246
SQL in HDInsight/Hadoop
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: NoSQL / Big Data
Speaker: Bill Preachuk
Title: SQL in HDInsight/Hadoop
Abstract:
Azure HDInsight lets you spin up an enterprise-class PaaS Hadoop cluster in minutes. But once you have the cluster, what can a SQL Server database professional do with it?
in this session you will learn all about the the big 3 SQL data access applications found in HDInsight - Hive, Phoenix, and SparkSQL. We'll discuss their respective engines, how they work, and and when you should choose each tool to accomplish your use cases. Ample demos, scripts, and DDL will be included.
SessionID: 68281
Backups for new/non-DBAs...the Why, not the How
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Administration
Speaker: Kevin Hill
Title: Backups for new/non-DBAs...the Why, not the How
Abstract:
Join me and get some new perspective on what your DBA is doing, and why!
Targeted at the non-DBA such as BI/DW folks, Application Developers, Managers, and System Admins, this session will go over the reasons we back up our databases, our systems, etc. Considerations such as Single points of failure, High Availability/Disaster recovery, Business Continuity and others will be discussed in this interactive conversation. It will be conversation heavy, with supporting slides to download, and one Database backup demo at the end if time permits.
Everyone involved in a technical role needs to at least know that the things they have created will be recoverable in the event of a disaster, or even just an "oops" moment. The CIO/CTO should know how long critical systems will be down when bad things happen. Backups are everyone's responsibility...whether asking the right questions or implementing the process.
SessionID: 68996
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Administration
Speaker: David Klee
Abstract:
SessionID: 69564
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Development
Speaker: Eric Strom
Abstract:
SessionID: 69848
Bridging the Data Science and SQL Divide for Practitioners
Event Date: 07-10-2017 - Session time: 10:15:00 - Track: Business Intelligence
Speaker: Matthew Simonson
Title: Bridging the Data Science and SQL Divide for Practitioners
Abstract:
As Data Science becomes more prevalent, operationalizing models built by Data Scientists as in-database analytics using SQL R Server often falls to the IT Staff. In this talk, we discuss the process of translating a standalone model to R Server, pros and cons of different approaches, and potential pitfalls.
SessionID: 67036
SSAS: What is it and How do I get started using it
Event Date: 07-10-2017 - Session time: 13:00:00 - Track: Business Intelligence
Speaker: Dave Bland
Title: SSAS: What is it and How do I get started using it
Abstract:
This session with provide a high level overview of what SQL Server Analysis Services is and what you need to know to get started. It will cover the fundamentals of Dimensions, Measures, how to view the data as well as the role of SSAS in the enterprise. The sessions with also provide a few scenarios demonstrating the benefits of using SSAS.
SessionID: 67318
Data Lake Architecture
Event Date: 07-10-2017 - Session time: 13:00:00 - Track: NoSQL / Big Data
Speaker: Matt Stenzel
Title: Data Lake Architecture
Abstract:
Data Lake is a big buzz word these days. if you aren't careful, that lake can quickly turn into a swamp that takes the value away from your data. What does it take to actually make one and not have a data swamp? In this session we will talk about what a data lake looks like, what is needed to make a data lake and best practices in building and maintaining one.
SessionID: 67844
Business Intelligence achieved
Event Date: 07-10-2017 - Session time: 13:00:00 - Track: Business Intelligence
Speaker: Anton Rozenson
Title: Business Intelligence achieved
Abstract:
Welcome to the exciting journey of designing and implementing Data Driven Business Solutions with SQL stack and PowerBI. During this session, you will learn how classic data warehouse architecture is implemented with new tools and features. You will dive into good practices to discover common pitfalls and advantages in physical architecture and rise to tell a story about Business with data visualizations.
SessionID: 67954
Designing an alternative to Replication - a Real World™ Example
Event Date: 07-10-2017 - Session time: 13:00:00 - Track: Development
Speaker: Ben Thul
Title: Designing an alternative to Replication - a Real World™ Example
Abstract:
Transactional Replication gets a bad rap for being fragile and somewhat difficult to manage. Given that reputation, we decided to try to accomplish some of the same things that it does using alternative means. Let me regale you with the tale of that journey. You may come out of it with a newfound appreciation of Replication or you may find yourself asking "that's pretty neat!". Only one way to find out, though…
SessionID: 68044
Index 360 - Looking at Indexes from Multiple Perspectives
Event Date: 07-10-2017 - Session time: 13:00:00 - Track: Development
Speaker: John Eisbrener
Title: Index 360 - Looking at Indexes from Multiple Perspectives
Abstract:
If you have used a database, chances are almost certain you've utilized indexes as well. In this presentation I will discuss both Rowstore and Columnstore Indexes and why they are important to anyone that interacts with a database. This session will cover what they are, how they are utilized, how best to take advantage of them, and even when they can be problematic. It is my intention to help anyone become more comfortable with indexes and understand what they can do for you and your role, be it a DBA, Developer, or BI Professional.
SessionID: 68310
SQL Server Databases in the Clouds
Event Date: 07-10-2017 - Session time: 13:00:00 - Track: Cloud
Speaker: Tim Plas
Title: SQL Server Databases in the Clouds
Abstract:
Application servers or services running on a cloud platform now have many options for their database engines. We discuss the various alternatives for providing Microsoft SQL Server services to cloud-based applications, including Microsoft Azure, Amazon AWS, and Google GCE, and multiple options within those environments. Why would you choose one approach over the other? What are the trade-offs on cost, performance, availability, security, ongoing maintenance, required skill sets, etc.
SessionID: 68889
Lightning Talks (Round 1)
Event Date: 07-10-2017 - Session time: 13:00:00 - Track: Administration
Speaker: Jim Horn
Title: Lightning Talks (Round 1)
Abstract:
Mitchell Hamann - SQL Server Up! Building SQL Server VM's with Vagrant
http://www.sqlsaturday.com/682/Sessions/Details.aspx?sid=68247
Daniel Crowson - No Budget "Good Enough" SQL Server Monitoring
http://www.sqlsaturday.com/682/Sessions/Details.aspx?sid=68270
Constantine Kokkinos - Testing Your Backups Are Safe in One Step
http://www.sqlsaturday.com/682/Sessions/Details.aspx?sid=68267
SessionID: 68966
Understanding Your SQL Server Ecosystem
Event Date: 07-10-2017 - Session time: 13:00:00 - Track: Administration
Speaker: Amanda Crisp
Title: Understanding Your SQL Server Ecosystem
Abstract:
SessionID: 66891
Analyzing Healthcare Open Data with Power BI
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Business Intelligence
Speaker: Dan English
Title: Analyzing Healthcare Open Data with Power BI
Abstract:
SessionID: 66895
Difficult Queries
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Development
Speaker: Rick Bielawski
Title: Difficult Queries
Abstract:
Take your T-SQL skills to the next level. Regardless of your current level there will be something here you'll be glad you didn't miss. Basics like avoiding cursors in iterative tasks and multi-database executions are the tip of the iceberg. If queries are basic arithmetic then this is basic algebra. First we see how coding style affects maintainability then dive into several types of encapsulation, parameterization and tricks with values, cross apply, pivot and more .
SessionID: 66975
I deleted 1 billion records, what happened next will shock you!
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Administration
Speaker: Eric Zierdt
Title: I deleted 1 billion records, what happened next will shock you!
Abstract:
In this session we will give an overview of what Table Partitioning is, how can it be used to move large amounts of data quickly and how can it be used with a data archiving strategy to quickly and easily drop archived data from a table. We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you. In this demo heavy session, attendees will be provided with scripts to get setup quickly so they can begin using the strategies to take control of rapid data archival
SessionID: 67134
Linux for the SQL Server Administrator
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Administration
Speaker: David Klee
Title: Linux for the SQL Server Administrator
Abstract:
SessionID: 68272
Automated Enterprise-wide SQL Server Auditing
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Administration
Speaker: Nem Schlecht
Title: Automated Enterprise-wide SQL Server Auditing
Abstract:
Do you have many SQL instances in your enterprise? Do you have to maintain multiple dev/test/uat/pre-prod/prod environments? Need to spin up new instances often? Do you need a way to ensure these environments are all set up correctly and consistently and be notified of changes to them? If so, you need an enterprise-wide auditing system! I will be presenting my free, open source, system that does the following: 1) Collects information an all of your SQL instances daily, 2) sends you a report of any changes that have occurred (new/old/changed values), 3) lets you set up rules for all/some of servers and checks these rules on a daily basis (ie - backup compression should be turned on, Max memory should be less than 2TB, etc) and will even send you the SQL to fix any rules that failed.
SessionID: 68307
SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem Cloud
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Cloud
Speaker: Paul Timmerman
Title: SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem Cloud
Abstract:
For years it seemed that the only message SQL Server professionals were hearing was "to the Cloud.... you must get to the Cloud!". However, if you work in a highly regulated industry, or one simply averse to change, this likely was not an option for you. The good news is, Microsoft heard your feedback and has been busy incorporating Cloud connectivity, compatibility, and functionality into the box product.
Come spend the hour with me and you’ll learn how to leverage the power of the Cloud with your on-premises SQL Server install. We’ll cover backup and restore options with Windows Azure Storage, using Windows Azure VMs for high availability, how to store your data files in Windows Azure Storage, and more. We’ll start with SQL Server 2012 and work our way up to the most recently released bits for SQL Server 2016. You can have the best of both worlds with a SQL Server Hybrid Cloud strategy!
SessionID: 68890
Lightning Talks (Round 2) and Panel
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Administration
Speaker: Jim Horn
Title: Lightning Talks (Round 2) and Panel
Abstract:
Drew Skwiers-Koballa - Utilizing Azure Functions with SQL Server/SQL Database
Panel Discussion with PASSMN Board Members Jim Dorame, Jim Horn, Cecil Spivey, Chris Kramer, and Riley Major.
SessionID: 69493
Navigating Modern BI - Infrastructure in 2017
Event Date: 07-10-2017 - Session time: 14:15:00 - Track: Business Intelligence
Speaker: George Bryant
Title: Navigating Modern BI - Infrastructure in 2017
Abstract:
SessionID: 69342
Event Date: 07-10-2017 - Session time: 15:25:00 - Track: Other
Speaker: Mike Matthews
Abstract:
SessionID: 67372
Event Date: 07-10-2017 - Session time: 15:55:00 - Track: Professional Development
Speaker: Cecil Spivey
Abstract:
Everybody loves a free lunch. Come to this session to learn about all the SQL Server freebees.
SessionID: 67705
Intro to Machine Learning
Event Date: 07-10-2017 - Session time: 15:55:00 - Track: Business Intelligence
Speaker: Jared Zagelbaum
Title: Intro to Machine Learning
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.
SessionID: 68173
The Consulting Dilemma: Is Inside or Outside of the Corporation the Right Fit for You?
Event Date: 07-10-2017 - Session time: 15:55:00 - Track: Professional Development
Speaker: Maxwell Myrick
Title: The Consulting Dilemma: Is Inside or Outside of the Corporation the Right Fit for You?
Abstract:
Accomplished IT staff looking to make the next step in their career development are often tempted to abandon the traditional full-time employee role for that of a self-managed consultant. The biggest challenge is how to know which role is the best fit for you. This session will discuss the pros/cons of self-managed consulting with an eye to the skills it takes to really be successful on the outside. For those that fit, we will also cover several of the hidden traps of consulting, what you need to get started, and the six skills that you absolutely have to have (or rent) to make a go of it. Whether you are looking at this type of move near-term or just keeping your options open, this talk will give you the real-life lessons to make that next step with confidence.
SessionID: 68210
Keys to a Successful Business Intelligence/Analytics Project
Event Date: 07-10-2017 - Session time: 15:55:00 - Track: Professional Development
Speaker: Brian Larson
Title: Keys to a Successful Business Intelligence/Analytics Project
Abstract:
Business intelligence and data analytics are popular buzz words these days, but what does a business intelligence/data analytics project actually look like and how can you ensure its success? This session will discuss the pieces of the puzzle that make up this type of project as well as the people who need to be involved. Learn the questions to ask to determine if an organization is even ready to undertake this type of endeavor. Most important, gain an understanding of the required parts and processes that ensure the implementation and application of meaningful analytics that will actually impact an organization’s bottom line.
SessionID: 68280
Requirements Document Templates for Reporting and ETL Projects
Event Date: 07-10-2017 - Session time: 15:55:00 - Track: Development
Speaker: Jim Horn
Title: Requirements Document Templates for Reporting and ETL Projects
Abstract:
A witty and highly entertaining session about requirements documents for reporting an ETL projects from a developers perspective.
Reporting Projects
https://www.experts-exchange.com/articles/12209/Requirements-Document-Template-for-a-Reporting-Project.html
ETL Projects
https://www.experts-exchange.com/articles/26539/Requirements-Document-Template-for-an-ETL-Project.html
SessionID: 68967
SQL Server 2017 on Containers
Event Date: 07-10-2017 - Session time: 15:55:00 - Track: Administration
Speaker: Chris Kramer
Title: SQL Server 2017 on Containers
Abstract:
What are these docker things my developers keep talking about? What's with all the excitement for SQL Server 2017 on Linux?
In this session, we take a look at the current state of container technology, how it applies to SQL Server 2017, and what changes you can expect to see in the future of managing your SQL Server installations upgrades.
SessionID: 69238
Building Stronger (Human) Relationships
Event Date: 07-10-2017 - Session time: 15:55:00 - Track: Professional Development
Speaker: Joshua Warne
Title: Building Stronger (Human) Relationships
Abstract:
SessionID: 68892
Closing
Event Date: 07-10-2017 - Session time: 17:05:00 - Track: Other
Speaker: Riley Major
Title: Closing
Abstract:
Thank you for attending SQLSaturday #682