sqlsathistory

Nr: 610

Back to Main list

SQLSaturday #610 - Richmond 2017

Start Time (24h) Speaker Track Title
08:30:00 Angela Henry Business Intelligence What is Power BI?
08:30:00 Andrew Kelly Database Administration, Deployment Monitoring The Art of War with Bad Code
08:30:00 Jana Sattainathan Application Database Development Practical PowerShell for the SQL Developers and DBA's - 0 to 60 in 60 mins
08:30:00 Ravi Kumar Business Intelligence What Makes SSIS Tick? A Look at Internals for Performance
09:40:00 Slava Murygin Database Administration, Deployment Monitoring SQL Server on Linux for SQL DBA.
09:40:00 Paul Rizza Business Intelligence New Features in SSIS 2016
09:40:00 Mark Hudson Business Intelligence Introducing Azure Machine Learning
09:40:00 Jamie Wick Database Administration, Deployment Monitoring Automated SQL Server installation and configuration using PowerShell
09:40:00 Rick Lowe Database Administration, Deployment Monitoring Why should I care about ... the plan cache?
10:50:00 Andrew Kelly Database Administration, Deployment Monitoring Query Store – What is it all about?
10:50:00 Jessica Moss Business Intelligence Introduction to SQL Server Integration Services 2016
10:50:00 Andy Leonard Business Intelligence Use Biml to Automate SSIS Design Patterns
10:50:00 Tracy Boggiano Database Administration, Deployment Monitoring Monitoring Availability Groups
10:50:00 Jason Brimhall Database Administration, Deployment Monitoring Extended Events - Better than Profiler
12:40:00 SQLSAT RVA Professional Development CIO Tech Panel
13:50:00 Judith Moffitt Application Database Development T-SQL Errors and Problems and Data Meaning
13:50:00 Shannon Lowder Business Intelligence Interrogating your data sources with Biml
13:50:00 Patrick Keisler Database Administration, Deployment Monitoring SQL Audit - Evidence Never Lies
13:50:00 Azhagappan Arunachalam Application Database Development SQL Server - R Services
13:50:00 Chris Bell Internals Performance Statistics Cardinality – How They Work to Find Data Efficiently
15:00:00 Anders Pedersen Database Administration, Deployment Monitoring I/O Tuning 101
15:00:00 Kevin Feasel Database Administration, Deployment Monitoring Securing SQL Server
15:00:00 Paul Rizza Database Administration, Deployment Monitoring SQL Server 2016 AlwaysOn Availability Groups - Enhancements and New Features
15:00:00 Brian Carrig Azure / Cloud / Big Data Running SQL Server in AWS
15:00:00 Doug Purnell Database Administration, Deployment Monitoring Moving from Change Tracking/Change Data Capture to Temporal Tables

SessionID: 57575

What is Power BI?

Back to calendar

Event Date: 18-03-2017 - Session time: 08:30:00 - Track: Business Intelligence

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

The Art of War with Bad Code

Back to calendar

Event Date: 18-03-2017 - Session time: 08:30:00 - Track: Database Administration, Deployment Monitoring

Speaker: Andrew Kelly

Title: The Art of War with Bad Code

Abstract:

Let’s face it, many of us are at war with poorly written or poorly tuned queries and processes. There is usually just one of you who has been tasked with managing one or more SQL Server instances while there are hundreds or even thousands of users of which a certain percentage will inevitably write poor code. So you must battle it out to identify the culprits before they wreak too much havoc on your systems. We will see several fairly straightforward techniques to positively identify the culprits and allow you to prioritize your efforts in tuning them to give you the biggest ROI for your time. TSQL and Extended Events code examples will be provided that you can use immediately in your environment to become more productive.

SessionID: 59601

Practical PowerShell for the SQL Developers and DBA's - 0 to 60 in 60 mins

Back to calendar

Event Date: 18-03-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Jana Sattainathan

Title: Practical PowerShell for the SQL Developers and DBA's - 0 to 60 in 60 mins

Abstract:

PowerShell is always something you heard about and wanted to use but never did! Starting with the resources available for a PowerShell newbie, we will advance to what pro's use to automate their database activities and beyond, for both DBA's and developers. The goal of this session is to get you immersed in PowerShell. Ask questions and learn how PowerShell can enable you and more importantly do your job for you (the way, future is heading). We will also look at free libraries and tools to help you advance your automation abilities. Common automation scenarios is the theme! Anything done with with clicks can be automated.

SessionID: 59841

What Makes SSIS Tick? A Look at Internals for Performance

Back to calendar

Event Date: 18-03-2017 - Session time: 08:30:00 - Track: Business Intelligence

Speaker: Ravi Kumar

Title: What Makes SSIS Tick? A Look at Internals for Performance

Abstract:

You can build basic SSIS packages, or you can build packages that perform. In this session, you'll learn about the internals of Integration Services. Using this knowledge, we'll review the DOs and DON'Ts that lead to improved ETL performance. (This session applies to SSIS versions from 2008, 2012, 2014 and 2016.)

SessionID: 57470

SQL Server on Linux for SQL DBA.

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Database Administration, Deployment Monitoring

Speaker: Slava Murygin

Title: SQL Server on Linux for SQL DBA.

Abstract:

For the last 25 years SQL Server DBAs have administered SQL databases using only Windows GUI.

For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it's flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.

SessionID: 57767

New Features in SSIS 2016

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Business Intelligence

Speaker: Paul Rizza

Title: New Features in SSIS 2016

Abstract:

This session will present detailed examples of the newest features added or enhanced in SSIS 2016.

Including but not limited to: True template based package design Incremental package deployment Non-Admin logging access Error Handling by Column name (prior versions only gave that cryptic lineage ID number) SSISDB AlwaysOn Availability Group support and many more...

The session will include a limited number of slides followed but demo examples of each new feature which will also be provided for download so attendees while have access to them for reference after the event.

SessionID: 59542

Introducing Azure Machine Learning

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Business Intelligence

Speaker: Mark Hudson

Title: Introducing Azure Machine Learning

Abstract:

Not satisfied with Multidimensional Analysis Services’ data mining or maybe you are using Tabular Analysis Services? Looking for a flexible and robust predictive analytics tool? Consider Azure Machine Learning … a cloud service for advanced analytics. In this session, I quickly describe concepts and terms before jumping straight into a start-to-finish AML experiment. Join me to see how AML might meet your advanced data analysis needs.

SessionID: 59756

Automated SQL Server installation and configuration using PowerShell

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Database Administration, Deployment Monitoring

Speaker: Jamie Wick

Title: Automated SQL Server installation and configuration using PowerShell

Abstract:

Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.

SessionID: 59875

Why should I care about ... the plan cache?

Back to calendar

Event Date: 18-03-2017 - Session time: 09:40:00 - Track: Database Administration, Deployment Monitoring

Speaker: Rick Lowe

Title: Why should I care about ... the plan cache?

Abstract:

SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this installment of Rick's "Why should I care" series, he lays out a case for why working knowledge of the plan cache is critical for performance tuning efforts in real world environments. A review of relevant views and functions is included for the (newly?) motivated audience.

Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBAs drink in the morning (allegedly). This is not a deep dive into the cache, it really is primarily a session exploring why these DMOs are worth slogging through.

SessionID: 57590

Query Store – What is it all about?

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Database Administration, Deployment Monitoring

Speaker: Andrew Kelly

Title: Query Store – What is it all about?

Abstract:

SQL 2016 brings us many new features but one of the most anticipated is surely the Query Store. The Query Store now allows us to track query plans as they change over time giving us a whole slew of new possibilities when it comes to tuning our queries. Even just the ability to compare a previous plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. This session will give you the insight to get started using this new and wonderful feature set.

SessionID: 57854

Introduction to SQL Server Integration Services 2016

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Business Intelligence

Speaker: Jessica Moss

Title: Introduction to SQL Server Integration Services 2016

Abstract:

SQL Server Integration Services (SSIS) provides database administrators, business intelligence developers, and application programmers the ability to quickly and easily move and transform data. Whether your data in on-premises or in the cloud, within SQL Server or stored in text files, clean or dirty, SSIS can help you extract, transform, and load (ETL) the information. Join this session to learn more about SSIS, specifically how to develop, deploy, and maintain SSIS packages.

SessionID: 57994

Use Biml to Automate SSIS Design Patterns

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Business Intelligence

Speaker: Andy Leonard

Title: Use Biml to Automate SSIS Design Patterns

Abstract:

Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.

In this session, you will learn:

SessionID: 59794

Monitoring Availability Groups

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Database Administration, Deployment Monitoring

Speaker: Tracy Boggiano

Title: Monitoring Availability Groups

Abstract:

So you have successfully configured Availability Groups, now what? In this session we will look beyond setup and look at how to monitor your Availability Groups. We will discuss what metrics to look at, what they mean, and what you need to alert on. You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts. This session is for anyone that uses, or plans to use Availability Groups. You should come in with a basic understanding of Availability Groups to get the most out of this session.

SessionID: 59806

Extended Events - Better than Profiler

Back to calendar

Event Date: 18-03-2017 - Session time: 10:50:00 - Track: Database Administration, Deployment Monitoring

Speaker: Jason Brimhall

Title: Extended Events - Better than Profiler

Abstract:

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

SessionID: 63292

CIO Tech Panel

Back to calendar

Event Date: 18-03-2017 - Session time: 12:40:00 - Track: Professional Development

Speaker: SQLSAT RVA

Title: CIO Tech Panel

Abstract:

Here is the abstract If there was one question you could ask your CIO, what would it be? In this session you'll have the opportunity to hear a panel of three CIOs and CTOs discuss the State of IT in Virginia while covering topics such as technology strategy, leveraging cloud technologies, Big Data and more. This panel discussion will be moderated by Solvaria's CEO, Greg Samuels, and panelists will include Alex Tulchinsky, CTO of UNOS, Alan Hagerman, VP of Technology at KBH Business Management Systems and Jeffrey Potter, CTO of Davenport Investments. This interactive session is geared at all levels of experience, so we hope you'll come with questions.

SessionID: 57509

T-SQL Errors and Problems and Data Meaning

Back to calendar

Event Date: 18-03-2017 - Session time: 13:50:00 - Track: Application Database Development

Speaker: Judith Moffitt

Title: T-SQL Errors and Problems and Data Meaning

Abstract:

You see it all the time, someone asks a question about how to fix an error like "Subquery returns more than one value" and an immediate answer is given that fixes the syntax. But is that the right fix or are there other things you need to consider when fixing syntax errors in SQL?

I am going to show why it is also important to consider the meaning of the results when fixing issues with a query and why syntax is never enough when querying a database. Along the way I will show you some common errors and problems and the multiple ways they can be fixed and how to evaluate what the correct fix would be.

SessionID: 59359

Interrogating your data sources with Biml

Back to calendar

Event Date: 18-03-2017 - Session time: 13:50:00 - Track: Business Intelligence

Speaker: Shannon Lowder

Title: Interrogating your data sources with Biml

Abstract:

You've decided to start using Biml to make your integration services packages. Congratulations!

Now, you're looking at data sources other than SQL Server. How do you automate package development for these flat files, Excel Files, and other databases? In this session, I'll share some of the techniques I've used to deal with these second-class sources. I'll be walking you through C# code. Don't worry, I'm not a real programmer, so the code isn't the most complex, but it does solve the need.

SessionID: 59614

SQL Audit - Evidence Never Lies

Back to calendar

Event Date: 18-03-2017 - Session time: 13:50:00 - Track: Database Administration, Deployment Monitoring

Speaker: Patrick Keisler

Title: SQL Audit - Evidence Never Lies

Abstract:

We've all heard about massive data breaches from big name companies. As a DBA, you should consider your company's data to be the most valuable assets. So when a data breach happens at your company, will you be able to provide management with the information? If not, then discover how SQL Server Audit can help provide you with an accurate forensic analysis of who did what to your data. In this session, we'll cover what SQL Audit can capture, how to set it up for both on-premise SQL Servers and Azure SQL Database, and finally produce reports from it.

SessionID: 59860

SQL Server - R Services

Back to calendar

Event Date: 18-03-2017 - Session time: 13:50:00 - Track: Application Database Development

Speaker: Azhagappan Arunachalam

Title: SQL Server - R Services

Abstract:

SQL Server R Services: Microsoft acquired Revolution Analytics in early 2015, and introduced R services (in-database/stand-alone) with SQL Server 2016 last year. With the first Microsoft Data Science summit behind us this past Sept, in Atlanta, let us review what R Services in SQL Server brings to the table and see how it complements/supercedes features that are available with other R offerings (R GUI, Microsoft R Client [R Studio], Microsoft R Open [RROpen], Microsoft R Server[RREnterprise] etc.,)

SessionID: 59864

Statistics Cardinality – How They Work to Find Data Efficiently

Back to calendar

Event Date: 18-03-2017 - Session time: 13:50:00 - Track: Internals Performance

Speaker: Chris Bell

Title: Statistics Cardinality – How They Work to Find Data Efficiently

Abstract:

Are your statistics up to date?

Yes, it’s that dreaded phrase you hear all the time when it comes to performance tuning your SQL Server. What does it matter? Why should I care about statistics? Aren’t they automatic or something like that? In this session we will go over why statistics matter, how they are generated, how they impact performance, and even how to maintain them. Once we have that all settled, we will take a quick look at how the cardinality estimator uses statistics to determine a ‘good enough’ plan to use. We will close out the session by taking a look at the performance impact from a simple upgrade of your SQL Server to 2014 and using the new cardinality estimator.

SessionID: 57500

I/O Tuning 101

Back to calendar

Event Date: 18-03-2017 - Session time: 15:00:00 - Track: Database Administration, Deployment Monitoring

Speaker: Anders Pedersen

Title: I/O Tuning 101

Abstract:

One of the most common problems I have encountered as a DBA is the complaints from users that a particular query is slow, just one query. Many times one that used to run in acceptable time, but that over time has slowed down substantially.

In this session we will show some of the causes for this, with emphasis on I/O requests being too high for the query.

First part of the session will explain how to find these numbers, looking at a few queries with some major performance issues, including explaining why they have a problem.

The second part will focus on how to reduce I/O requests.

All of this can be done without the need for any 3rd party tools, all within the scope of what is available to SQL Server, all versions, all editions, including Azure.

SessionID: 57527

Securing SQL Server

Back to calendar

Event Date: 18-03-2017 - Session time: 15:00:00 - Track: Database Administration, Deployment Monitoring

Speaker: Kevin Feasel

Title: Securing SQL Server

Abstract:

A default SQL Server installation is reasonably secure, but quot;reasonably securequot; doesn#39;t cut it in an era in which one bad line of code, one weak password, or one open port can result in your customer database ending up on Pastebin. In this talk, we will look at different methods of securing a SQL Server instance, from venerable (principle of least privilege, Transparent Data Encryption) to novel (Always Encrypted, row-level security). These tools and techniques will show us ways for developers, database administrators, and network specialists to work together to secure SQL Server instances.

SessionID: 57766

SQL Server 2016 AlwaysOn Availability Groups - Enhancements and New Features

Back to calendar

Event Date: 18-03-2017 - Session time: 15:00:00 - Track: Database Administration, Deployment Monitoring

Speaker: Paul Rizza

Title: SQL Server 2016 AlwaysOn Availability Groups - Enhancements and New Features

Abstract:

Using SQL 2016 AlwaysOn Availability Groups is a powerful feature which can provide HA support.

The session will begin with a basic overview of the creation of an Availability Group (assuming the SQL Instances are already installed for time) then I will go into detailed demos of the following features: Availability Group Readable Secondary Replicas Risks of readable secondary replicas when using a replica that is part of the Automatic Failover pair Shared Log Chain Database Impact Read Only Routing Load Balancing with Read Only Routing (Round Robin) What the hell is "Read-Intent Only" and why it is MUCH safer than "YES" Databases with Encryption (why you no longer need a job to set the password every time the SSISDB fails over) Multiple Availability Groups on a Single Cluster What are Basic Availability Groups (are they still better than Clustered Instances?) Automatic Page Repair and many others Demos available for download after the session.

SessionID: 59560

Running SQL Server in AWS

Back to calendar

Event Date: 18-03-2017 - Session time: 15:00:00 - Track: Azure / Cloud / Big Data

Speaker: Brian Carrig

Title: Running SQL Server in AWS

Abstract:

Amazon Web Services (AWS) is the world's largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.

SessionID: 59571

Moving from Change Tracking/Change Data Capture to Temporal Tables

Back to calendar

Event Date: 18-03-2017 - Session time: 15:00:00 - Track: Database Administration, Deployment Monitoring

Speaker: Doug Purnell

Title: Moving from Change Tracking/Change Data Capture to Temporal Tables

Abstract:

With the release of SQL Server 2016, Temporal tables are a new way to track changes within your tables. This session will walk you through moving from Change Tracking/Change Data Capture to Temporal tables and what advantages Temporal Tables has for your database and application.

This site is open source. Improve this page.