SQLSaturday #366 - Ottawa 2015

Event Date: 04/25/2015 00:00:00

Event Location:

  • Microsoft Ottawa
  • 100 Queen St, Suite 500
  • Ottawa, Ontario, Canada

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

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.


  • Damir Bersinic

Track and Room: Track 1 (DBA) - Room - DBA

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.


  • Warner Chaves

Track and Room: Track 1 (DBA) - Room - DBA

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.


  • Michelle Kamrat Gutzait

Track and Room: Track 1 (DBA) - Room - DBA

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.


  • Edwin M Sarmiento

Track and Room: Track 2 (BI) - Room - BI

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.


  • Michael DeFehr

Track and Room: Track 1 (DBA) - Room - DBA

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.


  • Steve Simon

Track and Room: Track 2 (BI) - Room - BI

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.


  • Paresh Motiwala

Track and Room: Track 2 (BI) - Room - BI

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.


  • Phillip Labry

Track and Room: Track 2 (BI) - Room - BI

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”.


  • Murilo Miranda

Track and Room: Track 1 (DBA) - Room - DBA

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.


  • Christian Cote

Track and Room: Track 2 (BI) - Room - BI


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Michelle Kamrat Gutzait

Contact: http://www.pythian.com/experts/

With greater than 25 years of IT experience, Michelle has worked exclusively with SQL Server for the past 15+ years. She has designed methodologies that consist of documentation, utilities, and scripts to automate architecture, design, and performance tuning initiatives for her clients. Michelle is able to see the wider vision of her clients’ business. She is passionate about solving problems quickly and providing value to her clients. She speaks English, Hebrew, Spanish and a lot of T-SQL!!

Damir Bersinic

Contact: http://about.me/damirb

Damir Bersinic is a Core Infrastructure Architect at the Microsoft Technology Center in Canada. He is passionate about showing customers the benefits Microsoft’s private, public, and hybrid cloud technologies to allow them to grow their ability to respond to business pressures with agility and confidence.

Murilo Miranda

Twitter: - murilocmiranda

LinkedIn: Murilo Miranda

Murilo Miranda is a blogger, speaker and SQL Server MVP from Portugal. Nowadays he#39;s a Cloud Operations Engineer at DataStax. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.

Warner Chaves

Twitter: - @warchav

LinkedIn: Warner Chaves

Contact: http://sqlturbo.com

Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.

Phillip Labry

Twitter: - @philliplabry

Contact: http://phillip.labry.com

Phillip Labry is a Senior BI Consultant and Trainer with over 20 years experience in SQL Server and over 30 in IT. He has been lucky enough to work on data projects spanning telecom, banking, retail, law enforcement, health care, insurance, financial services and energy sectors. As a national consultant he provides training and builds solutions utilizing the full MS BI stack. He is an active member of the Madison, WI PASS chapter and speaks at events in the USA and Canada.

Edwin M Sarmiento

Twitter: - EdwinMSarmiento

LinkedIn: Edwin M Sarmiento

Contact: http://www.EdwinMSarmiento.com

Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.

Steve Simon

Twitter: - SQLServerBoffin

LinkedIn: Steve Simon

Contact: http://www.sqlservercentral.com/blogs/simon_says/

Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com

Michael DeFehr

Twitter: - @mdefehr

LinkedIn: Michael DeFehr

Contact: http://mikedefehr.com

Michael DeFehr is an independent SQL Server consultant based in Winnipeg, Canada. He is focused on database administration and development using Microsoft SQL Server. A SQL Server MVP, Professional Engineer and MCITP in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity.

Paresh Motiwala

Twitter: - pareshmotiwala

LinkedIn: Paresh Motiwala

Contact: https://pareshmotiwala.wordpress.com/wp-admin/post.php?post=2amp;action=editamp;message=6amp;postpost=v2

Paresh Motiwala a Azure/Big Data enthusiast, Manager of Database Platform teams has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He has also been a Sr. SQL DBA and a Solutions Architect in Fortune 100 companies. He helps/organizes and speaks at many SQLSaturdays, Azure Bootcamp, Azure Datafests and User Groups(Boston BI UG, NESQL, PASS PD VG and PASS DBA VG).

He is certified in Big Data Analytics, FinTech, PMP, Public Speaking, Business Communications. He is a avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills and mentors children around the globe via www.circlesofgrowth.com

Christian Cote

Twitter: - Christian_SQL

LinkedIn: Christian Cote

Contact: http://bi-blogger.typepad.com/

Christian Coté is an IT professional with more than 15 years of experience working in data warehouse and business intelligence projects. Christian developed an expertise in data warehousing over the years and designed many ETL/BI processes using a range of tools on multiple platforms. He’s been presenting at several conferences and code camps. He currently co-leads the SQL Server PASS chapter in Montreal as well as Global French SQL PASS Chapter. He is also a Microsoft Data Platform Most Valuable Professional (MVP).


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page