SQLSaturday #366 - Ottawa 2015
Event Date: 04/25/2015 00:00:00
Event Location:
- Microsoft Ottawa
- 100 Queen St, Suite 500
- Ottawa, Ontario, Canada
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).
Sessions
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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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.
Speaker(s):
- 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”.
Speaker(s):
- 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.
Speaker(s):
- Christian Cote
Track and Room: Track 2 (BI) - Room - BI
Speakers
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
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).
Sponsors
The following is a list of sponsors that helped fund the event: