sqlsathistory

Nr: 726

Back to Main list

SQLSaturday #726 - Phoenix 2018

Start Time (24h)	Speaker	Track	Title
10:00:00	Dr. Suresh Rajappa	BI Platform Architecture, Development Administration	Practical Design Pitfalls in designing Enterprise Data Warehouse
10:00:00	Ryan Casey	BI Platform Architecture, Development Administration	Data Modeling for the Modern Data Warehouse
10:00:00	Eric Peterson	Enterprise Database Administration Deployment	Very Large Databases in your future
10:00:00	Chris Horvath	Strategy and Architecture	Azure Transient SQL Warehouse Resource
10:00:00	Andrea Letourneau	BI Information Delivery	Power BI: The Magic of M
10:00:00	Steve Hughes	BI Platform Architecture, Development Administration	Data Security in Power BI
10:00:00	Garry Bargsley	Enterprise Database Administration Deployment	Use PowerShell and dbatools to Manage your SQL Server Environment
10:00:00	Yueying Li	Advanced Analysis Techniques	Natural Language Processing (NLP) Intro
10:00:00	David Lundell	Enterprise Database Administration Deployment	Open Source vs SQL Database Maintenance Plans
11:15:00	Kristine Dyess	BI Information Delivery	Using SQL PowerPivot In Excel to create a SSAS Tabular Model for Power BI
11:15:00	Vern Rabe	Application Database Development	Proper DataType Usage=Guaranteed Better Performance and Accuracy
11:15:00	Adam Jorgensen	Strategy and Architecture	Data Driven Digital Transformation
11:15:00	Joe Abbott	BI Platform Architecture, Development Administration	Introduction to Azure SQL Database
11:15:00	Shawn Meyers	Enterprise Database Administration Deployment	Monitoring and Alerting of Availability Groups
11:15:00	Ginger Grant	Advanced Analysis Techniques	Implementing Python in SQL Server 2017
11:15:00	Jeff Schmidt	Enterprise Database Administration Deployment	Is it really HA when you upgrade from 2016 to 2017? I say yes.
11:15:00	Carlos Bossy	Advanced Analysis Techniques	Operationalizing Data Science
11:15:00	Phil Guevara	Application Database Development	Beginner's Guide to Query Tuning with SQL Server
13:15:00	Mark Broadbent	Enterprise Database Administration Deployment	Lockless in Seattle: Using In-Memory OLTP Transaction Processing
13:15:00	Mike Byrd	Application Database Development	Climbing the SQL Server Index B-Tree (from a user perspective)
13:15:00	Randy Knight	Application Database Development	Locks, Blocks, and Deadlocks, Oh My!
13:15:00	Meagan Longoria	Analytics and Visualization	Challenges and Opportunities in Creating Accessible Power BI Reports
13:15:00	Leslie Andrews	BI Platform Architecture, Development Administration	The Power of Data: The Complete Beginners Data Warehouse Kit
13:15:00	Martin Schoombee	BI Information Delivery	Power BI Development Best Practices
13:15:00	Leonard Lwakabamba	Analytics and Visualization	Relational meets Graph
13:15:00	Peter Kral	Enterprise Database Administration Deployment	SSIS Project Deployment: The T-SQL Way
13:15:00	Jason Brimhall	Enterprise Database Administration Deployment	Extended Events - Better than Profiler
14:30:00	Rob Mandeville	Enterprise Database Administration Deployment	DBA Impacting Trends
14:30:00	Phil Robinson	Analytics and Visualization	Data Wrangling for Reporting Analytics using Power BI
14:30:00	Steven Tidwell	Application Database Development	Dynamic SQL: Tables, Pivots, Parameters More
14:30:00	Randy Knight	Enterprise Database Administration Deployment	Understanding the SQL Server Transaction Log
14:30:00	Marc Beacom	BI Platform Architecture, Development Administration	ETL Best Practices and Techniques
14:30:00	Sandra Walters	Application Database Development	Intro to tSQLt: Unit Testing for Databases
14:30:00	Joseph Barth	BI Platform Architecture, Development Administration	Azure Data Factory Version 2 - Early Adopters
14:30:00	Jonathan Stewart	BI Platform Architecture, Development Administration	An introduction to the magical world of BIML!
15:45:00	TJay Belt	Enterprise Database Administration Deployment	PowerBI, from a DBA
15:45:00	Russel Loski	Cloud Application Development Deployment	Querying Semistructured Data in Azure Data Lake with USQL
15:45:00	Vern Rabe	Application Database Development	Query Optimization Statistics : Driving Force Behind Performance
15:45:00	Robert Miller	Enterprise Database Administration Deployment	SQL Server on Linux, a new frontier
15:45:00	Jared Wilber	Analytics and Visualization	Data Visualization with D3.js
15:45:00	Steve Williams	BI Platform Architecture, Development Administration	Solving Common DBA Problems With R

SessionID: 71304

Practical Design Pitfalls in designing Enterprise Data Warehouse

Back to calendar

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

Speaker: Dr. Suresh Rajappa

Title: Practical Design Pitfalls in designing Enterprise Data Warehouse

Abstract:

This session covers practical approaches in avoiding the common design issues in implementing Data Warehouse solutions. This also gives tips to spot the early symptoms on these issues

SessionID: 71386

Data Modeling for the Modern Data Warehouse

Back to calendar

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

Speaker: Ryan Casey

Title: Data Modeling for the Modern Data Warehouse

Abstract:

A theoretical discussion on two methods that professional data modelers use to model data (ERD and star schema).

We discuss why we need to model data, benefits / value of modeling data, and why we select one modeling technique over the other. Once we understand why and when we use these different modeling techniques, we will focus in on dimensional modeling that is used when developing data warehouses, SSAS cubes and Power BI.

Sample diagrams will be used to explain these different modeling techniques and try to bring a more tangible aspect to the theoretical aspects of the discussion.

Why Model Data • The Value of Enterprise Data • Why Should We Data Model • The Multifarious Data Environment • Business Benefits of Data Modeling

Different Model Types • Enterprise Model • Conceptual Model • Logical Model • Physical Model • Dimensional Model

Different Modeling Techniques • Normal Form Modeling • Star Snow Flake Schema • Slowly Changing Dimensions • Many to Many Relationships

SessionID: 72943

Very Large Databases in your future

Back to calendar

Event Date: 17-03-2018 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Peterson

Title: Very Large Databases in your future

Abstract:

Your databases may not be terabyte-sized yet, but they're probably growing every day. We'll look at lessons learned

from working with multi-terabyte, very large databases (VLDBs) in the real world. Topics include storage layout decisions, unique tuning challenges, HA/DR implications, and database restores, along with shoehorning backups, re- indexing and DBCC checks into itty-bitty maintenance windows. As a bonus, many of the techniques also apply to smaller databases and consolidated servers that run hundreds of databases.

SessionID: 72973

Azure Transient SQL Warehouse Resource

Back to calendar

Event Date: 17-03-2018 - Session time: 10:00:00 - Track: Strategy and Architecture

Speaker: Chris Horvath

Title: Azure Transient SQL Warehouse Resource

Abstract:

Cloud Migration

Big data to Big Memory Quick review of using a Azure SQL Warehouse to preform a system Cloud Rearchitect Rehost - Refactor - Rearchitect (move logic but use Cloud resources to execute) - Rebuild Hadoop Decommision Effort - Hadoop 16hr process replaced with 1.5 hr process at at fraction of the cost

SessionID: 73002

Power BI: The Magic of M

Back to calendar

Event Date: 17-03-2018 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Andrea Letourneau

Title: Power BI: The Magic of M

Abstract:

As the popularity of Power BI increases, knowledge of M, the language used in Power Query and queries in Power BI, is becoming more necessary. Although the Query Editor in Power BI generates most of the M needed for basic transformations, it's just the beginning of its capabilities. In this session we will look under the hood at the M query and demonstrate some of the magic of this powerful language.

SessionID: 73167

Data Security in Power BI

Back to calendar

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

Speaker: Steve Hughes

Title: Data Security in Power BI

Abstract:

As more enterprises adopt Power BI into their BI environment, questions still remain about data security when working with the Power BI Service. During this webinar, we will handle a number of these concerns and point out shortcomings that still exist. How does Power BI Premium impact security? (Hint: It’ not just about licensing). We will also take a closer look at auditing, App Workspaces, and Power BI Apps during this session.

Due to the frequent changes to Power BI, improvements to data security are common within the platform as it matures. We will discuss data security and compliance within the platform including data classification, privacy levels, and other settings which help to manage your data security.

SessionID: 73341

Use PowerShell and dbatools to Manage your SQL Server Environment

Back to calendar

Event Date: 17-03-2018 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Garry Bargsley

Title: Use PowerShell and dbatools to Manage your SQL Server Environment

Abstract:

Did you know there is an amazing open source community driven to make your SQL DBA life easier? The PowerShell dbatools suite not only save you time, but will provide you a better understanding of how your environment is configured.

In this session, you will learn how to standardize, monitor and alert on your environment when SQL Server settings fall out of best practices, using tools provided in the dbatools suite.

SessionID: 73443

Natural Language Processing (NLP) Intro

Back to calendar

Event Date: 17-03-2018 - Session time: 10:00:00 - Track: Advanced Analysis Techniques

Speaker: Yueying Li

Title: Natural Language Processing (NLP) Intro

Abstract:

NLP is part of AI that studies the interactions between computer and human languages. Numerous of smart devices/applications are powered by the advancement of NLP. It's made great contribution to an easier way of living and conducting business tasks related to translation, speech recognition, sentiment analysis, topic extraction, document classification, and more..

For this session, I will walk you through some fundamental techniques and demos.

SessionID: 77361

Open Source vs SQL Database Maintenance Plans

Back to calendar

Event Date: 17-03-2018 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Lundell

Title: Open Source vs SQL Database Maintenance Plans

Abstract:

The Database Maintenance plans used to be a one size fits all tool that did a lot of unnecessary work, especially, when it came to indexing. So I have been recommending that clients use other tools such as Ola Hallengren’s award winning free SQL Server Maintenance Solution. So let’s have a showdown at high noon in the Arizona desert and see if Database Maintenance Plans in SQL 2016 and 2017 are now good enough or if we still need to turn to other solutions like Ola’s.

SessionID: 73073

Using SQL PowerPivot In Excel to create a SSAS Tabular Model for Power BI

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15:00 - Track: BI Information Delivery

Speaker: Kristine Dyess

Title: Using SQL PowerPivot In Excel to create a SSAS Tabular Model for Power BI

Abstract:

PowerPivot is a quick and powerful tool that can be used to create an SSAS Tabular Model. In this session, I will use Power Query to connect to data sources in SQL, build a data model using Power Pivot in Excel and demonstrate how to move the data model into SSAS Tabular. We will also look at Power Update, which is a tool that can be used to schedule a PowerPivot workbook update and restore to an SSAS Tabular Model. Finally, we can see how we can connect to our SSAS Tabular Model and begin using our SSAS Tabular Model in Power BI in Excel.

SessionID: 73074

Proper DataType Usage=Guaranteed Better Performance and Accuracy

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Vern Rabe

Title: Proper DataType Usage=Guaranteed Better Performance and Accuracy

Abstract:

It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types.

In this demo-heavy presentation I will show you the importance of choosing the proper data type; show you some guidelines in determining what an appropriate data type would be; and once chosen, give you some tools for its usage and management. I will demonstrate several performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition I will cover several data type related functions, and point out caveats in their usage. I expect even advanced T-SQL developers and DBAs to walk away with a useful nugget or two.

SessionID: 73123

Data Driven Digital Transformation

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15:00 - Track: Strategy and Architecture

Speaker: Adam Jorgensen

Title: Data Driven Digital Transformation

Abstract:

Go beyond the buzzwords and let’s get real about how you can transform your company as a data professional. Adam will walk you through the major areas of business that you can help transform, as well as provide you with tips on how to gain influence within your organization by leading this change. You’ll leave with 5 specific steps that you can implement immediately to improve your company’s data culture.

SessionID: 73177

Introduction to Azure SQL Database

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15: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 to monitor cost, and most importantly why you would and should use it in your particular environment/situation.

SessionID: 73521

Monitoring and Alerting of Availability Groups

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: Monitoring and Alerting of Availability Groups

Abstract:

So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Were you notified when it failed over last night?

This session will answer all these questions

SessionID: 73660

Implementing Python in SQL Server 2017

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

Title: Implementing Python in SQL Server 2017

Abstract:

SQL Server 2016 added R to the analytical toolset and SQL Server 2017 has added Python. When looking at various lists of the most popular programming languages, Python always has one of the top positions. This session provides an introduction to Python, including why it is a good choice for analyzing data.

If you have not had a chance to review SQL Server 2017 yet, please attend to see some of the new changes coming later this year. One of the features covers will show what is needed to incorporate Python into SQL Server and how Python can be incorporated in stored procedures to provide the ability to analyze data using arguably the most popular programming language to review data.

SessionID: 73710

Is it really HA when you upgrade from 2016 to 2017? I say yes.

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Schmidt

Title: Is it really HA when you upgrade from 2016 to 2017? I say yes.

Abstract:

Tasked with upgrading 4 TB worth of data to a new HA cluster, I wanted a faster way to do this. Yes I love binge watching Netflix while files copy and the cluster builds its 4 nodes for 20 hours, but I also value sleep. In this demo heavy session watch while I upgrade an 2016 HA server to 2017 as fast as a planned failover.

SessionID: 74378

Operationalizing Data Science

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15:00 - Track: Advanced Analysis Techniques

Speaker: Carlos Bossy

Title: Operationalizing Data Science

Abstract:

The challenge of developing a predictive model is the secret sauce that data science practitioners strive to achieve. While sophisticated predictive models can be game changers that give you a competitive edge, they must be nurtured and closely watched to ensure they perform as expected. This session shows attendees how to build a framework and develop a data model that handles prediction logging, prediction performance management, and analysis. A case study will show predictions can degrade and ultimately fail, further emphasizing the importance of tracking their performance.

SessionID: 74608

Beginner's Guide to Query Tuning with SQL Server

Back to calendar

Event Date: 17-03-2018 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Phil Guevara

Title: Beginner's Guide to Query Tuning with SQL Server

Abstract:

A introduction to key concepts for improving Query Performance in SQL Server. We will cover the basics of the optimization engine, how to read execution plans, and potential pitfalls/anti-patterns to avoid.

SessionID: 71305

Lockless in Seattle: Using In-Memory OLTP Transaction Processing

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Mark Broadbent

Title: Lockless in Seattle: Using In-Memory OLTP Transaction Processing

Abstract:

Locks and latches have long been the mechanism used to implement SQL Server concurrency control, but with the introduction of In-Memory OLTP the paradigm has shifted. Are we really looking at the Brave New World of Transaction Processing or a dystopian nightmare?

In this session, we will understand how In-Memory OLTP architecture is implemented and how its mechanics function. We will learn what transactional bad dependencies and other considerations are introduced by its use and what capabilities are provided by SQL Server 2016.

SessionID: 72351

Climbing the SQL Server Index B-Tree (from a user perspective)

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: Climbing the SQL Server Index B-Tree (from a user perspective)

Abstract:

This session dives down and looks at the important items on data pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command. It will also look at the effect of row data compression on clustered and non-clustered indexes. In all demos we will try to ascertain how the SQL Server® optimizer might use them and also strive to gain some insight from a performance advantage. Its purpose is mainly to try and understand how SQL Server implements indexes, their underlying structure, and where performance benefits might lie from a layman’s viewpoint. Session is 80% demos.

SessionID: 72699

Locks, Blocks, and Deadlocks, Oh My!

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Randy Knight

Title: Locks, Blocks, and Deadlocks, Oh My!

Abstract:

"I've got a locking problem", "I need to get rid of blocking," and "deadlocks are normal behavior" are all things heard way too many times.

In this session targeted at the accidental or new DBA, we will walk through each of these items, what they are, what their causes are, which of them are normal behavior and which are not, and some common causes of deadlocks and excessive blocking.

SessionID: 72767

Challenges and Opportunities in Creating Accessible Power BI Reports

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Meagan Longoria

Title: Challenges and Opportunities in Creating Accessible Power BI Reports

Abstract:

Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way such that everyone can use them? This can be especially important if you are making reports for government entities, educational institutions, or the general public. In this session, we'll discuss accessibility standards and regulations of which you may want to be aware, how users with disabilities can consume Power BI reports, and guidance and pitfalls when designing inclusive reports.

SessionID: 73008

The Power of Data: The Complete Beginners Data Warehouse Kit

Back to calendar

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

Speaker: Leslie Andrews

Title: The Power of Data: The Complete Beginners Data Warehouse Kit

Abstract:

For many of us data is scattered in many different systems. We almost all have data that someone wants to compare or track but can't without a lot of manual manipulation. So, how do you tie disparate systems together? With a Data Warehouse! In this presentation you will get the skills you need to start building your own. We will discuss the basics of what a Data Warehouse is, the tools needed to create, deploy and manage the Data Warehouse process, and the benefits of using the data you collect to manage operational processes and create data visualizations. After attending this session you will be able to return to your job and amaze people with your ability to show them the power of the data!

SessionID: 73132

Power BI Development Best Practices

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Martin Schoombee

Title: Power BI Development Best Practices

Abstract:

Are you a developer or analyst, creating Power BI reports that will be shared across teams or even your entire organization? Have you given the structure of your Power BI data model any thought, what the best way is to ingest the data or whether you should have more than one table/entity in your data model?

In this session we will take a brief look at all of the considerations and best practices when developing Power BI models, reports and dashboards.

SessionID: 73439

Relational meets Graph

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Leonard Lwakabamba

Title: Relational meets Graph

Abstract:

In this session we will cover how to leverage Graph queries in SQL Server 2017 and Azure SQL DB. Everyone should leave with an understanding of when and how to leverage graph queries.

SessionID: 73444

SSIS Project Deployment: The T-SQL Way

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Kral

Title: SSIS Project Deployment: The T-SQL Way

Abstract:

Do you deploy SQL Server Integration Services (SSIS) Projects using the Integration Services Deployment Wizard? If you're looking for a repeatable deployment method that can be source controlled, there's another way...the T-SQL way! In this session, you will see a demonstration of T-SQL script deployment of SSIS projects, using stored procedures in the SSISDB database. You'll learn how to query the SSIS catalog to find your project configurations so they can be captured and source controlled. Take control of your SSIS deployments...the T-SQL way!

Prerequisites: You should have previous experience with SQL Server Integration Services (SSIS) package deployment and/or development.

SessionID: 73573

Extended Events - Better than Profiler

Back to calendar

Event Date: 17-03-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Extended Events - Better than Profiler

Abstract:

Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.

SessionID: 71281

DBA Impacting Trends

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Mandeville

Title: DBA Impacting Trends

Abstract:

There may be resume generating events on the horizon. Find out what trends are happening in our industry that are likely to impact the world of the data professional. Machine Learning, autonomous databases, cloud, OH MY! Are they all really scary? Let's have a discussion and separate the hype from the probable.

SessionID: 71367

Data Wrangling for Reporting Analytics using Power BI

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Analytics and Visualization

Speaker: Phil Robinson

Title: Data Wrangling for Reporting Analytics using Power BI

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

Dynamic SQL: Tables, Pivots, Parameters More

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Steven Tidwell

Title: Dynamic SQL: Tables, Pivots, Parameters More

Abstract:

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed. Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. We will also see how to use Dynamic SQL to build multiple databases across servers, alter a single table in multiple servers and add columns to a table, all through the magic of Dynamic SQL.

SessionID: 72955

Understanding the SQL Server Transaction Log

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Randy Knight

Title: Understanding the SQL Server Transaction Log

Abstract:

The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.

SessionID: 73127

ETL Best Practices and Techniques

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Marc Beacom

Title: ETL Best Practices and Techniques

Abstract:

ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or more of the effort. The tools you have access to allow you to make progress in a hurry. However, are you implementing best practices and techniques that will scale to the demands you need? Or will you be refactoring far too quickly than you should to meet performance requirements?

Gain helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.

SessionID: 73333

Intro to tSQLt: Unit Testing for Databases

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Sandra Walters

Title: Intro to tSQLt: Unit Testing for Databases

Abstract:

How do I test my Microsoft SQL database logic? How do I integrate it with my build? What's the point of testing T-SQL, anyway?

If you've ever had these questions, this introduction to the unit test framework, tSQLt, is for you. We'll address how to set up and run unit tests, fakes, and spy procedures. We'll also talk about how to structure your Visual Studio projects that use tSQLt, whether they're SSDT projects or the new ReadyRoll Core project type, available with Visual Studio 2017. You'll learn how to integrate your tSQLt tests with the CI/CD pipeline using Visual Studio Team Services, as well as how to analyze code coverage.

SessionID: 73537

Azure Data Factory Version 2 - Early Adopters

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Joseph Barth

Title: Azure Data Factory Version 2 - Early Adopters

Abstract:

Abstract: Azure Data Factory version 2 is really exciting, number one it can run SSIS in the cloud! Yes no more on-prem deploy to SSIS! Deploy from VS or SSMS directly to you cloud based SSIS instance.

Joe Barth will walk your through what is new and what is available to do with ADFv2. His presentation will also show what we have learned so far as an early adopter and how to run Azuure SSIS in the cloud.

Speaker Bio: Joe Barth is the AZSSUG PASS chapter Leader, over 9 years SQL Server experience from DBA to Developer. Joe's main focus over the past 5 years has been SSIS and Data Warehousing.

SessionID: 77789

An introduction to the magical world of BIML!

Back to calendar

Event Date: 17-03-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jonathan Stewart

Title: An introduction to the magical world of BIML!

Abstract:

Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

SessionID: 72784

PowerBI, from a DBA

Back to calendar

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

Speaker: TJay Belt

Title: PowerBI, from a DBA

Abstract:

Microsoft’s PowerBI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement PowerBI in his shop and make his data accessible.

As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point PowerBI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, PowerBI, and how to make these work for you.

SessionID: 72999

Querying Semistructured Data in Azure Data Lake with USQL

Back to calendar

Event Date: 17-03-2018 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Russel Loski

Title: Querying Semistructured Data in Azure Data Lake with USQL

Abstract:

Data is exploding across enterprises. Much of it is semi-structured junk. Or is it junk? What are you going to do with it until you can find out? Microsoft’s Azure Data Lake is a cloud storage and analytical service for parking a variety of data. When you are ready, you can query that semi-structured data using an ANSI SQL language called U-SQL. In this session I will demonstrate the similarities and differences between U-SQL and T-SQL. I will demonstrate how easy it is to build a query against 21 GB of CSV files. Such queries can help you determine whether you have a gold mine in your data or a bunch of garbage before investing in a full data warehouse build.

SessionID: 73075

Query Optimization Statistics : Driving Force Behind Performance

Back to calendar

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

Speaker: Vern Rabe

Title: Query Optimization Statistics : Driving Force Behind Performance

Abstract:

When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), correlated predicates, skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.

SessionID: 73726

SQL Server on Linux, a new frontier

Back to calendar

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

Speaker: Robert Miller

Title: SQL Server on Linux, a new frontier

Abstract:

At one time, Microsoft SQL Server was only available on the Windows platform. This expanded to the Azure cloud environment, though still on the Windows platform. One stronghold of the other RDB vendors remained and it has a significant installed base, Linux. Well, not just Linux, but "Open Source" systems and those derived from the open source operating systems, OS X included.

With the release of Microsoft SQL Server for Linux, this last major hurdle in the enterprise is starting to fall. There is much more product development work needed to catch its older brother, but Microsoft SQL Server for Linux has become interesting and viable for the enterprise and hobbyist. Join me as we take a look at what is currently available in Microsoft SQL Server for Linux.

SessionID: 73952

Data Visualization with D3.js

Back to calendar

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

Speaker: Jared Wilber

Title: Data Visualization with D3.js

Abstract:

The goal of this presentation is to introduce attendees to D3.js, Javascript's premiere library for data visualization. I’ll showcase prominent examples of D3.js in action (e.g. NYTimes, Netflix, etc.), explain how it works and where it exists in the ecosystem of data visualization tools, as well as walk through the creation process and iterative design of a data visualization via a live-coding demo.

SessionID: 73957

Solving Common DBA Problems With R

Back to calendar

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

Speaker: Steve Williams

Title: Solving Common DBA Problems With R

Abstract:

External script languages were introduced to SQL Server in 2016, starting with R and continuing with Python in SQL 2017. To familiarize myself, I attended various community sessions, but each one was about statistics, anomaly detection, or forecasting. That's all interesting, but it’s not my thing, so we won't be talking about any of that! This is a demo rich session about things you didn't know you could do from SQL Server with the help of R, such as parse JSON or convert to CSV, integrate Azure Key Vault for securely storing passwords, get documents from Azure Cosmos DB and add them to your data warehouse, archive tables across platforms, quick and simple ETL, and finding out easily which column of data is causing that "String or Binary data will be truncated" error. Come join me for some eye opening demos about the many practical uses of R for non-statisticians!

This site is open source. Improve this page.