sqlsathistory

Nr: 619

Back to Main list

SQLSaturday #619 - Rochester 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Justin Dearing	Application Database Development	Version control with GIT for the DBA Precon
08:30:00	Kevin Feasel	Strategy and Architecture	Big Data, Small Data, and Everything In Between
08:30:00	Grant Fritchey	Enterprise Database Administration Deployment	Azure SQL Database for the DBA
08:30:00	Jonathan Stewart	BI Information Delivery	From problem to Power BI: A journey in data visualization
08:30:00	Chris Sommer	Enterprise Database Administration Deployment	Painting with PowerShell: SQL Server Administration
09:45:00	James Serra	Enterprise Database Administration Deployment	Big data architectures and the data lake
09:45:00	Taiob Ali	Enterprise Database Administration Deployment	How to migrate a SQL database to Microsoft Azure SQL V12
09:45:00	Justin Dearing	Application Database Development	Version control with GIT for the DBA
09:45:00	Amy Herold	Enterprise Database Administration Deployment	Making the Leap from Developer to DBA
11:00:00	Kevin Feasel	Analytics and Visualization	R For the SQL Server Developer
11:00:00	Andrew Loree	Enterprise Database Administration Deployment	Stretch Database and Managed Backups: Cloud Services for your SQL Servers
11:00:00	Jonathan Stewart	BI Platform Architecture, Development Administration	An introduction to the magical world of BIML!
11:00:00	Paul Popovich Jr	Enterprise Database Administration Deployment	Distributed Replay, using it to plan for the future.
11:00:00	Thomas Grohser	Application Database Development	# vs @ - it's not about Social Media it's about temporary tables and data
12:15:00	Allen White	Other	Tuning Query Performance with SentryOne Plan Explorer
13:30:00	Edward Pollack	Application Database Development	Finding Islands, Gaps, and Clusters in Complex Data
13:30:00	Derik Hammer	Enterprise Database Administration Deployment	Architecting Availability Groups
13:30:00	Chris Hyde	Analytics and Visualization	SQL Server R Services in SQL 2016
13:30:00	Andrew Loree	Enterprise Database Administration Deployment	SQL Server vNext (Linux and Beyond)
13:30:00	Amy Herold	Professional Development	WIT: Start 'em Young - Growing Women in IT
14:45:00	Edward Pollack	Enterprise Database Administration Deployment	Building Effective Backups
14:45:00	Grant Fritchey	Application Database Development	The Query Store and Query Tuning in SQL Server
14:45:00	James Serra	Professional Development	Learning to present and becoming good at it
14:45:00	Thomas Grohser	Application Database Development	Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools
14:45:00	Allen White	Application Database Development	Scalable Application Design with Service Broker
16:00:00	Derik Hammer	Application Database Development	Query Tuning without Production Data
16:00:00	Taiob Ali	Enterprise Database Administration Deployment	Think like the Cardinality Estimator
16:00:00	Allen White	Enterprise Database Administration Deployment	Emergency! Are You Ready for Disaster to Strike?

SessionID: 62498

Version control with GIT for the DBA Precon

Back to calendar

Event Date: 29-04-2017 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Justin Dearing

Title: Version control with GIT for the DBA Precon

Abstract:

This is a half day pre-con for DBAs, database developers, and application developers that want to get started with storing their database schema in git.

We will cover using git from the command line and with Visual Studio. We will be using github as our central repository, but we will discus other cloud and on premisis options for the primary repository.

Our example application will be an ASP.NET MVC application and SQL Database whose schema will be managed by SSDT. Participants will be expected to have a laptop with either the community edition or professional edition of Visual Studio 2013, the latest CTP of SQL Server 2016, git for windows and Tortoise git. A github URL for the example application will be provided in advance. Attendees will be expected to have cloned the repo, compiled the application, and having it run locally.

SessionID: 57900

Big Data, Small Data, and Everything In Between

Back to calendar

Event Date: 29-04-2017 - Session time: 08:30:00 - Track: Strategy and Architecture

Speaker: Kevin Feasel

Title: Big Data, Small Data, and Everything In Between

Abstract:

The breadth of options available to data professionals today is staggering: between relational, object, graph, and document databases, we have a wide array of storage options, as well as a huge number of access and analysis tools. This talk will walk you through data platform, data analysis, and data processing options. We’ll discuss when to use (and when not to use) Spark, R, Storm, and SSAS, as well as a range of other tools and technologies. By the end of this talk, you may not have MongoDB or Neo4J, but you will know where they might fit.

SessionID: 59392

Azure SQL Database for the DBA

Back to calendar

Event Date: 29-04-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Grant Fritchey

Title: Azure SQL Database for the DBA

Abstract:

Everyone knows that Azure SQL Database only supports a small subset of SQL Server functionality, small databases, and has really bad performance. Except, everyone is wrong. In fact, Azure SQL Server Database is ready to support many, if not most, databases within your enterprise. This session reintroduces Azure SQL Database and shows the high degree of functionality and improved performance that is now available. We'll cover topics from monitoring, to high availability to disaster recovery, all within Azure SQL Database. You’ll leave this session with a more thorough understanding of the strengths and weaknesses of Azure SQL Database so that you can make a more informed choice over when, or if, you should use it within your environment.

SessionID: 61558

From problem to Power BI: A journey in data visualization

Back to calendar

Event Date: 29-04-2017 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Jonathan Stewart

Title: From problem to Power BI: A journey in data visualization

Abstract:

Power BI is all the rage right now in visualizing data on the Microsoft BI stack. We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization. Make your visualization count. Come join us on the journey.

SessionID: 61639

Painting with PowerShell: SQL Server Administration

Back to calendar

Event Date: 29-04-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Chris Sommer

Title: Painting with PowerShell: SQL Server Administration

Abstract:

The SQL Server canvas gives us limitless opportunity for scripting and automation, and PowerShell is the perfect brush to paint with. Configuring our database servers, deploying database code changes, performing backups and restores are just a few examples of a day in the life of a DBA. Automation and scripting bring consistency, simplicity and scalability to many of these sometimes daunting tasks.

Join me to learn how to paint your own SQL Server canvas with PowerShell.

SessionID: 57885

Big data architectures and the data lake

Back to calendar

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

Speaker: James Serra

Title: Big data architectures and the data lake

Abstract:

With so many new technologies it can get confusing on the best approach to building a big data architecture. The data lake is a great new concept, usually built in Hadoop, but what exactly is it and how does it fit in? In this presentation I’ll discuss the four most common patterns in big data production implementations, the top-down vs bottoms-up approach to analytics, and how you can use a data lake and a RDBMS data warehouse together. We will go into detail on the characteristics of a data lake and its benefits, and how you still need to perform the same data governance tasks in a data lake as you do in a data warehouse. Come to this presentation to make sure your data lake does not turn into a data swamp!

SessionID: 61389

How to migrate a SQL database to Microsoft Azure SQL V12

Back to calendar

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

Speaker: Taiob Ali

Title: How to migrate a SQL database to Microsoft Azure SQL V12

Abstract:

There are many tools available to successfully migrate your on-premises relational database to Microsoft Azure SQL V12 database. Do you know what tools are available for migration? How do you choose the best tool for you? How do you analyze what objects are not compatible for migrating to Azure? It depends on the type, size and complexity of the database being migrated. In this demo based session I will show you 4 different tools, that you can use to analyze/migrate your on-premises SQL Database to Microsoft Azure SQL V12. We will migrate a single database using 4 different tools so you know what options are available for you. I will also talk about where you can download and how you can set up these tools. Briefly talk about pros and cons of each tool. At the end of this session you will be aware of the various techniques available to analyze and migrate SQL Database to Azure V12 and chose the best fitting one for your database.

SessionID: 62495

Version control with GIT for the DBA

Back to calendar

Event Date: 29-04-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Justin Dearing

Title: Version control with GIT for the DBA

Abstract:

In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform agnostic and ubiquitous as the internet. In that same note, github, the most popular service for hosting git repositories has become so ubiquitous that Microsoft chose to host the source code for its OSS fork of the .NET framework there instead of its own codeplex.

What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.

In my session. We'll cover:

What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?

We will be covering using git from both the command line and Visual Studio.

SessionID: 63836

Making the Leap from Developer to DBA

Back to calendar

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

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 57902

R For the SQL Server Developer

Back to calendar

Event Date: 29-04-2017 - Session time: 11:00:00 - Track: 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: 61276

Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Back to calendar

Event Date: 29-04-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Loree

Title: Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Abstract:

Utilizing Azure cloud services does not mean moving all of your data or control away from your on-premises SQL Servers. In this session we will cover the new SQL 2016 Stretch Database and the SQL 2014 Managed Backups to Azure features. We will look at use-cases and limitations of both features to illustrate how these cloud services may fit into your current SQL Server environment.

SessionID: 61556

An introduction to the magical world of BIML!

Back to calendar

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

Speaker: Jonathan Stewart

Title: An introduction to the magical world of BIML!

Abstract:

Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

SessionID: 62407

Distributed Replay, using it to plan for the future.

Back to calendar

Event Date: 29-04-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Paul Popovich Jr

Title: Distributed Replay, using it to plan for the future.

Abstract:

Before you go and move that mission critical application to a new version of SQL or new hardware you are probably creating some sort of testing and benchmarking scenarios to ensure a smooth upgrade. Right? Come learn how distributed replay can capture your workload and play it back on your new instance. Be it an upgrade of SQL or hardware we can review all sorts of scenarios to help make your upgrade a smooth process.

SessionID: 62799

# vs @ - it's not about Social Media it's about temporary tables and data

Back to calendar

Event Date: 29-04-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Thomas Grohser

Title: # vs @ - it's not about Social Media it's about temporary tables and data

Abstract:

In this session Thomas will explore and explain the different options that exist in SQL Server to temporary store data and show you when to use which and why not the others. This will cover #, ##, @, Non-Durable Memory Optimized and regular user tables. He will also present alternatives like common table expressions.

SessionID: 64624

Tuning Query Performance with SentryOne Plan Explorer

Back to calendar

Event Date: 29-04-2017 - Session time: 12:15:00 - Track: Other

Speaker: Allen White

Title: Tuning Query Performance with SentryOne Plan Explorer

Abstract:

SQL Server query tuning can be challenging, and the free SentryOne Plan Explorer solution provides the necessary information to both diagnose and troubleshoot where those problems actually are, and help you fix those issues.

SessionID: 57878

Finding Islands, Gaps, and Clusters in Complex Data

Back to calendar

Event Date: 29-04-2017 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Edward Pollack

Title: Finding Islands, Gaps, and Clusters in Complex Data

Abstract:

Being able to group data into logical and meaningful sets can be extremely useful. When the data involved is a non-repeating sequence of integers, grouping is not too difficult. Most real data, though, is made up of dates, times, decimals, and rarely can guarantee non-repeating, non-null data sets.

This is a fast-paced session that delves into methods that can be applied to any data. Want to know how many production incidents make up a single common problem? Can we track sales success by the number of consecutive weeks that an agent has exceeded their goal? How about the longest home run streak hit by Derek Jeter at night games on Tuesdays?

Discussion will include performance, CTEs, recursion, set-based vs. iterative analysis, and some pretty hairy TSQL!

SessionID: 57895

Architecting Availability Groups

Back to calendar

Event Date: 29-04-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Derik Hammer

Title: Architecting Availability Groups

Abstract:

Are you a DBA familiar with some basic Windows clustering and database mirroring concepts, and now you're considering AlwaysOn Availability Groups? This session is for you! I'll cover the pros and cons of four typical configurations of AlwaysOn Availability Groups: stand-alone instances, fail-over cluster instances, multi-subnet configurations, and disaster-recovery-on-the-cheap. I'll also discuss read-only routing, and implications and limitations of the Availability Group Listener. In addition, you'll learn why you should be using Windows Server 2012 R2 or above for your Windows clusters. Join me to learn which configuration options you should choose for your Availability Group.

SessionID: 59588

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 29-04-2017 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 61277

SQL Server vNext (Linux and Beyond)

Back to calendar

Event Date: 29-04-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Loree

Title: SQL Server vNext (Linux and Beyond)

Abstract:

Microsoft has leveled the RDBMS playing field, with SQL Server vNext, allowing you to deploy and run SQL Server on a variety of operating systems and container solutions.

In this session, we will look at the background of SQL Server’s move to non-Windows platforms, cover how to install using package deployment on Linux and image-containers with Docker. Focus will cover administration and tools that you can leverage while running SQL Server on non-Windows platforms, including migration and current feature function limitations.

SessionID: 63727

WIT: Start 'em Young - Growing Women in IT

Back to calendar

Event Date: 29-04-2017 - Session time: 13:30:00 - Track: Professional Development

Speaker: Amy Herold

Title: WIT: Start 'em Young - Growing Women in IT

Abstract:

Do an internet search on "Women in Technology" and you'll find lots of articles with surveys, graphs and percentages telling you that there are not enough women in technology related fields. They'll give you just as many reasons why girls don't start in IT or women don't stay in IT. Is this true? As women in technology, are we wired differently? Was there some lightbulb moment that to put us on the path to innovate with code? Why are you in technology in the first place? From Grace Hopper to that 6th grade girl gaming with people around the globe - while technology has changed and is more accessible, what makes women pursue IT careers hasn't. With opportunities now spanning a wide array of fields and technologies, what does it take to inspire the young girls of today? In this session we will try to cut through a lot of the noise and get down to what drives young girls who grow to be women in technology, how we can encourage them, and not get in their way.

SessionID: 57880

Building Effective Backups

Back to calendar

Event Date: 29-04-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Edward Pollack

Title: Building Effective Backups

Abstract:

There are few aspects of a database infrastructure that are as basic, yet as critical as backups. Determining an appropriate backup methodology and architecting a fitting solution for it is critical to data security and the ability to service emergency requests.

Time constraints often cause us to lean on maintenance plans or third party tools to handle backups for us, but having a full understanding of the necessary processes involved is critical to having backup and restore processes that will provide us with exactly what we want, when we need it.

This is an opportunity to create a backup solution from scratch that takes into account the most important aspects of a backup process and can easily be customized to fit the needs of any database environment.

SessionID: 59393

The Query Store and Query Tuning in SQL Server

Back to calendar

Event Date: 29-04-2017 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Grant Fritchey

Title: The Query Store and Query Tuning in SQL Server

Abstract:

For the most part, query tuning in one version of SQL Server is pretty much like query tuning in the next. SQL Server 2016 introduces a number of new functions and methods that directly impact how you’re going to do query tuning in the future. The most important change is the introduction of the Query Store.

This session will explore how the Query Store works and how it’s going to change the methods you use to tune and troubleshoot query performance. With the information in this session, not only will you understand how the Query Store works, but you’ll know everything you need in order to put it to work with your own SQL Server 2016 tuning efforts, as well as your Azure SQL Databases.

SessionID: 59579

Learning to present and becoming good at it

Back to calendar

Event Date: 29-04-2017 - Session time: 14:45:00 - Track: Professional Development

Speaker: James Serra

Title: Learning to present and becoming good at it

Abstract:

Have you been thinking about presenting at a user group? Are you being asked to present at your work? Is learning to present one of the keys to advancing your career? Or do you just think it would be fun to present but you are too nervous to try it? Well take the first step to becoming a presenter by attending this session and I will guide you through the process of learning to present and becoming good at it. It's easier than you think! I am an introvert and was deathly afraid to speak in public. Now I love to present and it's actually my main function in my job at Microsoft. I'll share with you journey that lead me to speak at major conferences and the skills I learned along the way to become a good presenter and to get rid of the fear. You can do it!

SessionID: 62800

Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools

Back to calendar

Event Date: 29-04-2017 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Thomas Grohser

Title: Developing and deploying reusable TSQL code with Visual Studio and SQL Server Data Tools

Abstract:

Join Thomas in an almost PowerPoint free session where he shows how to write a reusable code library using TSQL, stored procedures, tables and functions and shows how to integrate the library into multiple database projects with a few mouse clicks.

He will also share many Tips and Tricks for using Visual Studio more effective for database development.

SessionID: 63451

Scalable Application Design with Service Broker

Back to calendar

Event Date: 29-04-2017 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Allen White

Title: Scalable Application Design with Service Broker

Abstract:

How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates. This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.

Learning Objectives: Session Goal 1 Understand the Service Broker architecture Session Goal 2 Understand the difference between critical and non-critical updates Session Goal 3 Demonstrate how the non-critical updates are best handled asynchronously

SessionID: 57897

Query Tuning without Production Data

Back to calendar

Event Date: 29-04-2017 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Derik Hammer

Title: Query Tuning without Production Data

Abstract:

The DBA is constantly ringing your phone complaining about why you did not include an index to support your new stored procedure. They have full access to production and do not understand how hard it is to tune a query with an underpowered development machine and a database which is less than 1/10th the size of the production equivalent. This session will cover query tuning techniques which will stop those phone calls and can be exercised on the worse of development environments. I will focus on query execution plan anti-patterns and faking out the optimizer.

SessionID: 61658

Think like the Cardinality Estimator

Back to calendar

Event Date: 29-04-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Taiob Ali

Title: Think like the Cardinality Estimator

Abstract:

SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers, will enable you to write better TSQL code and in turn influence type of physical operations during a query execution. Based on that estimated rows, the query processor decides how to access an object, which physical join to use, how to sort the data. Do you know how the CE generates these numbers? What happen when you have multiple predicates, range predicates, variable values that are “NOT KNOWN” to the optimizer or you have predicate values increasing in ascending order? Do you know what will happen if your predicate is using a value that is outside of histogram range? In this session, I will show you how CE estimates in all of these scenarios and you will walk out better equipped to tackle those nasty, hard to solve query plans.

SessionID: 63449

Emergency! Are You Ready for Disaster to Strike?

Back to calendar

Event Date: 29-04-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

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

Abstract:

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

Learning objectives: 1 Understand the kinds of issues that can arise in critical data environments 2 Understand the expectations for performance and recovery of those data environments 3 Define a Personal Minimums contract for meeting the data availability expectations of the business

This site is open source. Improve this page.