SQLSaturday #487 - Ottawa 2016
SQL Server Integration Services 2016 (SSIS) novelties and Azure Integration
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
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.
SQL Server 2016 Automation with PowerShell
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
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.
SQL Server as a Cloud Service
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
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.
TSQL Bullet-Dodging and Spoon-bending
Event Date: 16-04-2016 - Session time: 10:45:00 - Track: Application Database Development
Speaker: Michael DeFehr
Title: TSQL Bullet-Dodging and Spoon-bending
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.
DBA to Project Manager in 60 minutes flat
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
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.
Time to Stretch: Scaling out and in with Azure DB Elastic Scale
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
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!
Excel Power Map vs. Power BI Globe Map visualization
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
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.
SQL Server 2016 New Features
Event Date: 16-04-2016 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
Speaker: Edwin M Sarmiento
Title: SQL Server 2016 New Features
SQL Server 2016 New Features
UFC #1433 In-Memory tables 2014 vs. 2016
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
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!!
Analysis Services 2016 - Tabular Jumpstart
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
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.