sqlsathistory

Nr: 681

Back to Main list

SQLSaturday #681 - Spartanburg 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Andy Leonard	BI Platform Architecture, Development Administration	Designing an SSIS Framework
08:30:00	Angela Henry	BI Information Delivery	What is Power BI?
08:30:00	Richard Weiss	Cloud Application Development Deployment	A Tour of Cloud Data Platforms as a Service
08:30:00	Rick Heiges	Professional Development	Getting Noticed: Strategies for Your Resume and LinkedIn
08:30:00	Geoff Hiten	Cloud Application Development Deployment	ARMed for Azure
08:30:00	John Morehouse	Application Database Development	SQL Server Databaseology: A Deep Dive Into Database Internals
09:45:00	Andrew Kelly	Enterprise Database Administration Deployment	TempDB 101 Plus
09:45:00	Ed Watson	BI Platform Architecture, Development Administration	Introduction to SQL Server Integration Services
09:45:00	Tracy Boggiano	Enterprise Database Administration Deployment	Does This Look Weird? The Importance Of Baselining
09:45:00	Robert Eder	Professional Development	Learning on a Budget
09:45:00	Kiran Math	Advanced Analysis Techniques	R For Sql Developers
09:45:00	Brian Carrig	Enterprise Database Administration Deployment	Controlling Competing Workloads with SQL Server Resource Governor
09:45:00	Damu Venkatesan	Analytics and Visualization	Self-Service ETL with Microsoft Power Query in PowerBI
11:00:00	Neal Waterstreet	BI Platform Architecture, Development Administration	Master Data Management with SQL Server 2016 MDS
11:00:00	Rie Irish	Professional Development	Let Her Finish: Supporting Women's Voices in Technology
11:00:00	Justin Randall	Enterprise Database Administration Deployment	SQL Server 2016 In-Memory OLTP Tables
11:00:00	Azhagappan Arunachalam	BI Platform Architecture, Development Administration	Excel with DAX
11:00:00	Mike Lawell	Enterprise Database Administration Deployment	Execution Plans for Mere Mortals
11:00:00	Naomi Williams	Enterprise Database Administration Deployment	SQL Server Internals
13:15:00	George Walkey	Enterprise Database Administration Deployment	Using Powershell to Document SQL Server
13:15:00	Rick Heiges	Enterprise Database Administration Deployment	Winning with Columnstore - A Customer Story
13:15:00	Tracy Boggiano	Enterprise Database Administration Deployment	Query Store Primer
13:15:00	Jim Donahoe	Cloud Application Development Deployment	Getting started with SQL Azure Database: What you need to know
13:15:00	Stephen Muliokela	Enterprise Database Administration Deployment	Index Fragmentation
13:15:00	Rodney Landrum	Analytics and Visualization	Play Data - Increase Your Power BI Skills With Free and Fun Data Sets
13:15:00	Michael Wharton	Cloud Application Development Deployment	Create SQL Server VM, Active Directory VM and App Server VM in Azure
13:15:00	Rodney Landrum	Enterprise Database Administration Deployment	The DBA Script Thumb (10 year anniversary)
14:30:00	Thomas Norman	Application Database Development	Database Project Makes Deployment Consistent
14:30:00	Rie Irish	Enterprise Database Administration Deployment	How to Build Your Disaster Recovery Plan
14:30:00	Monica Rathbun	Enterprise Database Administration Deployment	Making your existing hardware work for you
14:30:00	Monica Rathbun	Professional Development	I'm It - Survival Techniques for the Lone DBA
14:30:00	Thomas Chan	Enterprise Database Administration Deployment	SQL Server Security Model 101
14:30:00	Roger Clark	BI Information Delivery	Microsoft Power BI Essentials
14:30:00	William Wolf	Application Database Development	Stop Doing That! Common T-SQL Anti-Patterns
15:45:00	Brandon Leach	Enterprise Database Administration Deployment	Treating Tables Like Legos: Table Partitioning Basics
15:45:00	Shannon Lowder	BI Platform Architecture, Development Administration	Interrogating your data sources with Biml
15:45:00	Luis Figueroa	BI Information Delivery	Enabling EDW and BI workloads on Hadoop with Hive / LLAP
15:45:00	Elizabeth Noble	Application Database Development	Making Your List and Checking It Twice: Introduction to unit testing with tSQLt
15:45:00	Jeff Mlakar	Enterprise Database Administration Deployment	Environmental SQL Server Troubleshooting
15:45:00	Rob Volk	Application Database Development	Tame Your Unruly Data With Constraints

SessionID: 66865

Designing an SSIS Framework

Back to calendar

Event Date: 23-09-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andy Leonard

Title: Designing an SSIS Framework

Abstract:

Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building on his previous work in the field of Data Integration Life Cycle Management (DILM) and SSIS Frameworks development, a Data Integration Architect with 10 years of SSIS experience explains the what, why, and how of an SSIS Catalog-integrated Framework that delivers metadata-driven package execution, connections management, and parameter configuration.

In this session, you will learn:

• A method for migrating packages from Development, through the data integration life cycle, to Production without editing SSIS Connection Manager Properties.
• A metadata-driven approach to SSIS package execution.
• A method for customizing enterprise data integration reporting.

SessionID: 67022

What is Power BI?

Back to calendar

Event Date: 23-09-2017 - Session time: 08:30:00 - Track: BI Information Delivery

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

A Tour of Cloud Data Platforms as a Service

Back to calendar

Event Date: 23-09-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Richard Weiss

Title: A Tour of Cloud Data Platforms as a Service

Abstract:

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

SessionID: 67443

Getting Noticed: Strategies for Your Resume and LinkedIn

Back to calendar

Event Date: 23-09-2017 - Session time: 08:30:00 - Track: Professional Development

Speaker: Rick Heiges

Title: Getting Noticed: Strategies for Your Resume and LinkedIn

Abstract:

You know you are well qualified for the jobs that you search for on any major job site. You know that if you just get to that next step that they will see it for themselves. This lightning talk focuses on strategies for your resume and LinkedIn profile to help get you noticed and reach that next step. Interaction with the audience is encouraged throughout the discussion.

SessionID: 68365

ARMed for Azure

Back to calendar

Event Date: 23-09-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Geoff Hiten

Title: ARMed for Azure

Abstract:

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

SessionID: 68434

SQL Server Databaseology: A Deep Dive Into Database Internals

Back to calendar

Event Date: 23-09-2017 - Session time: 08:30:00 - Track: Application Database Development

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

TempDB 101 Plus

Back to calendar

Event Date: 23-09-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Kelly

Title: TempDB 101 Plus

Abstract:

TempDB is not your ordinary user database and should definitely not be treated like one. The usage patterns dictate that the configuration, monitoring and usage be done in a different way to get the best performance. We will see why aspects such as configuration and file placement play such a key role and why you need to plan ahead for TempDB. See how to detect the memory and space usage associated with the various users in TempDB along with some of the most common performance related scenarios that you will encounter with a well-used TempDB database. In addition we will explain the differences between temp tables and table variables and when to use one over another.

SessionID: 66889

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 23-09-2017 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Watson

Title: Introduction to SQL Server Integration Services

Abstract:

Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

SessionID: 67857

Does This Look Weird? The Importance Of Baselining

Back to calendar

Event Date: 23-09-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Does This Look Weird? The Importance Of Baselining

Abstract:

How do you know when your server is on fire? Without a set of known-good measurements to compare against, you don’t. This session will show you how to capture a performance baseline for a SQL Server instance and help you decide what to capture, and where to store it. Finally we will put it all together by walking through a scenario using the captured baseline data to identify a problem.

SessionID: 67946

Learning on a Budget

Back to calendar

Event Date: 23-09-2017 - Session time: 09:45:00 - Track: Professional Development

Speaker: Robert Eder

Title: Learning on a Budget

Abstract:

Traditional classroom training is not cheap. Many companies do not provide this training to their employees. The cost of this training is often beyond a person’s financial means. To add to this challenge, over the past few years, Microsoft has added a lot of new technology increasing the amount of training to keep up.

There is a log of great training opportunities outside the traditional classroom. This session will go over the these options to allow you the opportunity to keep up with the technology.

SessionID: 68049

R For Sql Developers

Back to calendar

Event Date: 23-09-2017 - Session time: 09:45:00 - Track: Advanced Analysis Techniques

Speaker: Kiran Math

Title: R For Sql Developers

Abstract:

15 Mins : Introduction To R Data Structures

05 Mins : R Markdown 10 Mins : Functional Programming - R Functions 15 Mins : RevoScaleR Package 15 Mins : Operationalized R Code

All Section will be demonstrated using very simple examples.

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

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

SessionID: 68425

Controlling Competing Workloads with SQL Server Resource Governor

Back to calendar

Event Date: 23-09-2017 - Session time: 09:45: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: 68439

Self-Service ETL with Microsoft Power Query in PowerBI

Back to calendar

Event Date: 23-09-2017 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Damu Venkatesan

Title: Self-Service ETL with Microsoft Power Query in PowerBI

Abstract:

Are you trying to quickly extract, transform and load data from multiple data sources for data analysis without going through an extensive ETL development? In this session, I will introduce you to Microsoft's new self-service ETL tool "Power Query" for PowerBI. I will show you with several example demos, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to "M" language that is used in Power Query. I will show you how you can discover and mash data from public data sources with Power Query and model the data very easily. If you would like to do ETL quickly without writing SSIS packages or scripts, Power Query is the way go. Come and attend this session to learn "Power Query" for Power BI and Excel. You will be the data analysis star in your organization.

SessionID: 66883

Master Data Management with SQL Server 2016 MDS

Back to calendar

Event Date: 23-09-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Neal Waterstreet

Title: Master Data Management with SQL Server 2016 MDS

Abstract:

Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

SessionID: 68064

Let Her Finish: Supporting Women's Voices in Technology

Back to calendar

Event Date: 23-09-2017 - Session time: 11:00:00 - Track: Professional Development

Speaker: Rie Irish

Title: Let Her Finish: Supporting Women's Voices in Technology

Abstract:

Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out.

This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

SessionID: 68286

SQL Server 2016 In-Memory OLTP Tables

Back to calendar

Event Date: 23-09-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Randall

Title: SQL Server 2016 In-Memory OLTP Tables

Abstract:

In-Memory OLTP in SQL Server 2016 has been reborn. Many limitations within the previous versions have been removed, making it a viable option for a variety of workloads. In this session we will highlight critical issues in implementing and managing SQL Server 2016 instances and databases containing In-Memory tables. The bulk of this session will be spent walking through the process of identifying candidate In-Memory tables, migrating an on-disk table to an in-memory table and comparing performance.

SessionID: 68349

Excel with DAX

Back to calendar

Event Date: 23-09-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Azhagappan Arunachalam

Title: Excel with DAX

Abstract:

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

SessionID: 68382

Execution Plans for Mere Mortals

Back to calendar

Event Date: 23-09-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.

SessionID: 69200

SQL Server Internals

Back to calendar

Event Date: 23-09-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 66866

Using Powershell to Document SQL Server

Back to calendar

Event Date: 23-09-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: George Walkey

Title: Using Powershell to Document SQL Server

Abstract:

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

SessionID: 67445

Winning with Columnstore - A Customer Story

Back to calendar

Event Date: 23-09-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Heiges

Title: Winning with Columnstore - A Customer Story

Abstract:

This session will feature a real story of a customer who was running into performance and scaling issues on a big iron Oracle RAC system and why they decided to consider the magic of the Column Store for this situation. Discussion will focus on the existing environments for testing both SQL 2016 and Oracle as well as the methodologies used for testing. We will examine the decisions made for choosing indexes (both traditional and column store) for the main tables in the data warehouse as well as the partitioning strategies employed. We will wrap up the discussion with the results of the testing and where they are now.

SessionID: 67855

Query Store Primer

Back to calendar

Event Date: 23-09-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Query Store Primer

Abstract:

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

SessionID: 68407

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

Back to calendar

Event Date: 23-09-2017 - Session time: 13:15: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: 68751

Index Fragmentation

Back to calendar

Event Date: 23-09-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Stephen Muliokela

Title: Index Fragmentation

Abstract:

In this session I will be teaching all about index fragmentation, including why its a problem, how it happens, how to detect it, how to avoid it and how to remove it. This course is applicable to anyone who is responsible for SQL Server perfromance and much more.

List of topics include 1.Index structure 2.Singleton Lookups 3.Scans and mary go round scans 4.Read ahead 5.Logical fragmentation 6.Extent fragmentation 7.Low page density 8.Tracking Page splits ,removing fragmentation

SessionID: 68770

Play Data - Increase Your Power BI Skills With Free and Fun Data Sets

Back to calendar

Event Date: 23-09-2017 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Rodney Landrum

Title: Play Data - Increase Your Power BI Skills With Free and Fun Data Sets

Abstract:

Many of us have by now dipped our toes into the Power BI pool and liked it so much we thought we were ready to swim out to the deep end and dive right into analyzing data from our day to day jobs, whatever that may be. Soon we discover that we are now actually working. No fun. Using freely available data sets and some that I have modified from "work" to "play" with data that interests me, I will show how you can find, model, and analyze the data you find interesting as well. And then you can go back to work which should be much easier now.

SessionID: 69477

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

Back to calendar

Event Date: 23-09-2017 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Michael Wharton

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

Abstract:

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

SessionID: 69489

The DBA Script Thumb (10 year anniversary)

Back to calendar

Event Date: 23-09-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Rodney Landrum

Title: The DBA Script Thumb (10 year anniversary)

Abstract:

Over time and through many different roles I have collected a wide array of T-SQL scripts and techniques that I use many times per week. These vary from basic troubleshooting, to health checks and best practice configuration settings to custom alerting and trending. In this session, I will walk through several of these scripts and ultimately show how you can automate the delivery of the output into useful reports and visualizations that will wow your boss (or customers) but more importantly, help you find and address potential problems fast and for free.

https://www.red-gate.com/simple-talk/sql/database-administration/the-dba-script-thumb/

SessionID: 66878

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.

SessionID: 68063

How to Build Your Disaster Recovery Plan

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rie Irish

Title: How to Build Your Disaster Recovery Plan

Abstract:

So your boss asked for a copy of your DR plan. Once you've wiped that deer-in-the-headlights look off your face, you realize "We've got database backups," isn't exactly a plan. You need to come up with a plan to recover your business when disaster strikes. This session will help you build this plan by defining what a disaster could be, documenting the business impact, and identifying your limitations. We will show how to use this information to establish metrics (such as RTO and RPO), document current recovery configurations, and design an effective recovery strategy that meets the needs and budget of your business. Attending this session will give you the knowledge and tools to create an effective disaster recovery plan that will make your boss happy and ensure the continuity of your business.

SessionID: 68346

Making your existing hardware work for you

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: Making your existing hardware work for you

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

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: Professional Development

Speaker: Monica Rathbun

Title: I'm It - Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 68420

SQL Server Security Model 101

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Chan

Title: SQL Server Security Model 101

Abstract:

We will talk quickly about login (server), user (database), role (server and database), schema, permission and may be something more.

SessionID: 68734

Microsoft Power BI Essentials

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: BI Information Delivery

Speaker: Roger Clark

Title: Microsoft Power BI Essentials

Abstract:

This session will cover installation considerations as well as more advanced tool usage and visualization techniques. Current release information and tips and tricks will be included.

SessionID: 69197

Stop Doing That! Common T-SQL Anti-Patterns

Back to calendar

Event Date: 23-09-2017 - Session time: 14:30:00 - Track: Application Database Development

Speaker: William Wolf

Title: Stop Doing That! Common T-SQL Anti-Patterns

Abstract:

There are several programming design patterns that work great in object oriented code but do not scale inside SQL Server. Things like Scalar-Value functions, Unions, CTEs, and row by row processing can make for more work then you would expect.

In this session, we will focus on several anti-patterns like these and show how to rework them to improve scale in the database engine.

By the end of the session, you will be able to quickly identify these common anti-patterns and analyze their sometimes unclear cost to the engine. Heading back to the office, you’ll be able to identify pain points in your longest running queries from a T-SQL perspective and become a code tuning rockstar!

SessionID: 66893

Treating Tables Like Legos: Table Partitioning Basics

Back to calendar

Event Date: 23-09-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Leach

Title: Treating Tables Like Legos: Table Partitioning Basics

Abstract:

Have your tables and indexes that have grown rather large? Are they taking longer to query? Are your windows for maintenance getting tighter? If you answered yes to any of these questions, table partitioning may be for you!

With table partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and sliding windows. You'll see how we can make our index and statistics maintenance easier. At the end of this session you’ll have a firm understanding of how partitioning works and be able to make decisions on how and when to implement.

SessionID: 67216

Interrogating your data sources with Biml

Back to calendar

Event Date: 23-09-2017 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shannon Lowder

Title: Interrogating your data sources with Biml

Abstract:

You've started using Biml to make your ETL development easier. The problem is not all your data sources have easy to read metadata like SQL Server. How do you create usable metadata from these sources?

Simple! Attend my session and learn how others are doing it using my open source Interrogator. This code can take any text-based data and apply a series of tests in order to determine what datatype best fits. These tests also build on each other to allow you to determine the best fit for a column based on the whole file, or on a collection of files. No more guessing based on the first 200 rows!

During the session, I'll also give a primer on some basic C# programming techniques that can be used along with the code to apply the Interrogator to your own semi-structured data sources.

SessionID: 68120

Enabling EDW and BI workloads on Hadoop with Hive / LLAP

Back to calendar

Event Date: 23-09-2017 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Luis Figueroa

Title: Enabling EDW and BI workloads on Hadoop with Hive / LLAP

Abstract:

In its origin, Hadoop was created as a distributed computing system designed to process data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop. So a few years back the Stinger initiative was created as an ongoing effort to bring interactive SQL querying capabilities to Hive, and its latest release has finally delivered!

In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hive on Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. If you are a data pro this session is for you!

SessionID: 68248

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

Back to calendar

Event Date: 23-09-2017 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Elizabeth Noble

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

Abstract:

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

SessionID: 68302

Environmental SQL Server Troubleshooting

Back to calendar

Event Date: 23-09-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Mlakar

Title: Environmental SQL Server Troubleshooting

Abstract:

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

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

SessionID: 68362

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 23-09-2017 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.

This site is open source. Improve this page.