sqlsathistory

Nr: 773

Back to Main list

SQLSaturday #773 - Los Angeles 2018

Start Time (24h) Speaker Track Title
09:00:00 Andrew Karcher Database and Application Development Back to Basics - The SELECT Statement
09:00:00 Swagatika Sarangi Business Intelligence and Analytics Platforms Power BI For Master Data Management
09:00:00 Tracy Boggiano Database Administration, Performance Tuning Optimization, and DevOps Collecting Performance Metrics
09:00:00 Allan Hirt Database Administration, Performance Tuning Optimization, and DevOps Infrastructure 101 for SQL Server Deployments
09:00:00 Brodie Brickey Database and Application Development SSIS Basics
09:00:00 Daniel Janik Database Administration, Performance Tuning Optimization, and DevOps A DBA's guide to full stack performance troubleshooting
09:00:00 Mindy Curnutt Database and Application Development An Introduction to SQL Server Spatial Data
09:00:00 Marco Russo Business Intelligence and Analytics Platforms Time intelligence and date tables in Power BI
09:00:00 PEIXIN WANG Database Administration, Performance Tuning Optimization, and DevOps Move Over Dexter! We're Building a Machine Learning Lab!
09:00:00 Chris Hyde Business Intelligence and Analytics Platforms SQL Server R Services in SQL 2016
10:45:00 Randy Knight Professional Development Soft skills for Geeks: Don't be a flat boxer
10:45:00 Andrew Nakamura Database Administration, Performance Tuning Optimization, and DevOps Attack of the Linux Sea Monsters!
10:45:00 Elaena Bakman Database and Application Development The Magic of SSISDB
10:45:00 Leonard Lobel Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) Learning Azure Cosmos DB
10:45:00 Peter Kral Database and Application Development JSON and the Astronauts
10:45:00 Rick Lowe Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?
10:45:00 Chris Hyde Business Intelligence and Analytics Platforms Python in SQL Server 2017
10:45:00 Jeremy Frye Business Intelligence and Analytics Platforms Power BI Deployment Strategies: The Business versus I.T.
10:45:00 SQL Saturday in LA Professional Development Women in Technology (lead by Amy Herold and Mindy Curnutt)
12:45:00 Marsha Pierce Database Administration, Performance Tuning Optimization, and DevOps How To Talk To Your Storage Admin
12:45:00 Amie Mason Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) Azure Intelligent Services
12:45:00 Richard Waymire Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) SQL Server on Amazon Web Services
12:45:00 SQL Saturday in LA Database Administration, Performance Tuning Optimization, and DevOps Rubrik: Sponsor Session
12:45:00 SQL Saturday in LA Database Administration, Performance Tuning Optimization, and DevOps Quest: Sponsor Session
12:45:00 SQL Saturday in LA Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) CloudHealth: Master Rightsizing Reserved Instances for AWS Azure
12:45:00 SQL Saturday in LA Database and Application Development DELL-EMC: Sponsor Session
12:45:00 Brandon Leach Database Administration, Performance Tuning Optimization, and DevOps Virtualizing SQL Server on vSphere. Doing it Right!
12:45:00 Suresh Datla Business Intelligence and Analytics Platforms Power BI Dashboard - Creating End to End Solutions
14:00:00 Armando Lacerda Business Intelligence and Analytics Platforms Insights with massive data ingestion and Power BI
14:00:00 Jeff Mlakar Database Administration, Performance Tuning Optimization, and DevOps Environmental SQL Server Troubleshooting
14:00:00 Benjamin Nevarez Database and Application Development Understanding Parameter Sniffing
14:00:00 Nathaniel Payumo Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) My Journey to AWS
14:00:00 Ted Stathakis Business Intelligence and Analytics Platforms Reporting Services 2016: New Features Smart Migration Strategy
14:00:00 Konstantin Melamud Business Intelligence and Analytics Platforms Optimizing your data warehouse for OLAP Processing
14:00:00 Steve Jones Professional Development Branding Yourself for a Dream Job
14:00:00 John Sterrett Database Administration, Performance Tuning Optimization, and DevOps Automate the Pain Away with Adaptive Query Processing and Automatic Tuning
14:00:00 Jason Horner Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
15:45:00 Phil Robinson Business Intelligence and Analytics Platforms Data Wrangling for Reporting Analytics using Power BI M
15:45:00 Ike Ellis Business Intelligence and Analytics Platforms 60 Reporting Tips in 60 Minutes
15:45:00 Kevin Ngo Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) Azure SQL Data Warehouse - The next generation of cloud data warehousing
15:45:00 Jeff Prom Database Administration, Performance Tuning Optimization, and DevOps Save Valuable Time and Resources - Job Performance Tuning Strategies
15:45:00 Charles Embry Jr Database and Application Development The Mac DBA, using Docker and SQL Operations Studio
15:45:00 Brian Carrig Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS) Successfully Running SQL Server in AWS
15:45:00 Amy Herold Database Administration, Performance Tuning Optimization, and DevOps Hi, my name is Powershell, let's be friends! An Intro to PoSH
15:45:00 Jay Falck Database Administration, Performance Tuning Optimization, and DevOps Linux for SQL Server
15:45:00 Rushabh Mehta Database Administration, Performance Tuning Optimization, and DevOps GDPR – New age of data protection and privacy

SessionID: 77882

Back to Basics - The SELECT Statement

Back to calendar

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

Speaker: Andrew Karcher

Title: Back to Basics - The SELECT Statement

Abstract:

If you are going to do anything with data you are going to need to learn how to query data. And the language to query the majority of those systems is through SQL (Structured Query Language). The pull data from any systems you are going to be relying on the Select statement. The features in the statement may vary slightly from platform to platform, but the core capabilities are the same.

In this session, we will dive deep in to the SELECT statement as the window to getting your data. In this session, we will be using one platform, but the lessons learned here will be applicable to querying any system that supports a SQL language interface. This session will cover things like querying, joins, functions, aggregation, sub queries, and much more. This session will give you the foundation to start analyzing data in any database system.

SessionID: 78407

Power BI For Master Data Management

Back to calendar

Event Date: 09-06-2018 - Session time: 09:00:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Swagatika Sarangi

Title: Power BI For Master Data Management

Abstract:

Have you ever come across such business scenarios when you feel you have challenged your Reticular Activating System to find an “out-of-the-box solution for Master Data Management in your Reporting System”? Have you ever thought about a self-service BI system, designed and customized, only for your Master Data? Often times, in IT industry executives neglect the fact that 30% of their data visualization contains Master Data.

Integrating Master Data Services with Power BI, and presenting analytics on top only Master Data, can provide a high-end leverage to your organization. Whether it is a location model, a product model, a customer model etc., executives can highly be insightful from a report that contains all master data domains consolidated with a better visualization. Using individual subscription views from Master Data Services(SQL Server 2017) in Power Query, and utilizing all the cross references entities across models in MDS – can lead to a great one page report via Power BI.

SessionID: 78611

Collecting Performance Metrics

Back to calendar

Event Date: 09-06-2018 - Session time: 09:00:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Tracy Boggiano

Title: Collecting Performance Metrics

Abstract:

Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or if a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? If only you had performance metrics from your existing servers to answer these questions.

In this session, we will be combining three open source tools (Telegraf, InfluxDB, and Grafana) into an inexpensive system that collects performance metrics you can use to troubleshoot and answer important questions about your SQL Server instances, including your SQL Server on Linux instances. We will learn what data to collect, how to use the tools mentioned to collect that data and then we'll put it all together in an interactive dashboard for easy visualization.

SessionID: 78724

Infrastructure 101 for SQL Server Deployments

Back to calendar

Event Date: 09-06-2018 - Session time: 09:00:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Allan Hirt

Title: Infrastructure 101 for SQL Server Deployments

Abstract:

In a cloudy, virtualized world where we have less physical deployments of SQL Server, those responsible for SQL Server still need to understand basic infrastructure concepts whether you are deploying on Windows Server or Linux. Without them, your VMs and IaaS deployments will not scale, will underperform, and most likely will have poor availability. This session will cover the basics of what you need to know whether you are deploying SQL Server on premises or in the public cloud to go from SQL Server zero to SQL Server hero and be able to have better working relationships with the other administrators in your organization.

SessionID: 80910

SSIS Basics

Back to calendar

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

Speaker: Brodie Brickey

Title: SSIS Basics

Abstract:

Integration Services (SSIS) can be a very powerful tool for data loading as well as many other functions. In this demo we'll cover some methods for getting started with this program.

SessionID: 81966

A DBA's guide to full stack performance troubleshooting

Back to calendar

Event Date: 09-06-2018 - Session time: 09:00:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Daniel Janik

Title: A DBA's guide to full stack performance troubleshooting

Abstract:

Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood.

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.

SessionID: 82109

An Introduction to SQL Server Spatial Data

Back to calendar

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

Speaker: Mindy Curnutt

Title: An Introduction to SQL Server Spatial Data

Abstract:

Way, way back in SQL 2008 Microsoft added the capability to store and work with geospatial data types. (Wait...what's this you say?!?) Well, yes...it's been there for quite some time now. You can actually store spatial data in SQL tables (in the form of points, lines and polygons). There are also many powerful, built-in functions that allow the manipulation and calculation of results around this data. This is a powerful, but sadly underused feature of the product given that IoT tends to be so focused around the location of things.

Come to this session to learn about: ● The two elusive data types (geography and geometry) ● T-SQL Spatial routines and functions ● How to load spatial data ● Spatial Indexes - how they work and when they're useful ● Where you can get lots and lots of free spatial data to supplement your existing systems

SessionID: 82294

Time intelligence and date tables in Power BI

Back to calendar

Event Date: 09-06-2018 - Session time: 09:00:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Marco Russo

Title: Time intelligence and date tables in Power BI

Abstract:

Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, weeks based fiscal calendars and any non-standard calculation’

This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.

SessionID: 82984

Move Over Dexter! We're Building a Machine Learning Lab!

Back to calendar

Event Date: 09-06-2018 - Session time: 09:00:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: PEIXIN WANG

Title: Move Over Dexter! We're Building a Machine Learning Lab!

Abstract:

Dexter and Dee Dee are at it again! They managed to save the city with his super intellect and sister's hyperactive charm. We won't have to keep our lab a secret as you attend this session. Learn how to build your own Machine Learning Lab, without the keeping it underground. We will cover the fundamental knowledge to get started because you don't want you blowing up things in production. Learn step-by-step in my demo to build a full lab so you too can save the city…or at least get started with Machine Learning today.

SessionID: 83591

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 09-06-2018 - Session time: 09:00:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 77720

Soft skills for Geeks: Don't be a flat boxer

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Professional Development

Speaker: Randy Knight

Title: Soft skills for Geeks: Don't be a flat boxer

Abstract:

If you like being the surly IT geek who lives in a dark office and gets fed pizza under the door (i.e. a flat boxer) this session is NOT for you. However, if promotion, appreciation for what you do, and the adoration of your peers and management are appealing to you, you might want to participate in this one.

SessionID: 78564

Attack of the Linux Sea Monsters!

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Andrew Nakamura

Title: Attack of the Linux Sea Monsters!

Abstract:

Take a dive into SQL on Linux and take on some sea monsters that are lurking in your bathtub. We'll take on the biblical Leviathan and answer: Why learn SQL on Linux anyway? We'll hunt down Moby Dick by sharpening our harpoons, by using tools you're probably already using with on Windows. After getting our feet wet, we'll go after the legendary beast, The Kraken, by leveraging your existing skills with Linux. Don't be eaten alive by Jaws and all the new fast-paced piranha-like features of SQL 2017. You can sail safely into the sunset by making SQL on Linux fun, memorable and learning lasting skills that will future proof your career. If you can install, backup, and restore SQL on Windows in your sleep, then perhaps now is the time to jump in. Be careful, you might get wet in the splash zones so dress accordingly or at least bring weather proof gear. Anchors Away!

SessionID: 80014

The Magic of SSISDB

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Database and Application Development

Speaker: Elaena Bakman

Title: The Magic of SSISDB

Abstract:

The purpose of this presentation is to provide a better understanding of SSISDB and how it can be utilized to make the lives of developers and DBAs easier.

This presentation will demonstrate how to use SSISDB to script out deployments of folders, projects, environments and packages, and dynamically assign environment variables. We will write scripts to run our SSIS packages and use SSRS to kick them off. We will learn how to create SSRS Reports that recreate the All Executions and All Messages built-in reports and make them available to user developers.

SessionID: 80072

Learning Azure Cosmos DB

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: Leonard Lobel

Title: Learning Azure Cosmos DB

Abstract:

This session presents an overview of Azure Cosmos DB, a globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service that is designed specifically for modern web and mobile applications. Like other NoSQL platforms, Cosmos DB supports a schema-free data model, built-in partitioning for sustained heavy-write ingestion, and replication for high availability. But only Cosmos DB offers turnkey global distribution, automatic indexing, and SLAs for guarantees on 99.99% availability, throughput, latency, and consistency.

We tour many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON, graph, key/value, and columnar data models. You’ll learn about global distribution, scale-out partitioning, tunable consistency, custom indexing, and more. We’ll also explore client development using the many available SDKs and APIs. Attend this session, and get up to speed on Cosmos DB toda

SessionID: 80510

JSON and the Astronauts

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Database and Application Development

Speaker: Peter Kral

Title: JSON and the Astronauts

Abstract:

In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we'll learn to validate, read, and manipulate "unstructured" JSON data. We'll get The Right Stuff to start developing, no previous JSON experience required. Let's go where NoSQL has gone before!

Prerequisites: You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.

SessionID: 80925

SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: Rick Lowe

Title: SQL Server on Amazon Web Services - Elastic Compute Cloud vs Relational Database Service?

Abstract:

Amazon web services offers a befuddling number of of different services. Among these are the two major options for running SQL Server on AWS - Elastic Compute Cloud and Relational Database Services. Why would one be picked over the other? What are the limitations and trade offs? We will discuss these questions among others while working through the process of restoring a sample database under both services.

SessionID: 82095

Python in SQL Server 2017

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 82194

Power BI Deployment Strategies: The Business versus I.T.

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Jeremy Frye

Title: Power BI Deployment Strategies: The Business versus I.T.

Abstract:

Microsoft’s Power BI service has allowed end users and business analysts to exercise their creativity as developers. The expansion of department resources to create elegant and visually appealing reports for themselves and their organization at a fast pace, has taken some of the burden off developers, or has it?

Are you hoarding your environment with unorganized piles of data to feed your wonderful Power BI reports? In this life of point and click, drag and drop reporting, we sometimes lose sight of cohesive business standards, data integration and data modeling. In this session, we will look at potential data management concerns that include but are not limited to; overlapping data, inconsistent naming conventions, undocumented transformations, mismatch data types and varying granularity. We will focus on the importance of having a solid data model and managing data governance using Power BI as well as traditional tools and best practices.

SessionID: 82431

Women in Technology (lead by Amy Herold and Mindy Curnutt)

Back to calendar

Event Date: 09-06-2018 - Session time: 10:45:00 - Track: Professional Development

Speaker: SQL Saturday in LA

Title: Women in Technology (lead by Amy Herold and Mindy Curnutt)

Abstract:

Join our interactive discussion on diversity and inclusion. This WIT talk is open to all attendees. Let’s share our perspectives in career growth in this inevitable diverse industry. Learn some tips and tricks on how you can grow your potential and help others to grow as well.

Session format:

SessionID: 77689

How To Talk To Your Storage Admin

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 80227

Azure Intelligent Services

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: Amie Mason

Title: Azure Intelligent Services

Abstract:

Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.

SessionID: 82206

SQL Server on Amazon Web Services

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: Richard Waymire

Title: SQL Server on Amazon Web Services

Abstract:

This session will explore how to host your SQL Server databases on Amazon Web Services (AWS), comparing the Relational Database Service (RDS) SQL Server platform to hosting your databases on EC2. We will explore the versions supported, provide an overview of how licensing works, explain options around High Availability, and also explore migration options from on-premise, EC2, or other hosted SQL Server solutions.

SessionID: 82215

Rubrik: Sponsor Session

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: SQL Saturday in LA

Title: Rubrik: Sponsor Session

Abstract:

TBD

SessionID: 82220

Quest: Sponsor Session

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: SQL Saturday in LA

Title: Quest: Sponsor Session

Abstract:

TBD

SessionID: 82221

CloudHealth: Master Rightsizing Reserved Instances for AWS Azure

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: SQL Saturday in LA

Title: CloudHealth: Master Rightsizing Reserved Instances for AWS Azure

Abstract:

Many organizations have over- or under-utilized assets in their cloud infrastructure. While running infrastructure in the cloud can yield many benefits in terms of agility and innovation, it can also lead to increased costs. In this session we will walk you through the process of rightsizing, as well as how to take advantage of Reserved Instances once your infrastructure is running efficiently. This session will be beneficial for anyone using AWS, Azure, or both!

SessionID: 82224

DELL-EMC: Sponsor Session

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Database and Application Development

Speaker: SQL Saturday in LA

Title: DELL-EMC: Sponsor Session

Abstract:

TBD

SessionID: 82323

Virtualizing SQL Server on vSphere. Doing it Right!

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Brandon Leach

Title: Virtualizing SQL Server on vSphere. Doing it Right!

Abstract:

For most DBAs virtualization is no longer a matter of "If" but "When". This means it is critical for DBAs to understand how this technology works and how we can ensure we get the most performance and scalability out of it. In this session we will look at some of the best practices and gotchas when Designing Standalone and Highly Available SQL deployments in a vSphere environment. We'll also cover how to troubleshoot performance issues when they arise.

SessionID: 83214

Power BI Dashboard - Creating End to End Solutions

Back to calendar

Event Date: 09-06-2018 - Session time: 12:45:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Suresh Datla

Title: Power BI Dashboard - Creating End to End Solutions

Abstract:

We will be discussing the lifecycle of a Power BI Dashboard beginning from

Accessing data, Data preparation, and cleansing, consuming the data for reports and deploying the reports to Power BI services, configuring security and making the Dashboards available to end users.

SessionID: 77337

Insights with massive data ingestion and Power BI

Back to calendar

Event Date: 09-06-2018 - Session time: 14:00:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Armando Lacerda

Title: Insights with massive data ingestion and Power BI

Abstract:

We all love Power BI and its abilities to show data insights through its interface. But Power BI has its limits when it comes to massive data ingestion and near real time dashboards. In this presentation we will evaluate some out of the box solutions to render metrics and KPIs from massive loads that extrapolates Power BI limits.

SessionID: 77364

Environmental SQL Server Troubleshooting

Back to calendar

Event Date: 09-06-2018 - Session time: 14:00:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Jeff Mlakar

Title: Environmental SQL Server Troubleshooting

Abstract:

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!

SessionID: 80913

Understanding Parameter Sniffing

Back to calendar

Event Date: 09-06-2018 - Session time: 14:00:00 - Track: Database and Application Development

Speaker: Benjamin Nevarez

Title: Understanding Parameter Sniffing

Abstract:

Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.

SessionID: 80922

My Journey to AWS

Back to calendar

Event Date: 09-06-2018 - Session time: 14:00:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: Nathaniel Payumo

Title: My Journey to AWS

Abstract:

This session will discuss the trials and tribulations encountered when shifting from on-premise databases into AWS. We will cover topics such as: permissions, EC2 RDS setup, Database Migration Services, using Amazon S3 to transfer and restore databases, and cost analysis.

SessionID: 82161

Reporting Services 2016: New Features Smart Migration Strategy

Back to calendar

Event Date: 09-06-2018 - Session time: 14:00:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Ted Stathakis

Title: Reporting Services 2016: New Features Smart Migration Strategy

Abstract:

With the release of SQL Server 2016, Reporting Services finally got some love! In this session, you will get an overview of some of the new features and functionality in SSRS 2016: A look at the new Report Manager interface, Mobile reports, KPIS and the new control we have over the placement of parameters. We will also look at the new Mobile Report Publisher app and see how easy it is to take an existing report and make it mobile friendly.

The session will then dive into how to use the data in the ReportServer database tables to see which reports in your environment are being used and how well they are performing. With this understanding you can determine which reports, data sets and data sources to migrate to a new 2016 installation. Come see how to leverage PowerShell to extract the reports from the database, instead of having to download them from Report Manager, to facilitate an easy migration to a new SQL Server 2016 Reporting Services implementation.

SessionID: 82197

Optimizing your data warehouse for OLAP Processing

Back to calendar

Event Date: 09-06-2018 - Session time: 14:00:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Konstantin Melamud

Title: Optimizing your data warehouse for OLAP Processing

Abstract:

Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS and the database engine to ensure optimal performance, as well as enterprise level features within the database engine and SSAS available to us and how aligning those to work side by side would yield us significant improvement in our processing time.

SessionID: 82225

Branding Yourself for a Dream Job

Back to calendar

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

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job

Abstract:

Everyone wants a great job that they enjoy, but few of us know how to take charge of our career. Learn why it's important to raise your profile in today's highly competitive world where there are often more candidates than positions for great jobs. This session will help you build a strong brand that allows you to attract potential employers or clients and start to convince them ahead of time that you are the person they want to hire.

SessionID: 82359

Automate the Pain Away with Adaptive Query Processing and Automatic Tuning

Back to calendar

Event Date: 09-06-2018 - Session time: 14:00:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: John Sterrett

Title: Automate the Pain Away with Adaptive Query Processing and Automatic Tuning

Abstract:

The way you tune your SQL Server workloads are changing. In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events. In SQL Server 2012 we were introduced to Columnstore indexes; In SQL 2014 the cardinality estimator got a huge overhaul. With SQL Server 2016 we were given query store to allow us to get more insight into our performance pains and execution plan changes. SQL Server 2017 gave us Automatic Tuning and Adaptive Query Processing to help automate performance improvements. In this session, we will harness the ways you improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.

SessionID: 82567

Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2

Back to calendar

Event Date: 09-06-2018 - Session time: 14:00:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: Jason Horner

Title: Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2

Abstract:

In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.

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: 77334

Data Wrangling for Reporting Analytics using Power BI M

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Phil Robinson

Title: Data Wrangling for Reporting Analytics using Power BI M

Abstract:

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse.

Mashups using data from partners, commercial and public sources are fast becoming the new normal. Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening? Need to determine the quality of a file downloaded from the internet or supplied by another party? In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.

SessionID: 77353

60 Reporting Tips in 60 Minutes

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Business Intelligence and Analytics Platforms

Speaker: Ike Ellis

Title: 60 Reporting Tips in 60 Minutes

Abstract:

Microsoft report authors work in several tools, including T-SQL, SSMS, SSRS, and Power BI. Come to this session to learn 60 rapid fire tips that will make you not only be better, but increase you enjoyment working with those tools.

SessionID: 77385

Azure SQL Data Warehouse - The next generation of cloud data warehousing

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: Kevin Ngo

Title: Azure SQL Data Warehouse - The next generation of cloud data warehousing

Abstract:

Learn about Azure SQL Data Warehouse (SQL DW) which is a fully managed elastic database built for data warehouse workloads supporting up to petabytes of data. It has unique features like disaggregated compute and storage allowing customers to be able to utilize the service to match their diverse needs. In this session, we take a look at the architecture of SQL DW and features such as elastic scale (grow, shrink, and pause) and Polybase and how you take advantage of them for your data warehousing solution.

SessionID: 77411

Save Valuable Time and Resources - Job Performance Tuning Strategies

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Jeff Prom

Title: Save Valuable Time and Resources - Job Performance Tuning Strategies

Abstract:

We all know that execution plans and indexes are important pieces to performance tuning jobs. However, they are definitely not the only tools in the toolbox. This session will take a more high-level, holistic, approach to performance tuning jobs and their components. We will talk about where to start, how to identify problem areas, and many ways to improve performance. Many of the topics covered in the presentation come from real-world situations I've encountered. One example describes how we stopped a job after 13 hours and were able to tune it down to 8 minutes. Adding additional hardware is not always an option or the answer. Do more with what you have and tune your jobs. I'll show you how.

SessionID: 78233

The Mac DBA, using Docker and SQL Operations Studio

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Database and Application Development

Speaker: Charles Embry Jr

Title: The Mac DBA, using Docker and SQL Operations Studio

Abstract:

In this session we will go over the steps involved with getting a Database Dev environment set up on your Mac using SQL Server on Linux,Docker and SQL Operations Studio. We will go over installation of Docker and SQL Server, tips and tricks on data persistence in Docker, and how to connect and work with SQL Server running Docker using SQL Operations Studio.

SessionID: 80290

Successfully Running SQL Server in AWS

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Cloud Infrastructure (SaaS, PaaS, IaaS, DRaaS)

Speaker: Brian Carrig

Title: Successfully Running SQL Server in AWS

Abstract:

Amazon Web Services (AWS) is the world's largest public cloud hosting provider, with many companies successfully running SQL server on AWS infrastructure, but trying to make sense of the available options can be daunting. In this session, we will explore the options available for running SQL server in AWS, either as a managed service or using dedicated EC2 instances. We will document the different storage options, High Availability strategies, as well as important security and maintenance caveats. We will also cover various licensing approaches available when running SQL server in AWS.

SessionID: 82102

Hi, my name is Powershell, let's be friends! An Intro to PoSH

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Amy Herold

Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH

Abstract:

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

SessionID: 82425

Linux for SQL Server

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Jay Falck

Title: Linux for SQL Server

Abstract:

SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.

NOTE: This is an intro to Linux for Windows users, only brief references to SQL Server on Linux will be made.

SessionID: 83007

GDPR – New age of data protection and privacy

Back to calendar

Event Date: 09-06-2018 - Session time: 15:45:00 - Track: Database Administration, Performance Tuning Optimization, and DevOps

Speaker: Rushabh Mehta

Title: GDPR – New age of data protection and privacy

Abstract:

The General Data Protection Regulation (GDPR), which took effect on May 25, 2018 heralds a new era of enhanced personal privacy rights and adds additional duty to companies for protecting data. However, it’s not just about protecting the privacy of personal data of EU citizens. Data breaches such as at Target, Equifax, Uber and many others, result in loss of customers, loss of profits and cost executive jobs. A survey by Forrester reveals that 74% of individuals are ready to switch to a competitor if their bank or insurer suffers a data breach. Security and Privacy capabilities ranks as the number 1 initiative by 55% of organizations in a 2017 Customer Priorities Journey Survey.

In this session, we will discuss all things data protection with the Microsoft Data Platform. Whether it is to comply with the requirements of GDPR or ensuring that your data is the most secure it can be.

This site is open source. Improve this page.