Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type


Sessions Found: 24
Do you know your data?

Let's go on a journey into the mountains of data and see if we can reach the peak!

What instruments will we use on this journey and how will we transform our data to help ourselves make the right decisions?
Be prepared to see transformations of your data from a different point of view with the latest technology in this field, the Tabular Data Model. In this presentation, we will cover the main features of the Tabular Data Model, the usage of the standard reporting package, some useful applications / utilization through Share Point and exciting new features of Excel. We are enthusiastic facilitators of knowledge sharing, idea brainstorming, training and mentoring in the MS area of expertise. We are sure you will enjoy this presentation to the fullest and will get the maximum of useful tips for your everyday work!

Will you accept the challenge...?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI&Programing

Level: Intermedia

Session Code:

Date: October 10

Time: 5:15 PM - 6:15 PM

Room: B

Any data that we have today is delivered to end users as reports and dashboards.

=> When it is more than 50 reports, 10 departments, 300 users, how to manage the department categories by folders, reports, users, groups & security?
=> What are the techniques to implement linked reports, subscriptions, report history, snapshot options?
=> How to edit reports using browser based Report Builder and reuse some of the report parts?
=> How to build a report that is very simple to use but has advanced capabilities?
=> How do I see the subscription information that stores data in XML format within ReportServer database?
=> How to take ownership of a deployed report(s) using T-SQL and is it healthy modifying the data using T-SQL directly on the DB?

There are plenty of things that we can do with Reporting services, Report Manager and you can find answers for all above questions in this session.

This session also helps you identify the performance bottleneck in poor performing SSRS s
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI&Programing

Level: Intermedia

Session Code:

Date: October 10

Time: 11:30 AM - 12:30 PM

Room: D

Indexes are important! They can make your life easy, but they can be a huge performance killer. No matter your role - DBA or DEV, you need to design effective indexing strategy and most importantly - know if those indexes are really effective. SQL Server gives you number of possibilities to track the use of your indexes and suggest you new ones. But what else we need to be careful for? How to keep our SQL Server in proper index shape? Join me for this one-hour session where we will have real fun on indexes and I promise you, you will leave with plenty of ideas for improving your index environment!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Advanced

Session Code:

Date: October 10

Time: 11:30 AM - 12:30 PM

Room: B

ADF provides a managed way to orchestrate the collection, movement and transformation of structured and semi-structured data together. It works both with on-premises and cloud data and it has - of course - a powershell interface, enabling you to manage it without the bling of the Azure portal. But is it useful, is it fast, is it easy and powerful to use ? And most of all is Azure Data Factory  the new SSIS ?
These are some of the questions that might arise, when reading about this new PaaS and that we will answer together in this demo packed session where will we go through orchestration, consumption and administration of data through the ADF pipeline. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Intermedia

Session Code:

Date: October 10

Time: 11:30 AM - 12:30 PM

Room: C

Backup and Recovery are some of the most important DBA tasks. All in all it is the data that matters and having an optimized backup strategy and a great recovery plan will save your day! Let's dive into the basics and the tips and tricks you will need to optimize your SQL Server backups and restores.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: October 10

Time: 5:15 PM - 6:15 PM

Room: D

SQL Server 2016 brings the topic "in-memory" to a new level. Not that previous versions did not hold as much as data as possible inside of memory through caching, but now we enter a new era: in-memory row stores, in-memory column stores and compiled stored procedures are different from what we have seen so far. In this session, you will see how you can leverage those new features and how you can come by existing limitations. Come back to office with the knowledge how to boost the performance of your ETL, queries and reports into the new era.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI&Programing

Level: Intermedia

Session Code:

Date: October 10

Time: 2:30 PM - 3:30 PM

Room: C

Keep your DBAs happy. Sounds like an impossible task ? In this session we are going to walkthrough different scenarios based on the interaction between SSDT and Team Foundation Server. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will walkthrough several scenarios to get an idea of what works when and what doesn’t. At the end of this session you will be able to know how to get the best out of TFS and where the limitations are. You will also be able to pinpoint several other solutions for doing Continuous Integration with SSDT without compromising the flexibility.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database development

Level: Intermedia

Session Code:

Date: October 10

Time: 4:00 PM - 5:00 PM

Room: A

An overview of Data Science in cloud
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Beginner

Session Code:

Date: October 10

Time: 5:15 PM - 6:15 PM

Room: C

Azure SQL Datawarehouse is the latest SQL related cloud service, Microsoft released in Preview. It uses Microsoft’s massive parallel processing (MPP) architecture where you pay for time-to-insight, not hardware, based on performance objectives for fundamental data warehousing operations like scanning, loading, and query processing. Quickly deployable, it is definitely one of the services that will change the gear in the datawarehoue world. Join me in the session where I will provide a quick overview of the service and show you how easily you can migrate and start using it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure

Level: Intermedia

Session Code:

Date: October 10

Time: 4:00 PM - 5:00 PM

Room: C

Can ETL be fun? Unfortunately, very often creation of ETL layer is time-consuming, tedious, error-prone task. What’s more, any change in requirement needs most of the work to be redone. In our session we’ll present new approach to creating BI solutions using Biml language and Mist programming environment. They greatly simplify the process, allowing for amazing flexibility, and make the ETL work more pleasant. We will show real examples of how Biml and C# generates hundreds of usable SSIS packages in just couple of minutes. We will also cover integration of ETL with TFS and CI for ETL. Everything with 100% compatibility with unmodified SQL Server. Join us and see how BI just became fun again
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database development

Level: Beginner

Session Code:

Date: October 10

Time: 10:15 AM - 11:15 AM

Room: A

The topic of SQL Server concurrency is for sure one of the most complex ones in the field. Locking, blocking, timeouts and performance issues are just some of the consequences of not choosing the proper isolation level for our applications. In this demo-intensive session we will not only talk, but actually go deep into optimistic concurrency and the two isolation levels it offers to us - Read Committed Snapshot and Snapshot isolation level. We will see how they work, how much they can help for the performance and scalability of our applications and what are the little gotchas we need to be aware of.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: October 10

Time: 2:30 PM - 3:30 PM

Room: B

The session will show how to prepare cool reports with Excel and publish them to Office 365.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI&Programing

Level: Intermedia

Session Code:

Date: October 10

Time: 10:15 AM - 11:15 AM

Room: D

SQL Server 2014 is full of new features and improvements. Some of them are "Killer" features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight. In this session we will talk in details about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and more features will be covered in this session.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database development

Level: Advanced

Session Code:

Date: October 10

Time: 5:15 PM - 6:15 PM

Room: A

In this presentation we will start with description of the Data Mining Process, then we will Introduce the Microsoft Time Series Algorithm for Forecasting. Then we will demonstrate production of forecast by: SQL Server Data Tools (SSDT) Project. And we will show how to implement complete process as part of your application by using ADOMD on real data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI&Programing

Level: Advanced

Session Code:

Date: October 10

Time: 2:30 PM - 3:30 PM

Room: D

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:
Azure

Level: Intermedia

Session Code:

Date: October 10

Time: 10:15 AM - 11:15 AM

Room: C

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:
BI&Programing

Level: Intermedia

Session Code:

Date: October 10

Time: 1:15 PM - 2:15 PM

Room: B

Make your business happy with well performing databases. To master these approaches you are responsible for well performing indexes which may not harm the daily business of your customers. With a handy toolset of common database management objects (DMO) you can become the superstar in your SQL Server team. Impress your team members when you detect common indexing issues like a pro with dmo's.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: October 10

Time: 10:15 AM - 11:15 AM

Room: B

We will present in this  session the concept of the transaction log, its importance and the roles it plays inside the database engine. We will look at how logging and recovery works, the checkpoint process, write-ahead logging, and steps we need to perform as a DBA to ensure proper management of the transaction log for a SQL Server database.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: October 10

Time: 1:15 PM - 2:15 PM

Room: D

Pies are definitely fine for dessert :-) – but sometimes also used for reports, even if their real use case is very narrow. Do you want deliver information in an effective and efficient way? Do you think, this is crucial for you a business’ success? Even when attractiveness of a report is important, beauty is in the eye of the beholder. Research shows that we can help end-users to understand the message of the data quickly by following some simple rules. You will see how you can implement those rules with Microsoft Excel's Tables and Charts and the Power View add-on – ending up with effective and efficient information delivering through beautiful dashboards. You will learn how to identify suboptimal dashboards and what you can do to improve them.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI&Programing

Level: Intermedia

Session Code:

Date: October 10

Time: 4:00 PM - 5:00 PM

Room: D

In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database development

Level: Intermedia

Session Code:

Date: October 10

Time: 11:30 AM - 12:30 PM

Room: A

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