Nr: 794
SQLSaturday #794 - Oklahoma City 2018
SessionID: 82839
Are There Time Bombs in your SSIS Packages?
Event Date: 25-08-2018 - Session time: 09:45:00 - Track: Track 4
Speaker: Tim Mitchell
Title: Are There Time Bombs in your SSIS Packages?
Abstract:
In this session, we will explore some of the most common SSIS design patterns that are potentially more harmful than they first appear. From package configuration to control flow constraints, and data flow transformations to logging, we'll demonstrate what can go wrong and show some alternative designs to prevent these types of problems from developing into bigger issues.
SessionID: 83302
Beginning T-SQL
Event Date: 25-08-2018 - Session time: 09:45:00 - Track: Track 4
Speaker: Jennifer McCown
Title: Beginning T-SQL
Abstract:
If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
SessionID: 83561
SSMS Magic: Tips Tricks for Management Studio
Event Date: 25-08-2018 - Session time: 09:45:00 - Track: Track 4
Speaker: Caitlin Stewart
Title: SSMS Magic: Tips Tricks for Management Studio
Abstract:
You use SQL Server Management Studio every day, but do you really know all of the built in shortcuts? In this course we will go over some of the shortcuts to complete everyday operations, as well as look into some of the hidden functionality built into the software. You’ll learn tricks to help streamline your day-to-day work and we’ll take a look at some of the lesser known functionality.
SessionID: 83762
SQL Server Encryption
Event Date: 25-08-2018 - Session time: 09:45:00 - Track: Track 2
Speaker: Ben Miller
Title: SQL Server Encryption
Abstract:
Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. We will also go over how Always Encrypted works as well. Master the concepts of SQL Server Encryption when you are done with this session.
SessionID: 82648
A Rocket Scientist Perspective on Indexes
Event Date: 25-08-2018 - Session time: 11:15:00 - Track: Track 4
Speaker: Mike Byrd
Title: A Rocket Scientist Perspective on Indexes
Abstract:
SessionID: 82718
Get insights from data with Cognitive Services
Event Date: 25-08-2018 - Session time: 11:15:00 - Track: Track 4
Speaker: Shawn Weisfeld
Title: Get insights from data with Cognitive Services
Abstract:
How can you take advantage of Artificial Intelligence without being a data scientist? Cognitive Services allow you use Artificial Intelligence to enrich your data through simple API calls. In this session, we will demonstrate the Cognitive Services and brainstorm how we can apply these to our applications.
SessionID: 82836
Deep Dive into the SSIS Catalog
Event Date: 25-08-2018 - Session time: 11:15:00 - Track: Track 4
Speaker: Tim Mitchell
Title: Deep Dive into the SSIS Catalog
Abstract:
The SSIS catalog is one of the best-evolved features in the SQL Server Integration Services ecosystem. With integrated package storage, Windows ACL-like security settings, built-in logging, and many other features, the SSIS catalog has become an anchor for many ETL architectures. With all this complexity, it is important to understand the inner workings of the SSIS catalog to keep it running smoothly.
In this demo-heavy presentation, we will dive into the details of the SSIS catalog. We will start with a quick survey of catalog features, followed by an exploration of the moving parts (tables, views, and stored procedures) in the catalog database. We will also review the security capabilities in the catalog, and will discuss maintenance operations. Finally, we'll walk through the mechanics of deployment and execution, reviewing what happens under the covers during these operations.
SessionID: 83304
T-SQL's Hidden Support Feature
Event Date: 25-08-2018 - Session time: 11:15:00 - Track: Track 4
Speaker: Jennifer McCown
Title: T-SQL's Hidden Support Feature
Abstract:
In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.
SessionID: 85482
LUNCH: Simplifying SQL Data Protection by - Mike Fal
Event Date: 25-08-2018 - Session time: 12:30:00 - Track: Track 4
Speaker: William Barnes
Title: LUNCH: Simplifying SQL Data Protection by - Mike Fal
Abstract:
When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn't want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it's not about backing up, it's about going forward!
SessionID: 85483
LUNCH: Auditing your Enterprise with MinionWare By The Midnight DBAs
Event Date: 25-08-2018 - Session time: 12:30:00 - Track: Track 1
Speaker: William Barnes
Title: LUNCH: Auditing your Enterprise with MinionWare By The Midnight DBAs
Abstract:
This is a lunch session hosted by the Midnight DBAs!
SessionID: 85484
LUNCH: Introduction to Visual Analytics and Tableau-By Kent Sloan
Event Date: 25-08-2018 - Session time: 12:30:00 - Track: Track 1
Speaker: William Barnes
Title: LUNCH: Introduction to Visual Analytics and Tableau-By Kent Sloan
Abstract:
SessionID: 82627
"Real World" Examples on How to Load Data Warehouse Structures using SSIS
Event Date: 25-08-2018 - Session time: 13:45:00 - Track: Track 4
Speaker: Ryan Casey
Title: "Real World" Examples on How to Load Data Warehouse Structures using SSIS
Abstract:
"Real World" Examples on How to Load Data Warehouse Structures using SSIS
In this session we will discuss the value of a SSIS Framework, explore forward engineering benefits, and demonstrate SSIS design patterns on loading SQL structures when developing Data Warehouses, SSAS Cubes, and Power BI Analytics.
Live Demo SSIS Framework
Load Error Meta Data
Restart ability, Rollback, Reload Count
Master Load ID, LoadID, ExecutionID (SSISDB), Refresh
Package Sequencing and Signatures
Connections, Expressions, Parameters, Event Handlers
Alerting (SMTP), Error Flows (XML Destination Script)
Forward Engineering SQL Structures
Relationships, Primary Foreign Keys
Data Types, Nullability, Indexes
Demos for Multiple Design Patterns
Dimensions (Slowly Changing)
Facts (Inserts, Updates, Deletes)
Bridges / Snowflakes
SessionID: 82791
Finding root cause for unexplained Availability Group failover
Event Date: 25-08-2018 - Session time: 13:45:00 - Track: Track 2
Speaker: Trayce Jordan
Title: Finding root cause for unexplained Availability Group failover
Abstract:
SessionID: 83759
SQL Server PowerShell for the Beginner
Event Date: 25-08-2018 - Session time: 13:45:00 - Track: Track 2
Speaker: Ben Miller
Title: SQL Server PowerShell for the Beginner
Abstract:
Come on, PowerShell is all the rage and you have not even started looking into it. How productive can you actually be with PowerShell? This session will give you the jumpstart that you need to begin. This session will be focused on the DBA getting ramped up in the PowerShell world of SQL Server. PowerShell is everywhere and should not be ignored. Stop ignoring and join me for the beginning of your journey to really getting into how good you can get, using PowerShell and SQL Server together.
SessionID: 83772
SQL Server Security from the ground up
Event Date: 25-08-2018 - Session time: 13:45:00 - Track: Track 2
Speaker: Kenneth Fisher
Title: SQL Server Security from the ground up
Abstract:
In the modern age, data is a company's most valuable resource and, unfortunately, data crimes are common and laws to protect data are becoming more common and can have harsh punishments. Because of this, everyone that works with SQL Server should have a basic understanding of database security. Attend this session to learn the what, how, and why of database security. Learn what permissions, securables, and principals are. Learn how to manage database security. Most importantly, learn what the best practices are and why they are important. Your company's data is your responsibility, and after attending this session you can step up and keep it safe.
SessionID: 84078
Demystifying JSON in SQL Server
Event Date: 25-08-2018 - Session time: 13:45:00 - Track: Track 4
Speaker: Kristin Ferrier
Title: Demystifying JSON in SQL Server
Abstract:
SessionID: 85324
Intro Data Warehousing for the DBA\Dev: From “Stupid Data" to Star Schema
Event Date: 25-08-2018 - Session time: 13:45:00 - Track: Track 1
Speaker: Matthew Brimer
Title: Intro Data Warehousing for the DBA\Dev: From “Stupid Data" to Star Schema
Abstract:
Data Warehouses are expensive, right? I mean, companies charge hundreds of thousands of dollars to build them for you. We all know the hardest part is just getting started, in this session we will talk about general dimensional design, how to start modeling your schemas, and by the end of this session you will have built your first star schema.
SessionID: 82578
Event Date: 25-08-2018 - Session time: 15:15:00 - Track: Track 4
Speaker: John Wells
Abstract:
SessionID: 82649
Climbing the SQL Server Index B-Tree (from a user perspective)
Event Date: 25-08-2018 - Session time: 15:15:00 - Track: Track 4
Speaker: Mike Byrd
Title: Climbing the SQL Server Index B-Tree (from a user perspective)
Abstract:
• keep clustered index width small
• unique indexes perform better
• keep non-clustered index width small
• compressed indexes have fewer logical reads
This session dives down and looks at important items within index pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command to factually document index WOMs. The effect of row data compression on clustered and non-clustered indexes are also investigated. The demos will ascertain how the SQL Server® optimizer might use them and strive to gain some insight from a performance advantage.
The session is 80% demos. This presentation will propel the layman to a new level of index understanding.
Performance! That’s what we are all looking for. Blast off with this presentation.
SessionID: 82970
The Master Stored Procedure Workshop
Event Date: 25-08-2018 - Session time: 15:15:00 - Track: Track 4
Speaker: Sean McCown
Title: The Master Stored Procedure Workshop
Abstract:
Your job includes designing and writing stored procedures, but you haven’t had a lot of actual training on the subject, right? In a single day, we will show you how to write stored procedures from scratch, using the design advice we’ve accumulated in our combined 40 years of experience.
Here are a few of the things you’ll learn:
When and how to use stored procedures
The benefits and basics of contractual programming
How to write stored procedures from scratch
How to structure and organize stored procedures
Key techniques for ideal stored procedure management
Troubleshooting and debugging stored procedures
The session will be packed with tons of code examples, with plenty of labs to reinforce key concepts. Beginner and experienced T-SQL programmers both will walk away with a greater understanding of how to design, manage, and troubleshoot stored procedures. Join mefor one fun session of SQL Server programming!
SessionID: 83298
Querying Semistructured Data in Azure Data Lake with USQL
Event Date: 25-08-2018 - Session time: 15:15:00 - Track: Track 4
Speaker: Russel Loski
Title: Querying Semistructured Data in Azure Data Lake with USQL
Abstract:
Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.
SessionID: 84081
Agile Data Warehouse and ETL Design with Biml
Event Date: 25-08-2018 - Session time: 15:15:00 - Track: Track 4
Speaker: David Stein
Title: Agile Data Warehouse and ETL Design with Biml
Abstract: