SQLSaturday #487 - Ottawa 2016
Event Date: 04/16/2016 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: Time to Stretch: Scaling out and in with Azure DB Elastic Scale
Abstract: Elasticity is one of the main promises of cloud computing. The cloud has given us the ability to programmatically add or remove resources to an application and dynamically respond to our workload volume to allow for cost efficient, high performing solutions. However, achieving this elasticity in a transparent way can be a challenge in itself.
In particular, dynamically scaling the database tier can be difficult due to having to deal with distribution schemes, data movement, application routing and the actual increase or decrease of the database resources. Azure SQL Database and the Elastic Scale .NET API combine to provide a solution to these challenges in an easy to use but powerful set of capabilities.
In this session we will demo the elastic scale API, elastic db pools, elastic query and elastic database jobs and how they combine to bring database elasticity in your own application and take advantage of true cloud optimized infrastructure!
Speaker(s):
- Warner Chaves
Track and Room: Enterprise Database Administration Deployment - Room 1
Title: SQL Server 2016 Automation with PowerShell
Abstract: DBA’s are constantly faced with challenges in maintaining a healthy SQL Server environment. Monitoring our database servers, deploying database code changes and performing database restores are just a few examples of a day in the life of a DBA. As workloads increase, performing these tasks manually introduces more opportunity for human error and time starts to become our bottleneck. The only option if you want to stay above water is to become more efficient at what you do. Enter automation. Enter PowerShell.
Initially released in 2006, PowerShell has grown to become Microsoft’s premier scripting language on the Windows platform. This presentation will begin with a brief overview of the PowerShell language itself, but the primary focus will be on how to interface with SQL Server to help automate your database environment.
Speaker(s):
- Chris Sommer
Track and Room: Enterprise Database Administration Deployment - Room2
Title: Excel Power Map vs. Power BI Globe Map visualization
Abstract: You’ve crafted your geo data set in Power Query in Excel, then moved it to your Power Pivot model and joined with all other tables. Now you want to visualize your data points using Power Map in Excel or tempted to export your existing data model to Power BI and explore it using Power BI Globe custom visualization. Does Power BI Globe visualization replace the Power Map application in Excel? Can you explore your geo data facts sufficiently using the Power BI Globe only? And do Power BI Globe and Excel Power Map compete with each other or they’re just friends? Let’s try to explore this together.
Speaker(s):
- Rayis Imayev
Track and Room: Analytics and Visualization - Room2
Title: SQL Server 2016 New Features
Abstract: SQL Server 2016 New Features
Speaker(s):
- Edwin M Sarmiento
Track and Room: Advanced Analysis Techniques - Room 1
Title: UFC #1433 In-Memory tables 2014 vs. 2016
Abstract: In this session we will check the advantages of performance that In-Memory tables provides and how they evolved in SQL Server 2016. If you are planning to implement IN-Memory tables, check a performance comparison between 2014 and 2016, or just get to know how this technology works, this is the session you don#180;t want to miss. Let’s Get Ready To Rumble!!
Speaker(s):
- Alejandro Cordero
Track and Room: Application Database Development - Room 1
Title: DBA to Project Manager in 60 minutes flat
Abstract: As DBAs we are often stuck at the mercy of higher ups and Project Managers for completion of our assigned tasks/ projects. In this session we wil actually take an arbitrary application and its affiliated databases and go throught the tasks/resources needed to accomplish the task. We will think and act like a Project Manager and DBA rolled into one. This will surely help you advance your career within organization and help you think ahead of time.
Speaker(s):
- Paresh Motiwala
Track and Room: Professional Development - Room2
Title: SQL Server Integration Services 2016 (SSIS) novelties and Azure Integration
Abstract: SSIS has been around for the past decade and this 2016 version brings a lot a interesting features. This session will talk about SSIS 2016 and how it can now interact with Microsoft Azure HDInsight and storage.
Speaker(s):
- Christian Cote
Track and Room: Application Database Development - Room 1
Title: Analysis Services 2016 - Tabular Jumpstart
Abstract: Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization’s data. This is a demo heavy session and you should be able walk away knowing how to create your own tabular model.
Speaker(s):
- Phillip Labry
Track and Room: BI Platform Architecture, Development Administration - Room2
Title: SQL Server as a Cloud Service
Abstract: The war of the cloud providers continues and database services is one of the many arenas. These services provide a platform that reduces management by trading off detailed control of your underlying OS and hardware.
In this session we will do a comparison of the two most popular platforms for SQL Server: Amazon RDS and Azure SQL Database and explore the strengths and weaknesses of each one.
Speaker(s):
- Warner Chaves
Track and Room: Enterprise Database Administration Deployment - Room2
Title: TSQL Bullet-Dodging and Spoon-bending
Abstract: Did you think you could dodge bullets with SQL Server? Well, with some of these techniques, you won’t have to. Learn some of the newer language elements in SQL server: Recursive CTE’s, Composable DML, the MERGE statement, Row numbering and table-valued parameters. This fast-paced session that is almost exclusively demos is sure to leave you with a few ideas to make your TSQL development life easier.
Speaker(s):
- Michael DeFehr
Track and Room: Application Database Development - Room 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Alejandro Cordero
Twitter: - @ale_corderocr
LinkedIn: Alejandro Cordero
Contact: http://sqlturbo.com
DBA with Over 10 years of experience. Focused on SQL Server development , performance tuning, High Availability. Scrum Master Certified, MCTS, MCSA, Entrepreneur and Author at SQLTurbo.com. Currently working as technical leader for database consultants in Pythian Company.
Regular speaker at SQLSaturdays in Latin America ( Costa Rica, Guatemala, Colombia) and virtual chapters( In-Memory chapter, Spanish Chapter). Have presented in SQLSaturday Ottawa in Canada.
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.
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.
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.
Chris Sommer
Twitter: - @cjsommer
LinkedIn: Chris Sommer
Contact: http://www.cjsommer.com
Chris started in computing and I.T. in the mid to late 1990’s. After the dust had settled from Y2K, he found himself a bit more focused and working with database servers on the Unix platform. His first exposure to SQL Server was in 2007 and he has been working on that platform ever since. Chris is currently a Senior SQL DBA with a focus on reliability, stability and performance. He truly enjoys the building tools with PowerShell to help his fellow DBA#39;s manage their ever growing environment.
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).
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.
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
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.
Rayis Imayev
Twitter: - rayisimayev
LinkedIn: Rayis Imayev
Contact: http://datanrg.blogspot.ca/
Database professional with hands-on database design, data analysis, and reporting skills. I believe that I can help to make this intricate world of data to be more structured and well understood. Born in USSR; graduated and started my IT journey in Ukraine; now I work and live with my family in Toronto, Canada.
Sponsors
The following is a list of sponsors that helped fund the event: