Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type


Sessions Found: 28
As an experienced DBA you have probably asked yourself questions like how the memory is consumed, is my system well-tuned, and is my memory configuration well defined. In order to understanding such processes as local and global Memory pressure, caches concurrency, adding and removing plans from cache we will go through the internal organization of the plan cache, the metadata available, how SQL Server finds a plan in cache, plan cache sizing, and the plan eviction policy. We will point out the important cache consumers that affect your workload and how to get metadata about them, what are the thresholds in Cache Size Management. At the end you will understand how to monitor the memory consumers in your SQL Server, what are wait types that we need to look for, how to understand if your system is well-tuned and the memory configuration is well defined. You will have a clear understanding of cache plan problems and how to avoid them. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Advanced

Session Code:

Date: August 29

Time: 2:00 PM - 3:00 PM

Room: Room 4

With Microsofts recent aquisition of mobile analytics problems Datazen and subsequent free release for all enterprise customers, this mobile analytics tool is destined to soon become a must-know for any SQL Server BI professional. This session will, through a lot of demos, cover the basics; what the product is, when to use it, it's strengths and limitations, and how you can start 
creating your own impressive dashboards for mobile devices right away.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BI Analytics & Visualization

Level: Beginner

Session Code:

Date: August 29

Time: 2:00 PM - 3:00 PM

Room: Room 2

If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (nbi.codeplex.com). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We'll go a step further, generating the tests by an interesting system of templates and test-cases sources. 
Speaker:

Session Type:
Regular Session

Track:
BI Architecture & Development

Level: Intermedia

Session Code:

Date: August 29

Time: 9:00 AM - 10:00 AM

Room: Room 2

AlwaysOn Availability Groups provide an excellent way to build a High Availability platform with SQL Server at its core, however with these new capabilities come new and interesting maintenance requirements. In this session we will look at a number of the things you must do when making use of Availability Groups, and some of the things that you can do in order to ensure that you have a stable, reliable platform.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: August 29

Time: 11:40 AM - 12:40 PM

Room: Room 4

Machine learning makes it possible to analyse large amounts of data, and it opens the doors to new insight, operational efficiency, direct marketing and the ability to make qualified decisions about the future. The machine learning technology has been known for years, and now it's finally available, and easy to use, for everyone.
 
Come to my session to get an overview of the possibilities Azure Machine Learning enables, and to learn from some of the experience I've obtained working with different machine learning projects. As this is an intermediate session, we will be looking closer at some of the machine learning algorithms.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Analytics & Visualization

Level: Intermedia

Session Code:

Date: August 29

Time: 10:20 AM - 11:20 AM

Room: Room 2

Let's build a Powershell script together that will use Remoting to run whatever script you like in parallel on any number of servers. We'll talk about remoting, remoting across domains or even without, how to run scripts in the background and in parallel. I'll show you how to store the results and report on it across all your servers in one go.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: August 29

Time: 3:20 PM - 4:20 PM

Room: Room 4

Business Data Lakes - New architecture (and mindset) saves time and money 
How to support the business in their need for better analysis and create a modern architecture that accommodate for faster time to market, give true support to the business  needs at the same time as it reduce cost.
Imaging that you can give the business what they want in days rather than months! 
Speaker:

Session Type:
Regular Session

Track:
BI Architecture & Development

Level: Beginner

Session Code:

Date: August 29

Time: 11:40 AM - 12:40 PM

Room: Room 2

Azure Machine Learning
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (20 minutes)

Track:
Lunch with Sponsors

Level: Beginner

Session Code:

Date: August 29

Time: 1:00 PM - 1:20 PM

Room: Room 1

Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports.
In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data within the data warehouse to optimize it for cubes and MDX. We’ll see how adding functionality into the ETL layer and data warehouse can have a dramatic effect on the functionality and simplicity of the cube.
Speaker:

Session Type:
Regular Session

Track:
BI Architecture & Development

Level: Beginner

Session Code:

Date: August 29

Time: 9:00 AM - 10:00 AM

Room: Room 1

Indexes are incredibly powerful objects to optimize your database performance. However, when not implemented optimally, indexes can also have a negative impact on your queries! In this session we will take a close look at the different index types, how they work and how we can use that knowledge to design an efficient indexing strategy for your databases. We will also spend time analyzing existing indexes. Are those indexes being used? Can we combine indexes? Those are some of the questions you will learn to answer in this session.
Speaker:

Session Type:
Regular Session

Track:
Database Development

Level: Beginner

Session Code:

Date: August 29

Time: 11:40 AM - 12:40 PM

Room: Room 5

Risk assessment is becoming an integral part of many organizations. In order to do it successfully you need to do it regularly and consistently. You need to register the risk factors, the risks them self, evaluate them and then plan the actions required to mitigate them. Besides the registration you need to have compelling and easy reading reports that help managers quickly find how the assessment is going. The familiar Excel interface helps assessors register the risk factors and risks and then plan the actions. The solutions then uses Power Query to load data into PowerPivot without overwriting and the Power View to report the results. The results can then be monitored in Power BI. 

This method can easily transfer to any other data collection solution such as budgeting or incident registration
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BI Analytics & Visualization

Level: Intermedia

Session Code:

Date: August 29

Time: 9:00 AM - 10:00 AM

Room: Room 3

Never used SQL Server?
Do you know a little SQL (from MariaDB/MySQL, PostgreSQL, etc.)?
Do you have newbie questions about SQL Server that you're too ashamed to ask?
Here's your chance to learn all you need to know about SQL Server.
Session suited for developers and students (beginner level).
Speaker:

Session Type:
Regular Session

Track:
Database Development

Level: Beginner

Session Code:

Date: August 29

Time: 9:00 AM - 10:00 AM

Room: Room 5

DML is used in  most cases without thinking about the multiple operations for the db engine. This session will give a deep dive into the internal storage engine down to record level.After finishing the theory (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated.SEE, what a workload will be caused by a "forwarded record". What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Database Development

Level: Advanced

Session Code:

Date: August 29

Time: 3:20 PM - 4:20 PM

Room: Room 3

When loading a large amount of data, e.g. into your data warehouse, you want 
the data inserted into the table as fast as possible. You know you have to use bulk 
load, but what do you need to do to ensure that data is loaded as fast as possible? 

In this session, you will learn about the different methods for bulk loading data 
into your data warehouse; using SSIS, BCP and T-SQL. You will also learn what is 
happening behind the scene of minimal logged inserts, why they are so 
important when doing bulk load, and what is required to achieve a minimal 
footprint on the transaction log. 

And yes, there will be zombies!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Architecture & Development

Level: Advanced

Session Code:

Date: August 29

Time: 11:40 AM - 12:40 PM

Room: Room 1

Denne sesjonen tar for seg utfordringer rundt historikk-håndtering av data.
SSIS blir ofte slaktet i evalueringskriterier for ytelse, kompatibilitet og konfigurasjonsmuligheter når det gjelder denne viktige funksjonaliteten i et ETL verktøy.
I denne sesjonen vil vi vise at dette i høyeste grad er basert på foreldet og uriktig informasjon.
-          Kort om historiseringsmetodikker
o   Slowly changing dimensions
o   Relational (hybrid Kimball/Inmon models)
-          Teknikker for historikkhåndtering i Microsoft orienterte datavarehus
-          Praktiske eksempler med fordeler og ulemper
Speaker:

Accompanying Materials:

No material found.

Session Type:
Sponsor Session (20 minutes)

Track:
Lunch with Sponsors

Level: Beginner

Session Code:

Date: August 29

Time: 1:00 PM - 1:20 PM

Room: Room 2

Ever wondered what actually happens when a cube is “processed”, why it takes so long, how you can configure and optimise cube
 processing, or what strategies people commonly use for improving processing?

 This session provides a deep dive into cube processing
 for MOLAP, to help understand how it works and what you can
 do to work with it.

 Come to this session for a better understanding of how
 to configure, optimise and tune cube processing.

 Included in the session is case studies from our performance
 lab and some sample tools to analyse processing logs. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BI Architecture & Development

Level: Advanced

Session Code:

Date: August 29

Time: 10:20 AM - 11:20 AM

Room: Room 1

In-memory means blazingly fast, at least most of the time. 
But modeling for the xVelocity/Vertipaq engine is a completely different beast than modeling for your trusty multi-dimensional SSAS cubes.

Join me on a session of improving a malfunctioning PowerBI Excel sheet and pick up handy tips and tricks you will need to tune your xVelocity models. 

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI Architecture & Development

Level: Intermedia

Session Code:

Date: August 29

Time: 2:00 PM - 3:00 PM

Room: Room 1

Extended events are really useful for gathering information not available otherwise. However, compared to other technologies such as trace and event notifications, it seems to be lacking a way to react to the events as soon as they happen. In this session we will see how this is possible using the APIs and which new possibilities this approach enables. 
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: August 29

Time: 10:20 AM - 11:20 AM

Room: Room 3

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL! 

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: August 29

Time: 3:20 PM - 4:20 PM

Room: Room 5

Do you think that your data is not secured in the cloud? Is that one of the reasons for you to not migrate at least some workloads there? Things changed in the last few months in terms of Azure database security. In this session we will take a closer look at what the features Row Level Security(RLS) and Dynamic Data Masking can do for your business and how they can help you secure your data.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: August 29

Time: 9:00 AM - 10:00 AM

Room: Room 4

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