Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type



Sessions Found: 33
Agile BI promises to deliver value much quicker to its end users. But how do you keep track of versions and prioritize all the demands users have? 

With Visual Studio Online (cloud version of Team Foundation Server) it is possible to start for free with 5 users, with Version Control, Work Item management and much more.

In my session you will get the directions to a quick start with Visual Studio Online.
You will learn the possibilities of Version Control and in which way to implement Scrum work item management with all available tools.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: September 26

Time: 4:00 PM - 5:00 PM

Room: Zaal 042

Data Science is hot. 
But what does it take to be a Data Scientist? And how do you get started?
This session will give you a brief introduction to Data Science. 
We’ll explore the steps involved to take on an analytical endeavour, and show how these concepts work with several demos.
Attend this session and discover what (Microsoft) tools and technologies you can use to extract value from (big) data!
This session will be co-presented by Maarten van Duren. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: September 26

Time: 9:00 AM - 10:00 AM

Room: Zaal D

Microsoft Azure Machine Learning (AML) changes the way we work with data and what knowledge and skills are required in order to predict outcome of future events.  AML is a comprehensive “drag, drop, predict” technology with all the benefits of the cloud.  The transfer of machine learning to the new platform with ability to use R programming language makes common machine learning tasks very simple for the different customers and academic community.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code:

Date: September 26

Time: 11:30 AM - 12:30 PM

Room: Zaal D

In the world of Data Platform a variety of solutions are available going from on premises, hybrid to cloud solutions. Database Administrators play a crucial role in application design and architecture, providing mission critical and highly available solutions. In this session you will learn everything a DBA needs to know about Azure. You’ll learn about SQL Server running in Windows Azure virtual machines, Azure Storage and network configurations, SQL Database and how to manage and support workloads running in a traditional, hybrid and cloud based environment. 
Become the DBA of the future!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: September 26

Time: 4:00 PM - 5:00 PM

Room: Zaal 040

Power pivot in Excel or SQL server have quite similar in user interfaces. Power pivot in SQL server has a lot more to offer, which you, as Excel user, will like. You prototype in Excel Power pivot, while bearing in mind you want to port your Excel power pivot model to SQL server Power pivot. There are best practices you should stick to in order to port without problems. This session will discuss the advantage and disadvantages of porting your Excel Power pivot model to SQL. After that the best practices in using formula, structuring Power pivot models and even before that how to look at your data will be showed. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: September 26

Time: 2:45 PM - 3:45 PM

Room: Zaal 042

As more enterprises start implementing big data solutions, how does the DBA support these efforts and do they have the skills and knowledge to integrate big data solutions into your current architecture and processes? This demo-filled session has two purposes; first, to help DBAs understand how to apply their existing SQL Server skills in understanding and utilizing HDInsight and related technologies. Big data technologies don’t need to be intimidating, and this session will help DBAs see how they can easily apply their current skill when working with big data. Second, this session will show how SQL Server and HDInsight be used together to create solutions to solve big data problems without the complexities of massive learning curves and using technologies DBAs are already familiar with. We’ll look at technologies that make working with big data much less daunting, including HiveQL and Sqoop, both of which don’t require a rocket science degree to use.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: September 26

Time: 10:15 AM - 11:15 AM

Room: Zaal D

Analyzing huge sets of data isn't something humans are made for. Humans are more suitable for making decisions based on things they can see. So how do you bring that into the business? One of the options you have is to visualize some of your (location based) data on maps. A feature for this in SQL Server is called spatial data (geo data). By using physical locations and shapes to visualize data, you can quickly analyze big sets of data.

In this session, we're going to take a look at how spatial data works, how you can query it, and how to use it to leverage your decision making process.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: September 26

Time: 10:15 AM - 11:15 AM

Room: Zaal 4

To compete with other vendors supplying mobile BI & dashboarding solutions, Datazen has entered the SQL Server BI stack.
In this session we will discover what it has to offer and what kind of effort is needed for publishing your very own dashboards.
We will go through local dashboards on Excel and evolve to a basic server setup with your dashboards published to mobile devices and SharePoint.
Let us guide you on your way to the future of mobile BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: September 26

Time: 1:30 PM - 2:30 PM

Room: Zaal 042

When you were young, did you enjoy taking things apart to look at their inner workings? If you did, or still do, this session might be just the thing for you! Combining SQL Server internals with our curiosity on how things work, we will take a look underneath the hood of SQL Server by debugging it.

In this session we will debug the various parts of SQL Server using WinDbg. I’ll show you how to setup, configure and use WinDbg to extract information from a running SQL Server process. We will take a look at the various dump files that record information when a SQL Server crash occurs, capturing valuable information on why SQL Server crashed. And finally, I will demonstrate how you can use Extended Events to create dump files when specific conditions occur, helping you learn more about why they occur.

Don't worry if you are not a programmer. We will go through this session at a relaxed pace without causing (too many) headaches!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Adminstration

Level: Advanced

Session Code:

Date: September 26

Time: 2:45 PM - 3:45 PM

Room: Zaal 2

While building of Tabular Models may be straight forward it rapidly becomes more complex when you steer off-piste and into more complex design pattern such as:
- Many to Many relationships
- Semi-Additive Measures
- Last Ever Non Empty
- Events in Progress
- Versioned Fact Tables
- Almost real time processing requirements
- Huge volume
- Non Star Schema Data Warehouses
- measure explosion and lack of calculated dimensions
- Selecting Hardware

This one hour session will walk through an actual case study of a tabular model and discuss the pain points we encountered on the way, along with solutions and workarounds.


Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: September 26

Time: 9:00 AM - 10:30 AM

Room: Zaal 042

Are you curious about the array of NoSQL technologies available in Azure, but aren't sure how they differ from each other or the relational models available? Or maybe you've got specific data in mind, but aren't sure which NoSQL technology is best for your application. 

Microsoft Azure supports a variety of NoSQL technologies (i.e. key/value, document, column and graph databases). In this session we walk through the options, explaining what each one provides. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Beginner

Session Code:

Date: September 26

Time: 1:30 PM - 2:30 PM

Room: Zaal D

So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:

•	Optimizing TempDB in an Azure VM
•	Reducing latency between application VMs and database VMs
•	Right sizing Azure VMs for performance and cost
•	Striping I/O across devices in Azure VMs
•	Performance Tuning in Azure DB

You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code:

Date: September 26

Time: 2:45 PM - 3:45 PM

Room: Zaal Rood

SQL DW is wederom een mijlpaal in de geschiedenis van SQL Server voor wat betreft schaalbaarheid: deze  Massive Parallel Processing (MPP) SQL Server  versie @ Cloud scale  biedt de mogelijkheid om binnen een minuut de rekenkracht en in-memory geheugencapaciteit met een factor 60x  op te schalen of in z’n geheel te pauzeren wanneer je de database even niet nodig hebt!   Tijdens deze presentatie krijg je via een boel live demo's snel een overzicht van de mogelijkheden van SQL DW inclusief antwoord op vragen  als: hoe werkt SQL DW en hoe begin ik hiermee? Hoe migreer ik m’n database naar SQL DW?  Hoe kan ik het beste data laden, via BCP of Polybase? En met welke dmv’s  kan ik SQLDW het beste monitoren ? 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 26

Time: 1:30 PM - 2:30 PM

Room: Zaal Rood

Azure DocumentDB is a new highly-scalable NoSQL database platform on Microsoft Azure, designed as a fully managed cloud service for modern web and mobile applications. Like other NoSQL platforms, DocumentDB supports schema-free designs, and scales across replicas with fast write performance and eventual consistency. But DocumentDB also offers several unique features that make it a compelling candidate for NoSQL scenarios, which you will learn about in this session. The platform is based on HTTP/REST, embraces JSON as a standard document format, and is supported by a wide range of SDKs for .NET, JavaScript, Java, Python, and Node.js. Without defining any index paths, new documents are queryable within milliseconds, using SQL grammar or LINQ. Learn these and other capabilities, including server-side JavaScript-based stored procedures, user-defined functions, triggers, tunable consistency, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code:

Date: September 26

Time: 2:45 PM - 3:45 PM

Room: Zaal D

The SQL Server Data Warehouse Fast Track (DWFT) program is designed to provide customers standard and proven system architectures optimized for a range of enterprise data warehousing needs. DWFT is a joint effort between Microsoft and many hardware partners. The goal is to help enterprise customers deploy Data Warehouse solutions with recommended hardware configuration appropriate for the requirements of the workload with reduced risk, cost and complexity.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: September 26

Time: 4:00 PM - 5:00 PM

Room: Zaal A

SQL Server has many moving parts with a massive amount of metrics that you can monitor to see how your system is performing, but which ones do you need to pay attention to, what do they mean and how do you interpret them? In this session we will look at the key areas of CPU, Memory and Storage, from performance counters to DMVs that you can use to check on the health of your server and gain insight into how it is performing. We will also look at some of the configuration options that exist which you can use to ensure that you have a healthy base on which to build.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Adminstration

Level: Advanced

Session Code:

Date: September 26

Time: 2:45 PM - 3:45 PM

Room: Zaal 040

This session will guide you with practical tips & tricks to move away from SQL Profiler and use Extended Events instead.
Extended Events were first introduced in SQL Server 2008 and should be used instead of the SQL Profiler. Still lots of DBA's and DEV's use SQL Profiler nowadays because of the convenience and lack of an Extended Events GUI in SQL 2008. 
Extended events however impose a minimal performance penalty on SQL Server and provides much more detailed tracing.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Beginner

Session Code:

Date: September 26

Time: 4:00 PM - 5:00 PM

Room: Zaal Rood

NB: This is part one of a two-part session
The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there?
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.
Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Advanced

Session Code:

Date: September 26

Time: 1:30 PM - 2:30 PM

Room: Zaal A

NB: This is part two of a two-part session
The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And there's nothing you can do about it. Or is there?
In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates.
Though the focus of this session is on understanding the cause of bad estimates, you will also learn ways to fix the problems and get better estimates - and hence, better performing queries.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Advanced

Session Code:

Date: September 26

Time: 2:45 PM - 3:45 PM

Room: Zaal A

In this session, we'll explore some of the things you should be looking at within your virtual environment to ensure that you are getting the best possible performance out of it. 

We will discuss how to look for CPU performance issues at the host level. We will also be looking at the Memory Balloon drivers and what they actually do, as well as how you should be configuring them and why.  

We will then talk about some of the memory sharing technologies which are built into vSphere and Hyper-V and how they relate to SQL Server, and we’ll finish up the session with some storage configuration options.

Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Adminstration

Level: Beginner

Session Code:

Date: September 26

Time: 10:15 AM - 11:15 AM

Room: Zaal 040

Sessions Found: 33
Back to Top