sqlsathistory

Nr: 683

SQLSaturday #683 - Charlotte 2017

Start Time (24h)	Speaker	Track	Title
09:00:00	Leila Etaati	Advanced Analysis Techniques	Advanced Analytics with R, Microsoft SQL Server, Power BI, and Az
09:00:00	Melissa Coates	Cloud Application Development Deployment	Architecting a Data Lake to Modernize Your Data Warehouse
08:45:00	Tracy Boggiano	Enterprise Database Administration Deployment	Query Store Primer
08:45:00	Kellyn Pot'Vin-Gorman	Strategy and Architecture	DevOps for the DBA
08:45:00	Thomas Norman	Enterprise Database Administration Deployment	Database Project Makes Deployment Consistent
08:45:00	Anders Pedersen	Application Database Development	I/O Tuning 101
08:45:00	Chris Bell	Enterprise Database Administration Deployment	5 Minute No Sweat SQL Security Audits
08:45:00	Jeff Mlakar	Enterprise Database Administration Deployment	Environmental SQL Server Troubleshooting
08:45:00	Azhagappan Arunachalam	BI Platform Architecture, Development Administration	Excel with DAX
08:45:00	Andy Leonard	BI Platform Architecture, Development Administration	Faster SSIS
08:45:00	Michael Wharton	Cloud Application Development Deployment	Create SQL Server VM, Active Directory VM and App Server VM in Az
10:00:00	Simon Kingaby	BI Platform Architecture, Development Administration	Implementing an SSIS Framework and enforcing SSIS Patterns (with Biml).
10:00:00	Melissa Coates	BI Platform Architecture, Development Administration	Designing a Modern Data Warehouse + Data Lake
10:00:00	Kevin Feasel	Application Database Development	Using Kafka for Real-Time Data Ingestion with .NET
10:00:00	Kiran Math	Advanced Analysis Techniques	R For Sql Developers
10:00:00	Stephen Muliokela	Enterprise Database Administration Deployment	Database Corruption
10:00:00	Robert Smith	Application Database Development	Table Partitioning 101
10:00:00	David Mellinger	BI Platform Architecture, Development Administration	SQL Server 2017 New BI Features
10:00:00	Thomas Chan	Enterprise Database Administration Deployment	Finding more space for your tight environment.
10:00:00	Prabhaker Potharaju	BI Platform Architecture, Development Administration	Master Data Services Overview
11:15:00	Jeffrey Garbus	Enterprise Database Administration Deployment	Indexing for performance
11:15:00	Sean Werick	BI Information Delivery	SSRS 2016 or Power BI?....or Both?
11:15:00	Kevin Kline	Application Database Development	Secrets of the Query Optimizer Revealed Using Trace Flag 86xx
11:15:00	boB Taylor	Application Database Development	Solving Real World DevOps Problems - Customer success stories (90 min)
11:15:00	Leveat Ruse	Professional Development	Interviewing-Be So Good They Can’t Ignore You
11:15:00	Reza Rad	BI Information Delivery	Take Power BI Visualization to the Next Level
11:15:00	Jeff Renz	BI Platform Architecture, Development Administration	Introduction to Ensemble Modeling
12:30:00	Jeffrey Garbus	Sponsor Session	Soaring Eagle: How to be a GREAT DBA
12:30:00	Matt Henderson	Sponsor Session	Vexata: Architecting for performance
12:30:00	Kevin Kline	Sponsor Session	SentryOne: SQL Query Tuning Horror Stories
12:30:00	Vincent Staropoli	Sponsor Session	Cardinal Solutions: Advanced Analytics with SQL Server 2017
12:30:00	Ben Page	Sponsor Session	DellEMC: The Path to #GetModern
13:45:00	Julie Smith	BI Information Delivery	H*ckin Sweet Reports with Power BI
13:45:00	Richard Weiss	Cloud Application Development Deployment	A Tour of Cloud Data Platforms as a Service
13:45:00	Brad Llewellyn	Advanced Analysis Techniques	Azure Machine Learning: Making Data Science Easy(er)
13:45:00	Jared Poché	Enterprise Database Administration Deployment	Using DMVs for Performance Root Cause
13:45:00	Brian Carrig	Enterprise Database Administration Deployment	How to Manage Very Large Databases with SQL Server
13:45:00	Lindsay Clark	Professional Development	TechGirlz How You Can Help Usher In The Next Generation
13:45:00	Maxwell Myrick	Strategy and Architecture	The Art and Science of Designing a Mission Critical SQL Server
13:45:00	Elizabeth Noble	Application Database Development	Making Your List and Checking It Twice: Introduction to unit testing with tSQLt
13:45:00	Geoff Hiten	Cloud Application Development Deployment	ARMed for Azure
15:00:00	Mindy Curnutt	Professional Development	Impostor Syndrome: Are You Faking It Will they Find Out?
15:00:00	George Walkey	Enterprise Database Administration Deployment	Using Powershell to Document SQL Server
15:00:00	Shannon Lowder	BI Platform Architecture, Development Administration	Build Your Extract Packages Automatically!
15:00:00	Rick Heiges	Professional Development	SQL Games
15:00:00	Andy Mallon	Application Database Development	Demystifying Data Compression
15:00:00	Matt Gordon	Strategy and Architecture	Where Should My Data Live (and Why)?
15:00:00	Leila Etaati	Advanced Analysis Techniques	Azure ML Algorithm Accuracy Enhancement, Tips and Tricks
15:00:00	Carlos L Chacon	Enterprise Database Administration Deployment	Measure Performance Through Baselines
15:00:00	Reza Rad	BI Platform Architecture, Development Administration	Deep Dive into Power Query and M

SessionID: 69574

Advanced Analytics with R, Microsoft SQL Server, Power BI, and Az

Back to calendar

Event Date: 14-10-2017 - Session time: 09:00:00 - Track: Advanced Analysis Techniques

Speaker: Leila Etaati

Title: Advanced Analytics with R, Microsoft SQL Server, Power BI, and Az

Abstract:

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

Azure ML:

The main functionality of Azure ML and how to set it up.

Different components in Azure environments Such as Data import and Export into Azure studio in “Dataset” component using “Import Data”, “Export Data”, “Enter Data Manually”.

Using “Reader” component to fetch data from cloud services

Data format conversion such as “Convert to CSV”, “Convert to Dataset”

Manipulation: Add columns and rows, Apply SQL Transformation, Clean Missing Data, Join Data, Remove Duplicate Row, Select Column in Dataset.

Split and Sample: Partition and Sample and Split Data.

Scale and reduce: Group Data in Bins and Normalize Data.

SessionID: 69575

Architecting a Data Lake to Modernize Your Data Warehouse

Back to calendar

Event Date: 14-10-2017 - Session time: 09:00:00 - Track: Cloud Application Development Deployment

Speaker: Melissa Coates

Title: Architecting a Data Lake to Modernize Your Data Warehouse

Abstract:

This full-day session will focus on principles for designing and implementing a data lake. There will be a mix of concepts, lessons learned, and technical implementation details. During the session we will build a data lake from the ground up, populate it, organize it, secure it, integrate it with a data warehouse via logical constructs, and query the data. You will leave this session with an understanding of the benefits and challenges of a multi-platform analytics/DW/BI environment, as well as recommendations for how to get started.

Target audience:

Technologists who are considering using a data lake. No data lake experience is required. However, familiarity with SQL Server and data warehousing is suggested, as the scenarios discussed will primarily focus on extending functionality and improving agility for an existing data warehouse.

You will learn in this session:

Scenarios and use cases for expanding an analytics/DW/BI environment into a multi-platform environment

SessionID: 67088

Query Store Primer

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Query Store Primer

Abstract:

This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems new features in 2017.

SessionID: 67098

DevOps for the DBA

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: Strategy and Architecture

Speaker: Kellyn Pot'Vin-Gorman

Title: DevOps for the DBA

Abstract:

DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data.

This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as: • Develop, Rinse, Repeat • Test Until Your Five Year Old Can Do It • Human Intervention Creates Human Error- Automate EVERYTHING.

SessionID: 67143

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

SessionID: 67366

I/O Tuning 101

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: Application Database Development

Speaker: Anders Pedersen

Title: I/O Tuning 101

Abstract:

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query. Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.

SessionID: 67437

5 Minute No Sweat SQL Security Audits

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Bell

Title: 5 Minute No Sweat SQL Security Audits

Abstract:

Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the requirements it may take considerable time to gather the information you will need.

In this session, you will get scripts that I use for compliance audits that help to collect the information required for many different audits quickly. Even when you have multiple SQL Servers, you can quickly and easily identify where to focus your efforts to ensure you pass security audits. Through demonstration and discussion of what and why certain items get reviewed you will leave with a better understanding of how to be compliant within you SQL Server environment.

SessionID: 68304

Environmental SQL Server Troubleshooting

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

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

Excel with DAX

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Azhagappan Arunachalam

Title: Excel with DAX

Abstract:

DAX is the new formula language (builds upon Excel's) supporting PowerPivot and Analysis Services Tabular mode. If you know Excel, you already know the basics of DAX (without even knowing it). PowerBI also uses DAX for all the formula expressions. We'll cover the basics of DAX, and go over some time intelligence functions.

SessionID: 68809

Faster SSIS

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andy Leonard

Title: Faster SSIS

Abstract:

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.

SessionID: 69486

Create SQL Server VM, Active Directory VM and App Server VM in Az

Back to calendar

Event Date: 14-10-2017 - Session time: 08:45:00 - Track: Cloud Application Development Deployment

Speaker: Michael Wharton

Title: Create SQL Server VM, Active Directory VM and App Server VM in Az

Abstract:

Getting started with basics of Azure environment, such as Accounts, VNET, Storage and creating VMS. Once we fly by reviewing several building blocks, we then build Active Directory VM, SQL Server VM and App Server Tier VM using Azure portal and PowerShell.

SessionID: 67091

Implementing an SSIS Framework and enforcing SSIS Patterns (with Biml).

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Kingaby

Title: Implementing an SSIS Framework and enforcing SSIS Patterns (with Biml).

Abstract:

Let's use Biml to automate the implementation of a standard, pattern-based SSIS Framework. I.e. Logging, error handling, etc. Business Intelligence Markup Language (Biml) is great at automating the creation of SSIS packages. With Biml we can generate a template package that implements a standard SSIS framework. In this fast-paced session, we will create the tables and load some metadata, write the Biml to implement logging and error handling, and generate some packages that implement our standard framework. In this session, you don't need to know Biml, but some familiarity with XML, TSQL or C# will help. By the end of this session, you will know how to use Biml to automatically generate packages that implement a simple SSIS Framework with Audit Logging and Error Handling.

SessionID: 67378

Designing a Modern Data Warehouse + Data Lake

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Designing a Modern Data Warehouse + Data Lake

Abstract:

Join us for a discussion of strategies and architecture options for implementing a modern data warehousing environment. We will explore advantages of augmenting an existing data warehouse investment with a data lake, and ideas for organizing the data lake for optimal data retrieval. We will also look at situations when federated queries are appropriate for employing data virtualization, and how federated queries work with SQL Server, Azure SQL DB, Azure SQL DW, Azure Data Lake, and/or Azure Blob Storage.

SessionID: 67389

Using Kafka for Real-Time Data Ingestion with .NET

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Using Kafka for Real-Time Data Ingestion with .NET

Abstract:

SessionID: 68048

R For Sql Developers

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Advanced Analysis Techniques

Speaker: Kiran Math

Title: R For Sql Developers

Abstract:

15 Mins : Introduction To R Data Structures

5 Mins : R Markdown 10 Mins : Functional Programming - R Functions 15 Mins : RevoScaleR Package 15 MIns : Operationalized R

All Section will be demonstrated using very simple examples.

Data Modeling and Data Visualization will not be covered in this session. Familiarity with RTVS ( R Tools for Visual Studio) or R Studio will be helpful

Download R Studio : - https://www.rstudio.com/ Download Open R : - https://mran.revolutionanalytics.com/

SessionID: 68268

Database Corruption

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Stephen Muliokela

Title: Database Corruption

Abstract:

Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption?

The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues. Highlight of topics

Why corruption occurs?
Detecting corruption – how SQL Servers detects corruption at the page level.
Different types of corruption- e.g. False alarms, memory corruption etc.
Limitation of DBCC how to speed the DBCC process.
Undocumented DBCC commands.
Monitoring I/O errors.
Verifying backup for corruption.

SessionID: 68578

Table Partitioning 101

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Application Database Development

Speaker: Robert Smith

Title: Table Partitioning 101

Abstract:

Do you have large tables you can’t delete old data from or perform maintenance on? Then this may be for you! Table Partitioning 101 will make an introduction to table partitioning through the GUI and a code based approach. The session will be a discussion about how to make it work and will include: creating partitioned tables, partition schemes, left vs. right facing partition functions and how to do a basic switch operation. A small deep dive about how to find out which partition your data is in and what exactly does it mean for an index to be “aligned” will also be discussed.

SessionID: 68865

SQL Server 2017 New BI Features

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Mellinger

Title: SQL Server 2017 New BI Features

Abstract:

While SQL Server on Linux is getting the major marketing push for 2017, there are plenty of other new features which will also be included in SQL Server 2017. This session will provide an overview and some demos on new features in SQL Server BI tools. This will include changes to SSAS, SSIS, SSRS (Power BI Report Server), and Machine Learning Services (formerly R Services).

SessionID: 68928

Finding more space for your tight environment.

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Chan

Title: Finding more space for your tight environment.

Abstract:

If you do not have enough space in your hard disk and do not want buy more space, one way to get more space is compress the tables and also do some house keeping.

I will use T-SQL script to generate script to compress each tables and release the free space by shrinking the datafiles. And in the final I will defragment the indexes and update the statistics, since shrink datafile is not fragmentation aware task.

SessionID: 69029

Master Data Services Overview

Back to calendar

Event Date: 14-10-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Prabhaker Potharaju

Title: Master Data Services Overview

Abstract:

Description of Session: Master Data Services (MDS) helps organizations standardize and streamline the business data customers use across their organization to make critical business decisions. MDS is a Master Data Management (MDM) application built from platform components which may be deployed as an application or extended by use of the platform components to consistently define and manage the critical data entities of an organization. This session will cover an overview of MDS services installation, configuration and how customers can manage critical data assets by enforcing data quality rules, defining workflows around data changes, managing hierarchies etc.

SessionID: 67453

Indexing for performance

Back to calendar

Event Date: 14-10-2017 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeffrey Garbus

Title: Indexing for performance

Abstract:

Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

SessionID: 68255

SSRS 2016 or Power BI?....or Both?

Back to calendar

Event Date: 14-10-2017 - Session time: 11:15:00 - Track: BI Information Delivery

Speaker: Sean Werick

Title: SSRS 2016 or Power BI?....or Both?

Abstract:

One of the most frequent questions around Microsoft visualizations and reporting platforms is whether to choose Power BI or SSRS 2016. We will provide brief overviews of each, the pros and cons of each, the pricing models, and ultimately how they can even work together to satisfy your business goals.

SessionID: 68353

Secrets of the Query Optimizer Revealed Using Trace Flag 86xx

Back to calendar

Event Date: 14-10-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Kevin Kline

Title: Secrets of the Query Optimizer Revealed Using Trace Flag 86xx

Abstract:

You already know a thing or two about tuning a SQL query on Microsoft SQL Server. You can read an execution plan and know the most significant red flags to look for. And you have also learned how to track the most important metrics revealed by features like the SET STATISTICS. But you want to take it up another level!

First, we will examine using undocumented trace flags to look at the steps of parsing, binding, and query optimization. Second, we will show how SQL Server builds internal memo structures and it interrogates the heuristics of the optimizer search space. Finally, we will discuss a secret trace flag that gives the optimizer more time to produce alternative execution plans for queries that push the boundaries of extreme database processing.

SessionID: 68421

Solving Real World DevOps Problems - Customer success stories (90 min)

Back to calendar

Event Date: 14-10-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: boB Taylor

Title: Solving Real World DevOps Problems - Customer success stories (90 min)

Abstract:

In a cloud-first world, DB DevOps are critical, not only from a functional perspective but even more from both scalability of operations and availability perspectives. Here are some of the challenges faced by SaaS ISVs and enterprises using Azure SQL DB or SQL Server: - How do you minimize downtime due to database schema changes? - How do you deploy at scale across hundreds or thousands of databases? - How do you ensure end-to-end security at the DB layer regardless of the type of the query? SQL Server offers some great DB DevOps capabilities with SSDT and SQLPackage.

Underlying these are the SQLDOM parser and the DACFX libraries. Iwill showcase the power of these libraries by using some real-world use cases (with demos!), each of which was encountered in direct customer engagement by the SQLCAT team and field counterpart.

SessionID: 68872

Interviewing-Be So Good They Can’t Ignore You

Back to calendar

Event Date: 14-10-2017 - Session time: 11:15:00 - Track: Professional Development

Speaker: Leveat Ruse

Title: Interviewing-Be So Good They Can’t Ignore You

Abstract:

From the basics to the advanced, we will explore techniques that will ensure you leave a positive impression and help you land that role!

SessionID: 69185

Take Power BI Visualization to the Next Level

Back to calendar

Event Date: 14-10-2017 - Session time: 11:15:00 - Track: BI Information Delivery

Speaker: Reza Rad

Title: Take Power BI Visualization to the Next Level

Abstract:

Data Visualization is the front end of every BI system, and getting it right is one of the most important tasks in a BI application. Good visualization will affect tremendously on decision making process, bad visualization leads to wrong decisions. In this session, you will learn how to choose the right chart of visual with examples of Line chart, bar/column charts, and some other main charts in Power BI. You will also learn some tips and tricks to control interactivity of visuals in Power BI. You will learn about specific features in Power BI that helps empowering your visualizations. Session is full of demos, and through that you will learn tips and tricks for choosing best colors and best visuals for your solution.

SessionID: 69333

Introduction to Ensemble Modeling

Back to calendar

Event Date: 14-10-2017 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeff Renz

Title: Introduction to Ensemble Modeling

Abstract:

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server. We will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage BI features of SQL Server to help make your data warehouse solution provide maximum value to your users. We will walk through example data models to help highlight why data vault architecture facilitates traceability, auditability and scalability. Additionally we will cover implementation advantages which can facilitate agile development, strategies to load massive amounts of data in parallel, how to transition the data warehouse to a system of record, how to easily automate loading using BIML because of strictly naming rules and conventions, and finally how to support the Master Data Management needs of the organization.

SessionID: 67454

Soaring Eagle: How to be a GREAT DBA

Back to calendar

Event Date: 14-10-2017 - Session time: 12:30:00 - Track: Sponsor Session

Speaker: Jeffrey Garbus

Title: Soaring Eagle: How to be a GREAT DBA

Abstract:

This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.

SessionID: 70118

Vexata: Architecting for performance

Back to calendar

Event Date: 14-10-2017 - Session time: 12:30:00 - Track: Sponsor Session

Speaker: Matt Henderson

Title: Vexata: Architecting for performance

Abstract:

SessionID: 70130

SentryOne: SQL Query Tuning Horror Stories

Back to calendar

Event Date: 14-10-2017 - Session time: 12:30:00 - Track: Sponsor Session

Speaker: Kevin Kline

Title: SentryOne: SQL Query Tuning Horror Stories

Abstract:

SessionID: 70133

Cardinal Solutions: Advanced Analytics with SQL Server 2017

Back to calendar

Event Date: 14-10-2017 - Session time: 12:30:00 - Track: Sponsor Session

Speaker: Vincent Staropoli

Title: Cardinal Solutions: Advanced Analytics with SQL Server 2017

Abstract:

SessionID: 70147

DellEMC: The Path to #GetModern

Back to calendar

Event Date: 14-10-2017 - Session time: 12:30:00 - Track: Sponsor Session

Speaker: Ben Page

Title: DellEMC: The Path to #GetModern

Abstract:

SessionID: 67096

H*ckin Sweet Reports with Power BI

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: BI Information Delivery

Speaker: Julie Smith

Title: H*ckin Sweet Reports with Power BI

Abstract:

Power BI is constantly evolving; this session is an overview of the current elements of Power BI and ways to implement them, based on our experience in the field using it. Topics include the Power BI Service, Power BI Desktop, Power BI Embedded, Pricing models and some details of Power BI Premium. Sample data set used in this presentation is from @DogRates

SessionID: 67196

A Tour of Cloud Data Platforms as a Service

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Richard Weiss

Title: A Tour of Cloud Data Platforms as a Service

Abstract:

With the proliferation of SQL, NoSQL and Big Data databases, organizations can now target specific fit-for-purpose database platforms that align with their particular application requirements regarding scalability, elasticity, functionality and manageability. Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations.

SessionID: 67580

Azure Machine Learning: Making Data Science Easy(er)

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: Advanced Analysis Techniques

Speaker: Brad Llewellyn

Title: Azure Machine Learning: Making Data Science Easy(er)

Abstract:

There's a ton of buzz around Data Science and Machine Learning. What is it? What can we do with it? Do I have to learn a new language or tool? We will walk through an example of how to use Azure Machine Learning to predict income based on demographic data. You'll see why Azure Machine Learning is the future of data science.

SessionID: 67660

Using DMVs for Performance Root Cause

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jared Poché

Title: Using DMVs for Performance Root Cause

Abstract:

What are your first steps when you hear one of your SQL Servers is having a performance problem? In this demo-driven session, we will discuss key DMVs that can provide us data quickly. We will examine a number of example queries that can lead us to a quick root cause analysis in a number of different situations. This session will be kept at a very functional level, and should be accessible for anyone interested in SQL Server performance.

SessionID: 67819

How to Manage Very Large Databases with SQL Server

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Carrig

Title: How to Manage Very Large Databases with SQL Server

Abstract:

Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges do to future growth? In this session, I will provide practical advice on managing very large databases (databases > 1TB) with SQL server, focusing on common problem areas for new and experienced DBAs alike. These problem areas include index maintenance, integrity checks, archival, backups, and restores. We will look at new features available in SQL Server 2016 and SQL Server 2017 which make managing large databases easier, and we will explore some of the challenges and opportunities of managing large databases using SQL Server 2017 on Linux.

SessionID: 68146

TechGirlz How You Can Help Usher In The Next Generation

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: Professional Development

Speaker: Lindsay Clark

Title: TechGirlz How You Can Help Usher In The Next Generation

Abstract:

Middle school aged girls often lose interest in STEM topics. Come learn how you can help usher in the next generation of technology gurus. TechGirlz is a grassroots effort to enable busy technology professionals give back to their local communities in a major way, putting the power of technology in the minds of young girls to help keep the spark of interest in the tech fields for future job markets.

SessionID: 68179

The Art and Science of Designing a Mission Critical SQL Server

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: Strategy and Architecture

Speaker: Maxwell Myrick

Title: The Art and Science of Designing a Mission Critical SQL Server

Abstract:

When asked to design a critical database system, too many people pick an HA feature and then design the solution around it. This usually results in a costly and disappointing design.

This session will show you the five basic archetypes for mission critical database systems and how to select the right features from SQL Server to implement each design. Along the way you’ll hear some best practices, tips, and real world advice for choosing between features like Availability Groups and clustered instances of SQL Server, as well as the history of some of the more interesting and less often used availability features. You will also get a glimpse of how some of the largest mission critical systems running on the Microsoft platform are created using a distributed model where redundancy replaces failover. While you may not be able to revisit your current designs right away, what you learn will improve how you approach thinking about making a system as fail-proof as it can be.

SessionID: 68250

Making Your List and Checking It Twice: Introduction to unit testing with tSQLt

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Elizabeth Noble

Title: Making Your List and Checking It Twice: Introduction to unit testing with tSQLt

Abstract:

Unit testing allows database code to be consistently tested during the development process, but it can be challenging to get unit testing setup for database development. This session will give an overview on the purpose of unit testing, the installation of the tSQLt framework, and the design of unit tests. I will use general concepts of test driven design to create and run unit tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement unit testing in a development environment and create and run your own units tests.

SessionID: 68366

ARMed for Azure

Back to calendar

Event Date: 14-10-2017 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Geoff Hiten

Title: ARMed for Azure

Abstract:

The Azure Resource Model (ARM) enables Azure infrastructure automation for both IaaS and PaaS deployments. Using Visual Studio as a management tool enables repeatable, automated, source controlled deployments for test and development environments, enabling true DevOps practices for all aspects of pre-production systems. In this session, I will demonstrate, explain, and deploy a IaaS/PaaS hybrid environment (SQL and BI stack elements) using ARM templates, Visual Studio, source control integration, and PowerShell scripts.

SessionID: 67082

Impostor Syndrome: Are You Faking It Will they Find Out?

Back to calendar

Event Date: 14-10-2017 - Session time: 15:00:00 - Track: Professional Development

Speaker: Mindy Curnutt

Title: Impostor Syndrome: Are You Faking It Will they Find Out?

Abstract:

Have you ever thought to yourself “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!” If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!

SessionID: 67089

Using Powershell to Document SQL Server

Back to calendar

Event Date: 14-10-2017 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: George Walkey

Title: Using Powershell to Document SQL Server

Abstract:

Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more

SessionID: 67217

Build Your Extract Packages Automatically!

Back to calendar

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

Speaker: Shannon Lowder

Title: Build Your Extract Packages Automatically!

Abstract:

Automating extract packages is trivial, you simply use INFORMATION_SCHEMA. The problem is not all your data sources have easy to read metadata like SQL Server. How do you create usable metadata from these sources? In this hour, I’ll show you how easy it is to make an educated guess on the schema of flat files and other “semi-structured” data sources.

With that schema, automatically generating your extract package is a matter of seconds! Join me while I share my interrogator project with you and start saving hours at work today!

SessionID: 67442

SQL Games

Back to calendar

Event Date: 14-10-2017 - Session time: 15:00:00 - Track: Professional Development

Speaker: Rick Heiges

Title: SQL Games

Abstract:

SessionID: 68211

Demystifying Data Compression

Back to calendar

Event Date: 14-10-2017 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Andy Mallon

Title: Demystifying Data Compression

Abstract:

SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce storage costs, and provide a performance boost—and now compression is available without the added cost of Enterprise Edition. Whether you are a developer or a DBA, it's important to know how to use compression to save money and improve speed.

Come learn about how data compression actually works, the differences between ROW and PAGE compression, and learn how to pick the best compression level for your data. This session will cover the details of the compression algorithms, and the costs and benefits associated with each type of compression.

By the end of this session, you'll have a better idea of how the different compression algorithms work, when compression is the right solution, as well as what type of compression to use.

SessionID: 68577

Where Should My Data Live (and Why)?

Back to calendar

Event Date: 14-10-2017 - Session time: 15:00:00 - Track: Strategy and Architecture

Speaker: Matt Gordon

Title: Where Should My Data Live (and Why)?

Abstract:

Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy. This is a shorter preview version of this talk that I'll be presenting at PASS Summit 2017.

SessionID: 69039

Azure ML Algorithm Accuracy Enhancement, Tips and Tricks

Back to calendar

Event Date: 14-10-2017 - Session time: 15:00:00 - Track: Advanced Analysis Techniques

Speaker: Leila Etaati

Title: Azure ML Algorithm Accuracy Enhancement, Tips and Tricks

Abstract:

Azure ML is the Microsoft cloud based Machine Learning tool. It provides variety of algorithms for doing descriptive, Predictive and Prescriptive analysis. Moreover, it supports the variety of Data science the techniques for data wrangling, feature selection, cross validation and so forth for enhancing the accuracy. In this session, I will first talk about how to measure the accuracy of the predictive or descriptive analysis in azure Ml. then I will show how to do feature selection in Azure ML to find proper attributes. Finally, I will demo how to do data sampling and Cross validation using existing components in Azure ML which will help us to enhance the machine learning accuracy.

SessionID: 70073

Measure Performance Through Baselines

Back to calendar

Event Date: 14-10-2017 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Carlos L Chacon

Title: Measure Performance Through Baselines

Abstract:

You get a ticket or email indicating there is a problem with the database and are asked to review. How do you know there is a problem? Baselines. Without a set known measurements to compare against it will be impossible to know whether your change is helping. This session reviews the process for collecting information about your SQL Server so you can compare current processes with historical processes. Once you understand the current behavior of the database, you can measure the impact of any change. This session will review ways to set up the collection of performance information and make it available for review later.

SessionID: 70152

Deep Dive into Power Query and M

Back to calendar

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

Speaker: Reza Rad

Title: Deep Dive into Power Query and M

Abstract:

Power Query is the transformation engine in Power BI. This is the engine that you do all data preparation before loading data into the model. This is the keystone of your Power BI solution. In this session, you will learn what things Power Query can do. M is the language behind the scene of Power Query, you will learn how M can be more beneficial than the Power Query Graphical interface. You will see demos of transformations that you can do with M Code. You will learn about Functions, Parameters, Generators and many other amazing features of this tool. This session is full of live demos. Prepare to be amazed by what Power Query can do with heaps of demos in this session.

This site is open source. Improve this page.