sqlsathistory

Nr: 807

Back to Main list

SQLSaturday #807 - Redmond 2019

Start Time (24h) Speaker Track Title
08:30:00 Kalen Delaney Application Database Development Everlasting Issues with Temporary Tables and tempdb
08:30:00 Amie Mason Advanced Analysis Techniques Real-World AI in Azure
08:30:00 Swagatika Sarangi Information Delivery Why Solidity is Solid – Basics of Ethereum, Smart Contracts, and Blockchain.
08:30:00 Vern Rabe Application Database Development Better Query Performance from Proper Statistics Management
08:30:00 Yana Berkovich BI Platform Architecture, Development Administration Practical Visual Guidance for PowerBI
08:30:00 Brian Carrig Enterprise Database Administration Deployment A Beginner's Guide To Plan Guides
08:30:00 Janice Gerbrandt Application Database Development Automated tests in your database: tSQLt
09:45:00 Mark Kromer BI Information Delivery Build ETL Patterns in the Cloud with Azure Data Factory
09:45:00 Vern Rabe Application Database Development T-SQL Habits and Practices That Can Kill Performance
09:45:00 Amie Mason Analytics and Visualization Keys to Successfully Governing Power BI for your Organization
09:45:00 Reid Havens Analytics and Visualization Demystifying Chart Types and Report Design Principles in Power BI
09:45:00 Greg Larsen Application Database Development Protect Your SQL Server Data with Static Data Masking
09:45:00 Sergiy Lunyakin Cloud Application Development Deployment Azure SQL DW: Optimization Technics to Maximize Performance
09:45:00 Yana Berkovich BI Platform Architecture, Development Administration PowerApps Power BI: Better Together
11:00:00 Konstantin Kosinsky Application Database Development Using Columnstore indexes in Azure DevOps Services. Lessons learned
11:00:00 Ron Talmage Enterprise Database Administration Deployment Managing Table Partitions at the Extremes
11:00:00 Russel Loski BI Platform Architecture, Development Administration Managing ETL Change using BIMLScript
11:00:00 Scott Stauffer BI Information Delivery Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
11:00:00 Michael Wall Professional Development Becoming a Master by Giving It All Away
11:00:00 josh smith Enterprise Database Administration Deployment SQL 101: A Very Good Place to Start
11:00:00 Sergiy Lunyakin BI Platform Architecture, Development Administration Azure SQL DWH: Tips and Tricks for developers
13:30:00 Joseph Yeates Advanced Analysis Techniques Predictive Analytics with R in Power BI
13:30:00 Arvind Shyamsundar Application Database Development Large-scale graph querying and analytics with SQL Graph
13:30:00 Russel Loski Cloud Application Development Deployment Querying Semistructured Data in Azure Data Lake with USQL
13:30:00 Arnie Rowland Application Database Development RC, SI, and RCSI -It's So Confusing. Which Should You Use?
13:30:00 Rock Pereira Advanced Analysis Techniques SQL Server 2019 Big Data Clusters
13:30:00 DeNisha Malone BI Platform Architecture, Development Administration Power BI Administration to Optimize your Premium Services
13:30:00 Blythe Morrow Professional Development How to write a Kicka** anything
15:15:00 Arnie Rowland Professional Development Prevent Presentation Paralysis
15:15:00 John McAllister BI Platform Architecture, Development Administration Master Data Management: BI and Data Science’s Best Friend
15:15:00 Janis Griffin Application Database Development Everything You Need to Know About SQL Server Indexes
15:15:00 Brian Carrig Enterprise Database Administration Deployment Controlling Competing Workloads with SQL Server Resource Governor
15:15:00 DeNisha Malone BI Information Delivery Tell a Story with Data in Power BI
15:15:00 vinh vu Analytics and Visualization Machine Learning – Classification
15:15:00 Blythe Morrow Professional Development Build a blog worth reading

SessionID: 85340

Everlasting Issues with Temporary Tables and tempdb

Back to calendar

Event Date: 27-04-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Kalen Delaney

Title: Everlasting Issues with Temporary Tables and tempdb

Abstract:

Tempdb has been a source of configuration confusion since the very first version of SQL Server. Each SQL Server instance only has one tempdb database used by all users in all databases. In this session, we’ll look at all the different uses of tempdb and how to configure your tempdb to support them. We’ll look at all the different kinds of temporary tables and see when you should use each type. We’ll talk about the difference between global and local temp tables, table variables and work tables. We’ll explore the various tools available that let you monitor the use (and abuse) of your tempdb database and we look at some best practice guidelines for how to keep your tempdb as healthy as possible.

SessionID: 85840

Real-World AI in Azure

Back to calendar

Event Date: 27-04-2019 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Amie Mason

Title: Real-World AI in Azure

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. Discussion of real-world scenarios and the tools used to solve them.

SessionID: 86680

Why Solidity is Solid – Basics of Ethereum, Smart Contracts, and Blockchain.

Back to calendar

Event Date: 27-04-2019 - Session time: 08:30:00 - Track: Information Delivery

Speaker: Swagatika Sarangi

Title: Why Solidity is Solid – Basics of Ethereum, Smart Contracts, and Blockchain.

Abstract:

If you are into Ethereum or any latest Blockchain platform you may know the availability of “smart contract language (SCL)” comes easily. In this foundational quick talk, I will be introducing my audiences to a newer coding platform in Blockchain. We know that any RELATIONAL language/platform is legacy and solid when it comes to prevalence. But if you are open to experiment and broaden your understanding to a Blockchain world with the new-cutting-age-y languages, feel free to join my session.

Topics that I will cover in this session –

  1. What is Ethereum Blockchain (A, B, Cs of it.)
  2. Overview of NEO platform Solidity language
  3. What are ‘Smart Contracts’
  4. Python, C++ Vs Solidity, Language of Smart Contract
  5. Last but not least, if you attend my session and do NOT understand ‘a thing’ I am speaking; you will still get a ton of ‘reference materials’ that I have been gaining from many over-priced Blockchain courses conducted by multi-millionaires, geeks.

SessionID: 87044

Better Query Performance from Proper Statistics Management

Back to calendar

Event Date: 27-04-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Vern Rabe

Title: Better Query Performance from Proper Statistics Management

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?), 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: 87742

Practical Visual Guidance for PowerBI

Back to calendar

Event Date: 27-04-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Yana Berkovich

Title: Practical Visual Guidance for PowerBI

Abstract:

Building data visualizations is about data-driven decision support or simply answering a business question. How do we make our report answer this question at a glance?

When we are building the reports, how do we fit them to different platforms in PowerBI? Implementing UI/UX rules and best practices when designing a PowerBI report

Attendees are welcome to bring a laptop with PowerBI desktop installed and a sample Microsoft dataset downloaded - https://docs.microsoft.com/en-us/power-bi/sample-datasets Customer Profitability sample and HR sample

SessionID: 90975

A Beginner's Guide To Plan Guides

Back to calendar

Event Date: 27-04-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Carrig

Title: A Beginner's Guide To Plan Guides

Abstract:

Even with the increased simplicity of plan forcing using Query Data Store in SQL Server 2016 and above, plan guides remain a very powerful but often overlooked feature of SQL server. There is a misconception in the community that plan guides are really only useful for situations where the DBA "cannot change the code" but actually plan guides have much broader applicability than simply fixing problems with poorly designed ISV code. However, for the DBA, working with plan guides can often be a confusing and frustrating experience.

In this session we will cover what plan guides are, how they work and demonstrate scenarios where they can be successfully used to solve a number of problems DBAs experience on a day to day basis.

SessionID: 91118

Automated tests in your database: tSQLt

Back to calendar

Event Date: 27-04-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Janice Gerbrandt

Title: Automated tests in your database: tSQLt

Abstract:

tSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt is ideal for the database developer because tests are written in TSQL and is easy to use.

In this session you’ll learn how to use tSQLt to add automated tests to your database to ensure your code produces desired results even after modifications.

SessionID: 85998

Build ETL Patterns in the Cloud with Azure Data Factory

Back to calendar

Event Date: 27-04-2019 - Session time: 09:45:00 - Track: BI Information Delivery

Speaker: Mark Kromer

Title: Build ETL Patterns in the Cloud with Azure Data Factory

Abstract:

Modern Data Warehouse solution patterns require moving classic DW data, processes, and methods to the Cloud and to incorporate Big Data. In this session, I will demonstrate how to accomplish those goals using Azure Data Factory.

SessionID: 87045

T-SQL Habits and Practices That Can Kill Performance

Back to calendar

Event Date: 27-04-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Vern Rabe

Title: T-SQL Habits and Practices That Can Kill Performance

Abstract:

All too often we are on a project or given a task where the time or financial constraints require us to develop T-SQL “quick-and-dirty”. Or maybe we have been tasked with quickly improving the performance of some existing T-SQL. These situations often lead to code that later needs to be tuned for better performance. Wouldn’t it be nice if we could satisfy those tight time constraints while also avoiding many of the pitfalls that later plague performance?

In this session we will see ten common T-SQL writing habits that contribute to poor performance. We’ll see WHY each of these patterns can have such negative impact on performance, including examples, and we’ll see one or more alternatives for each that don’t have the same negative impact. Armed with this knowledge, you will definitely impress your boss with your ability to create fast T-SQL within tight time constraints, and also quickly fix existing T-SQL code. Enjoy the merit raise you’ll get due to your new tuning talents.

SessionID: 87354

Keys to Successfully Governing Power BI for your Organization

Back to calendar

Event Date: 27-04-2019 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Amie Mason

Title: Keys to Successfully Governing Power BI for your Organization

Abstract:

Discussion of the best practices and considerations for security, governance, and administration of Power BI. Not only of the available options, but tips and tricks for how to navigate those options and set yourself and your organization up for success down the road.

SessionID: 91147

Demystifying Chart Types and Report Design Principles in Power BI

Back to calendar

Event Date: 27-04-2019 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Reid Havens

Title: Demystifying Chart Types and Report Design Principles in Power BI

Abstract:

Failing to deliver a well-designed Power BI Report can be a common reporting pitfall. What good is quality data if it is not presented in a way that is meaningful or easily understood? Someone without any prior knowledge should be able to quickly understand a report without explanation and be quickly drawn to the key elements you want them to view. This talk will walk through many elements of bad report design. Learn about visual cues and how certain chart types can convey data more accurately than others. Also, learn about the basic dos and don’ts of report design and layout, using easy-to-learn techniques that bring data to life.

SessionID: 91804

Protect Your SQL Server Data with Static Data Masking

Back to calendar

Event Date: 27-04-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Greg Larsen

Title: Protect Your SQL Server Data with Static Data Masking

Abstract:

Are you providing adequate protection to your sensitive and confidential data? I’m sure we all do our best to protect our confidential data in a production environment by allowing only approved methods to access production data. But how are you protecting your development and testing environments when they contain copies of production databases?

In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by development and testing must not contain private and sensitive data from production databases. In this presentation, Greg will demonstrate using a new feature of SQL Server Management Studio (SSMS) called Static Data Masking to protect your sensitive/confidential data when copying production databases to your development and testing environments.

SessionID: 93367

Azure SQL DW: Optimization Technics to Maximize Performance

Back to calendar

Event Date: 27-04-2019 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Sergiy Lunyakin

Title: Azure SQL DW: Optimization Technics to Maximize Performance

Abstract:

Azure SQL DW is powerful MPP cluster for processing a big amount of structured data. But, it still requires optimization to maximize performance and optimize resource usage. Some technics almost similar to what we do with our regular SQL Server, some of them not due to MPP architecture. In this session, I will cover next topics:

SessionID: 93369

PowerApps Power BI: Better Together

Back to calendar

Event Date: 27-04-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Yana Berkovich

Title: PowerApps Power BI: Better Together

Abstract:

SessionID: 86698

Using Columnstore indexes in Azure DevOps Services. Lessons learned

Back to calendar

Event Date: 27-04-2019 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Konstantin Kosinsky

Title: Using Columnstore indexes in Azure DevOps Services. Lessons learned

Abstract:

The Analytics service in Azure DevOps Services provides all-over insights to your DevOps data: work item tracking, CI/CD pipelines, testing process etc.

 

Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions records and daily growth in 10s of millions, only a few minutes delay from operation store, sub second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries.   Working on it, I've learned a lot of DOs and DON'Ts about columnstore indexes. Session covers how to:

SessionID: 86781

Managing Table Partitions at the Extremes

Back to calendar

Event Date: 27-04-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ron Talmage

Title: Managing Table Partitions at the Extremes

Abstract:

SQL Server’s table partitioning gets interesting at the extremes: namely the initial (often “before”) partition, as well as the last (often “future”) partition. In this session you’ll learn how to manage partitioned tables at these extremes based on choices concerning the partition key, files and filegroups, archiving, and adding future partitions.

SessionID: 87649

Managing ETL Change using BIMLScript

Back to calendar

Event Date: 27-04-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Russel Loski

Title: Managing ETL Change using BIMLScript

Abstract:

You develop an SSIS package to load a flat file. You meticulously identify each of the columns and map the columns to the target table. Your package runs fine for months. Then the file format changes. It is back to the drawing board, selecting each column, setting the data types (type, length, etc.). In many cases, you actually have the file structure in an electronic form. Wouldn't it be nice to simply regenerate your SSIS package using that metadata?

In this session I will demonstrate how to automate the generation of SSIS packages using the open source BIML and BIMLScript.

I will then demonstrate how to use this technique to handle changes in file structure. I will generate an SSIS package from a simple Excel workbook I will represent the structure of a flat file and its relationship to a staging table.

Finally, I will use BIMLScript to handle changes from one version of SSIS to the next and from SSIS to Azure data factory.

SessionID: 87920

Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!

Back to calendar

Event Date: 27-04-2019 - Session time: 11:00:00 - Track: BI Information Delivery

Speaker: Scott Stauffer

Title: Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!

Abstract:

You've heard about Power BI, and you've seen it, but you haven't yet rolled up your sleeves and got your hands dirty. It looks like it is really easy, but sometimes it helps to have someone step you through it the first time to help you hit the ground running. We will grab various public data sources, join them together in a model and build an interactive pièce de ré·sis·tance on the visual design surface!

SessionID: 93362

Becoming a Master by Giving It All Away

Back to calendar

Event Date: 27-04-2019 - Session time: 11:00:00 - Track: Professional Development

Speaker: Michael Wall

Title: Becoming a Master by Giving It All Away

Abstract:

It has been said that “novices absorb knowledge like a sponge, intermediates hoard it for themselves, and masters just simply give it away.”

The community spirit of PASS is for like-minded professionals to interact and share knowledge. But how do you do this in your own workplace? IT people are notorious about being siloed and not sharing their knowledge. That may be, but you have to move past all of that in order to truly move forward in your career and your life. There are many barriers in place to giving away your knowledge, but we will help you be ready to do so. The only way to truly become a master at your craft is to share your precious knowledge with your peers and workmates. We will discuss past and new trends in learning and knowledge transfer, the reasons why you should pass on knowledge, and methods for making this happen in your workplace and in your life. By passing on your knowledge, you are leaving behind a legacy that extends beyond your tenure at an organization

SessionID: 93363

SQL 101: A Very Good Place to Start

Back to calendar

Event Date: 27-04-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: josh smith

Title: SQL 101: A Very Good Place to Start

Abstract:

We’ll use Azure Data Studio to dive into the basics of T-SQL queries. In this interactive, all-demo session I’ll take you on a tour of basic queries and filter operators as we build out some single table queries and multi-table joins. We’ll also cover some basic data aggregations and talk a little bit about what the SQL query optimizer is doing under the covers to return your results as quickly as possible.

SessionID: 93366

Azure SQL DWH: Tips and Tricks for developers

Back to calendar

Event Date: 27-04-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sergiy Lunyakin

Title: Azure SQL DWH: Tips and Tricks for developers

Abstract:

Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can't use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching and so on. In this session, I'm going to cover several tips and tricks how we can handle with this limitations using available possibilities.

SessionID: 84867

Predictive Analytics with R in Power BI

Back to calendar

Event Date: 27-04-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Joseph Yeates

Title: Predictive Analytics with R in Power BI

Abstract:

Power BI reports are typically used for descriptive analysis: a historical look of what has happened. But what if your report could visualize what is likely to happen and recommend what you can do about it now? This session will cover how to shift from descriptive to predictive analysis and leverage the power of machine learning to enhance your business intelligence solutions. The basics and best practices of predictive modeling will be introduced, and these concepts will be applied to create three predictive models in R using three different techniques. We will then walk through the three different ways to integrate the predictive power of these models into a Power BI report.

SessionID: 86966

Large-scale graph querying and analytics with SQL Graph

Back to calendar

Event Date: 27-04-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Arvind Shyamsundar

Title: Large-scale graph querying and analytics with SQL Graph

Abstract:

SQL Server 2017 and Azure SQL DB introduced capabilities to store and query directed graphs in the database, with further improvements in SQL Server 2019 and recent Azure SQL DB releases. As with any new feature, scalability is a top question. In this session, we will demonstrate the features and scalability of SQL Graph by using a publicly available graph dataset: the Open Academic Graph - OAG - (https://www.openacademic.ai/oag/). The OAG graph includes over 166 million academic publications and over 1 billion citations. We show you how to efficiently import such large-scale graphs into SQL and then fully leverage the SQL Graph features to accomplish common graph query tasks (finding citations) and advanced analytics (PageRank, Shortest Paths etc.) on this large-scale graph. After this session, you will be amazed by the functionality, performance and scalability of SQL Graph!

SessionID: 87648

Querying Semistructured Data in Azure Data Lake with USQL

Back to calendar

Event Date: 27-04-2019 - Session time: 13:30: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: 87826

RC, SI, and RCSI -It's So Confusing. Which Should You Use?

Back to calendar

Event Date: 27-04-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Arnie Rowland

Title: RC, SI, and RCSI -It's So Confusing. Which Should You Use?

Abstract:

I'm just going to say it straight out. I'm pessimistically optimistic that most really understand transaction concurrency in SQL Server. There is often significant confusion about transaction concurrency and contention options available to Developers -is it 'pessimistic', or 'optimistic', or in between? Everyone ‘sort of’ understands READ COMMITTED (RC). But do you sometimes feel 'dirty' as you attempt to 'repeatedly' read that phantasma? In order to reduce locking and blocking conflicts, some folks adopt SNAPSHOT ISOLATION (SI). And a few hardy stalwarts have ventured into the new world of READ COMMITTED SNAPSHOT ISOLATION (RCSI). In this session, we will explore the differences between the three, including a discussion about the positives and negatives of each option. We will discuss the effects of 'Dirty', 'Repeatable' and 'Phantom' reads, and why you may want to know which may be buried in your code. There will be code examples demonstrating the benefits and traps of each option.

SessionID: 87919

SQL Server 2019 Big Data Clusters

Back to calendar

Event Date: 27-04-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Rock Pereira

Title: SQL Server 2019 Big Data Clusters

Abstract:

This talk shows how to use Kubernetes to analyze both high-volume data on HDFS, and high-value, very recent relational data in SQL Server. In the demo, we'll work with a time series dataset (1 billion rows) of 26,000 marine vessels in the Northwest from 2015 to 2017 to understand shipping patterns and improve safety. We'll do data prep with Spark, spatiotemporal analysis with R, and model serving with SQL Server.

SessionID: 93364

Power BI Administration to Optimize your Premium Services

Back to calendar

Event Date: 27-04-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: DeNisha Malone

Title: Power BI Administration to Optimize your Premium Services

Abstract:

In this session, attendees will learn a few things:

If you are a premium user, a Power BI Service Admin, or just interested in premium capacity - you don’t want to miss this session!

SessionID: 93370

How to write a Kicka** anything

Back to calendar

Event Date: 27-04-2019 - Session time: 13:30:00 - Track: Professional Development

Speaker: Blythe Morrow

Title: How to write a Kicka** anything

Abstract:

If you want to communicate your technical knowledge or want people to actually your emails, you’re going to need strong written communication skills. Writing is something most of us do every day, but it’s a difficult skill worth mastering. Join Blythe Morrow, Data Platform Marketer and life-long communicator, for a tips and tricks session that will take your written communication to the next level. We’ll review the most common business communication mistakes and learn a few tips to make your words stand out.

SessionID: 87827

Prevent Presentation Paralysis

Back to calendar

Event Date: 27-04-2019 - Session time: 15:15:00 - Track: Professional Development

Speaker: Arnie Rowland

Title: Prevent Presentation Paralysis

Abstract:

Stop fretting about giving presentations -you CAN decide to become more confident, come across more polished, and actually present with authority. In this session, you will learn and pick up some great tips about how to better prepare, and then present, technical material. You WILL leave with an improved sense of possibility!

Arnie will guide you with techniques to better understand and match the audience's expectations to your presentation goals. You will gain a better understanding of how to prepare your presentation, as well as how to get, and hold the audience's attention. And even how to be more relaxed with the inevitable critique from colleagues. Ramp up your career. Don't miss this session!

SessionID: 89380

Master Data Management: BI and Data Science’s Best Friend

Back to calendar

Event Date: 27-04-2019 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: John McAllister

Title: Master Data Management: BI and Data Science’s Best Friend

Abstract:

No matter the complexity of your BI application, Master Data Management can provide your organization the tools needed to conform, manage and simplify your dimensions. Attend this session and learn how Analytical MDM can forge quicker and more valuable insights.

SessionID: 90778

Everything You Need to Know About SQL Server Indexes

Back to calendar

Event Date: 27-04-2019 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Janis Griffin

Title: Everything You Need to Know About SQL Server Indexes

Abstract:

You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.

This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown. This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.

SessionID: 90976

Controlling Competing Workloads with SQL Server Resource Governor

Back to calendar

Event Date: 27-04-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Carrig

Title: Controlling Competing Workloads with SQL Server Resource Governor

Abstract:

With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor feature is an incredibly useful tool for any DBA to have in their toolbox. It allows for the effective throttling and control of CPU, memory and I/O consumed by multiple workloads running on a single SQL Server instance. In this session, we will cover the fundamental concepts of the SQL Server Resource Governor and provide demonstrations of practical scenarios where Resource Governor can control resources for specific workloads. Some of these demonstrations include how to limit the amount of memory consumed by memory-optimized tables and how to prevent poorly-written queries from overwhelming your storage subsystem. We will also discuss cases where Resource Governor can mitigate parameter sniffing problems. Finally, we will look at ways to leverage the useful information contained in the Resource Governor DMVs for monitoring and reporting.

SessionID: 91420

Tell a Story with Data in Power BI

Back to calendar

Event Date: 27-04-2019 - Session time: 15:15:00 - Track: BI Information Delivery

Speaker: DeNisha Malone

Title: Tell a Story with Data in Power BI

Abstract:

Got lot's of data, but not sure what to do with it?

This session will give you the steps to get the most insightful story from you dataset! We will also review Power BI Best Practices for everyday developers

SessionID: 93365

Machine Learning – Classification

Back to calendar

Event Date: 27-04-2019 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: vinh vu

Title: Machine Learning – Classification

Abstract:

As a data analyst, you need to analyze data and address business problems. In order to make your analysis have more impact, you can use machine learning to understand data correlation and predict business trends based on past patterns.

Through my presentation, I will talk about the classification problem in machine learning and how machine learning improves the business.

SessionID: 93371

Build a blog worth reading

Back to calendar

Event Date: 27-04-2019 - Session time: 15:15:00 - Track: Professional Development

Speaker: Blythe Morrow

Title: Build a blog worth reading

Abstract:

Creating a blog worth reading is no easy task. It’s a fine balance between consistency, topic choice, readability and SEO magic. Join marketing expert Blythe Morrow as we discuss how to build content for technical audiences that generates reads that connects you deeper into the SQL Server Community. Learn what it takes to eliminate confusion for your readers and connect people in a way that solves their problems. We'll also have a cameo or two from SQL celebrity bloggers who can lend advice and tips.

This site is open source. Improve this page.