Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 12
Exploring and analyzing typical industry problem - from detecting a problem, finding a solution and deploying the statistical and machine learning algorithm. 
Session will be focusing on exploring the data, testing and validating the statistical and machine learning models and how to use them and consume them in production.
Using SQL Server Machine Learning stack and exploring with T-SQL code, R or Python code and using proprietary tools, packages for continuous deployment of your solution in enterprise environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: September 22

Time: 2:00 PM - 3:00 PM

Room: Buisiness Intelligence

See how we can finally run SSIS on Azure with ADF V2 and go for 100% BI solutions in PAAS since there is no need anymore to have Virtual Machines).
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 22

Time: 9:00 AM - 10:00 AM

Room: Buisiness Intelligence

Continuous Integration (CI) and Continuous Deployment (CD) are well used methods in modern software engineering approaches and can help reduce workload, risks and therefore costs significantly. But Business Intelligence projects and amongst those especially Analysis Services projects offer certain challenges to the appliance of those methods. Comprehensive support by software vendors is definitely not given. So if you want to integrate those methods into your application life-cycle management (ALM) you probably will need to build your own solution. We will shortly recap definition and advantages of CI and CD. After a short analysis of the special challenges for BI projects we will dive into possible approaches. And let's try to find out if cloud services can be of significant importance.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: September 22

Time: 3:15 PM - 4:15 PM

Room: Buisiness Intelligence

On average Microsoft releases a new version SQL Server every two years. Not all customers are able to upgrade their BI Infrastructure (SSDE, SSIS, SSAS – Multidimensional & Tabular, SSRS, Sharepoint, etc.) to every new version sometimes skipping some versions all together.

In this session, I will share the knowledge acquired migrating the BI Infrastructure of a Financial Institution from SQL Server 2008 R2 and SQL Server 2012 (< 10%) to SQL Server 2016.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 22

Time: 11:45 AM - 12:45 PM

Room: Buisiness Intelligence

Testing a Data Warehouse (DW) is so important as in other IT solutions, however, we often left it to the business users without a technical background that are not able to validate this complex and huge structure. Moreover, we should anticipate technical issues as early as possible before delivering it for other people to test. In this session, we will discuss which type of SQL queries we can use during development/unit test phases to ensure that data has been transformed and loaded properly to the DW.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 22

Time: 4:45 PM - 5:45 PM

Room: Buisiness Intelligence

Come round to talk about DevOps, Continuous Deployment and Application Lifecycle Management (ALM) and delivery of Microsoft Business Intelligence (BI) Applications, including Database for Data Warehouse, Analysis Services and SSRS! You will learn how to manage and deploy a full stack BI solution with Team Foundation Server (TFS). I will share my view of end-to-end architecture of MS BI ALM and practical tips on how to make it happen with TFS toolkit, with specific examples for every MS BI project type. The presentation will also compare features of TFS and RedGate for Database deployment. I will show a demo of continuous deployment for a typical BI project using TFS. The material does not assume prior knowledge of TFS administration, but some experience using Visual Studio database projects and general TFS terminology will be helpful.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 22

Time: 10:30 AM - 11:30 AM

Room: Buisiness Intelligence

Working as a DBA, I came across some creepy things in what comes to database user (abusive) rights! 
From users that were database owners, simply because they had to be able to truncate tables and read/write data to users that were Sysadmin because they needed to Bulk Insert into one table in one database!!!!
Yes... Creepy things as I said!
This is a very sensitive and (sadly) common issue, so in this session I'll be speaking about Permissions Management and demonstrate how we can address it in the best way, i.e. giving the necessary permissions without incurring into the risk of compromising the security of an entire database or SQL Server instance!
I will also show how easily this can be done ;)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 22

Time: 4:45 PM - 5:45 PM

Room: DBA & DEV

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:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 22

Time: 10:30 AM - 11:30 AM

Room: DBA & DEV

Query Store is referred to as the "flight data recorder" for SQL Server because it tracks query information over time – including the text, the plan, and execution statistics. The addition of wait statistics information – tracked for each query plan – in SQL Server 2017 makes Query Store a tool that every data professional needs to know how to use, whether you're new to troubleshooting or someone who's been doing it for years. When you include the new Automatic Tuning capabilities in SQL Server 2017 and Azure SQL Database, suddenly it seems like you might spend less time fighting fires and more time enjoying a lunch break that’s not at your desk. In this session, we'll talk through these new features - and see them in action - so you can understand how you can immediately start to use them once you’ve upgraded to SQL Server 2017.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 22

Time: 3:15 PM - 4:15 PM

Room: DBA & DEV

Extended Events provide deep insight into SQL Server's behavior and allow us to gather information not available by other means. However, compared to other technologies such as SQL Trace and Event Notifications, Extended Events don't seem to provide a way to react to the events as soon as they happen.

In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems, such as capturing and notifying deadlocks or blocking sessions. We will also offer a different approach to analyzing captured events, without shredding XML files.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 22

Time: 11:45 AM - 12:45 PM

Room: DBA & DEV

Service Broker is one of that features that every DBA knows that exists but just few of them uses, and these feature is awesome for some use cases.
In this session I will show you where Service Broker can be very useful, how to configure and to solve the common errors.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 22

Time: 2:00 PM - 3:00 PM

Room: DBA & DEV

On PASS Summit 2017 Microsoft revealed a new tool for managing and developing SQL Server: SQL Operations Studio. In his demo packed session German Data Platform MVP Frank Geisler will show how to use SQL Operations Studio, what is new compared with SQL Server Management Studio and he will show what capabilites this tool has not only to develop SQL Server Solutions but also how to monitor a SQL Server with Operations Studio. By the way: One of the biggest advantages is that SQL Operations Studio is not only available for Windows but also for Mac and for Linux.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 22

Time: 9:00 AM - 10:00 AM

Room: DBA & DEV

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