Nr: 787
SQLSaturday #787 - Sioux Falls 2018
SessionID: 82586
Powering Up with Power BI (Pre-Con)
Event Date: 18-08-2018 - Session time: 09:00:00 - Track: PreCon1
Speaker: Brian Larson
Title: Powering Up with Power BI (Pre-Con)
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 with an emphasis on user interactivity with the data
• 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.
Register Here:
https://www.eventbrite.com/e/sqlsaturday-sioux-falls-pre-conference-tickets-45947239430?aff=utm_source%3Deb_email%26utm_medium%3Demail%26utm_campaign%3Dnew_event_emailutm_term=eventname_text#tickets
SessionID: 82591
Event Date: 18-08-2018 - Session time: 09:00:00 - Track: PreCon3
Speaker: Grant Fritchey
Abstract:
This workshop teaches new techniques for tuning queries using all the new tools introduced in SQL Server 2016 and 2017. You'll be able to put this knowledge to work immediately, not only in your 2016 or better instances but also in your Azure SQL Database databases. You will be tuning your queries faster and more accurately using the new tools available.
Register here:
https://www.eventbrite.com/e/sqlsaturday-sioux-falls-pre-conference-tickets-45947239430?aff=utm_source%3Deb_email%26utm_medium%3Demail%26utm_campaign%3Dnew_event_emailutm_term=eventname_text#tickets
SessionID: 82034
Getting Started with Power Query
Event Date: 18-08-2018 - Session time: 08:00:00 - Track: Advanced Analysis Techniques
Speaker: Shawn Dorward
Title: Getting Started with Power Query
Abstract:
SessionID: 82075
Intro to Powershell for the SQL Server DBA
Event Date: 18-08-2018 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Andy Galbraith
Title: Intro to Powershell for the SQL Server DBA
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!
SessionID: 82895
The Power of Data: The Complete Beginners Data Warehouse Kit
Event Date: 18-08-2018 - Session time: 08:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Leslie Andrews
Title: The Power of Data: The Complete Beginners Data Warehouse Kit
Abstract:
SessionID: 83024
JSON for the Data Mortals
Event Date: 18-08-2018 - Session time: 08:00:00 - Track: Application Database Development
Speaker: Jim Dorame
Title: JSON for the Data Mortals
Abstract:
Do you see curly brackets stored in your database and wonder what that is? Are you a DBA, with developers storing JSON in your database? As a database administrator or developer, it's important to understand JSON today. This session will explain what JSON is, where it came from, and why it is showing up all over the place. When you leave this session you will understand how to investigate, manipulate, and validate JSON in your database. You will walk away with example code of how to use Microsoft’s additions to SQL Server to use this data.
SessionID: 82091
An (Advanced) Introduction to Dax
Event Date: 18-08-2018 - Session time: 09:25:00 - Track: BI Information Delivery
Speaker: Eugene Meidinger
Title: An (Advanced) Introduction to Dax
Abstract:
SessionID: 82170
Difficult Queries
Event Date: 18-08-2018 - Session time: 09:25:00 - Track: Application Database 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: 82589
Extending DevOps To SQL Server
Event Date: 18-08-2018 - Session time: 09:25:00 - Track: Application Database Development
Speaker: Grant Fritchey
Title: Extending DevOps To SQL Server
Abstract:
SessionID: 83005
Learn History from Temporal Tables
Event Date: 18-08-2018 - Session time: 09:25:00 - Track: Enterprise Database Administration Deployment
Speaker: Ameena Lalani
Title: Learn History from Temporal Tables
Abstract:
SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. SQL Server 2017 made some enhancements in this area. Temporal tables are basically history tables of the normal tables; that allows us to retrieve data from any point in time for every change such as updates and deletes. It does this all without any change to application code. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. We will touch upon retention of history as well. It has lots of demos and less theory.
SessionID: 82533
Mom Rules for Managing Enterprise Database Environments
Event Date: 18-08-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
Speaker: Marsha Pierce
Title: Mom Rules for Managing Enterprise Database Environments
Abstract:
Have you ever looked at an environment and wondered how the heck they ever got anything done because it is so disorganized? The first thing I do for newly inherited environments is implement some organization and do some database clean up. Not only does organization make the environment easier to maintain, it can help speed up trouble shooting. Good organization can even help with some performance issues.
SessionID: 83192
Getting Started with Extended Events
Event Date: 18-08-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
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: 83810
Event Date: 18-08-2018 - Session time: 10:50:00 - Track: Application Database Development
Speaker: Eric Swiggum
Abstract:
SessionID: 85362
Power BI Deployment:Scaling from 5 to 5000
Event Date: 18-08-2018 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration
Speaker: Eugene Meidinger
Title: Power BI Deployment:Scaling from 5 to 5000
Abstract:
With Power BI, hitting publish is just a click away. But what do you do when you want to share with your team, your company, or the whole world? In this presentation, we cover all of the different ways to deploy and share Power BI reports. We'll start with sharing dashboards and work our way up to newer options like Power BI Premium and Power BI Embedded. By the end of this session, you'll have an idea of the best deployment method for you.
SessionID: 82033
Looking through the Windshield: Forward-looking Dashboards KPIs
Event Date: 18-08-2018 - Session time: 13:15:00 - Track: BI Information Delivery
Speaker: Brian Larson
Title: Looking through the Windshield: Forward-looking Dashboards KPIs
Abstract:
It is dangerous to drive forward while looking through the rear window. The same is true about guiding our organizations forward while looking only at the past. Yet, much of our BI shows only the past. This session explores simple techniques to make our dashboards and KPIs visualize what is likely in the future. No fancy predictive algorithms are necessary – just an appreciation of what we know about our organization’s future and a recognition of past trends that are likely to continue. Examples are provided in Power BI, SSRS Paginated Report and SSRS Mobile reports.
SessionID: 82048
A Rocket Scientist Perspective on Indexes
Event Date: 18-08-2018 - Session time: 13:15:00 - Track: Application Database Development
Speaker: Mike Byrd
Title: A Rocket Scientist Perspective on Indexes
Abstract:
SessionID: 82619
Maximizing SQL Server Management Studio for Developers and DBAs
Event Date: 18-08-2018 - Session time: 13:15:00 - Track: Application Database Development
Speaker: Nem Schlecht
Title: Maximizing SQL Server Management Studio for Developers and DBAs
Abstract:
Whether you're a developer or a DBA, you likely use SSMS (SQL Server Management Studio) a lot. However, are you using all the features and extensions available to maximize your efficiency? This talk will show some of the most useful, yet overlooked, features of SSMS and some of the best (and free) extensions to make life easier for you and your teams. I'll also include some of my most useful code snippets that I've found or written over the years. Save yourself some time and headaches!
Demos will include the latest version of SSMS and the new SQL
Operations Studio.
SessionID: 83883
Let's Explore SQL Internals
Event Date: 18-08-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Brian Hansen
Title: Let's Explore SQL Internals
Abstract:
Have you ever wondered how SQL Server stores your data? With so many ways that it can be done, we couldn't possibly cover everything in this session, but we'll discuss the fundamental building blocks that SQL uses to organize data into usable units. We'll also see how we can peek under the covers to actually view some of the strutures involved. Why? Because understanding how the pieces fit together will help you to design better, more efficient databases and tables, as well as providing knowledge of a critical component of how the SQL optimizer comes up with query plans.
SessionID: 82026
DAX 201
Event Date: 18-08-2018 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration
Speaker: Belinda Allen
Title: DAX 201
Abstract:
All Power BI models have date components. In this session, we’ll be talking about how to optimize time intelligence functions in DAX, like Year-To-Date, Same Period Last year, etc. We’ll review building DAX tables and the use of variables to assist.
SessionID: 82588
Data Protection Privacy in the World of Database DevOps
Event Date: 18-08-2018 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Grant Fritchey
Title: Data Protection Privacy in the World of Database DevOps
Abstract:
SessionID: 83886
SQL Server Databases in the Clouds
Event Date: 18-08-2018 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
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: 84123
The Case for Change: Identifying and Remedying Bad Code
Event Date: 18-08-2018 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment
Speaker: Amy Herold
Title: The Case for Change: Identifying and Remedying Bad Code
Abstract:
How do you capture those bad queries? When you have this data what do you look at besides the query itself? How do you make the case to the business that a code change is necessary? In this session we will explore capturing and identifying those problem queries, the analysis of the performance data, and how to effectively communicate your findings to the business to get your proposed code change approved and implemented.
SessionID: 82086
Event Date: 18-08-2018 - Session time: 16:05:00 - Track: Application Database Development
Speaker: Steven Tidwell
Abstract:
SessionID: 82177
Data Cleansing With SQL And R
Event Date: 18-08-2018 - Session time: 16:05:00 - Track: Analytics and Visualization
Speaker: Kevin Feasel
Title: Data Cleansing With SQL And R
Abstract:
SessionID: 82337
An introduction to the magical world of BIML!
Event Date: 18-08-2018 - Session time: 16:05:00 - Track: BI Platform Architecture, Development Administration
Speaker: Jonathan Stewart
Title: An introduction to the magical world of BIML!
Abstract:
SessionID: 83555
Decoder ring not needed
Event Date: 18-08-2018 - Session time: 16:05:00 - Track: Enterprise Database Administration Deployment
Speaker: Marcus Hopfinger
Title: Decoder ring not needed
Abstract:
Data privacy has never been more relevant than the last few months. Are you doing all you can to protect your data? In this session we will look at different methods to encrypt data and what those methods protect against as well as what they do not protect. I will also demonstrate enabling Transparent Data Encryption (TDE) and column level encryption along with how to encrypt and decrypt your data….no decoder ring needed.