Nr: 607
SQLSaturday #607 - Calgary 2017
SessionID: 57446
PowerQuery Tips and Tricks for Power BI
Event Date: 29-04-2017 - Session time: 09:30:00 - Track: Other
Speaker: Rushabh Mehta
Title: PowerQuery Tips and Tricks for Power BI
Abstract:
In this session, we will first learn how to expose organizational data using the data management gateway to Power BI. We will then look at how to use PowerQuery to acquire and cleanse data from organizational and external sources. As part of the session, we will also look at some tips and tricks to facilitate data acquisition and cleansing.
SessionID: 62989
Secrets of SQL Server - Database Worst Practices
Event Date: 29-04-2017 - Session time: 09:30:00 - Track: Application Database Development
Speaker: Pinal Dave
Title: Secrets of SQL Server - Database Worst Practices
Abstract:
“OMG! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
SessionID: 57436
SQL Server on Linux - The How, the What and the Why?
Event Date: 29-04-2017 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Patrick Flynn
Title: SQL Server on Linux - The How, the What and the Why?
Abstract:
In this Demo Heavy Session we will explore the recently released SQL Server on Linux
Join me as we try to understand questions like?
How do we install and run SQL Server on Linux?
What is different, what is the same?
What may be better? What might be worse?
Why would it be useful?
What new skills will you need?
The presentation will be based around experience gained in evaluating the Public CTP and will help introduce you into the brave new world of SQL Server on Linux
SessionID: 61057
SQL Server Security Enhancements
Event Date: 29-04-2017 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Mohit Gupta
Title: SQL Server Security Enhancements
Abstract:
Microsoft SQL Server 2016 introduced multiple new security enhancements that can help make your environment more secure. In this session we will cover these options and brief demo on how they are implemented.
SessionID: 63403
Using Models as the Blueprints for Enterprise Data Governance
Event Date: 29-04-2017 - Session time: 12:00:00 - Track: Strategy and Architecture
Speaker: Ron Huizenga
Title: Using Models as the Blueprints for Enterprise Data Governance
Abstract:
Data governance is becoming increasingly important to corporations who must demonstrate compliance to industry and corporate regulations. This is occurring against a backdrop of continuously evolving technology, an explosion of diverse data sources, and exponential growth in volume. Data professionals are tasked with ensuring data quality, enforcing data security, tracking model changes, and complying with audits. We will discuss a practical, model-based approach to enterprise data governance, with a focus on Master Data Management (MDM).
SessionID: 57702
Event Date: 29-04-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Patrick Flynn
Abstract:
Interested in being able to manage, monitor and document your SQL Environment from a single location? Want to be able to produce modern interactive reports and dashboards that can be viewed on both desktop and mobile devices?
By adding a little "Power" to your DBA toolkit you can!
By combining PowerShell and PowerBi with the more traditional DBA tools I will show how to query and document your entire environment and produce rich interactive reports that can be consumed by all levels of your organisation.
This is a constantly evolving Presentation based around latest features in PowerBI and PowerShell
SessionID: 62990
Performance in 60 Seconds - SQL Tricks Everybody MUST Know
Event Date: 29-04-2017 - Session time: 13:00:00 - Track: Application Database Development
Speaker: Pinal Dave
Title: Performance in 60 Seconds - SQL Tricks Everybody MUST Know
Abstract:
Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.
SessionID: 57634
Event Date: 29-04-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Chris Wood
Abstract:
Have you looked in the plan cache?
What to look for in saved plans
Keep you plan cache trim
Are your indexes being used as you expect?
Do you have table/index hot-spots?
SessionID: 61143
SQL Server In-Flight Recorder Deep-Dive
Event Date: 29-04-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Mohit Gupta
Title: SQL Server In-Flight Recorder Deep-Dive
Abstract:
SessionID: 61785
Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
Event Date: 29-04-2017 - Session time: 15:30:00 - Track: Analytics and Visualization
Speaker: Scott Stauffer
Title: Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
Abstract:
You've heard about Power BI, and you've seen it, but you haven't yet rolled up your sleeves and got your hands dirty. It looks like it is really easy, but sometimes it helps to have someone step you through it the first time to help you hit the ground running. We will grab various public data sources, join them together in a model and build an interactive pièce de ré·sis·tance on the visual design surface!
SessionID: 63365
Introduction to Unit-Testing in SQL Server
Event Date: 29-04-2017 - Session time: 15:30:00 - Track: Application Database Development
Speaker: Sebastian Meine
Title: Introduction to Unit-Testing in SQL Server
Abstract:
It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.
In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.
You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.