Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 16
Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. Free statistical package / language R is also useful for the text mining tasks. Azure ML is adding additional techniques to the big picture. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with the tools mentioned.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: November 28

Time: 4:15 PM - 5:15 PM

Room: Room 2 (65 seats)

Azure Stream Analytics targets complex event streams (CEP’s) to deduce meaningful patterns. Most of the typical use cases for this product is when various devices and sensors are sending data for further processing.

This technology uses a T-SQL like syntax to express its intents. A language that most data-power users will be familiar with.

The biggest advantage of Stream Analytics is when events are being published to the Stream Analytics, the only thing that event publishers needs to know is which Event Bus or Blob storage to place the data. Stream Analytics will then fetch the data.

This talk is about the main concepts and solution architecture when using Azure Stream Analytics, and also how to use this technology together with MS SQL Server, Azure SQL Database and Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: November 28

Time: 5:30 PM - 6:30 PM

Room: Room 2 (65 seats)

High availability starts at database design. This session will show how to design your database supporting partial database availability. 
Session agenda is the follwoing:
- What is RPO/RTO?
- What HA options are available?
- Database physical layout basics
- DEMO: files and filegroups
- Multiple filegroups and files
- Filegroup/file restore options
- DEMO: online restore
- DEMO: Auto Page repair in AAG and DBM
- DEMO: offline restore (if time permits)



Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: November 28

Time: 10:30 AM - 11:30 AM

Room: Room 1 (55 seats)

Or IoT for DBAs
And we are not talking about Oracle Index Organized Tables, we are talking about Internet of Things. This buzzword you hear almost everywhere, and for sure needs databases. So let’s take the Microsoft vision of IoT and see the database side of it. We will talk about the vision of IoT and the real world practicalities of it. The presentation goal is to provide a DBA all he/she needs to know to support an IoT application.  And to make you curious we will cover topics such SQL 2014 for Embedded Systems or the Azure offerings (and their SQL connections), and I will try full demos with IoT hardware.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 28

Time: 5:30 PM - 6:30 PM

Room: Room 1 (55 seats)

Cesto velike kompanije imaju BI alate (Cognos, SAS, Informatica Tableau,…) koji kao izvor koriste MS SQL Server. Kako optimizovati dimanzionu bazu podataka na MS SQL Server 2012/2014 tako da se ona može podjednako dobro koristiti kao ROLAP za ad hoc izveštavanje kao i za izvodenje promenljivih za potrebe data mining-a? Na ovom predavanju bice prikazano kako koristiti funkcionalnosti MS SQL Server 2012/2014 kao što su Column Stored Index, Sequence objekat, SUM() OVER() za racunanje running totala, particionisanje, kompresija,… Takode, na predavanju ce biti prikazano kako upravljati rastom dimenzione baze.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: November 28

Time: 11:45 AM - 12:45 PM

Room: Room 1 (55 seats)

SQL Server transaction log is one of the most critical components of the database and in the same time one of the most misunderstood. While being neglected it can easily become a bottleneck for our system. Are you interested in learning how to avoid issues with the transaction log and streamline its work? In these sessions we will explore how to optimize it, configure it and keep it under control.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: November 28

Time: 3:00 PM - 4:00 PM

Room: Room 1 (55 seats)

SQL Server 2014 introduces Extreme Transaction Processing, a brand new memory-optimized data management feature, targetting OLTP workloads. In this session you will learn about two new, and not very well known, features that you can use to share sets of data between modules - either within the database, or between client applications and databases:
- Memory-optimized Table Variables; and
- Memory-optimized Table-valued Parameters.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: November 28

Time: 1:45 PM - 2:45 PM

Room: Room 1 (55 seats)

Microsoft SQL Server 2016 alloows you to run analytic queries on in-memory and disk-based OLTP tables with minimal impact on business critical OLTP workloads, requiring no application changes. This session covers various configurations and best practices for achieving significant performance gains with Operational Analytics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 28

Time: 10:30 AM - 11:30 AM

Room: Room 2 (65 seats)

SQL Server indexing is an art. Choosing the right index for the right solution might just not be enough. Options are also without boundaries, but still there are several rules you must always apply to design an effective indexing strategy. Join me in this session and find out about these rules, how the SQL Server optimizer chooses an index and most importantly - is your index useful enough or is just a burden to your database. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: November 28

Time: 3:00 PM - 4:00 PM

Room: Room 2 (65 seats)

Temporal tables are defined in the SQL 2011 standard and now transactional (system-versioned) temporary tables are included in Azure SQL Database and SQL Server 2016.

In this session we'll explain why we need them, how system-time tables work and demonstraint how to design and implement solutions for common use cases that involve temporal tables...
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: November 28

Time: 1:45 PM - 2:45 PM

Room: Room 2 (65 seats)

You can stretch your legs and relax and get a quick session on delivering your analytics against hot, warm & cold data. Stretch Database is the new concept, which allows you to stretch from on-prem to cloud easily and this session will enable you to understand enabling / disabling data stretch, accessing data using stretch database, setup remote data archiving, basic concepts on enabling database/table and backup & restore for the stretch enabled databases. Stretch DB also covers the concepts of Shallow & Deep backups. However, Deep backups are not currently supported with SQL Server 2016 CTP2.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: November 28

Time: 9:15 AM - 10:15 AM

Room: Room 1 (55 seats)

Proper design of cubes, dimensions, hierarchies and attributes is critical to optimal performance of SQL Server Analysis Services solutions.

I've collected a number of best practices during the years I've spent on building and maintaining OLAP cubes. In this session, we will go through the most important ten of these, so you can consider them in your everyday work when you build analytical back-end solutions with SSAS. Join this session, and see how these tips and best practices can save your precious time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: November 28

Time: 9:15 AM - 10:15 AM

Room: Room 2 (65 seats)

We're all familiar with reports or dashboards that show you a static snapshot of the data
that has to be refreshed on an interval. And those are very important visualizations.
But sometimes you just have to have a real time view of your data streams and snapshots aren't enough.
What if you could monitor multiple servers with SQL Trace or Extended Events or had some other source of streaming data and 
be able to see it all happening live on a central monitoring website?
This is a scenario we'll take a detailed look at and build a system for such monitoring.
We'll do this by using Extended Events .Net provider to get the live data stream, 
SignalR to get the live stream from the server to the website and the D3 javaScript library 
for actual real time visualizations on any device.
After seeing all this in action, you'll definitely get a few ideas on where you could use this in your company.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: November 28

Time: 4:15 PM - 5:15 PM

Room: Room 1 (55 seats)

Keynote session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: November 28

Time: 9:00 AM - 10:00 AM

Room: Room 1 (55 seats)

Welcome Note
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: November 28

Time: 9:00 AM - 10:00 AM

Room: Room 2 (65 seats)

We'll walk through how to detect and repair corruption in a database. 
The DBCC command is the most important part and its output will be covered.
The different methods to repair the pages gives different amounts of data loss, so we'll go through some of your options such as page level restore, DBCC repair options and some other options. 
Finally you'll learn to estimate how much data loss you can expect. We'll even going to see how to look at the corrupt page with DBCC PAGE to try to see approximately what data we are going to loose.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: November 28

Time: 11:45 AM - 12:45 PM

Room: Room 2 (65 seats)

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