sqlsathistory

Nr: 366

Back to Main list

SQLSaturday #366 - Ottawa 2015

Start Time (24h) Speaker Track Title
09:00:00 Michelle Kamrat Gutzait Track 1 (DBA) Discover the performance hidden secrets with the Microsoft Performance Analysis of Logs (PAL) Tool
09:00:00 Phillip Labry Track 2 (BI) Interactive Data Visualizations in Power View
10:45:00 Christian Cote Track 2 (BI) Azure Data Factory concepts
10:45:00 Michael DeFehr Track 1 (DBA) Query Plans and Indexes in SQL Server
13:15:00 Damir Bersinic Track 1 (DBA) Best Practices for Fabric Configuration of SQL Server Workloads in Private Cloud Environments
13:15:00 Steve Simon Track 2 (BI) DAX and the tabular model
15:00:00 Murilo Miranda Track 1 (DBA) What a DBA need to know about In-Memory OLTP?
15:00:00 Paresh Motiwala Track 2 (BI) Setting up your BI Infrastructure
16:15:00 Edwin M Sarmiento Track 2 (BI) Configuring SharePoint 2013 as a BI Platform
16:15:00 Warner Chaves Track 1 (DBA) The Restore Cookbook

SessionID: 14865

Discover the performance hidden secrets with the Microsoft Performance Analysis of Logs (PAL) Tool

Back to calendar

Event Date: 25-04-2015 - Session time: 09:00:00 - Track: Track 1 (DBA)

Speaker: Michelle Kamrat Gutzait

Title: Discover the performance hidden secrets with the Microsoft Performance Analysis of Logs (PAL) Tool

Abstract:

Performance and tuning has always been a big and complex topic for DBAs, developers and users.

This session covers the Microsoft PAL tool report and how to easily find performance bottlenecks in your SQL Server environment.

SessionID: 22124

Interactive Data Visualizations in Power View

Back to calendar

Event Date: 25-04-2015 - Session time: 09:00:00 - Track: Track 2 (BI)

Speaker: Phillip Labry

Title: Interactive Data Visualizations in Power View

Abstract:

Power View is an interactive data exploration, reporting and presentation tool that is a pleasure for business people to use. It the one of the core building blocks of Power BI. In this session we will cover slicing, filtering, custom drill hierarchies, animated scatter plots, maps and more. You don't have to be a visualization expert to create beautiful and compelling visualizations.

SessionID: 11578

Azure Data Factory concepts

Back to calendar

Event Date: 25-04-2015 - Session time: 10:45:00 - Track: Track 2 (BI)

Speaker: Christian Cote

Title: Azure Data Factory concepts

Abstract:

Azure Data Factory is a new Service offered by Microsoft on Azure that can help you to manage your data on premise and in the clouds. This session will allow you to familiarize yourself with the different concepts and opportunities offered by the Azure Data Factory service.

SessionID: 19997

Query Plans and Indexes in SQL Server

Back to calendar

Event Date: 25-04-2015 - Session time: 10:45:00 - Track: Track 1 (DBA)

Speaker: Michael DeFehr

Title: Query Plans and Indexes in SQL Server

Abstract:

Data access can be easy to set up in your applications with wizards and ORMs, but sometimes your queries are just not as fast as you think they should be – especially on those tables that are getting bigger and bigger. In this session, we will take a peek under the hood and see how SQL server answers the questions you ask of it. This is an introductory session, but it will be jam-packed with demos and useful tips that you will be able to use to make your applications more responsive.

SessionID: 12146

Best Practices for Fabric Configuration of SQL Server Workloads in Private Cloud Environments

Back to calendar

Event Date: 25-04-2015 - Session time: 13:15:00 - Track: Track 1 (DBA)

Speaker: Damir Bersinic

Title: Best Practices for Fabric Configuration of SQL Server Workloads in Private Cloud Environments

Abstract:

As you migrate SQL Server workloads to a private cloud, many questions arise on how to best configure the virtualization host and virtual machines to get the best performance possible. Further, questions around how the physical architecture impacts to the virtual environment and vice versa need to be addressed in order to ensure the organization reaps the benefits of cloud computing.

In this session you will learn how to configure the four key fabric resources (CPU, memory, disk, and network) to enable best performance for your SQL Server workloads. We will also cover how to avoid the little "gotchas" that could really cause you headaches. Find out the impact of NUMA architecture on VM configuration, how to leverage storage capabilities in Windows Server 2012 R2 to enable robust performance, how SR-IOV and RDMA can help boost network performance, and much more. You will also learn how to extend your architecture to Microsoft Azure to allow for additional capabilities.

SessionID: 25590

DAX and the tabular model

Back to calendar

Event Date: 25-04-2015 - Session time: 13:15:00 - Track: Track 2 (BI)

Speaker: Steve Simon

Title: DAX and the tabular model

Abstract:

With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done, how to extract data from a tabular model using Data Analysis Expressions (DAX).

We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.

SessionID: 21200

What a DBA need to know about In-Memory OLTP?

Back to calendar

Event Date: 25-04-2015 - Session time: 15:00:00 - Track: Track 1 (DBA)

Speaker: Murilo Miranda

Title: What a DBA need to know about In-Memory OLTP?

Abstract:

A recent capability on SQL Server world, the In-Memory OLTP (aka Hekaton) is one of the most exciting features that came on SQL Server 2014 and promises a great performance improvement. On this session we will introduce this feature and discuss few topics as its architecture, high-availability, migration and other interesting topics for DBAs who want to better understand this new "beast".

SessionID: 21686

Setting up your BI Infrastructure

Back to calendar

Event Date: 25-04-2015 - Session time: 15:00:00 - Track: Track 2 (BI)

Speaker: Paresh Motiwala

Title: Setting up your BI Infrastructure

Abstract:

We know BI in bits and pieces. But imagine if you had to setup the BI infrastructure from scratch.

What do we need to consider, which players do we consider, what are the components, the HA/DR scenario for the same, what technology to use? These are the questions we will attempt to answer along the way. What are the best practices involved in creating a BI infrastructure. We can discuss whether to outsource this project or rise above our DBA job and do it ourselves.

SessionID: 13741

Configuring SharePoint 2013 as a BI Platform

Back to calendar

Event Date: 25-04-2015 - Session time: 16:15:00 - Track: Track 2 (BI)

Speaker: Edwin M Sarmiento

Title: Configuring SharePoint 2013 as a BI Platform

Abstract:

With SharePoint as the business collaboration platform of choice for the enterprise, it has become an important piece in the overall Microsoft BI stack. However, deploying and configuring it to support Microsoft BI solutions has become a cumbersome task for the IT professional.

In this session, you will learn what it takes to successfully architect and design SharePoint 2013 as a BI platform. We will cover multiple configuration scenarios and the different technologies necessary to build the infrastructure. At the end of the session, you can walk away feeling confident to run Power Pivot, Power View and Reporting Services in your SharePoint 2013 farm.

SessionID: 27638

The Restore Cookbook

Back to calendar

Event Date: 25-04-2015 - Session time: 16:15:00 - Track: Track 1 (DBA)

Speaker: Warner Chaves

Title: The Restore Cookbook

Abstract:

How do you restore a database that has lost a file? How do you recover from a lost transaction log? How do you get rid of corruption in the fastest time?

At some point in time, these and other destructive scenarios will happen to your databases. And people will look at you and expect you to react swiftly and confidently.

In this session we will demo these scenarios from disaster to resolution. Because if we are the guardians of our SQL Servers then we should all know these recipes.