Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 26
Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.

Afraid of PowerShell? 
Worried its too complicated?
Don't want to go through the learning curve?

Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday

Want to restore an entire servers databases to the latest available point in time of the backups in just one line?
Be useful to know the Last DBCC Check for your entire estate in only one line of code?
Need to test your restores but its complicated?
and many many more
All this in a fast paced, fun session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 09

Time: 10:45 AM - 11:45 AM

Room: Room1

In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB.  There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 09

Time: 3:45 PM - 4:45 PM

Room: Room1

Azure SQL Data Warehouse is a massively parallel, cloud-based relational data warehouse-as-a-service (PaaS). In this session you will learn more about what ASDW is and how it scales to handle your enterprise workload. The session also discusses ASDW’s place in the Microsoft’s Intelligence Suite of services including, how the data is loaded in (Azure Data Factory), how we can learn from the data (Machine Learning) and how we can analyse and visualise the data (Power BI)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 09

Time: 11:45 AM - 12:45 PM

Room: Room3

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 09

Time: 10:45 AM - 11:45 AM

Room: Room3

Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can't use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching  and so on. In this session, I'm going to cover several tips and tricks how we can handle with this limitations using available possibilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 09

Time: 8:30 AM - 9:30 AM

Room: Room3

Popularized by Bitcoin, now with Ethereum & Co already at least in version 2.x. 
What is technically behind the ominous blockchain, what does it have to do with databases and data warehousing? Are smart contracts only interesting for the financiers? And why should you program contracts? In the first part of this session, we deliver the background, and not just technically.

In the second part we take a closer look at the Bitcoin Blockchain as a "database". Starting point here: How anonymous really is the whole thing, when everything must be visible to everyone? After a brief introduction to its structure, we load the blockchain of bitcoin (that is, all the transactions that have been done so far) into Neo4J, a graph database and look what analyzes are possible (and why does a Graph DB work better here? And why aren’t we using the new exciting Graph stuff of SQL Server 2017???) Visualization and further analysis we do with Power BI, directly connected to Neo4j.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 09

Time: 11:45 AM - 12:45 PM

Room: Room4

In this session Mary Fealty @Br0adtree will take you through her personal review of Power BI by looking back at the many updates there have seen since it’s launch
She will give us a walk through of the many updates to Power BI and will demo some of the more recent additions.
It's a fun session that demonstrates the pace at which the Power BI team at Microsoft continue to deliver improvements to an amazing piece of software.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 09

Time: 8:30 AM - 9:30 AM

Room: Room2

Data Science, it really is easier than you think. 
You’re a DBA or BI Developer?
You don’t have time to become an expert in R or Python?
You’re sick of these data science sessions that assume everyone knows statistics?
Using demo’s in SQL Server 2017 ML Services, I’ll share my experience applying Machine Learning experiments as both a DBA and BI Developer.
This way you’ll finally see how easy it can actually be to build and bring a Machine Learning experiment to production.
I’ll share good practices you should apply to make your job easier and will guide you through the end to end process using Microsoft’s Team Data Science Process.
That way you'll also have all the practical knowledge you need to do this yourself.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: June 09

Time: 1:30 PM - 2:30 PM

Room: Room3

SQL Server 2017 extends Business Intelligence tools from previous versions. This is an exciting time for the Business Intelligence Professional, with new tools for the Data Visualization toolbox including R, Python and Power BI. In this session, we will have an overview of these tools and learn 'what to use, when' so that you have a blueprint for your Business Intelligence strategy, using SQL Serve 2017 as the supporting technology.

Takeaways:
- SQL Server Reporting Services (SSRS) has been given the love it deserves
- Learn the latest about SSRS and Power BI
- See the new capabilities for SQL Server Analysis Services
- Learn R in SQL Server for the purposes of building intelligent applications to drive action

Join this session to get the inside scoop on SQL Server 2017 from the Business Intelligence perspective.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 09

Time: 10:45 AM - 11:45 AM

Room: Room2

There are fundamentally two ways to source control and deploy your databases. Either you source control the desired state/model and let software work out the upgrade scripts or you source control your upgrade scripts and run them in sequence.

Which is better? Well, that question has a tendency to divide the room.
 
I'm irritated whenever I go to a "how to do database DevOps" session and the speaker presents just one as "the right way", perhaps referring to the other as "the wrong way". Like most things, it depends.
 
I'll illustrate the limitations of each approach with a simple scenario. I'll describe which projects are better suited to a model or a migrations approach. I'll also discuss whether it's possible to get the best of both worlds.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 09

Time: 10:45 AM - 11:45 AM

Room: Room4

In this session, we’ll see in detail how to create nodes and edges tables designed for graphs traversal in SQL Server 2017. After a summary of the underlying graph theory and its implementation in databases, we’ll see how to create graph tables in SQL Server 2017, and how to query them with the match operator. This session will give you a kickstart on using graphs in SQL Server 2017.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 09

Time: 3:45 PM - 4:45 PM

Room: Room2

Abstract: Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 09

Time: 9:30 AM - 10:30 AM

Room: Room1

Not only does Enterprise Data Warehousing success depend on the right technology, the right Data Architecture and supporting processes also need to be in place.
 
The Data Modelling life cycle necessitates solid foundation stones, from maintained Glossaries & Data Dictionaries, to Data Stewardship and Master and Reference Data Management, to ensuring regulatory compliance and Business buy-in of all of the above.

This session will cover:

- End to End EDW delivery from a Data Architectural perspective
- The Data modelling lifecycle, data consolidation and the value of auditing the process
- Business Data Lineage vs. Technical Data Lineage
- How to select the right Data Modelling tool for you
- The pro’s and con’s of off the shelf data models v.s. a blank canvas approach
- Release management
- Regulatory compliance including BCBS 239 and GDPR
- The EDW Methodologies throw down
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: June 09

Time: 2:30 PM - 3:30 PM

Room: Room3

All welcome! These short (5-10 mins) are a quick and fun way of getting up to speed on various data-related technologies. Email sqlsaturday742@sqlsaturday.com if you have an idea for a talk.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: June 09

Time: 1:30 PM - 2:30 PM

Room: Room4

Partitioning has been available in SQL Server since 2005 but there can be a lot of misconceptions around it.
This session will give attendees a refresher through partitioning concepts and the implementation of those concepts through live demos.

Topics covered will be: -
Partitioning definition
Partitioning key
Indexing considerations
Overview of partitioning functions and schemes
Table design considerations
Splitting and merging partitions
Switching data
Implementing sliding windows
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 09

Time: 3:45 PM - 4:45 PM

Room: Room3

The concurrency model of most Relational Database Systems are defined by the ACID properties but as they aim for ever increasing transactional throughput, those rules are bent, ignored, or even broken.

In this session, we will investigate how SQL Server implements transactional durability in order to understand how Delayed Durability bends the rules to remove transactional bottlenecks and achieve improved throughput. We will take a look at how this can be used to compliment In-Memory OLTP performance, and how it might impact or compromise other things.

Attend this session and you will be assimilated!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 09

Time: 8:30 AM - 9:30 AM

Room: Room1

This session guides you through important considerations for deploying your own Power BI Infrastructure on site.
Topic covered are:
- Architecture and Scalability
- Selecting Hardware and Capacity Planning
- Service Account Planning
- Configuring and Testing Kerberos
- Configuring Office online integration
- Licensing
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 09

Time: 11:45 AM - 12:45 PM

Room: Room1

With todays features within PowerShell developers are able to create the most advanced functions imaginable.

We're talking about multiple functions interacting with each other, parameter validation, pipelines, use of the -WhatIf, modules, classes etc.

If you're someone who wants to learn more to upgrade your current scripts to advanced functions, come to my session. I'll show you in a couple of easy steps how a simple script can be turned into something beautiful. 

Have you written a couple of scripts but want to get them to the next level. Than you'll want to attend this session and we'll see how far the rabbit hole goes.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 09

Time: 2:30 PM - 3:30 PM

Room: Room4

The Query Editor is possibly the most underutilised tool in Power BI Desktop. People are often more fascinated in the pretty visuals and Dashboard reporting, rather than the data transformations that take place before any of this is even possible. The Query Editor enables us to carry out a vast array of data manipulations, but often at a cost. If the transformations are not structured and ordered properly, we can find ourselves watching them complete in what feels like an eternity.

So, how can we speed up data transformations in Power BI and in turn, enhance the capabilities of the Query Editor? The answer is Query Folding. This technique takes the processing strain away from Power BI and the machine you are developing on, instead using the greater capabilities from where the data is sourced.

The 1 hour session will explain Query Folding in more detail, give examples of where/when it can be used and tips of how to get transformations to perform at their best.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: June 09

Time: 2:30 PM - 3:30 PM

Room: Room2

R is actually a really nice, practical language that you can use to do ETL and reporting. You can do it for free and you don’t even need a Coursera course in stats to be able to use it. In this talk, we’re going to look at how we can get started using R for reporting.

We’ll look at building dashboards, from connecting to our database, wrangling our data, to presenting good looking charts back to the user.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: June 09

Time: 2:30 PM - 3:30 PM

Room: Room1

Sessions Found: 26
Back to Top cage-aids
cage-aids
cage-aids
cage-aids