Advanced Filters:
  • Track

    clear all















  • Speaker


  • Level


  • Session Type

Sessions Found: 18
SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over and over again. Handling metadata and schema changes is a manual process, and there are no easy ways to implement new requirements in multiple packages at the same time.

It is time to bring the Don't Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml and BimlScript to generate SSIS packages from database metadata and implement changes in all packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code. 

Speed up your SSIS development by using Biml and BimlScript, and see how you can complete in a day what once took more than a week!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: June 18

Time: 1:50 PM - 2:50 PM

Room: BI

Have you pulled a script to identify duplicates from a blog post, but couldn’t quite get it to work, because you weren’t sure what that ROW_NUMBER() function was doing. Maybe you heard talk about creating running totals without using sub-queries, but you got frustrated when the groups weren’t totaling correctly. Or maybe, you’ve never even heard of Window Functions. All are good reasons to attend this all-demo session which demystifies this versatile T-SQL tool. First, we’ll break apart the OVER clause, the key to understanding how window functions work. Then we’ll expand on each group of functions that can use the OVER clause: ranking, aggregate, and analytic functions. Finally, we’ll look at real scenarios where this tool works and talk about performance considerations. When you leave, you’ll have the fundamentals you need to fully develop your mastery of Window Functions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEVOPS

Level: Intermedia

Session Code:

Date: June 18

Time: 9:40 AM - 10:40 AM

Room: DEVOPS

Persistence of databases and crash recovery is a fundamental problem in systems research, particularly in database management systems, key-value stores, and file systems.
Crash recovery is hard to get right; as evidence ten-year gap between the release of commercial database products, System R and DB2 and the development of a working crash recovery algorithm. Even after it was invented, another five years passed before the algorithm was proven correct. 
Modern day Database owners and administrators have to navigate trough a horde of backup methodologies and false promises in order to preserve data. In this lecture we will cover many of the modern day database data protection technologies, and there pros and cons.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEVOPS

Level: Advanced

Session Code:

Date: June 18

Time: 12:40 PM - 1:40 PM

Room: DEVOPS

Azure offers many great tools and services, but how to they fit together and what are your options when trying to architect an end to end Azure BI platform?
We'll take a high level look at the available Azure services, discussing what their capabilities are and how they fit together. Covering Azure Data Factory, Data Lake, Table Storage, Blob Storage, U-SQL, HDInsight, SQL Data Warehouse, Machine Learning, Power BI, Event Hub, Stream Analytics and more.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: June 18

Time: 9:40 AM - 10:40 AM

Room: BI

The prevailing opinion is that the optimizations for SQL Server are usually only done on the server itself. But is there anything we can do on the client to gain more speed? In this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader() and SqlCommand.ExecuteNonQuery().
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DEVOPS

Level: Intermedia

Session Code:

Date: June 18

Time: 1:50 PM - 2:50 PM

Room: DEVOPS

One of the hardest things to do in SQL is to identify the cause of a sudden degradation in performance. The DMVs don’t persist information over a restart of the instance and, unless there was already some query benchmarking (and there almost never is), answering the question of how the queries behaved last week needs a time machine. Up until now, that is. The addition of the QueryStore to SQL Server 2016 makes identifying and resolving performance regressions a breeze.

In this session we’ll take a look at what the QueryStore is and how it works, before diving into a scenario where overall performance suddenly degraded, and we’ll see why QueryStore is the best new feature in SQL Server 2016, bar none.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: June 18

Time: 1:50 PM - 2:50 PM

Room: DBA

Like Frankenstein's Monster (or our teenagers) things get released into the wild and behave differently than planned - database usage patterns are no different.  Join Tim as he reviews what to look for when tweaking your index strategy: poor clustering key decisions, underutilized indexes, covering indexes gone wrong, overlooked heaps and fill factor failures are just a few of the blunders to be identified.  

A working knowledge of Dynamic Management Objects, indexing internals, and eagerness to experiment with metadata is a prerequisite!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: June 18

Time: 10:50 AM - 11:50 AM

Room: DBA

SQL Server is a high performance relational engine and provides a highly scalable database platform but due to its complexity (and bad programming practices) can be prone to serious concurrency problems, unexpected behaviors, lost updates and much more!
In SQL Server 2005, two optimistic concurrency mechanisms were introduced and touted as the solution to all our problems. Now in SQL Server 2012, 2014 and 2016 even more have followed, but many challenges and problems still remain.
Let’s take a long look into the world of SQL Server concurrency and investigate Pessimistic and Optimistic isolation understanding how they work, when you should use them, and more importantly when they can go very wrong. Don't be staring down the wrong end of SQL Server's two Smoking Barrels and join me for this revealing and thought provoking presentation.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: June 18

Time: 12:40 PM - 1:40 PM

Room: DBA

You've learnt the basics of cloud computing and taken a tour of Microsoft Azure. It's now time to take a deeper look at using Azure SQL Database.

In this presentation we will have wall to wall demos on creating, configuring, connecting, using, securing, monitoring, uploading, scheduling and syncing your SQL Azure database.

We will specifically cover
 
•Linked Servers
•Mobile App WebJobs
•Azure Automation
•Monitoring and Alerts
•Firewall Rules
•Dynamic Data Masking
•Always Encrypted
•Stretch Tables
•DACPACs and BACPACs
 
By the end of this sessions you will some way to becoming an Azure Jedi
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEVOPS

Level: Intermedia

Session Code:

Date: June 18

Time: 8:30 AM - 9:30 AM

Room: DEVOPS

If you like to visualize data in the Microsoft Data Platform you use the visualization power of Excel, Power BI or Reporting Services. With the integration of R a 4th force is approaching to help you achieving great visualization results in new ways. This session will help you with the basics of the R language, the integration and of course, applying visualization best practices to it. Base on live demos, we show how to start, what R libraries are useful, how to integrate R in your favorite reporting tools like SSRS or Power BI and what you need to apply corporate identity, manage code and a proper development life cycle. When you walk out of the session, you will think the 4th force is with you and gives you additional visualization super power for your job.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: June 18

Time: 12:40 PM - 1:40 PM

Room: BI

DataZEN? Reporting Services? Power BI? Third Party Tools?
If you apply Microsofts strategy Cloud First Mobile First to Microsoft BI you may wonder where you find the right direction on Mobile BI in this strategy. In the last years  the mobile part was somehow in the fog. This session will jump into the jungle of different approaches and will deliver a clear and understandable Matrix, when you should use what and how it may or may not meet your expectations. We will review the different toolsets under Self-Service and Corporate BI Standards and of course  we also check the mobile device shop to see, which offering fits best on the Hardware available.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: June 18

Time: 8:30 AM - 9:30 AM

Room: BI

The quickest way to migrate your on-premises OLTP database to Azure is to simply "Lift & Shift".
You create a vm in Azure and size it to match your local system and move your database into it.
This might not be the most cost effective way though and also, you still have to do all the
database maintenance yourself.
In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc. in order to truly scale
our system. And we'll see if this increases or lowers the total cost of ownership.
This excercise is about an OLTP system but we will also look at how it affects loading our DWH from this new setup.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: June 18

Time: 3:00 PM - 4:00 PM

Room: DBA

Since 2008 version Reporting Services was a product that didn't show significative enhancements, today it has several interesting novelties, a new Web Portal, Mobile Report Published, improved Report Builder, integration to pin reports in Power BI Dahsboards, Custom Parameter Panel, all these topics will we covered in this session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: June 18

Time: 3:00 PM - 4:00 PM

Room: BI

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL! 

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DEVOPS

Level: Intermedia

Session Code:

Date: June 18

Time: 3:00 PM - 4:00 PM

Room: DEVOPS

In this session will be shown how to obfuscate critical data in real time using Dynamic Data Masking, a new feature in SQL Server 2016, also will be covered two other topics, Always Encrypted, defined as Help to protect data at rest and in motion with the master key residing with the application avoiding application changes, because they are not required, finally Row-Level security that consists in set access control to table rows based on users rights.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: June 18

Time: 8:30 AM - 9:30 AM

Room: DBA

What if migrating SQL Server instances was as simple as executing a single command? 

In this presentation, I'll cover the reasons companies migrate, the ways SQL migrations are usually performed, and the considerations that must be made when performing a migration.

Then I'll show you how to use the PowerShell dbatools module to simplify your SQL Server migrations. dbatools makes migrating databases, logins, linked servers, credentials, jobs, database mail, and other essential SQL components extremely easy. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: June 18

Time: 9:40 AM - 10:40 AM

Room: DBA

Based on our work with converting an existing application to memory optimized tables and natively compiled stored procedures this session, will take you through this journey and show you the (large) gaps between what we have in our normal SQL belt and what is possible in Natively compiled stored procedures. I will show how to overcome all the gaps and get all out normal stuff to work in these monster fast procedures – even the things that the documentation says cannot be done.

You will therefore be taken through the concept of in-memory tables and what to be aware of when considering converting your database tables and code to In-Memory tables and through a life migration demo be given all the tips and tricks I picked up while doing so. After attending this session, you will be able to leverage on the new concepts and work your way around its current limitations to gain enormous speed increase and a lock-free environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DEVOPS

Level: Intermedia

Session Code:

Date: June 18

Time: 10:50 AM - 11:50 AM

Room: DEVOPS

In early 2015, Microsoft delivered a new Version of Power BI, Power BI 2.0. After publishing the new Version they kept publishing updates each month. At the end of 2015 Microsoft started to publish visualisations and data sources for Power BI each week. In this session, Data Platform MVP Frank Geisler will show all of the new Features. This will be done by creating a Dashboard live in the session which will analyze data from the Internet Movie Database.  
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI

Level: Beginner

Session Code:

Date: June 18

Time: 10:50 AM - 11:50 AM

Room: BI

Sessions Found: 18
SQLSaturday