Nr: 631
SQLSaturday #631 - Wausau 2017
SessionID: 61780
MS SSAS Business Value: Should I choose Tabular or Multidimensional?
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: Data Analysis
Speaker: Wylie Blanchard
Title: MS SSAS Business Value: Should I choose Tabular or Multidimensional?
Abstract:
Determine which model presents the right business value for your company's analytical needs. In this session we'll discuss the difference between SSAS Tabular and SSAS Multidimensional modes, feature differences as well as the benefits and cons to utilizing both modes in MS SQL Server 2016.
SessionID: 63845
Creating an Azure SQL Database Using PowerShell
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: Server Administration
Speaker: Frank Gill
Title: Creating an Azure SQL Database Using PowerShell
Abstract:
SessionID: 64226
SSAS: What is it and How do I get started using it
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: Business Intelligence Development
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: 64415
What is new in SQL Server 2016 for DBAs?
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: Database Administration - Advanced
Speaker: Ameena Lalani
Title: What is new in SQL Server 2016 for DBAs?
Abstract:
SQL Server 2016 was released in June 2016 with tons of new features. When Service Pack 1 was released in November 2016, many of the Enterprise level features were allowed in lower editions of SQL server 2016. Microsoft made sure everyone got something out from an upgrade to SQL Server 2016. In this session, you will get an overview of several of the new features in SQL Server 2016. It will cover Dynamic Data masking, Row Level Security, Always Encrypted, Temporal tables and time permitting few more goodies. This is a high-level overview session on advanced features of SQL Server 2016 and therefore we will not be going deep into any one technology. My goal is to inspire you to take action and play with new features of this great product.
SessionID: 68045
Index 360 - Looking at Indexes from Multiple Perspectives
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: Database Administration - Advanced
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: 68140
Protecting Your Data with Encryption
Event Date: 16-09-2017 - Session time: 09:00:00 - Track: Database Administration - Beginner
Speaker: Ed Leighton-Dick
Title: Protecting Your Data with Encryption
Abstract:
We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.
SessionID: 61225
Learn History from Temporal Tables
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Database Administration - Advanced
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. They are basically history tables of the normal tables; that allow 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 and without using any behind the scene triggers. 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. It has lots of demos and less theory.
SessionID: 61326
JSON for the Data Mortals
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Other
Speaker: Jim Dorame
Title: JSON for the Data Mortals
Abstract:
In SQL Server 2016 Microsoft has include native handling of JSON. What does that mean? What is JSON? Why do I care? Will there be knives and hockey masks? Come to this session and you will learn what JSON is, where and how it is used and why as a data professional you need to know this.
SessionID: 63045
Processing Big Data with Azure Data Lake Analytics
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Business Intelligence Development
Speaker: Sean Forgatch
Title: Processing Big Data with Azure Data Lake Analytics
Abstract:
In this session of Getting Started with Azure Data Lake Analytics, we will learn the fundamentals of designing a Data Lake, how that fits into your organization, and then spend most of the time processing data with Data Lake Analytics in U-SQL.
SessionID: 63846
The SQL Server Transaction Log for Developers
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Database Administration - Beginner
Speaker: Frank Gill
Title: The SQL Server Transaction Log for Developers
Abstract:
SessionID: 64228
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Database Administration - Beginner
Speaker: Dave Bland
Abstract:
SessionID: 68137
How to Keep Your Databases Secure in Just Minutes a Day
Event Date: 16-09-2017 - Session time: 10:15:00 - Track: Database Administration - Advanced
Speaker: Ed Leighton-Dick
Title: How to Keep Your Databases Secure in Just Minutes a Day
Abstract:
You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database... right?
Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.
In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you'll also learn where to find security-related information in SQL Server's metadata and logs to allow you to customize and extend the reports to meet your company's unique needs.
SessionID: 61223
Automated Restore Script Output for Ola Hallengren’s Maintenance Solution
Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Database Administration - Advanced
Speaker: Jared Zagelbaum
Title: Automated Restore Script Output for Ola Hallengren’s Maintenance Solution
Abstract:
This session is designed to be useful to two different audiences:
1.Those implementing Ola Hallengren’s Maintenance Solution for the first time. (Or don't even know what the Maintenance Solution is!)
2.Those that have been using it for awhile, but might have a hole in their DR plan – what to restore when a resource goes offline.
We will do an overview of the maintenance solution to start, then get down and dirty with the guts of the extension. What I am presenting is a custom extension that works out of the box for jobs created using the maintenance solution. The scripts will add an additional job step to all DatabaseBackup jobs which will output a text file that contains the most current restore scripts for each database in the instance.
If you don't know what I just described in that last paragraph, you should come to this session and that will be explained as well!
SessionID: 61779
SSAS Tabular in 60 mins: Developing Business-Driven Self-Service BI
Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Business Intelligence Development
Speaker: Wylie Blanchard
Title: SSAS Tabular in 60 mins: Developing Business-Driven Self-Service BI
Abstract:
In this session we'll develop a Tabular Data Model in MS SSAS and review our options for deploying, sharing and visualizing it. Well also discuss how senior leaders will see the business value of SSAS and how end users can utilize it for Self-Service Business Intelligence.
SessionID: 64227
I Know SQL Server, but want to become a great DBA - What do I need to know?
Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Professional Development
Speaker: Dave Bland
Title: I Know SQL Server, but want to become a great DBA - What do I need to know?
Abstract:
This session will cover what is needed to transition from someone who knows SQL Server to becoming a great DBA. It will cover what technical skills are needed, how to think like a great DBA and explore some of the functionality of SQL Server that can help all DBAs do their job. The presenter will share of the his experiences of his journey to go from a trainer to a successful DBA.
SessionID: 64605
Problem Solving With The In-Memory Engine
Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Database Administration - Advanced
Speaker: Christopher Adkin
Title: Problem Solving With The In-Memory Engine
Abstract:
- Staging data as fast as possible
- Turbo charging scalar aggregate functions
- Implementing a scalable sequence
- Overcoming the performance limitations of temporary tables
- Making the critical path in your code base run faster
SessionID: 67415
Event Date: 16-09-2017 - Session time: 12:45: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: 67912
Get Your Optimizer to Give up All Its Secrets
Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Database Administration - Advanced
Speaker: Brian Hansen
Title: Get Your Optimizer to Give up All Its Secrets
Abstract:
SessionID: 68138
Understanding SQL Server 2016 Always Encrypted
Event Date: 16-09-2017 - Session time: 12:45:00 - Track: Database Administration - Beginner
Speaker: Ed Leighton-Dick
Title: Understanding SQL Server 2016 Always Encrypted
Abstract:
SessionID: 61224
SQL Server 2016 - New Security Features
Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Database Administration - Advanced
Speaker: Jared Zagelbaum
Title: SQL Server 2016 - New Security Features
Abstract:
Per Microsoft, SQL Server 2016 “is the biggest leap forward in Microsoft's data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios.”
There’s a ton of ground to cover on all of the new enhancements, so this session will focus on some of the new advanced security offerings that Microsoft has incorporated into the platform: Dynamic Data Masking, Row-Level Security, and Always Encrypted.
SessionID: 63844
Anatomy of a Transaction
Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Database Administration - Advanced
Speaker: Frank Gill
Title: Anatomy of a Transaction
Abstract:
In SQL Server, the transaction log is the most important file in any database. All changes to the data and schema are tracked in the transaction log. Join me to learn how to read the transaction log, how to follow a transaction as is processes, and how SQL Server handles a transaction rollback. You will also learn how to identify the resources and objects SQL Server accesses during the course of the transaction. Finally, you will see how SQL Server processes transactions for In-Memory tables.
SessionID: 64229
Extended Events: What are they and How do I use them
Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Other
Speaker: Dave Bland
Title: Extended Events: What are they and How do I use them
Abstract:
Since Extended Events are replacing Profiler, 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!
SessionID: 67911
Set Me Up: How to Think in Sets
Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Database Administration - Beginner
Speaker: Brian Hansen
Title: Set Me Up: How to Think in Sets
Abstract:
SQL Server is optimized to work in sets, but this is certainly a paradigm shift for someone accustomed to row-by-row operations.
We will look at T-SQL features that can break set-based processing -- generally meaning poor performance -- and gather empirical evidence to support that assertion. We'll also look at some constructs to overcome these issues and make your T-SQL scripts run faster and use fewer resources.
SessionID: 68488
Navigating Modern BI Infrastructure – Power BI Report Server (On-
Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Business Intelligence Development
Speaker: George Bryant
Title: Navigating Modern BI Infrastructure – Power BI Report Server (On-
Abstract:
SessionID: 68978
How to Get Microsoft Certified
Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Professional Development
Speaker: John Deardurff
Title: How to Get Microsoft Certified
Abstract:
Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.
SessionID: 68984
Intro to Machine Learning
Event Date: 16-09-2017 - Session time: 14:00:00 - Track: Business Intelligence Development
Speaker: Jared Zagelbaum
Title: Intro to Machine Learning
Abstract:
Come to this session to get your toes wet with machine learning. What types of questions it can answer? What types of models it can produce? What are some 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: 67910
Visualize Your Transaction Log
Event Date: 16-09-2017 - Session time: 15:15:00 - Track: Database Administration - Beginner
Speaker: Brian Hansen
Title: Visualize Your Transaction Log
Abstract:
SessionID: 68139
Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)
Event Date: 16-09-2017 - Session time: 15:15:00 - Track: Database Administration - Advanced
Speaker: Ed Leighton-Dick
Title: Dammit Jim! Dr McCoy’s Field Guide to system_health (and the default trace)
Abstract:
SessionID: 69203
The PROCESS of Queries
Event Date: 16-09-2017 - Session time: 15:15:00 - Track: Database Administration - Beginner
Speaker: John Deardurff
Title: The PROCESS of Queries
Abstract:
This session is for the absolute beginner to learn the terminology and the PROCESS of queries. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss table structures and the differences between Heaps and Clustered Indexes. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses.
SessionID: 69204
Building Your First Data Warehouse
Event Date: 16-09-2017 - Session time: 15:15:00 - Track: Business Intelligence Development
Speaker: Jesse Seymour
Title: Building Your First Data Warehouse
Abstract:
Ever wonder about those mysterious databases that are full of data? Curious about what's inside, or how they are built? Follow along in this session as we build a data warehouse from scratch. Learn about fact tables, dimension tables, measures, and attributes as we work through a small data warehouse using Microsoft's newest sample database. In this beginner level session, we will talk about data warehouse concepts, build a small data warehouse with a fact table and several dimensions, and implement an ETL process using T-SQL and stored procedures.
SessionID: 69500
QA with SQL Experts
Event Date: 16-09-2017 - Session time: 15:15:00 - Track: Business Intelligence Development
Speaker: Krista Olson
Title: QA with SQL Experts
Abstract:
Come chat with our panel of SQL experts for an hour long QA session. From DBA 101 to advanced internals, any question is fair game!