sqlsathistory

Nr: 708

Back to Main list

SQLSaturday #708 - Cleveland 2018

Start Time (24h) Speaker Track Title
08:30:00 Eugene Meidinger BI An (Advanced) Introduction to Dax
08:30:00 Dave Bland Enterprise Database Administration Deployment Statistics - Why are they there and what do I do with them
08:30:00 Arthur Daniels III Application Database Development Reading Execution Plans Successfully
08:30:00 Dave Mattingly Cloud Application Development Deployment Alexa, Talk to Me
08:30:00 Allen White Strategy and Architecture Emergency! Are You Ready for Disaster to Strike?
08:30:00 Carlton Ramsey Application Database Development T-SQL Basics
09:45:00 Jim Donahoe Cloud Application Development Deployment Getting started with SQL Azure Database: What you need to know
09:45:00 David Maxwell Enterprise Database Administration Deployment Targeting Wait Statistics with Extended Events and DMVs
09:45:00 Joe Obbish Application Database Development Decoding the Cardinality Estimator to Speed Up Queries
09:45:00 Angela Henry BI What is Power BI?
09:45:00 Peter Shore Enterprise Database Administration Deployment The Data-Professional’s Junk Drawer
09:45:00 Kerry Tyler Application Database Development Managing Your Schema with Database Projects in Visual Studio
11:00:00 Kevin Mackey Application Database Development Don't just code it—Generate It
11:00:00 Joseph D'Antoni BI Relationships Matter: Graph DB in SQL Server 2017
11:00:00 Kellyn Pot'Vin-Gorman Enterprise Database Administration Deployment Essential Linux for the SQL Server DBA
11:00:00 Angela Henry BI Intro to Integration Services (SSIS)
11:00:00 Erin Stellato Cloud Application Development Deployment Query Store and Automatic Tuning in SQL Server 2017 and Azure SQL DB
11:00:00 John Morehouse Enterprise Database Administration Deployment SQL Server Databaseology: A Deep Dive Into Database Internals
13:30:00 Hasan Savran Multi-Purpose (AppDev, DBA, BI) What's new in SQL Server 2017
13:30:00 Kevin Feasel Enterprise Database Administration Deployment Applying Forensic Accounting Techniques Using SQL And R
13:30:00 Drew Furgiuele Enterprise Database Administration Deployment SQL Server and PowerShell: Let's Get Serious
13:30:00 Wendy Pastrick Strategy and Architecture Navigating the Options for Data Redundancy
13:30:00 Jeremy Frye BI Data Hoarding (Buried Alive): Better Data Modeling and Management When Using Power BI
13:30:00 Eric Blinn Application Database Development Intro to indexing for SQL writers
14:45:00 Hope Foley Cloud Application Development Deployment PaaS Your BISM: Intro to Azure Analysis Services
14:45:00 Mindy Curnutt Application Database Development Parameters in SQL Server - Query Performance Makers or Breakers
14:45:00 Andy Mallon Enterprise Database Administration Deployment Shortcuts from an Impatient DBA
14:45:00 Sam Nasr Enterprise Database Administration Deployment SQL Server 2016 Security Features
14:45:00 Pat Phelan Application Database Development Relational Data Architecture 101
14:45:00 Bert Wagner BI High-Performance SSRS: Techniques For Faster Reports
16:15:00 Matt Gordon Enterprise Database Administration Deployment New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups
16:15:00 Julie Smith BI H*ckin Sweet Reports with Power BI
16:15:00 Tracy Boggiano Enterprise Database Administration Deployment Tips on Managing Lots of SQL Servers
16:15:00 Monica Rathbun Strategy and Architecture You're Stuck with Crappy Hardware, Now What?
16:15:00 John Deardurff Application Database Development The Vocabulary of Performance Tuning
16:15:00 Jeff Moden Application Database Development Hierarchies on Steroids

SessionID: 70031

An (Advanced) Introduction to Dax

Back to calendar

Event Date: 03-02-2018 - Session time: 08:30:00 - Track: BI

Speaker: Eugene Meidinger

Title: An (Advanced) Introduction to Dax

Abstract:

Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be successful with DAX and Powerpivot, you'll need a completely different mental model. In this introduction to DAX, we won't spend too much time on the basics. Instead, we'll focus the concepts that make DAX unique. This will help you avoid the stumbling blocks of working with DAX. We will cover calculated columns, measures, aggregations, filtering, and iterators.

SessionID: 70037

Statistics - Why are they there and what do I do with them

Back to calendar

Event Date: 03-02-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Statistics - Why are they there and what do I do with them

Abstract:

In this session you will learn the basics of statistics and what they are used for. You will learn how to gather information about the statistics and how to use the information to improve performance. It is important the statistics are maintained to work properly. We will discuss what on going maintenance should be done on statistics.

SessionID: 70108

Reading Execution Plans Successfully

Back to calendar

Event Date: 03-02-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Arthur Daniels III

Title: Reading Execution Plans Successfully

Abstract:

If you've seen an execution plan but didn't know how to read it, this session is for you.

The goal of this session to learn how SQL Server is interpreting your query into an execution plan. We'll discuss execution plan internals, how SQL Server estimates the cost of your query, and what a graphical execution plan is displaying through its operators.

Learning to read an execution plan is a great way to begin troubleshooting performance. At the end, we will take a look at how SQL Server 2016 provides more tools for exploring execution plans.

SessionID: 70292

Alexa, Talk to Me

Back to calendar

Event Date: 03-02-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Dave Mattingly

Title: Alexa, Talk to Me

Abstract:

Learn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa.

In this session, we'll create a simple skill from scratch, and show how to get into some of the more advanced options.

SessionID: 70628

Emergency! Are You Ready for Disaster to Strike?

Back to calendar

Event Date: 03-02-2018 - Session time: 08:30:00 - Track: Strategy and Architecture

Speaker: Allen White

Title: Emergency! Are You Ready for Disaster to Strike?

Abstract:

Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.

SessionID: 70975

T-SQL Basics

Back to calendar

Event Date: 03-02-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Carlton Ramsey

Title: T-SQL Basics

Abstract:

In this session we will go over T-SQL Basics. We will review SELECT, INSERT, UPDATES and DELETE statements. Discuss how to retrieve data from multiple tables. Work with group by and other commands to retrieve data from your database.

This session is geared towards and audience that may have never worked with a SQL Server Database and is looking for a quick start for working with data stored in a database.

SessionID: 70068

Getting started with SQL Azure Database: What you need to know

Back to calendar

Event Date: 03-02-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Jim Donahoe

Title: Getting started with SQL Azure Database: What you need to know

Abstract:

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.

In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

SessionID: 70369

Targeting Wait Statistics with Extended Events and DMVs

Back to calendar

Event Date: 03-02-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Targeting Wait Statistics with Extended Events and DMVs

Abstract:

When troubleshooting overall server performance, wait statistics are a great place to start. But when your SQL Server hosts a complex set of workloads, it can be difficult to narrow down which queries are causing the most wait, and what types of wait they are causing. Fortunately, SQL Server provides easy ways for targeting which queries are causing you the most wait time. In this session, we’ll learn how to use both Extended Events, and Dynamic Management Views new to SQL Server 2016 for examining wait statistics at a query level, rather than at the server level. We’ll analyze poorly performing queries using a combination of methods and show how to quickly narrow down what SQL Server is waiting for, and why.

SessionID: 70974

Decoding the Cardinality Estimator to Speed Up Queries

Back to calendar

Event Date: 03-02-2018 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Joe Obbish

Title: Decoding the Cardinality Estimator to Speed Up Queries

Abstract:

The cardinality estimator in SQL Server is a massively complex piece of software that is responsible for calculating the estimated number of rows for query plans. We will derive some of the simplest and most important rules for cardinality estimation. Armed with that knowledge, we will address errors in cardinality estimates which can cause poor query performance. Demos include filtering on multiple columns, using local variables, dealing with ascending keys, and more.

SessionID: 71249

What is Power BI?

Back to calendar

Event Date: 03-02-2018 - Session time: 09:45:00 - Track: BI

Speaker: Angela Henry

Title: What is Power BI?

Abstract:

You’ve heard all the buzz about Power BI, but you have no idea what it is and how it works. This session explains what Power BI is, who can use it and why you would want to. It’s an introductory session that gives you the information you need to determine if Power BI is right for you and your organization.

SessionID: 71373

The Data-Professional’s Junk Drawer

Back to calendar

Event Date: 03-02-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: The Data-Professional’s Junk Drawer

Abstract:

There is at least one in your home right now, a box, a basket, a bucket, perhaps even actually drawer; hastily organized at best but full of tools, gadgets, widgets and whatchamacallits designed for one or two specific purposes. Realistically, we all want to use the more generic, multipurposed item found in our “well organized place for storing things”, yet deep down we know that tool/gadget/widget etc. is really what we need. As data-professionals, we are all familiar with the largest “junk drawer” ever created, the Internet. In this session, we will discuss some tools which are not data specific, the jobs they do well, and where to find them. Join as us as explore Robocopy, parts of the SysInterals Suite, a connection manager or two, portables apps aplenty and more so that you can move that file more efficiently, troubleshoot that problem through a different lens, or simply know what the heck someone else is talking about.

SessionID: 71440

Managing Your Schema with Database Projects in Visual Studio

Back to calendar

Event Date: 03-02-2018 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Kerry Tyler

Title: Managing Your Schema with Database Projects in Visual Studio

Abstract:

Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a daunting and often tedious proposition. Adding the complexity of version control to the mix complicates this scenario. Fortunately, beginning with Visual Studio 2012, Database Projects add an "easy" button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does no code management.

SessionID: 70070

Don't just code it—Generate It

Back to calendar

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

Speaker: Kevin Mackey

Title: Don't just code it—Generate It

Abstract:

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.

Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.

SessionID: 70744

Relationships Matter: Graph DB in SQL Server 2017

Back to calendar

Event Date: 03-02-2018 - Session time: 11:00:00 - Track: BI

Speaker: Joseph D'Antoni

Title: Relationships Matter: Graph DB in SQL Server 2017

Abstract:

Graph databases solve a lot of complex relationship challenges that relational databases struggle

to support. Relational databases are optimized for capturing data and answering data questions. Graph databases are highly optimized for answering questions about data relationships. Do you, data professional, understand which data stories need which type of technology?

SessionID: 70884

Essential Linux for the SQL Server DBA

Back to calendar

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

Speaker: Kellyn Pot'Vin-Gorman

Title: Essential Linux for the SQL Server DBA

Abstract:

Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for years to manage their databases on this valuable OS?

This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience. The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment. We’ll learn:

  1. Linux history and concepts.
  2. Important differences between systems
  3. Crucial commands to get around a. Navigating, searching and managing b. Monitoring, tracing and updating c. Editing and scripting

You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!

SessionID: 71248

Intro to Integration Services (SSIS)

Back to calendar

Event Date: 03-02-2018 - Session time: 11:00:00 - Track: BI

Speaker: Angela Henry

Title: Intro to Integration Services (SSIS)

Abstract:

This session is a very basic introduction to Integration Services (SSIS). We’ll cover the basics; what it’s used for and the various parts and pieces to get you started creating your own projects in no time. We’ll talk about packages, connections and project parameters and their respective tasks/properties. We’ll also cover some basic performance tuning to make your packages run faster.

SessionID: 71437

Query Store and Automatic Tuning in SQL Server 2017 and Azure SQL DB

Back to calendar

Event Date: 03-02-2018 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Erin Stellato

Title: Query Store and Automatic Tuning in SQL Server 2017 and Azure SQL DB

Abstract:

One of the most highly anticipated new features in the SQL Server 2016 release was Query Store. It's referred to as the "flight data recorder" for SQL Server because it tracks query information over time – including the text, the plan, and execution statistics. The addition of wait statistics information – tracked for each query plan – in SQL Server 2017 makes Query Store a tool that every data professional needs to know how to use, whether you're new to troubleshooting or someone who's been doing it for years. When you include the new Automatic Tuning capabilities in SQL Server 2017 and Azure SQL Database, suddenly it seems like you might spend less time fighting fires and more time enjoying a lunch break that’s not at your desk. In this session, we'll talk through these new features - and see them in action - so you can understand how you can immediately start to use them once you’ve upgraded to SQL Server 2017.

SessionID: 71461

SQL Server Databaseology: A Deep Dive Into Database Internals

Back to calendar

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

Speaker: John Morehouse

Title: SQL Server Databaseology: A Deep Dive Into Database Internals

Abstract:

Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge will allow you to build better, faster databases.

SessionID: 70169

What's new in SQL Server 2017

Back to calendar

Event Date: 03-02-2018 - Session time: 13:30:00 - Track: Multi-Purpose (AppDev, DBA, BI)

Speaker: Hasan Savran

Title: What's new in SQL Server 2017

Abstract:

SQL Server 2017 has great new additions and features for everybody. If you are a developer, you want to learn about new Graph tables, new M.O.T enhancements, and new functions. If you are a BI developer, you want to learn about how to run R and Python in SQL Server. If you are a DBA, you might want to learn about new features like Resumable Online Indexes, Automatic Query Optimization and how to monitor R and Python scripts. This session will have overall information about new features of SQL Server 2017

SessionID: 70247

Applying Forensic Accounting Techniques Using SQL And R

Back to calendar

Event Date: 03-02-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Feasel

Title: Applying Forensic Accounting Techniques Using SQL And R

Abstract:

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.

SessionID: 70410

SQL Server and PowerShell: Let's Get Serious

Back to calendar

Event Date: 03-02-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server and PowerShell: Let's Get Serious

Abstract:

Whether you’ve dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell isn’t going away. It is definitely something worth learning to make your life as a SQL Server professional easier, and allow you to advance in your career as a DBA.

In this session, you’ll see practical, real-world examples of how you can blend SQL Server and PowerShell together. You’ll also get a look at the SQL Server PowerShell provider and how you can incorporate it into your automation scripts.

Instead of focusing on syntax, the session will plunge straight into examples and highlight various snippets of code and how they work. You can expect to see code examples on how PowerShell can do anything from comparing tables across servers, automating and centralizing your backups, and even doing in-depth security audits.

SessionID: 70529

Navigating the Options for Data Redundancy

Back to calendar

Event Date: 03-02-2018 - Session time: 13:30:00 - Track: Strategy and Architecture

Speaker: Wendy Pastrick

Title: Navigating the Options for Data Redundancy

Abstract:

SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.

SessionID: 71064

Data Hoarding (Buried Alive): Better Data Modeling and Management When Using Power BI

Back to calendar

Event Date: 03-02-2018 - Session time: 13:30:00 - Track: BI

Speaker: Jeremy Frye

Title: Data Hoarding (Buried Alive): Better Data Modeling and Management When Using Power BI

Abstract:

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

Are you hoarding your environment with unorganized piles of data to feed your wonderful Power BI reports? In this life of point and click, drag and drop reporting, we sometimes lose sight of cohesive business standards, data integration and modeling.

In this session, we will look at potential data management nightmares that include but are not limited to; overlapping data, inconsistent naming conventions, undocumented transformations, mismatch data types and varying granularity. We will focus on the importance of having a solid data model and managing data governance using Power BI as well as traditional tools and best practices.

SessionID: 71492

Intro to indexing for SQL writers

Back to calendar

Event Date: 03-02-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Eric Blinn

Title: Intro to indexing for SQL writers

Abstract:

Are you just starting out writing SQL for applications or reports? Did you back into a DBA role by accident? Do you know nothing about indexes and think you should? If you answered yes to any of those questions then this class is for you.

This class presents indexes from the ground up and lays the foundation for solid index usage. We'll cover what indexes are, different types of indexes, when to use them, and when not to use them. We'll also briefly cover index maintenance.
This class is designed for beginners and is designed to be very practical. It won't dive deep on any one subject and won't bog down with technical minutiae.

SessionID: 70131

PaaS Your BISM: Intro to Azure Analysis Services

Back to calendar

Event Date: 03-02-2018 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Hope Foley

Title: PaaS Your BISM: Intro to Azure Analysis Services

Abstract:

The acronyms get out of control sometimes but the platform as a service (PaaS) offerings keep coming! Microsoft has introduced another one in the data platform called Azure Analysis Services. This service allows for the hosting of your BI Semantic models (BISM) in Azure. In this session we'll get an introduction to this new service and walk through how to get started using it. We'll also discuss the benefits and differences of this and the on premise SSAS solution.

SessionID: 70865

Parameters in SQL Server - Query Performance Makers or Breakers

Back to calendar

Event Date: 03-02-2018 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: Parameters in SQL Server - Query Performance Makers or Breakers

Abstract:

T-SQL programming makes wide use of parameterization in stored procedures, dynamic statements and ad-hoc queries. Many developers aren’t aware of the significant influence they have on query performance. Incorrect use or lack of parameters is a common reason for query performance issues.

Have you experienced a query that always ran fast, suddenly (and for "no reason") become slow? And with nothing changing? Yep!

SessionID: 71244

Shortcuts from an Impatient DBA

Back to calendar

Event Date: 03-02-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Mallon

Title: Shortcuts from an Impatient DBA

Abstract:

This session is about performance tuning your day.

We spend a lot of time thinking about how to write efficient code, but we don't spend a lot of time thinking about how to be efficient with how we use our tools. In this session I will show you some lesser known keyboard shortcuts, tips, tricks, and hacks that will make your day easier. These are the tricks I've picked up over the years that help me get my work done quicker and easier.

Even the most seasoned Database Professionals will learn a new trick that makes SSMS even easier to use.

SessionID: 71389

SQL Server 2016 Security Features

Back to calendar

Event Date: 03-02-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Sam Nasr

Title: SQL Server 2016 Security Features

Abstract:

SQL Server 2016 provides several new security features for developers and architects. Features such as Dynamic Data Masking (DDM), "Always Encrypted", and Row-Level Security provide an additional level of security natively through the database server. We'll explore the implementation of these features on the client/server for data in transmission or at rest. In addition, we'll examine built-in features and custom implementations.

SessionID: 71495

Relational Data Architecture 101

Back to calendar

Event Date: 03-02-2018 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Relational Data Architecture 101

Abstract:

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.

SessionID: 72369

High-Performance SSRS: Techniques For Faster Reports

Back to calendar

Event Date: 03-02-2018 - Session time: 14:45:00 - Track: BI

Speaker: Bert Wagner

Title: High-Performance SSRS: Techniques For Faster Reports

Abstract:

SQL Server Reporting Services (SSRS) is an easy-to-use tool for automating reports and creating highly visual dashboards. Although SSRS is easy to learn there are many tips and tricks that can improve your report building experience, not to mention make your reports run blazing fast!

This rapid-fire session goes over my learnings from the past six years of developing high-performance SSRS reports, including topics like multivalue parameter efficiencies, how to best utilize subreports, and performing SQL CRUD operations with SSRS. Each rapid-fire topic includes sample data and an SSRS reporting example that users will be able to try out for themselves.

SessionID: 70040

New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups

Back to calendar

Event Date: 03-02-2018 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: New Features and New Speed in SQL Server 2016 (and 2017!) Always On Availability Groups

Abstract:

Microsoft has added new performance improvements and new features to SQL Server 2016 and 2017’s implementation of Always On Availability Groups. This session will cover improvements that range from Standard Edition support for AGs to load balanced replicas to new ways to create those replicas. We’ll kick the tires on the improved Azure support and discuss the massive performance improvements in Always On as well.

SessionID: 70132

H*ckin Sweet Reports with Power BI

Back to calendar

Event Date: 03-02-2018 - Session time: 16:15:00 - Track: BI

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

Tips on Managing Lots of SQL Servers

Back to calendar

Event Date: 03-02-2018 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Tips on Managing Lots of SQL Servers

Abstract:

When managing a single server it is easy to keep track of the configuration of that server, but what about when you have more than ten servers to manage or a hundred? How do you know they are setup correctly? How do you maintain the databases on each server? How do you take care of patching? How do you know when your server is on fire?

In this talk we will answer these questions and more as we discuss technologies and approaches you can use to make sure your environment is configured and performing at its best.

SessionID: 70709

You're Stuck with Crappy Hardware, Now What?

Back to calendar

Event Date: 03-02-2018 - Session time: 16:15:00 - Track: Strategy and Architecture

Speaker: Monica Rathbun

Title: You're Stuck with Crappy Hardware, Now What?

Abstract:

Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking. Let’s see how compression, statistics, and indexes bring new life into your existing hardware.

SessionID: 70946

The Vocabulary of Performance Tuning

Back to calendar

Event Date: 03-02-2018 - Session time: 16:15:00 - Track: Application Database Development

Speaker: John Deardurff

Title: The Vocabulary of Performance Tuning

Abstract:

This session is for the absolute beginner to learn the terminology of performance tuning and how queries are processed. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss table structures and the differences between Heaps and Clustered Indexes. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses.

SessionID: 71370

Hierarchies on Steroids

Back to calendar

Event Date: 03-02-2018 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Jeff Moden

Title: Hierarchies on Steroids

Abstract:

Hierarchical data sets are everywhere. If you haven't worked with one yet, you probably will someday.

If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process.

This simple but code intensive "Black Arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and includes a very high performance method (100,000 nodes in less than 4 seconds and 1 Million nodes in less than a minute) for converting Adjacency Lists to Nested Sets that even a beginner can understand.

If there's time, we'll cover a new "pre-aggregated" Hierarchical table structure that answers most of the questions you'd ask of a Hierarchy. You just have to know that a Tally Table is involved somewhere in this. ;-)

Don't let the "Intermediate" rating of this session scare you beginners away because we start at the ground floor.

This site is open source. Improve this page.