sqlsathistory

Nr: 802

Back to Main list

SQLSaturday #802 - San Diego 2018

Start Time (24h)	Speaker	Track	Title
09:15:00	Denny Cherry	Enterprise Database Administration Deployment	How to Maintain the Same Level of Utilities in Cloud Deployments - Securability, Reliability and Sca
09:15:00	Armando Lacerda	Cloud Application Development Deployment	Azure for SQL Server Professionals - Get your head in the Cloud
09:15:00	Mindy Curnutt	Professional Development	Impostor Syndrome: Are You Faking It Will they Find Out?
09:15:00	Andrew Karcher	Strategy and Architecture	Foundations of a Data Driven Organization
09:15:00	Sepand Gojgini	BI Platform Architecture, Development Administration	Columnstore Index Primer
09:15:00	Maxwell Myrick	Enterprise Database Administration Deployment	The Art and Science of Designing a Mission Critical SQL Server
09:15:00	Ike Ellis	BI Information Delivery	Introduction to DAX
09:15:00	Simon Cho	Application Database Development	[StepbyStep] SQL server Index operation for beginner to expert.
10:30:00	Jeff Prom	Strategy and Architecture	Save Time and Resources - Performance Tuning Strategies
10:30:00	Jay Falck	Enterprise Database Administration Deployment	Introduction to Linux for SQL Server
10:30:00	Kevin Feasel	Strategy and Architecture	Much Ado About Hadoop
10:30:00	Suresh Datla	BI Information Delivery	Power BI Dashboard - Creating End to End Solutions
10:30:00	Ted Stathakis	BI Information Delivery	Introduction to SQL Server Reporting Services
10:30:00	Peter Kral	BI Platform Architecture, Development Administration	SSIS Deployment Smackdown! Package vs. Project!
10:30:00	Ben Aminnia	Professional Development	Choosing a Career Path in Database Technologies
10:30:00	Dustin Vannoy	Data Science, Analytics and Visualization	A Week in the Life of a Data Scientist
12:15:00	Diane Schuster	BI Platform Architecture, Development Administration	CozyRoc: Dynamic Data Flows in SSIS Without Programming
12:15:00	Arneh Eskandari	Enterprise Database Administration Deployment	The role of the DBA in Compliant Database DevOps
12:15:00	Susan Wong	Cloud Application Development Deployment	Database Migration to Cloud with Zero Downtime
13:30:00	Denny Cherry	Application Database Development	SQL Server Database Administration for the non-DBA
13:30:00	Armando Lacerda	Professional Development	DBA vNext
13:30:00	Mindy Curnutt	Application Database Development	The Ins and Outs of SQL Indexes
13:30:00	Zia Khan	Data Science, Analytics and Visualization	Hands on Data Science Tutorial
13:30:00	Maxwell Myrick	Enterprise Database Administration Deployment	SQL Server Then and Now: Changing the State of Long-held Beliefs
13:30:00	Brodie Brickey	Application Database Development	SSIS Basics
13:30:00	Benjamin Nevarez	Application Database Development	Dive into the Query Optimizer - Undocumented Insight
13:30:00	Mike Burek	Application Database Development	Use SQL Server 2017 Features in Your Older SQL Server Versions
14:45:00	Randy Knight	Enterprise Database Administration Deployment	Locks, Blocks, and Deadlocks, Oh My!
14:45:00	Kevin Feasel	Data Science, Analytics and Visualization	R For the SQL Server Developer
14:45:00	Adam Anderson	BI Platform Architecture, Development Administration	Delivering Business Value Faster
14:45:00	Jeff Mlakar	Enterprise Database Administration Deployment	Database Corruption! Preventing Disaster to your Database.
14:45:00	Brodie Brickey	BI Information Delivery	Data Driven Subscription Reports with SSRS Standard Edition
14:45:00	Steve Rezhener	BI Information Delivery	SQL Server Integration Services (SSIS) - hate to love it or love to hate it?
14:45:00	Patrick Partin	Information Delivery	What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf.
14:45:00	Benjamin Nevarez	Application Database Development	Understanding Parameter Sniffing
16:00:00	Randy Knight	Application Database Development	But it worked great in Dev! Perfomance for Devs
16:00:00	Amie Mason	Data Science, Analytics and Visualization	Azure Intelligent Services
16:00:00	Jeff Mlakar	Enterprise Database Administration Deployment	Environmental SQL Server Troubleshooting
16:00:00	Ted Stathakis	BI Platform Architecture, Development Administration	Reporting Services 2016: New Features Smart Migration Strategy
16:00:00	Peter Kral	Enterprise Database Administration Deployment	SSIS Project Deployment: The T-SQL Way
16:00:00	Eddie Maloney	Application Database Development	The Secrets of Partitioning
16:00:00	Mike Burek	Application Database Development	Basic Windowing Functions
16:00:00	Thomas Hull	Enterprise Database Administration Deployment	SQL Security, Encryption, Compliance

SessionID: 83477

How to Maintain the Same Level of Utilities in Cloud Deployments - Securability, Reliability and Sca

Back to calendar

Event Date: 22-09-2018 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Denny Cherry

Title: How to Maintain the Same Level of Utilities in Cloud Deployments - Securability, Reliability and Sca

Abstract:

In this session we will review the differences between deploying Microsoft SQL Server 2016 in Microsoft Azure and on-premises from a Security, Reliability and Scalability perspective. We'll review the common mistakes which people make when deploying SQL Server Virtual Machines to Azure which can lead to security problems including data breaches. We'll review the common performance problems which people encounter, and how to resolve them. Finally, we'll review the common scalability misunderstandings of Azure and SQL Server Virtual Machines. Join us for this fun session and learn how to improve the security, reliability and scalability of your Azure deployments of SQL Server 2016.

SessionID: 83533

Azure for SQL Server Professionals - Get your head in the Cloud

Back to calendar

Event Date: 22-09-2018 - Session time: 09:15:00 - Track: Cloud Application Development Deployment

Speaker: Armando Lacerda

Title: Azure for SQL Server Professionals - Get your head in the Cloud

Abstract:

Lift and shift is an utopia many IT professionals have about moving on-prem resources to the cloud. The truth is we must understand how the cloud works so we adjust, design accordingly and deliver to expectations. As SQL DBAs we have options. We can choose between IaaS or PaaS, between SQL in a VM or SQL DB, NoSQL options, Azure Data Warehouse some more. In this session we will dive into these options and understand some key points on the platform through some demos.

SessionID: 83550

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

Back to calendar

Event Date: 22-09-2018 - Session time: 09:15:00 - Track: Professional Development

Speaker: Mindy Curnutt

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

Abstract:

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

SessionID: 83888

Foundations of a Data Driven Organization

Back to calendar

Event Date: 22-09-2018 - Session time: 09:15:00 - Track: Strategy and Architecture

Speaker: Andrew Karcher

Title: Foundations of a Data Driven Organization

Abstract:

What is Data Driven? You might have heard someone at your organization say you need to be more data driven, but what does it mean? How does your organization need to change to be able to support being data driven?

As you might imagine it is a little bit more complicated that just saying the words or putting together a few charts. This session will talk about the fundamental things that you need to think about to move to being more data driven. It is a combination of people, process, policy and technology. This session will give you a lot to think about how to apply the principles of being data applies to your company.

SessionID: 84419

Columnstore Index Primer

Back to calendar

Event Date: 22-09-2018 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sepand Gojgini

Title: Columnstore Index Primer

Abstract:

Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each release. We will explore how data is organized differently in Columnstore and its impact on query performances. We would cover some of best practices when using this new technology and pitfalls to watch out for when designing your system.

SessionID: 84477

The Art and Science of Designing a Mission Critical SQL Server

Back to calendar

Event Date: 22-09-2018 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Maxwell Myrick

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

Abstract:

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

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

SessionID: 85198

Introduction to DAX

Back to calendar

Event Date: 22-09-2018 - Session time: 09:15:00 - Track: BI Information Delivery

Speaker: Ike Ellis

Title: Introduction to DAX

Abstract:

DAX is used everywhere now: Excel, Power BI, SSAS Tabular. If you were in a job interview and someone asked if you knew DAX, can you say "yes?" This session is here to help you learn the basics of DAX and put you well on your way to DAX mastery. We'll talk about all the popular aggregations like SUM, MAX, MIN, CALCULATE, ALL, FILTER. We'll cover the filter context. We'll show the difference between the SUM and SUMX functions. Come to this session to learn all you need to know about DAX.

SessionID: 85389

[StepbyStep] SQL server Index operation for beginner to expert.

Back to calendar

Event Date: 22-09-2018 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Simon Cho

Title: [StepbyStep] SQL server Index operation for beginner to expert.

Abstract:

Understanding Index internal operation is very important.

It is a fundamental knowledge of performance tuning and troubleshooting. However, Index internal seems very hard to understand because many materials explain it a very complicated way.

This presentation covers from basic concept of index to all of internal index structure. I will explain the index structure very simple concept. Therefore, all developer who attends this session could understand how index work with a Clustered index and a Non-clustered index together. Furthermore, this presentation will share very important tip how to troubleshooting index issue. This presentation would very help not only who does not know index but also, who know very well index internal.

SessionID: 83492

Save Time and Resources - Performance Tuning Strategies

Back to calendar

Event Date: 22-09-2018 - Session time: 10:30:00 - Track: Strategy and Architecture

Speaker: Jeff Prom

Title: Save Time and Resources - Performance Tuning Strategies

Abstract:

We all know that execution plans and indexes are important pieces to performance tuning jobs. However, they are definitely not the only tools in the toolbox. This session will take a more high-level, holistic, approach to performance tuning jobs and their components. We will talk about where to start, how to identify problem areas, and many ways to improve performance. Many of the topics covered in the presentation come from real-world situations I've encountered. One example describes how we stopped a job after 13 hours and were able to tune it down to 8 minutes. Adding additional hardware is not always an option or the answer. Do more with what you have and tune your jobs. I'll show you how.

SessionID: 83622

Introduction to Linux for SQL Server

Back to calendar

Event Date: 22-09-2018 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jay Falck

Title: Introduction to Linux for SQL Server

Abstract:

SQL Server is now available on Linux but you only know Windows, now what? During this session we'll introduce the Linux version of Windows commands you use on a daily basis for administering SQL Server. We'll look at updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. We'll also look at default file locations for SQL Server and what can be moved and how to accomplish that.

SessionID: 84103

Much Ado About Hadoop

Back to calendar

Event Date: 22-09-2018 - Session time: 10:30:00 - Track: Strategy and Architecture

Speaker: Kevin Feasel

Title: Much Ado About Hadoop

Abstract:

If you're interested in Hadoop but don't know where to begin, this session will give you an idea of what you can do with the open-source platform. We will see an overview of the Hadoop architecture, becoming familiar with the overall platform and its solutions for warehousing, ETL, streaming data ingest, in-memory processing, and more. We will compare Hadoop to SQL Server to help gain an understanding of when to deploy which technology.

SessionID: 84479

Power BI Dashboard - Creating End to End Solutions

Back to calendar

Event Date: 22-09-2018 - Session time: 10:30:00 - Track: BI Information Delivery

Speaker: Suresh Datla

Title: Power BI Dashboard - Creating End to End Solutions

Abstract:

We will be discussing the lifecycle of a Power BI Dashboard beginning from

Accessing data, Data preparation, and cleansing, consuming the data for reports and deploying the reports to Power BI services, configuring security and making the Dashboards available to end users.

SessionID: 85126

Introduction to SQL Server Reporting Services

Back to calendar

Event Date: 22-09-2018 - Session time: 10:30:00 - Track: BI Information Delivery

Speaker: Ted Stathakis

Title: Introduction to SQL Server Reporting Services

Abstract:

This session will cover the basics of developing, publishing and using SQL Server Reporting Services. You will learn all the steps needed to get started from connecting to the data source, creating data sets through putting the data on the page and publishing the report to the report server. See how easy SSRS is to use and how powerful it can be. The demo will be using SSRS 2016 but the concepts covered are applicable to any version of SQL Server.

The session will also include: A tour of a wide variety of report examples including interactive graphical dashboards that you can do in SSRS, even in older versions. A comprehensive discussion of design elements to include and avoid when creating reports. Report printing and export considerations for optimal output depending on rendering format. You will leave this session able to return to the office and present meaningful data to your end users with minimal time and effort with easy to use and powerful BI tool that you already own.

SessionID: 85209

SSIS Deployment Smackdown! Package vs. Project!

Back to calendar

Event Date: 22-09-2018 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Peter Kral

Title: SSIS Deployment Smackdown! Package vs. Project!

Abstract:

SSIS Package deployment was the first, but is it the best? Project deployment promised so much, but did it deliver? Find out which method is best for you when you see two expert practitioners go head-to-head, presenting their best-case solution for their method, and then take on the weaknesses of their opposition! Which will emerge as the supreme deployment method? BE THERE!!!

SessionID: 85331

Choosing a Career Path in Database Technologies

Back to calendar

Event Date: 22-09-2018 - Session time: 10:30:00 - Track: Professional Development

Speaker: Ben Aminnia

Title: Choosing a Career Path in Database Technologies

Abstract:

Historical review of how SQL Server has evolved over the years;

Significant additions and new features in some of the new versions; There are fundamentally two career paths in the world of SQL Server: DBA and Developer What is the future for each of these career paths and why is this an important question to ask?

SessionID: 85502

A Week in the Life of a Data Scientist

Back to calendar

Event Date: 22-09-2018 - Session time: 10:30:00 - Track: Data Science, Analytics and Visualization

Speaker: Dustin Vannoy

Title: A Week in the Life of a Data Scientist

Abstract:

Predictive modeling contains six stages of analysis according to the Cross Industry Standard Process Model for Data Mining (CRISP-DM). I will break this down into three primary tasks for predictive modelers including preparing data, building models, and explaining results.

Data preparation often requires skills in SQL, python, or other languages to be able to pull data out of data stores and convert the normalized data into flattened data that the algorithms can use to build models

Modeling requires a qualitative (if not quantitative) understanding of the algorithms, including mathematics or statistics, in order to build effectively.

Finally, modelers should know how to explain the results of their findings to other analysts and to decision-makers and stakeholders.

The session will walk through the building of a predictive model for a retail application: predicting the days to next purchase propensity model.

SessionID: 85419

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 22-09-2018 - Session time: 12:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Diane Schuster

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 85805

The role of the DBA in Compliant Database DevOps

Back to calendar

Event Date: 22-09-2018 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Arneh Eskandari

Title: The role of the DBA in Compliant Database DevOps

Abstract:

Organizations are under increasing pressure to deliver high quality software and services fast. But for Operations teams, the ability to support frequent change can be constrained by the complexities of database environments, and a need to protect the stability of the live environment and the security of the data it contains.

In this session, we’ll demonstrate the tools you can use to protect sensitive data as it moves through environments, while helping your organization embrace a DevOps approach to software delivery.

You will learn how to:

Provision realistic isolated environments quickly and without the storage concerns Anonymize or replace sensitive data for reliable and compliant development Measure the performance impact of changes as they’re introduced Gain an understanding of the state of databases that are being deployed against

SessionID: 85956

Database Migration to Cloud with Zero Downtime

Back to calendar

Event Date: 22-09-2018 - Session time: 12:15:00 - Track: Cloud Application Development Deployment

Speaker: Susan Wong

Title: Database Migration to Cloud with Zero Downtime

Abstract:

Cloud adoption for enterprise databases is in full swing. Whether it is production databases supporting mission critical applications or for High availability or Disaster recovery, the Cloud is on nearly every enterprise roadmap. Organizations are presented with options when it comes to cloud platform vendors like Azure, AWS, Google, etc., but have business dependencies on high performance, tight security and near zero downtimes during and after migration. If you are planning on migrating your on-premises production database to the cloud, keeping test or development environments refreshed and in sync this session is for you.

Learn about:

• Key trends driving cloud adoption
• Top considerations for a DBA before moving databases to cloud
• Architecture that supports on-prem/cloud/hybrid databases for HA or DR using Quest Software's SharePlex replication

SessionID: 83473

SQL Server Database Administration for the non-DBA

Back to calendar

Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Denny Cherry

Title: SQL Server Database Administration for the non-DBA

Abstract:

Are you a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it? I've got some of the answers here in this session for you. During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.

SessionID: 83534

DBA vNext

Back to calendar

Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Professional Development

Speaker: Armando Lacerda

Title: DBA vNext

Abstract:

Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.

Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.

In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.

SessionID: 83549

The Ins and Outs of SQL Indexes

Back to calendar

Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Mindy Curnutt

Title: The Ins and Outs of SQL Indexes

Abstract:

This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.

SessionID: 84056

Hands on Data Science Tutorial

Back to calendar

Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Data Science, Analytics and Visualization

Speaker: Zia Khan

Title: Hands on Data Science Tutorial

Abstract:

Our tutorial is for anyone new to data science or is interested in taking the first steps. We start by highlighting how data science and artificial intelligence can help achieve business goals. We go into reviewing the data science process and steps involved. This is followed by a live hands-on workshop where we build a simple linear regression model to make predictions and then we evaluate the results.

SessionID: 84476

SQL Server Then and Now: Changing the State of Long-held Beliefs

Back to calendar

Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Maxwell Myrick

Title: SQL Server Then and Now: Changing the State of Long-held Beliefs

Abstract:

We’ve all heard the rules for SQL Server like separate your data from your log, watch for a disk queue length over 2, and a low Page Life Expectancy always means memory pressure. All of these used to be true, but on today’s hardware and SQL Server versions – they are dangerously outdated. In this session, we will take on a bunch of these old “givens” of SQL Server that everybody has heard and followed, the underlying technological reasons they were true then, how today’s technology has rendered them obsolete, and what the new rules are that you need to know. So whether you are one of the old guard looking to refresh your set of working SQL Server rules or a member of the up-and-comers looking for the facts to win over the old guard, this session is for you.

SessionID: 85199

SSIS Basics

Back to calendar

Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Brodie Brickey

Title: SSIS Basics

Abstract:

Integration Services (SSIS) can be a very powerful tool for data loading as well as many other functions. In this demo we'll cover some methods for getting started with this program.

SessionID: 85620

Dive into the Query Optimizer - Undocumented Insight

Back to calendar

Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Benjamin Nevarez

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract:

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

SessionID: 85722

Use SQL Server 2017 Features in Your Older SQL Server Versions

Back to calendar

Event Date: 22-09-2018 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Mike Burek

Title: Use SQL Server 2017 Features in Your Older SQL Server Versions

Abstract:

Have you read about the amazing new SQL Server 2017 features, but your work is still stuck using SQL Server 2012 or older? Maybe even 2005? Would using Python or R to make it easier to manipulate and analyze your data ?

Would temporal tables be an easy solution? Maybe In-Memory Tables or Columnstore Indexes would give you a performance boost?

By thinking outside of the box and applying a little process massaging, we can actually do all this inside of the free SQL Server Express edition. The limits and features of this edition have been greatly increased, you just need to consider it. Because Express is still SQL Server, it easily connects to your existing SQL Server Standard and Enterprise versions that are doing the main workload. We're just partitioning off part of the workflow.

Come see examples of incorporating all these features into your workload to increase performance, and to stop limiting your knowledge to yesterday's tech.

SessionID: 83816

Locks, Blocks, and Deadlocks, Oh My!

Back to calendar

Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Randy Knight

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

Abstract:

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

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

SessionID: 84104

R For the SQL Server Developer

Back to calendar

Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Data Science, Analytics and Visualization

Speaker: Kevin Feasel

Title: R For the SQL Server Developer

Abstract:

R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

SessionID: 84501

Delivering Business Value Faster

Back to calendar

Event Date: 22-09-2018 - Session time: 14:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Adam Anderson

Title: Delivering Business Value Faster

Abstract:

Every team’s goal is to deliver business value faster, the question is how do you do that? If you’re a small shop with 1 or 2 developers then writing script in test and then running them production may be okay, but for a larger team that leads to problems. Using continuous integration (CI) and deployment techniques you can make small incremental changes which then set off a chain of automation steps that validates the new code. After automated validation, the code changes are ready for any additional User Acceptance Testing (UAT) and staging environments. During this session, you will learn how to manage database schema changes in a dynamic environment and deliver code to production by utilizing continuous integration and certain development techniques in minutes with minimal risk.

SessionID: 84680

Database Corruption! Preventing Disaster to your Database.

Back to calendar

Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Mlakar

Title: Database Corruption! Preventing Disaster to your Database.

Abstract:

Every DBA should know about database corruption because it can be a resume generating event. A corrupt database can ruin your day, affect system stability, lead to unnecessary downtime, and possibly data loss.

In this presentation we will explore database corruption, learn how to diagnose, and see what we can do to fix it. We will discuss the causes, dispel some myths, and learn what questions to ask. After this, we dive into discovering the root cause and putting a plan in place to stop it in the future. Demos will illustrate diagnosing, troubleshooting, and fixing database corruption. Prepare to break a database and go through the steps to return it back to a usable state.

Beginners will benefit along with others who may one day find themselves with a corrupt database. By the end of the session, you will have the tools and understanding necessary to take corrective action and prevent your databases from corruption!

SessionID: 85200

Data Driven Subscription Reports with SSRS Standard Edition

Back to calendar

Event Date: 22-09-2018 - Session time: 14:45:00 - Track: BI Information Delivery

Speaker: Brodie Brickey

Title: Data Driven Subscription Reports with SSRS Standard Edition

Abstract:

Why not create a report that only sends information if there is data? Oh, don't have the Enterprise Edition? I'll show you how with SQL Server Standard Edition. This demo will walk you through the steps to create these data driven subscriptions. We'll be using Reporting Services, Integration Services and SQL Agent Jobs to setup and schedule data driven subscriptions. SQL Server 2008 and up.

SessionID: 85248

SQL Server Integration Services (SSIS) - hate to love it or love to hate it?

Back to calendar

Event Date: 22-09-2018 - Session time: 14:45:00 - Track: BI Information Delivery

Speaker: Steve Rezhener

Title: SQL Server Integration Services (SSIS) - hate to love it or love to hate it?

Abstract:

We will have an introduction to ETL, ETL software landscape and Microsoft SQL Server Integration Services a.k.a. SSIS in greater details. We will also discuss what's new in SSIS 2016/2017. For the hands-on section, we will create a simple SSIS package and test-drive some selected features, like Balance Data Distributor, Control parts, and Expression Task.

SessionID: 85608

What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf.

Back to calendar

Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Information Delivery

Speaker: Patrick Partin

Title: What just happened? Creating your own real-time dashboard with Grafana, Influx, and Telegraf.

Abstract:

Like many of you, I've been fortunate enough to work in places where the budgets were non-existent, the systems were always crashing, and what tools we did have, were good for some, not all. For those fighting fires and wearing multiple hats, you're used to, but still scared of "hey, what just happened?"

In this session, I'll show you how to install, configure, and build your own dashboard with Grafana, and utilize InfluxDB and Telegraf, which I believe will help you fight your fires better than before. Going past just monitoring your SQL Server, we'll also use some Powershell and SQL Server Agent Jobs to track our custom business KPIs, and configure some alerting to send us Slack notifications.

SessionID: 85622

Understanding Parameter Sniffing

Back to calendar

Event Date: 22-09-2018 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Benjamin Nevarez

Title: Understanding Parameter Sniffing

Abstract:

Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.

SessionID: 83815

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Randy Knight

Title: But it worked great in Dev! Perfomance for Devs

Abstract:

If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.

SessionID: 84481

Azure Intelligent Services

Back to calendar

Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Data Science, Analytics and Visualization

Speaker: Amie Mason

Title: Azure Intelligent Services

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.

SessionID: 84679

Environmental SQL Server Troubleshooting

Back to calendar

Event Date: 22-09-2018 - Session time: 16:00: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: 85127

Reporting Services 2016: New Features Smart Migration Strategy

Back to calendar

Event Date: 22-09-2018 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ted Stathakis

Title: Reporting Services 2016: New Features Smart Migration Strategy

Abstract:

With the release of SQL Server 2016, Reporting Services finally got some love! In this session, you will get an overview of some of the new features and functionality: A look at the new Report Manager interface, Mobile reports, KPIs and the new control we have over the placement of parameters. We will also look at the new Mobile Report Publisher app and see how easy it is to create mobile reports. The session will cover tips for a smart migration to 2016.

The session will then dive into how to use the data in the ReportServer database tables to see which reports in your environment are being used and how well they are performing. With this understanding you can determine which reports, data sets and data sources to migrate to a new 2016 installation. Come see how to leverage PowerShell to extract the reports from the database, instead of having to download them from Report Manager, to facilitate an easy migration to a new SQL Server 2016 Reporting Services implementation.

SessionID: 85208

SSIS Project Deployment: The T-SQL Way

Back to calendar

Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Kral

Title: SSIS Project Deployment: The T-SQL Way

Abstract:

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

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

SessionID: 85585

The Secrets of Partitioning

Back to calendar

Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Eddie Maloney

Title: The Secrets of Partitioning

Abstract:

The magic of Partitioning will be revealed. The session will cover the basics of partitioning a table including all the decisions you'll need to make when you’re creating your first. Additionally, I'll demonstrate how to add, alter and remove partitions. Plus explore other features that are available. Demos will include using both the SSMS GUI and/or T-SQL Scripts as we build a table partition and handle all the expected maintenance and normal operations you may encounter.

SessionID: 85719

Basic Windowing Functions

Back to calendar

Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Mike Burek

Title: Basic Windowing Functions

Abstract:

Windowing functions are when you add a "window" to which rows a function will look at using the OVER clause. We'll start by learning how to add the OVER clause to the commonplace COUNT, SUM, AVG, MIN, and MAX aggregate functions, since the OVER clause is optional. From there, we'll learn some ranking functions, which do require the OVER clause. You'll see examples that use the ROW_NUMBER function to identify and delete duplicate rows. Finally, we'll close with the RANK and DENSE_RANK functions that help you report on the grouping of your data.

SessionID: 85725

SQL Security, Encryption, Compliance

Back to calendar

Event Date: 22-09-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Hull

Title: SQL Security, Encryption, Compliance

Abstract:

In today's regulatory environment, expertise in security and compliance are table stakes in the DBA job market. Industries that manage customer data (finance, health care, etc.) have strict protocols required by law and enforced by audits, which are kind of like a month-long root canal but not as fun.

In this presentation we'll cover regulatory standards, security basics and best practices, and the various encryption options available in SQL Server (Backups, TDE, Column, AlwaysEncrypted). We'll also cover monitoring/logging, go over some new features, and some bonus material on dealing with audits.
I look forward to seeing you there!

This site is open source. Improve this page.