sqlsathistory

Nr: 487

SQLSaturday #487 - Ottawa 2016

Start Time (24h)	Speaker	Track	Title
09:15:00	Christian Cote	Application Database Development	SQL Server Integration Services 2016 (SSIS) novelties and Azure Integration
09:15:00	Chris Sommer	Enterprise Database Administration Deployment	SQL Server 2016 Automation with PowerShell
10:45:00	Warner Chaves	Enterprise Database Administration Deployment	SQL Server as a Cloud Service
10:45:00	Michael DeFehr	Application Database Development	TSQL Bullet-Dodging and Spoon-bending
13:15:00	Paresh Motiwala	Professional Development	DBA to Project Manager in 60 minutes flat
13:15:00	Warner Chaves	Enterprise Database Administration Deployment	Time to Stretch: Scaling out and in with Azure DB Elastic Scale
14:30:00	Rayis Imayev	Analytics and Visualization	Excel Power Map vs. Power BI Globe Map visualization
14:30:00	Edwin M Sarmiento	Advanced Analysis Techniques	SQL Server 2016 New Features
16:00:00	Alejandro Cordero	Application Database Development	UFC #1433 In-Memory tables 2014 vs. 2016
16:00:00	Phillip Labry	BI Platform Architecture, Development Administration	Analysis Services 2016 - Tabular Jumpstart

SessionID: 41441

SQL Server Integration Services 2016 (SSIS) novelties and Azure Integration

Back to calendar

Event Date: 16-04-2016 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Christian Cote

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.

SessionID: 46185

SQL Server 2016 Automation with PowerShell

Back to calendar

Event Date: 16-04-2016 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Sommer

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.

SessionID: 42249

SQL Server as a Cloud Service

Back to calendar

Event Date: 16-04-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Warner Chaves

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.

SessionID: 44731

TSQL Bullet-Dodging and Spoon-bending

Back to calendar

Event Date: 16-04-2016 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Michael DeFehr

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.

SessionID: 41419

DBA to Project Manager in 60 minutes flat

Back to calendar

Event Date: 16-04-2016 - Session time: 13:15:00 - Track: Professional Development

Speaker: Paresh Motiwala

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.

SessionID: 42252

Time to Stretch: Scaling out and in with Azure DB Elastic Scale

Back to calendar

Event Date: 16-04-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Warner Chaves

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!

SessionID: 46476

Excel Power Map vs. Power BI Globe Map visualization

Back to calendar

Event Date: 16-04-2016 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Rayis Imayev

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.

SessionID: 47205

SQL Server 2016 New Features

Back to calendar

Event Date: 16-04-2016 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Edwin M Sarmiento

Title: SQL Server 2016 New Features

Abstract:

SQL Server 2016 New Features

SessionID: 42508

UFC #1433 In-Memory tables 2014 vs. 2016

Back to calendar

Event Date: 16-04-2016 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Alejandro Cordero

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!!

SessionID: 44265

Analysis Services 2016 - Tabular Jumpstart

Back to calendar

Event Date: 16-04-2016 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Phillip Labry

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.

This site is open source. Improve this page.