sqlsathistory

Nr: 759

Back to Main list

SQLSaturday #759 - Jacksonville 2018

Start Time (24h) Speaker Track Title
09:00:00 Adam Jorgensen Professional Development The future data professional - Hacking your growth!
09:00:00 Janis Griffin Enterprise Database Administration Deployment HiHo! HiHo! SQL Server on Linux, We Go!
09:00:00 Joe Abbott BI Platform Architecture, Development Administration Introduction to Azure SQL Database
09:00:00 Victor Ivantsov BI Platform Architecture, Development Administration Make your SSIS 2016 packages talk to each other
09:00:00 Louis Davidson Application Database Development Let Me Finish... Isolating Write Operations
09:00:00 Chad Churchwell BI Platform Architecture, Development Administration Introduction to SQL Server Clustering
09:00:00 Andy Warren Enterprise Database Administration Deployment Lessons Learned from Two Years as a Devops DBA
09:00:00 Mitchell Pearson Advanced Analysis Techniques Advanced Power BI
10:15:00 Jim Miller BI Platform Architecture, Development Administration Populating a Data Warehouse with SSIS and Biml Patterns
10:15:00 Troy Gallant Enterprise Database Administration Deployment Supercharge Your Maintenance Plans!
10:15:00 Brad Raney Professional Development Are They Hearing What You Said - or Something Completely Different?!
10:15:00 Haim Shternshus Analytics and Visualization Numbers Don't Lie. Or Do They?
10:15:00 Dmitri Korotkevitch Enterprise Database Administration Deployment Intro Into Index Analysis
10:15:00 Dustin Ryan Enterprise Database Administration Deployment Monitoring and Tuning Azure SQL Database
10:15:00 Valentin Iamandi Enterprise Database Administration Deployment Health Check your Sql Server like a Boss
10:15:00 Shabnam Watson BI Platform Architecture, Development Administration SQL Server Analysis Services for SQL Server DBAs
11:45:00 Shawn Meyers Enterprise Database Administration Deployment Successfully Virtualizing SQL Server on vSphere
11:45:00 Tristan Coles Other #GetModern with Dell EMC
11:45:00 Janis Griffin Advanced Analysis Techniques Introduction to Wait Time Analysis for Performance Tuning
13:00:00 Jeff Taylor Application Database Development What's New In SQL Server For The Developer
13:00:00 Jorge Novo BI Information Delivery Pull and Push Json Data Files into AWS using SSIS
13:00:00 Jonathon Moorman Professional Development Surviving Your Sql Developer Interview
13:00:00 Steve Schneider BI Platform Architecture, Development Administration To Azure and Beyond: Create an Azure VM with SSRS server and deploy Mobile and Paginated reports
13:00:00 Jason Brugger Application Database Development SQL to NoSQL: Querying Azure Cosmos DB
13:00:00 Taras Kaduk Analytics and Visualization Using R in Power BI: why, when and how
13:00:00 Steven Wheeler Enterprise Database Administration Deployment About those SQL data files…
13:00:00 Bradley Schacht Enterprise Database Administration Deployment Intro to MPP Database with Azure SQL Data Warehouse
14:15:00 Janis Griffin Enterprise Database Administration Deployment What’s New in the 2017 Query Store
14:15:00 Cindy Chapman Professional Development [Harassment
14:15:00 Matt Gordon Enterprise Database Administration Deployment How to Keep Your Database Servers Out of the News
14:15:00 Shawn Harrison BI Platform Architecture, Development Administration SSIS Troubleshooting, Error Handling, and Logging
14:15:00 Susan Schneider BI Information Delivery Discovering SSRS 2016 in Azure: Dataset to Deployment
14:15:00 Taras Kaduk Professional Development All the ways to break into data science and analytics
14:15:00 Sumit Vadodaria Advanced Analysis Techniques Introduction to Azure Machine Learning
14:15:00 Shawn Meyers Enterprise Database Administration Deployment Policies are not just for HR
15:45:00 Devin Knight BI Information Delivery Anytime, Anywhere Data with Power BI Mobile Reporting
15:45:00 Dale Sullenberger Enterprise Database Administration Deployment Temporal Tables: Creation, Use, and Optimizing
15:45:00 Joshua Corrick Enterprise Database Administration Deployment Test and Verify Instances with DbaChecks
15:45:00 Louis Davidson Application Database Development Database Design Fundamentals
15:45:00 Luigi Delfin Analytics and Visualization Azure Analytics In the Cloud
15:45:00 Ben Cusson Professional Development Creating Your Personal Brand Behind the Staffing Curtain
15:45:00 Manuel Quintana BI Platform Architecture, Development Administration SSIS: Loading Dimension Tables
15:45:00 Bradley Schacht BI Platform Architecture, Development Administration Intro to Cloud ETL: Azure Data Factory V2

SessionID: 74171

The future data professional - Hacking your growth!

Back to calendar

Event Date: 05-05-2018 - Session time: 09:00:00 - Track: Professional Development

Speaker: Adam Jorgensen

Title: The future data professional - Hacking your growth!

Abstract:

We are in a new industrial revolution. Data is the new innovation lever and companies are all seeking new ways to use it to catapult them forward. Incremental growth or improvement are no longer optional. The current needs of the business world are outpacing the technology expertise of most of its technical leadership. Learn how to rethink your own development and get the right capabilities for an amazing future in data! Leave with a roadmap for building out your modern personal development plan.

SessionID: 74387

HiHo! HiHo! SQL Server on Linux, We Go!

Back to calendar

Event Date: 05-05-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: HiHo! HiHo! SQL Server on Linux, We Go!

Abstract:

SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.

The participant will learn:

  1. The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
  2. How to install, maintain and backup SQL Server on Ubuntu Linux systems
  3. Several useful Linux commands to monitor/manage SQL Server

SessionID: 75780

Introduction to Azure SQL Database

Back to calendar

Event Date: 05-05-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Joe Abbott

Title: Introduction to Azure SQL Database

Abstract:

What is this “Azure SQL Database” that I keep hearing about? In this session we will start from the beginning and answer the big questions around what it is, how you use it, how much does it cost, and most importantly why you would and should use it in your particular environment/situation.

SessionID: 77023

Make your SSIS 2016 packages talk to each other

Back to calendar

Event Date: 05-05-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Victor Ivantsov

Title: Make your SSIS 2016 packages talk to each other

Abstract:

This presentation will focus on how SSIS 2016 packages can communicate with each other and how you can create a sophisticated solution for your enterprise integration with maximum code reuse and flexibilty

SessionID: 77927

Let Me Finish... Isolating Write Operations

Back to calendar

Event Date: 05-05-2018 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Let Me Finish... Isolating Write Operations

Abstract:

OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

SessionID: 78773

Introduction to SQL Server Clustering

Back to calendar

Event Date: 05-05-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chad Churchwell

Title: Introduction to SQL Server Clustering

Abstract:

This session will provide an introductory into failover clustering of SQL Server, including when and why to cluster SQL. We will cover the required components and walk through how clustering works behind the scenes

SessionID: 80042

Lessons Learned from Two Years as a Devops DBA

Back to calendar

Event Date: 05-05-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Warren

Title: Lessons Learned from Two Years as a Devops DBA

Abstract:

Join me as I talk about lessons learned from two years on a Devops team. Process, source control, changes that block, rolling back changes, out of band changes, and more! I still don't have all the answers (or maybe even all the questions), but I can say this - DBA's have nothing to fear and a lot to gain when an org adopts a devops culture.

SessionID: 80434

Advanced Power BI

Back to calendar

Event Date: 05-05-2018 - Session time: 09:00:00 - Track: Advanced Analysis Techniques

Speaker: Mitchell Pearson

Title: Advanced Power BI

Abstract:

By now you have probably seen many Power BI demos and likely love what you see in the product. However, you may have noticed in most Power BI demos that they tend to show scenarios where everything just works right on the first try. So what do you do when your data is not perfect or your business problem is more complex? In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work. This session will give you many tips on how to solve real-world problems with Power BI.

SessionID: 74173

Populating a Data Warehouse with SSIS and Biml Patterns

Back to calendar

Event Date: 05-05-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jim Miller

Title: Populating a Data Warehouse with SSIS and Biml Patterns

Abstract:

This session will demonstrate how to leverage Biml Patterns, along with SQL Server Metadata, to rapidly build SSIS packages. The focus of this session will be on populating a data warehouse, however the concepts presented could be applied to most any ETL/ETL scenarios.

The components used during this session:

Attend to see how Biml can revolutionize your SSIS development!

SessionID: 74176

Supercharge Your Maintenance Plans!

Back to calendar

Event Date: 05-05-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Troy Gallant

Title: Supercharge Your Maintenance Plans!

Abstract:

Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.

In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.

SessionID: 74185

Are They Hearing What You Said - or Something Completely Different?!

Back to calendar

Event Date: 05-05-2018 - Session time: 10:15:00 - Track: Professional Development

Speaker: Brad Raney

Title: Are They Hearing What You Said - or Something Completely Different?!

Abstract:

In this 60 minute interactive workshop, attendees are given the knowledge tools to take charge of their listening skills to improve the quality of their communication with other professionals. Ever have trouble getting the right message across to your co-workers or clients? This topic deals with the ways we communicate – accurately and inaccurately – and includes 2 interactive elements: table exercise about voice inflection called “Really? REALLY?!” volunteer activity called the “Alien Press Conference” – a hilarious take on verbal non-verbal cues. Other topics include: Challenges of Communicating; Listening to Understand, Not Respond; 7 Stages of Communication; Verbal vs Nonverbal Cues; Tone is Everything; 5 Ways to Change Your Listening Habits Now; and more. Attendees will learn:

• How to control their voice tone and inflection to improve their message delivery; • How to develop and improve their active listening skills; • How to use non-verbal cues to their advantage; more

SessionID: 74191

Numbers Don't Lie. Or Do They?

Back to calendar

Event Date: 05-05-2018 - Session time: 10:15:00 - Track: Analytics and Visualization

Speaker: Haim Shternshus

Title: Numbers Don't Lie. Or Do They?

Abstract:

82.7% of all statistics are made up.

Don't believe it?
Well, you shouldn't. Statistics and data visualizations are misused every day. Sometimes by mistake, but often enough - deliberately. You already know not to believe everything you read, so now come and develop a critical look at statistics and data visualizations.
Learn the "tricks of the trade" and become a better consumer of graphs, charts, and infographics.

100% of people who liked this talk, said they liked it!

SessionID: 77806

Intro Into Index Analysis

Back to calendar

Event Date: 05-05-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dmitri Korotkevitch

Title: Intro Into Index Analysis

Abstract:

Indexing in SQL Server is both - art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes.

In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.

SessionID: 78338

Monitoring and Tuning Azure SQL Database

Back to calendar

Event Date: 05-05-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dustin Ryan

Title: Monitoring and Tuning Azure SQL Database

Abstract:

Being able to monitor and tune the performance of your database is an important part of any database professional's job. Azure introduces a host of new tools and capabilities designed to make optimizing your managed databases easier than ever. In this session, attendees will be introduced to using tools such as Query Performance Insights, Intelligent Insights, and Automatic Tuning to monitor and tune the performance of their Azure SQL Databases.

SessionID: 78887

Health Check your Sql Server like a Boss

Back to calendar

Event Date: 05-05-2018 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Valentin Iamandi

Title: Health Check your Sql Server like a Boss

Abstract:

-- analyse database Sql Server configuration: Degree of parallelism and Cost threshold of parallelism, TempDB, disks latency

-- analyse databases configuration -- maintenance plans: what works best -- index maintenance: rebuild or reorg -- Statistics maintenance -- new indexes? Duplicate Indexes? We got it -- slow sprocs? slow queries? we will give them a new life

SessionID: 80107

SQL Server Analysis Services for SQL Server DBAs

Back to calendar

Event Date: 05-05-2018 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shabnam Watson

Title: SQL Server Analysis Services for SQL Server DBAs

Abstract:

This session is for SQL Server DBAs who support BI developers with SQL Server Analysis Services (SSAS) projects. Join this session to learn what SSAS is, how it stores data, and how/when it queries data from SQL Server. During a demo you will see examples of these queries and learn the extent of the control that BI developers have over the design of such queries. This gives you an overview of both Multidimensional and Tabular modes of SSAS as it relates to interacting with SQL Server.

SessionID: 80456

Successfully Virtualizing SQL Server on vSphere

Back to calendar

Event Date: 05-05-2018 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: Successfully Virtualizing SQL Server on vSphere

Abstract:

Today, many organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications.

Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by a member of the VMware's SQL Server Experts Group.

SessionID: 80558

#GetModern with Dell EMC

Back to calendar

Event Date: 05-05-2018 - Session time: 11:45:00 - Track: Other

Speaker: Tristan Coles

Title: #GetModern with Dell EMC

Abstract:

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.

SessionID: 80638

Introduction to Wait Time Analysis for Performance Tuning

Back to calendar

Event Date: 05-05-2018 - Session time: 11:45:00 - Track: Advanced Analysis Techniques

Speaker: Janis Griffin

Title: Introduction to Wait Time Analysis for Performance Tuning

Abstract:

Are you struggling with performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for tuning SQL statements by utilizing wait time analysis. The speaker will use real-life case studies to show how quickly you can identify and fix the problems that are affecting your end user applications.

SessionID: 74158

What's New In SQL Server For The Developer

Back to calendar

Event Date: 05-05-2018 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Jeff Taylor

Title: What's New In SQL Server For The Developer

Abstract:

SessionID: 76995

Pull and Push Json Data Files into AWS using SSIS

Back to calendar

Event Date: 05-05-2018 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Jorge Novo

Title: Pull and Push Json Data Files into AWS using SSIS

Abstract:

Generate and stream Json Files into Amazon Web Services AWS

Learn how to create Json objects and deliver them into an AWS secure bucket, also learn how to interact with a source bucket to pull files into your on premises file store servers.

SessionID: 77521

Surviving Your Sql Developer Interview

Back to calendar

Event Date: 05-05-2018 - Session time: 13:00:00 - Track: Professional Development

Speaker: Jonathon Moorman

Title: Surviving Your Sql Developer Interview

Abstract:

Going into an interview is always stressful. The best way to reduce that stress is to have an idea of how the technical, and personal, interview will be conducted. Jon has conducted 50+ sql developer interviews and been interviewed by over a dozen companies. He has seen some really good things, but there have also seen some real head scratchers. Come hear some tips that you can use on your next sql developer interview!

SessionID: 77853

To Azure and Beyond: Create an Azure VM with SSRS server and deploy Mobile and Paginated reports

Back to calendar

Event Date: 05-05-2018 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Schneider

Title: To Azure and Beyond: Create an Azure VM with SSRS server and deploy Mobile and Paginated reports

Abstract:

SSRS Report Server is no long ‘earthbound’; it can live among the ‘stars’ up in Azure!

When we think of Azure, our happy home in the Cloud, we may not think Reporting Services; after all, we have Power BI. However, even with Power BI, there is still a strong need (desire) for paginated reports in today’s businesses. So how can we have the best of both worlds; have the data and servers in Azure and still create SSRS reports for the end users? The answer: create a report server in Azure. With that, you can host both Paginated (old style) and Mobile Reports. Steve will deploy both to the newly created VM. Steve will take you step by step to Build a VM in Azure, Create a Report Server on the VM, and Configure the various components; you will be able to see how everything works together. Come join Steve for this demo heavy session as he walks you through the entire process, including report deployment. Lastly, compare Paginated Mobile rpts to similar PowerBI. To Azure and Beyond!

SessionID: 77928

SQL to NoSQL: Querying Azure Cosmos DB

Back to calendar

Event Date: 05-05-2018 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Jason Brugger

Title: SQL to NoSQL: Querying Azure Cosmos DB

Abstract:

NoSQL, or "Not only SQL", might be the greatest misnomer ever. This session will discuss NoSQL queries on Cosmos DB using the SQL API, server side scripts, and some of the pros and cons of using NoSQL over a traditional RDBMS.

SessionID: 78517

Using R in Power BI: why, when and how

Back to calendar

Event Date: 05-05-2018 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Taras Kaduk

Title: Using R in Power BI: why, when and how

Abstract:

In this session, we will touch on R as the language for data science, and then will dive right into how to use R within the Power BI environment, and why to use it in a first place.

SessionID: 78699

About those SQL data files…

Back to calendar

Event Date: 05-05-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Steven Wheeler

Title: About those SQL data files…

Abstract:

This session is a talk on data and transaction log files; performance and best practices. How many databases have you come across where SQL Server was installed with all the default settings and wonder why performance is poor? We will discuss the defaults that affects SQL data files and how they ruin database performance. We will look at best practices, things to watch out for, and undoing the damage.

SessionID: 80568

Intro to MPP Database with Azure SQL Data Warehouse

Back to calendar

Event Date: 05-05-2018 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Bradley Schacht

Title: Intro to MPP Database with Azure SQL Data Warehouse

Abstract:

When database servers slow down the options are generally to tune or scale up. Massively Parallel Processing, or MPP, databases offer an alternative: scale out. A traditional database engine uses a single processor and memory space to process queries while an MPP engine will divide and conquer by spreading the workload across multiple servers resulting in increased query performance. MPP databases don't operate the exact same as a traditional database engine. In this session Brad will explore the similarities and difference of operating in an MPP environment, dive into distribution theory, discuss join and aggregation compatibility, and get you up to speed on all the basics of MPP theory. By the end of the session you'll be well positioned to understand the design pattern differences, ETL considerations, and query basics of MPP databases.

SessionID: 74386

What’s New in the 2017 Query Store

Back to calendar

Event Date: 05-05-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: What’s New in the 2017 Query Store

Abstract:

The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload and plan changes. This presentation will take a look at what’s new in the 2017 Query Store, the new adaptive query processing features and how to incorporate Query Store queries into the new SQL Operation Studio for monitoring slow running queries and analyzing waits. You will learn how to use the Query Store to quickly find plan changes, analyze performance issues and find the waits which caused them. Both DBAs and developers can increase their performance tuning skills by attending this session.

SessionID: 74663

Harassment| Bystander's Guide to Action

Back to calendar

Event Date: 05-05-2018 - Session time: 14:15:00 - Track: Professional Development

Speaker: Cindy Chapman

Title: Harassment| Bystander's Guide to Action

Abstract:

Have you ever encountered harassment at work? Me, too.

In your workplace, what would you do if someone was choking? If their clothes were on fire? Statistically, you are far more likely to witness harassment. Do you know what to do? Bystanders have unique power to resolve harassment and restore respect in the workplace. Uncertainty is the biggest reason Bystanders don't take action. Vagueness about what action to take, and when. Indecision about when and what action is warranted. Even doubt about the role Bystanders should play. In this session you will:

SessionID: 77293

How to Keep Your Database Servers Out of the News

Back to calendar

Event Date: 05-05-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: How to Keep Your Database Servers Out of the News

Abstract:

Every few months the headlines are filled with news of yet another system outage inconveniencing customers and users. As data platform professionals, the systems and servers for which we are responsible generally form the foundation of our companies’ customer-facing applications. In this fast-paced session, we’ll discuss the differences between high availability and disaster recovery as well as the tools and technologies Microsoft provides us within SQL Server to keep our databases up, our users happy, and our DBAs well rested.

SessionID: 77463

SSIS Troubleshooting, Error Handling, and Logging

Back to calendar

Event Date: 05-05-2018 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shawn Harrison

Title: SSIS Troubleshooting, Error Handling, and Logging

Abstract:

Encountering error messages in SSIS can be confusing and incredibly frustrating. Sometimes it’s difficult to determine what’s causing a problem and how to correct or avoid it if it happens again. As developers, we have a useful yet underrated set of tools to help us navigate many ETL pitfalls. In this session, Shawn will walk through a variety of tips and tricks to interpret errors during design time and demonstrate some common uses for event handling to help prevent problems after deployment.

SessionID: 77854

Discovering SSRS 2016 in Azure: Dataset to Deployment

Back to calendar

Event Date: 05-05-2018 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Susan Schneider

Title: Discovering SSRS 2016 in Azure: Dataset to Deployment

Abstract:

Dataset to Deployment (to Azure!!?) in one session, seriously? Well, it depends. Sixty minutes is not enough time to become an expert on how to create a dataset, develop a report with SQL Server Data Tools (SSDT) and deploy the report to a Report Server in Azure; but you can become familiar with the SSRS components and the report deployment process. Whether you are new to 2016 SSRS or have some SSRS experience, there’s something to learn for everyone.

In ‘Dataset’, we’ll talk about different options and ideas to create a good dataset. Then in ‘Develop’, we’ll look at the various components inside SSDT; building a report along the way. In ‘Deploy’, we’ll walk through the steps to configuration and deploy the report to a Report Server sitting on a VM in Azure. Yes, Azure! By the end of the session, you will be more familiar with the SSDT environment and the report deployment process. You won’t be a pro after this one session, but you will definitely be on your way!

SessionID: 78516

All the ways to break into data science and analytics

Back to calendar

Event Date: 05-05-2018 - Session time: 14:15:00 - Track: Professional Development

Speaker: Taras Kaduk

Title: All the ways to break into data science and analytics

Abstract:

In this session, we will explore all the various ways to pivot into the data science field. We will go over some common scenarios, and will inspect different pieces of advice found on the Internet.

SessionID: 80282

Introduction to Azure Machine Learning

Back to calendar

Event Date: 05-05-2018 - Session time: 14:15:00 - Track: Advanced Analysis Techniques

Speaker: Sumit Vadodaria

Title: Introduction to Azure Machine Learning

Abstract:

Introductory session on Azure machine learning, overview and practical demo.

SessionID: 80458

Policies are not just for HR

Back to calendar

Event Date: 05-05-2018 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: Policies are not just for HR

Abstract:

The use of SQL Server Policies can make a DBAs life much easier. Nearly anything you need to track can be monitored with policies. When something changes you will be notified. Save hours and hours of looking at configurations or building your own monitoring database. Set a policy and apply it all SQL Servers.

SessionID: 74670

Anytime, Anywhere Data with Power BI Mobile Reporting

Back to calendar

Event Date: 05-05-2018 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Devin Knight

Title: Anytime, Anywhere Data with Power BI Mobile Reporting

Abstract:

Over the past few decades, mobile devices have become incredibly important to the way we communicate, play and do business. In 2017, the time spent per day on mobile devices has reach a new record high of 3 hours and 15 minutes per day. With this much time on-the-go, it’s necessary to have your data right there with you.

In this session, you will learn how to design Power BI reports optimized for mobile devices and learn the ins and outs of the Power BI mobile app.

SessionID: 75730

Temporal Tables: Creation, Use, and Optimizing

Back to calendar

Event Date: 05-05-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dale Sullenberger

Title: Temporal Tables: Creation, Use, and Optimizing

Abstract:

With SQL 2016, Microsoft introduced Temporal tables. In this session we will learn what a Temporal table is, and discuss uses in current environments. We will learn how to create the tables and optimize them for query performance allowing simplicity for the consumers of the data.

SessionID: 76897

Test and Verify Instances with DbaChecks

Back to calendar

Event Date: 05-05-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Joshua Corrick

Title: Test and Verify Instances with DbaChecks

Abstract:

Once you have systems out in the wild, how do you know that they are configured correctly, and that the backups you are taking are actually valid? DbaChecks is a new Community built PowerShell Module (from the makers of Dbatools) that is designed to test your SQL Servers for various best practices, and help you prevent having a disaster. It also comes with a cool feature to output results to a PowerBI report. Basic knowledge of PowerShell is encouraged, but not required for this session.

SessionID: 77925

Database Design Fundamentals

Back to calendar

Event Date: 05-05-2018 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Louis Davidson

Title: Database Design Fundamentals

Abstract:

Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.

SessionID: 78521

Azure Analytics In the Cloud

Back to calendar

Event Date: 05-05-2018 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Luigi Delfin

Title: Azure Analytics In the Cloud

Abstract:

WIll present a sample business intelligence/analytics application of cloud technologies such as Azure Sql Server Analysis Services, Power BI and Azure Machine Learning and how it all works together.

SessionID: 80534

Creating Your Personal Brand Behind the Staffing Curtain

Back to calendar

Event Date: 05-05-2018 - Session time: 15:45:00 - Track: Professional Development

Speaker: Ben Cusson

Title: Creating Your Personal Brand Behind the Staffing Curtain

Abstract:

Creating Your Personal Brand Behind the Staffing Curtain

I will share my experience over the years in Staffing to provide some tips and tricks to help the community. I will discuss online presence, personal branding, selecting a staffing vendor, resume tips and tricks, nailing a technical interview, industry trends and anything else that may come up!

SessionID: 80535

SSIS: Loading Dimension Tables

Back to calendar

Event Date: 05-05-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Manuel Quintana

Title: SSIS: Loading Dimension Tables

Abstract:

In this session we will look at what options are available to developers within SSIS to load and maintain our Dimension tables within the Data Warehouse. As well we will explore alternate design patterns that could improve performance

SessionID: 80567

Intro to Cloud ETL: Azure Data Factory V2

Back to calendar

Event Date: 05-05-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bradley Schacht

Title: Intro to Cloud ETL: Azure Data Factory V2

Abstract:

Azure Data Factory (ADF) has long been a service that confused the masses. With pipelines, data sets, availability schedules, and JSON littering the code based environment it was no wonder the learning curve was steep. With the introduction of Azure Data Factory Version 2 that has all changed. The environment is simplified, scheduling is easily understood, pipelines are more straightforward, and there is more functionality now than ever before. Data Factory now feels like a true cloud-born ETL tool for everyone who is already familiar with SSIS. As a bonus, the lift-and-shift story has never been easier as SSIS packages can now be run natively in ADF.

In this session, Brad will walk through the major features including creating the environment, authoring your first pipeline, scheduling, monitoring, deploying SSIS packages, and interacting with on-prem data sets. At the end of this session, you will be ready to orchestrate data movement with Azure Data Factory like a pro!

This site is open source. Improve this page.