Nr: 808
SQLSaturday #808 - Oregon 2018
SessionID: 84533
SQLOpsStudio Vs SSMS - There can be only one
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: DBAdmin
Speaker: Warwick Rudd
Title: SQLOpsStudio Vs SSMS - There can be only one
Abstract:
SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS?
In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.
SessionID: 84538
Uhms and Bunny Hands: Tips for Improving Your Presentation Skills
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Prof Dev
Speaker: Cathrine Wilhelmsen
Title: Uhms and Bunny Hands: Tips for Improving Your Presentation Skills
Abstract:
Are you considering becoming a speaker, but feel nervous about getting on stage for the first time? Have you already presented a few sessions and want advice on how to improve? Do you learn more from seeing examples of what you should NOT do during a presentation instead of reading a list of bullet points on how to become a better speaker?
Don't worry! I have made plenty of presentation mistakes over the years so you won't have to :)
In this session, we will go through common presentation mistakes and how you can avoid them, as well as how you can prepare for those dreaded worst-case scenarios. Don't let those "uhms" and "uhhs" dominate your presentation, help the audience focus on the key message you're delivering instead of making them read a wall of text in your slides, recover gracefully from any demo failures, and stop distracting your attendees with floppy bunny hands.
All it takes is a little preparation and practice. You can do this!
SessionID: 84541
Encrypting Data within Sql Server
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: DBDev
Speaker: Thomas Norman
Title: Encrypting Data within Sql Server
Abstract:
Data breaches abound! SQL Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and SQL Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data and learn about my experiences implementing Always Encrypted.
SessionID: 84591
The SQL Server Transaction Log for Developers
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: DBDev
Speaker: Frank Gill
Title: The SQL Server Transaction Log for Developers
Abstract:
SessionID: 84801
Data Modeling and Prototyping in Power BI Desktop [VIDEO]
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: BI Design
Speaker: Steve Wake
Title: Data Modeling and Prototyping in Power BI Desktop [VIDEO]
Abstract:
SessionID: 84802
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: DBAdmin
Speaker: Rob Sewell
Abstract:
Afraid of PowerShell?
Worried its too complicated?
Don't want to go through the learning curve?
Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday
Want to restore an entire servers databases to the latest available point in time of the backups in just one line?
Be useful to know the Last DBCC Check for your entire estate in only one line of code?
Need to test your restores but its complicated?
and many many more
All this in a fast paced, fun session
SessionID: 84921
Power BI data preparation with Dataflows [VIDEO]
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: BI Arch/Admin
Speaker: Michael Johnson
Title: Power BI data preparation with Dataflows [VIDEO]
Abstract:
Data preparation is often the most labour-intensive component of an analytics project and getting this right is vital if the results are to be accurate. While the growth of self-service BI has empowered users to answer important questions, ensuring well managed data is available to all employees remains one of businesses biggest challenges.
Dataflows is an extension of the Power BI ecosystem, providing a low code approach using Power Query to create curated datasets that can be easily consumed by business analysts, thereby improving the speed at which business value can be delivered. Dataflows provides a single-version-of-the-truth which was traditionally attained by building a data warehouse.
You will learn
-How Dataflows can be used to create rich, vetted datasets
-How Dataflows can be created with the click of a button, ingesting data from many well knows SAAS solution such as Dynamics and Salesforce
-How to manage Dataflows using advanced data preparation tools such as Databricks
SessionID: 85222
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Prof Dev
Speaker: Je'Anna Lanza-Abbott
Abstract:
Because little in business or life gets done without negotiation, this session has the potential to deliver significant upside in your professional and personal outcomes. In this session, you will be introduced to basic negotiation concepts and tactics, followed by a focus on important aspects of the negotiation process—obstacles to effective communication at the bargaining table, the maximization of multiple interests, and preparation tactics for your next negotiation. We will put it all together by examining a special type of negotiation: YOUR SALARY!
Participants will:
• Learn strategies for negotiation analysis and preparation
• Understand different strategic choices and interpersonal skills necessary for success
• Know what information is needed to negotiate effective outcomes
• Experiment with new techniques and test their effectiveness in a safe environment
SessionID: 85531
The Big Picture: SQL Overview -Getting the Most of SQL Saturday
Event Date: 03-11-2018 - Session time: 08:30:00 - Track: Essentials
Speaker: Michael Curry
Title: The Big Picture: SQL Overview -Getting the Most of SQL Saturday
Abstract:
SessionID: 86897
Lightning Talks: Session One
Event Date: 03-11-2018 - Session time: 08:30:00 - Track:
Speaker: Misc Speakers
Title: Lightning Talks: Session One
Abstract:
Creating a Time Inspector Measure in Power BI for Easier Time Intelligence |
Data Science in 15 Minutes! Predictive Analytics with R in Power BI
SessionID: 84386
Educating yourself will make a SQL career more fulfilling
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: Prof Dev
Speaker: Chris Wood
Title: Educating yourself will make a SQL career more fulfilling
Abstract:
Do you want to turn your SQL knowledge into a possible career?
This session will show you what options are available to learn about MS SQL Server and make you more knowledgeable about the product
This session will show the many different options available to learn MS SQL Server ranging from free events thru to international conferences
It will also show how to make any conference more affordable and justify the benefits
SessionID: 84653
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: Essentials
Speaker: Thomas Grohser
Abstract:
Most rookie DBA's do not establish a Service Level Agreements (SLA) with the management and if they do they sometimes just come up with some random numbers for availability. Then when at some point later something goes wrong everybody wonders why it takes so long to bring everything back online.
This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA and communicate it to the rest of the comapany
SessionID: 84657
Everything You Need to Know About SQL Server Indexes
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBAdmin
Speaker: Janis Griffin
Title: Everything You Need to Know About SQL Server Indexes
Abstract:
You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.
This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown.
This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.
SessionID: 84857
Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: BI Arch/Admin
Speaker: Jason Horner
Title: Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
Abstract:
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
SessionID: 84974
Power BI Report Design for the aesthetically challenged
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: BI Design
Speaker: James McGillivray
Title: Power BI Report Design for the aesthetically challenged
Abstract:
Do you ever worry that your reports look they were born in the 90s, or designed by a grade 1? Do you feel overwhelmed when tasked with creating attractive reports which tell the customer a story?
Thankfully, a few simple design concepts can have big impacts on your reports. There are easy-to-learn techniques and patterns to create a pleasing look and feel to our reports, and some well defined principles to decide which visual is most appropriate in your situation.
Join me in this session to learn:
- How to choose the right visual to complement the data message.
- Best practices for visual formatting to tell a complete story.
- Colour theory - designing a colour palette, and ensuring accessibility.
- Layout techniques for clean and simple reports.
- Real estate management, or how to fit everything on a report without it looking cluttered and losing effectiveness.
SessionID: 85043
Locks, Blocks, and Deadlocks, Oh My!
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBAdmin
Speaker: Randy Knight
Title: Locks, Blocks, and Deadlocks, Oh My!
Abstract:
"I've got a locking problem", "I need to get rid of blocking," and "deadlocks are normal behavior" are all things heard way too many times.
In this session targeted at the accidental or new DBA, we will walk through each of these items, what they are, what their causes are, which of them are normal behavior and which are not, and some common causes of deadlocks and excessive blocking.
SessionID: 85518
Relational Data Architecture 101
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBAdmin
Speaker: Pat Phelan
Title: Relational Data Architecture 101
Abstract:
This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!
You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
SessionID: 85636
Be Friendly to SQL Server with TSQL Best Practices [VIDEO]
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBDev
Speaker: Ben Miller
Title: Be Friendly to SQL Server with TSQL Best Practices [VIDEO]
Abstract:
SessionID: 85650
Data Types Do Matter [VIDEO]
Event Date: 03-11-2018 - Session time: 10:15:00 - Track: DBDev
Speaker: Angela Henry
Title: Data Types Do Matter [VIDEO]
Abstract:
SessionID: 86898
Lightning Talks: Session Two
Event Date: 03-11-2018 - Session time: 10:15:00 - Track:
Speaker: Misc Speakers
Title: Lightning Talks: Session Two
Abstract:
What's it like to have a career in consulting?
Why Solidity is Solid - Basic of Ethereum, Smart Contracts, and Blockchain.
Managing Execution Plans [VIDEO]
SessionID: 84636
3D printing at HP and spreadsheets; how HP broke free of data bottlenecks.
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: Essentials
Speaker: Jeff Honsowetz
Title: 3D printing at HP and spreadsheets; how HP broke free of data bottlenecks.
Abstract:
Join Jeff and guest speaker from HP to hear their story. In today’s complex world, we know inherently simple gets it done now. And “now” is the typical deadline of our supervisors. The difficulty is they demand tough requirements and often make changes that take extra time and staff. In HP’s world of 3D printing, they discovered a new simplicity in consuming data daily, pivoting quickly in new directions, and keeping their users in control within IT boundaries. Learn about HP 3D printing ingenuity in your own back yard and how Interject provided a spreadsheet platform for them to run even faster and collaborate on data in record time. What took months or weeks, now takes days or hours, and users need minimal training.
Be the first 20 to attend and pick a cold red bull or hot latte/mocha that will be waiting. Even better, at the end of the session we will be giving another $300 lightsaber like last year that is too cool for the kids. Space is limited so arrive early.
SessionID: 84655
CozyRoc: Dynamic Data Flows in SSIS Without Programming
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: BI Arch/Admin
Speaker: Diane Schuster
Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming
Abstract:
This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
SessionID: 84983
Azure Intelligent Services
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: Data Science
Speaker: Amie Mason
Title: Azure Intelligent Services
Abstract:
SessionID: 85039
Game, Set, Match: Set Theory for Beginners [VIDEO]
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBDev
Speaker: Jared Karney
Title: Game, Set, Match: Set Theory for Beginners [VIDEO]
Abstract:
SessionID: 85558
Successfully Virtualizing and Maintaining SQL Server on VMware vSphere [VIDEO]
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBAdmin
Speaker: Victor Isakov
Title: Successfully Virtualizing and Maintaining SQL Server on VMware vSphere [VIDEO]
Abstract:
Microsoft SQL server is the most virtualized enterprise mission critical application today. In recent years it has become a mainstream effort among VMware customers to virtualize critical databases to allow better agility and scale while increasing availability and operational efficiency. In this session we will focus on the configuration of vSphere and SQL server for maximizing the benefits of virtualizing SQL server. The session is aimed at providing VMware customers and partners guidance on how to achieve best performance and efficiency with the latest versions of Microsoft SQL server and VMware vSphere.
SessionID: 86132
Going Beyond Monitoring With SentryOne
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBAdmin
Speaker: Andy Yun
Title: Going Beyond Monitoring With SentryOne
Abstract:
Hopefully you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.
SessionID: 86162
3 tips for getting executive buy-in for DevOps
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DevOps
Speaker: Kendra Little
Title: 3 tips for getting executive buy-in for DevOps
Abstract:
SessionID: 86585
Running SQL Server on Amazon Web Services
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: Cloud Data
Speaker: Richard Waymire
Title: Running SQL Server on Amazon Web Services
Abstract:
SessionID: 86615
Real-time monitoring and detailed workload analysis with Spotligh
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBAdmin
Speaker: Trent Mera
Title: Real-time monitoring and detailed workload analysis with Spotligh
Abstract:
SessionID: 86896
Event Date: 03-11-2018 - Session time: 11:45:00 - Track: DBAdmin
Speaker: Craig Allen
Abstract:
SessionID: 84573
SQL Server Take Over: Establishing a Baseline
Event Date: 03-11-2018 - Session time: 13:00:00 - Track: DBAdmin
Speaker: Lowry Kozlowski
Title: SQL Server Take Over: Establishing a Baseline
Abstract:
SQL Server Take Over: Establishing a Baseline
Performance assessment and tuning for the beginner DBA
Have you ever inherited a group of servers with not a lot of documentation to accompany them? Do you have a lot of undocumented or new servers in your environment and you want to establish some baseline configuration setting prior to making changes? You need up to date information on the system very quickly.
The server is running slowly... or is it? Slow compared to what? Before you being digging into performance issues, there are some baseline metrics you should have established. Only after the information has been gathered, can a plan of attack be developed to help resolve issues with performance. Attendees in this session will learn how to quickly gather information, review the results and get an action plan on the next step in performance tuning.
SessionID: 84610
Detecting and Capturing Change for Data Warehousing
Event Date: 03-11-2018 - Session time: 13:00:00 - Track: BI Design
Speaker: Chris Hyde
Title: Detecting and Capturing Change for Data Warehousing
Abstract:
There are many ways of detecting and capturing changes to the data in your business system in order to populate your data warehouse. In this session we will compare and contrast several methods for loading slowly-changing dimensions in your ETL solutions, including SSIS design patterns, T-SQL code, change data capture (CDC) and temporal tables.
Attendees will gain a full understanding of the pros and cons of each of these solutions and become confident in choosing and implementing them in their own ETL solutions.
SessionID: 84898
Select Stars: A SQL DBA's Introduction to Azure Cosmos DB
Event Date: 03-11-2018 - Session time: 13:00:00 - Track: Cloud Data
Speaker: Bob Pusateri
Title: Select Stars: A SQL DBA's Introduction to Azure Cosmos DB
Abstract:
SessionID: 85040
Indexing for Beginners [VIDEO]
Event Date: 03-11-2018 - Session time: 13:00:00 - Track: Essentials
Speaker: Kathi Kellenberger
Title: Indexing for Beginners [VIDEO]
Abstract:
SessionID: 85210
SSIS Deployment Smackdown! Package vs. Project!
Event Date: 03-11-2018 - Session time: 13:00:00 - Track: BI Arch/Admin
Speaker: Peter Kral
Title: SSIS Deployment Smackdown! Package vs. Project!
Abstract:
SSIS Package deployment was the first, but is it the best? Project deployment promised so much, but did it deliver? Find out which method is best for you when you see two expert practitioners go head-to-head, presenting their best-case solution for their method, and then take on the weaknesses of their opposition! Which will emerge as the supreme deployment method? BE THERE!!!
SessionID: 85434
Event Date: 03-11-2018 - Session time: 13:00:00 - Track: DBAdmin
Speaker: Ben Thul
Abstract:
How many times have you been told by your customers:
- "just grant db_owner/sysadmin to my application and it will work"
- "I need to be able to issue raw DML against these tables"
- "my login doesn't work the way it should!"
- "this query that is accessing objects in multiple databases isn't working"
In this session, we'll talk about ways to service requests like these without
having to give away the world. We’ll start with authentication and
authorization, for context.
We will then go into different methods to augment the "normal" means of
obtaining permissions that will allow you to help your customers while at the
same time not needing to be overly permissive.
In the course of this presentation, you'll learn about:
* Module signing
* Permission chaining
* Impersonation
and more!
SessionID: 85610
What is Temporal Tables
Event Date: 03-11-2018 - Session time: 13:00:00 - Track: DBDev
Speaker: Jean-Pierre Voogt
Title: What is Temporal Tables
Abstract:
In this session we will take an introduction look at Temporal Tables in SQL Server. How do we query a temporal table and how do we manage a large temporal table with Stretch Database to Azure. We will look at when to use Temporal tables and why would you use it.
SessionID: 85652
Event Date: 03-11-2018 - Session time: 13:00:00 - Track: DBDev
Speaker: Vern Rabe
Abstract:
In this session we will see ten common T-SQL writing habits that contribute to poor performance. We’ll see WHY each of these patterns can have such negative impact on performance, including examples, and we’ll see one or more alternatives for each that don’t have the same negative impact.
Armed with this knowledge, you will definitely impress your boss with your ability to create fast T-SQL within tight time constraints, and also quickly fix existing T-SQL code. Enjoy the merit raise you’ll get due to your new tuning talents.
SessionID: 86899
Lightning Talks: Session Three
Event Date: 03-11-2018 - Session time: 13:00:00 - Track:
Speaker: Misc Speakers
Title: Lightning Talks: Session Three
Abstract:
ProperCase - My Favorite UDF
PLE, it's not what you think it is!
SessionID: 84557
Containerized databases: SQL Server and DevOps
Event Date: 03-11-2018 - Session time: 14:45:00 - Track: DevOps
Speaker: Ned Otter
Title: Containerized databases: SQL Server and DevOps
Abstract:
What are containers? When would you use them? Are they supported for production? Do they run on Windows? Do they run on Linux? Can they persist data?
These are just a few of the questions we will answer in this session. Containers are all the rage today - don't get left behind!
SessionID: 84600
How to Migrate your in house data to the cloud [VIDEO]
Event Date: 03-11-2018 - Session time: 14:45:00 - Track: Cloud Data
Speaker: James Phillips
Title: How to Migrate your in house data to the cloud [VIDEO]
Abstract:
SessionID: 84695
Don't Use Cursors or Why You Maybe Should Use a Cursor After All
Event Date: 03-11-2018 - Session time: 14:45:00 - Track: DBDev
Speaker: Erland Sommarskog
Title: Don't Use Cursors or Why You Maybe Should Use a Cursor After All
Abstract:
SessionID: 84889
Predictive Analytics with R in Power BI [VIDEO]
Event Date: 03-11-2018 - Session time: 14:45:00 - Track: Data Science
Speaker: Joseph Yeates
Title: Predictive Analytics with R in Power BI [VIDEO]
Abstract:
Power BI reports are typically used for descriptive analysis: a historical look of what has happened. But what if your report could visualize what is likely to happen and recommend what you can do about it now?
This session will introduce how to start the shift from descriptive to predictive analysis and how you can begin to leverage the power of machine learning in your business intelligence solutions. No previous knowledge of R or predictive modeling is required!
We will cover the basics and best practices of predictive modeling and then these concepts will be applied to create three different predictive models in R. Then we will cover three ways to integrate the predictive power of these models into a Power BI report.
SessionID: 85239
Execution plans ... where do I start? [VIDEO]
Event Date: 03-11-2018 - Session time: 14:45:00 - Track: Essentials
Speaker: Hugo Kornelis
Title: Execution plans ... where do I start? [VIDEO]
Abstract:
But sometimes it doesn't. Sometimes a query takes too much time. You need to find out why, so you can fix it. That's where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it's slow.
However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?
In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
SessionID: 85365
Introduction to SQL Server Reporting Services [VIDEO]
Event Date: 03-11-2018 - Session time: 14:45:00 - Track: BI Design
Speaker: Ted Stathakis
Title: Introduction to SQL Server Reporting Services [VIDEO]
Abstract:
This session will cover the basics of developing, publishing and using SQL Server Reporting Services. You will learn all the steps needed to get started from connecting to the data source, creating data sets through putting the data on the page and publishing the report to the report server. See how easy SSRS is to use and how powerful it can be. The demo will be using SSRS 2016 but the concepts covered are applicable to any version of SQL Server.
The session will also include:
A tour of a wide variety of report examples including interactive graphical dashboards that you can do in SSRS, even in older versions.
A comprehensive discussion of design elements to include and avoid when creating reports.
Report printing and export considerations for optimal output depending on rendering format.
You will leave this session able to return to the office and present meaningful data to your end users with minimal time and effort with easy to use and powerful BI tool that you already own
SessionID: 85492
PowerShell for the DBA
Event Date: 03-11-2018 - Session time: 14:45:00 - Track: DBAdmin
Speaker: Amy Herold
Title: PowerShell for the DBA
Abstract:
In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
SessionID: 85643
What is DevOps? - and why should I care?
Event Date: 03-11-2018 - Session time: 14:45:00 - Track: DBDev
Speaker: Martin Catherall
Title: What is DevOps? - and why should I care?
Abstract:
If you like an interactive and lively sessions them this is the place for you.
We’ll look at the background of this term – and see how it has transformed to bring focus to the data professional.
We’ll take a peak at what it means for the technology professional as well as what it means for the business professional - and we'll see Visual Studio Team Services (VSTS) and the cloud in action.
We’ll look at the different kinds of disciplines that lead to a well-rounded DevOps set up.
We’ll have a run through some of the motivations for developing a DevOps mindset and we’ll also hear about some of the arguments for non-adoption.
We’ll look at some of the other IT methodologies that we’ve seen emerge over the years and examine exactly what sets DevOps apart from these.
Regardless of if you’re never heard this term before or you have strong feeling about the subject – either way – you’ll leave the room with a new perspective and quite likely you’ll have contributed to your fellow delegates kn
SessionID: 86901
Lightning Talks: Session Four
Event Date: 03-11-2018 - Session time: 14:45:00 - Track:
Speaker: Misc Speakers
Title: Lightning Talks: Session Four
Abstract:
Using Text Manipulation For Great Good
The top 3 Availability Groups pitfalls and how to avoid them
The top five things DBAs need to know about DevOps
SessionID: 84575
Code Like a Snake Charmer - Intro to Python! [VIDEO]
Event Date: 03-11-2018 - Session time: 16:15:00 - Track: Data Science
Speaker: Jamey Johnston
Title: Code Like a Snake Charmer - Intro to Python! [VIDEO]
Abstract:
The session will be an introduction to the Python language including:
1.) Installing and Configuring Python
2.) Access and Manipulate Data
3.) Install and Manage Packages
4.) Create and Use Objects/Variables
5.) Control Flows and Functions
6.) Managing the Python installation in MSSQL
Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.
No prior statistics knowledge needed.
SessionID: 84579
DBA vNext
Event Date: 03-11-2018 - Session time: 16:15:00 - Track: DBAdmin
Speaker: Armando Lacerda
Title: DBA vNext
Abstract:
Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.
Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.
In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.
SessionID: 84612
High Availability/Disaster Recovery 101
Event Date: 03-11-2018 - Session time: 16:15:00 - Track: DBAdmin
Speaker: Glenn Berry
Title: High Availability/Disaster Recovery 101
Abstract:
SessionID: 84646
Introduction to Managed Instances [Video]
Event Date: 03-11-2018 - Session time: 16:15:00 - Track: Cloud Data
Speaker: John Martin
Title: Introduction to Managed Instances [Video]
Abstract:
What are Azure SQL Database Managed Instances?
The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are
and how you might start using them.
Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server. Including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges to using Azure SQL Databases.
But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology, working through a full migration including workload analysis, selecting the appropriate migration pathway and then putting it in place.
SessionID: 85506
Test Driven Development in SQL Server – how to deploy code safer [VIDEO]
Event Date: 03-11-2018 - Session time: 16:15:00 - Track: DBDev
Speaker: Hamish Watson
Title: Test Driven Development in SQL Server – how to deploy code safer [VIDEO]
Abstract:
Test Driven Development (TDD) is a design approach which has enabled application developers to write cleaner code. It is relevant for database development as it ensures that code produced using TDD and unit tests will be of higher quality which means interactions with data will be safer.
TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code.
In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases.
TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery.
A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code safer.
SessionID: 85618
Data Testing Integrity – BI Edition
Event Date: 03-11-2018 - Session time: 16:15:00 - Track: BI Design
Speaker: Rob Long
Title: Data Testing Integrity – BI Edition
Abstract:
Unit Testing and Test-Driven Development are common practices in application development. In SQL development we’ve even got tSQLT! In the realm of BI with desperate systems, integration layers, data warehouses and even cubes we need a better approach.
In this session, we’ll discuss different problem scenarios and practical solutions. We’ll identify the need to look at the data from the business perspective and define specific integrity checks to ensure our data is accurate. Then the fun part! Using the Microsoft BI tool-set, we will walk-through a working solution demonstrating a way to efficiently centralize this process.
At the end of the session, we’ll all still agree that we can’t use a unit test or record counts to ensure that data is accurate. You will have a simple solution that you can start with to work in your environment and look at data testing integrity differently.
SessionID: 85619
Building Your Own Power BI Image Generating Measures
Event Date: 03-11-2018 - Session time: 16:15:00 - Track: BI Design
Speaker: Brian Grant
Title: Building Your Own Power BI Image Generating Measures
Abstract:
With the August 2018 version of Power BI, you can now write DAX measures that generate dynamic chart images using the SVG (Scalable Vector Graphics) standard. This means the long sought-after chart types of "small multiples" and "spark lines" are suddenly available, letting report authors create a sort of pivot table, not of numbers, but of dozens of tiny dynamic charts. However, this only works if you know how to leverage DAX to write dynamic SVG code, a rather oblique use of the language. In this session we'll be showing users how to do exactly that live on stage. We'll create several chart measures, from KPI indicators, to spark lines, to the game-changing bullet charts. Folks will walk away with some basic patterns they can use to create their own chart measures at home in no time at all.
SessionID: 85623
Tame Your Unruly Data With Constraints
Event Date: 03-11-2018 - Session time: 16:15:00 - Track: Essentials
Speaker: Rob Volk
Title: Tame Your Unruly Data With Constraints
Abstract:
SessionID: 86900
Lightning Talks: Session Five
Event Date: 03-11-2018 - Session time: 16:15:00 - Track:
Speaker: Misc Speakers
Title: Lightning Talks: Session Five
Abstract:
TBD