Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 24
When I joined runtastic.com to build their very first centralized data warehouse with Microsoft SQL Server, no one really felt in charge of the server – so the responsibility fell into my humble hands. Besides my duties as a business intelligence architect (designing & implementing the database, ETL & cube), I had to quickly come up with a solution for the most important administrative tasks:
•	Disaster Recovery and Failover
•	Database Maintenance
•	Capacity Management
•	Job & Performance Monitoring
In this session I will invite you to discuss the pros & cons of the solutions I came up with and you will leave the session with helpful concepts and scripts which you can use freely.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 15

Time: 5:00 PM - 6:00 PM

Room: Room Enterprise (fl.3)

During this session we will talk about Azure Search - full-text search engine provided to us via SaaS model. The main advantage of this service is not only that is fully managed by Microsoft, scalable, reliable and all other cloud related stuff. It is more about numerous data sources you can use to populate your search indexes. Also, because you use HTTP to work with Azure Search, you can easily use it not only within your desktop or web applications, but also you can easily consume it in your mobile applications, IoT solutions, etc.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: October 15

Time: 2:15 PM - 3:15 PM

Room: Room Enterprise (fl.3)

Have you heard about Azure SQL DWH? Do you want to move your current DWH into the Cloud? Can I use Azure SQL DWH like my regular DWH on-premise?
In this session I'm going to answer on these questions. Also, I will prodive information where is better to use Azure SQL DWH and what is more important, how to use it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: October 15

Time: 2:15 PM - 3:15 PM

Room: Room New (fl.1)

R is the world's most widely-used programming language for data analysis. Despite being the most popular, R suffers from lack of scalability and being slow. 
In this demo heavy session I will introduce you to the fundamentals of Microsoft R Server, it’s native file format XDF (eXternal Data Frame), data analytics and manipulation  functions, as well to scalable machine learning algorithms. 
Don’t miss the opportunity to see how MRS addresses open source R scalability and performance issues.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: October 15

Time: 10:00 AM - 11:00 AM

Room: Room Ultimate (fl.2)

In order to ascertain the abilities of cloud computing platform, let us overview what is available & offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: October 15

Time: 10:00 AM - 11:00 AM

Room: Room Enterprise (fl.3)

SQL Server 2016 has major enhancements to existing features as well as brand new ones that will contribute to making SQL Server implementations more highly available. 
This two-part session will cover not only what is in SQL Server 2016, such as all of the improvements to availability groups like seeding and basic AGs, but important Windows Server 2016 features like site awareness, storage replica, and more that all DBAs should be aware of. With this extended session, most of what will be discussed will be shown so you can see how they work. The session is based on practical scenarios from a customer’s implementation. We will start with requirements list and will end up with an implemented solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 15

Time: 1:00 PM - 2:00 PM

Room: Room Ultimate (fl.2)

SQL Server 2016 has major enhancements to existing features as well as brand new ones that will contribute to making SQL Server implementations more highly available. 
This two-part session will cover not only what is in SQL Server 2016, such as all of the improvements to availability groups like seeding and basic AGs, but important Windows Server 2016 features like site awareness, storage replica, and more that all DBAs should be aware of. With this extended session, most of what will be discussed will be shown so you can see how they work. The session is based on practical scenarios from a customer’s implementation. We will start with requirements list and will end up with an implemented solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 15

Time: 2:15 PM - 3:15 PM

Room: Room Ultimate (fl.2)

This talk will introduce you to the world of real time apps.
Nowadays with the help of advanced SDKs like SignalR, real time apps are almost trivial to create and are the ones that provide the "Wow!" factor to our clients.
Having real time capabilities in your application is important, can solve you big problems and users gradually start taking them for a given.
You will learn how to create an app that magically updates its data and of course some nice tricks about SignalR and SQL Server.
Cool demos are guaranteed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: October 15

Time: 2:15 PM - 3:15 PM

Room: Room Meetings (fl.1)

R is coming to SQL Server. SQL Server 2016 includes new real-time analytics, automatic data encryption, and the ability to run R within the database itself. For deeper insights into data, SQL Server 2016 expands its scope beyond transaction processing, data warehousing and business intelligence to deliver advanced analytics as an additional workload in SQL Server with proven technology from Revolution Analytics.  Microsoft SQL Server team want to make advanced analytics more accessible and also to increase performance for your advanced analytic workloads by bringing R processing closer to the data and building advanced analytic capabilities right into SQL Server. With this update, data scientists will no longer need to extract data from SQL server via ODBC to analyze it with R. Instead, you will be able to take your R code to the data, where is will be run inside a sandbox process within SQL Server itself. This eliminates the time and storage required to move the data, and gives you al
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: October 15

Time: 1:00 PM - 2:00 PM

Room: Room Meetings (fl.1)

EF Core is the new (.NET Core) version of Entity Framework on which the team have started working from scratch. 

It represents a lightweight and extensible version of the popular Entity Framework data access technology.
EF Core supports many database engines (SQLite, MSSQL, Posgre, MySQL, SQL Server Compact, IBM Data Servers and Oracle (soon)).

We'll talk about what's in the v1.0 release, and what is still planned. We'll look into some interesting demos as well (C#).
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 15

Time: 11:15 AM - 12:15 PM

Room: Room Enterprise (fl.3)

In an enterprise, merging master data, like customer data, from multiple sources is a common problem. Typically, you do not have a single, i.e. the same key identifying a customer in different sources. You have to match data based on similarity of strings, like names and addresses. In this session, we are going to check how different algorithms for comparing strings included in SQL Server  work. We are going to use four different algorithms that come with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services. Finally, we are going to introduce how SQL Server Data Quality Services help us here.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: October 15

Time: 3:45 PM - 4:45 PM

Room: Room Ultimate (fl.2)

Do you still prefer troubleshooting issues using SQL Server Profiler, because you find Extended Events too complicated? Or is it because you have never used Extended Events before, or it was in the dark ages of 2008 and your love for XML wasn’t strong enough to make you use them? The good news are that the recent versions of SQL Server give you a nice UI and made it all as user friendly as possible. The bad news are that you have no excuse anymore to not use them! Join this session to learn the basics of SQL Server Extended Events. You will see example use cases that could make your life easier and will learn how to troubleshoot issues in a modern and efficient way.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: October 15

Time: 3:45 PM - 4:45 PM

Room: Room New (fl.1)

This talk is a parallel, between IoT solutions, based on premise and systems, build with Microsoft Azure components. The presentation will cover the architecture, technology stack, implementation and best practices. We will consider plusses and deltas in different cases, using both approaches. You will see also many demos, which will help you to build own cloud based or on premises Internet of Things systems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: October 15

Time: 11:15 AM - 12:15 PM

Room: Room Meetings (fl.1)

-	Going through mountains of different methods and approaches to better understanding DWH loading. 
-	Show how to use standard components in Microsoft SSIS. 
-	Loading extremely fast data into DWH with components that we can develop or we can use. 
-	Better understanding of architecture of loading.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Advanced

Session Code:

Date: October 15

Time: 1:00 PM - 2:00 PM

Room: Room New (fl.1)

Database queries have their own life. Sometimes it is not so long but for sure it is a fascinating one.
Come join me in a session where we will be chasing a wild query thru the SQL Server engine. Or at least put a DB Administrator on the interrogation table.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 15

Time: 5:00 PM - 6:00 PM

Room: Room New (fl.1)

The best SQL ServerMigration Strategies
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: October 15

Time: 5:00 PM - 6:00 PM

Room: Room Meetings (fl.1)

In SQL Server 2016 (currently availabe as a preview) Microsoft added support for mobile reports to Reporting Services.
They also released the Mobile Report Publisher for authoring and creation of mobile reports. This application is based on Datazen technology, a company that Microsoft acquired in 2015.
As Microsoft stated, using only one mobile BI app users will access dashboards and reports on mobile devices.

Now developers must choose a tool  for developing BI optimized for mobile devices: SSRS,  Mobile Report Publisher (former Datazen) or Power BI? The question is: which one to choose? What are the key factor for supporting the correct decision? 
We will provide a clear and understandable overview of each product, highlighting strengths and weaknesses.
Based on some real examples we will set out a comparison matrix to find the best way to meet your needs with the right mobile reporting tool. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: October 15

Time: 11:15 AM - 12:15 PM

Room: Room New (fl.1)

Alongside with all other features SQL 2016 now natively supports JSON – one of the most common formats for data exchange. SQL 2016 now has built-in capabilities to query, analyze, exchange and transform JSON data. 
JSON functionality is quite similar to SQL XML support  but despite this being one of the most desired additions to SQL 2016 there is a flavour of something missing – the JSON data type. 
In this session we will talk about JSON support features, limitations and some tricks to overcome these.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: October 15

Time: 3:45 PM - 4:45 PM

Room: Room Meetings (fl.1)

The Columnstore Indexes technology has been subjected to a number of important improvements, including updateable nonclustered columnstore indexes, columnstore indexes on in-memory tables, and many more new features for operational analytics. In this session we will show this evolution, from the beginnings until today's state of the art.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 15

Time: 10:00 AM - 11:00 AM

Room: Room New (fl.1)

SQL Server is full of misunderstood features and misnomers that could affect how it is operating and respectively our applications. If you do not want to be surprised in a bad way by some intended, but not widely known SQL functionalities, join me in this session where we will, in an entertaining way, examine some of the most common behaviors that you probably have not expected.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: October 15

Time: 10:00 AM - 11:00 AM

Room: Room Meetings (fl.1)

Sessions Found: 24
SQLSaturday