sqlsathistory

Nr: 592

Back to Main list

SQLSaturday #592 - Raleigh 2017

Start Time (24h) Speaker Track Title
08:30:00 Drew Furgiuele Enterprise Database Administration Deployment SQL Server Transactional Replication: A Deep Dive
08:30:00 Paco Gonzalez Advanced Analysis Techniques Enterprise Machine Learning with R and SQL Server
08:30:00 Doug McClurg BI Platform Architecture, Development Administration Tracking Change is the Backbone of Your Data Platform
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 Pritesh Ostwal Analytics and Visualization Embedding Power BI In Your Web Application
09:45:00 Jamie Wick Enterprise Database Administration Deployment SQL Backups: Choosing the right solution for your environment
09:45:00 Slava Murygin Enterprise Database Administration Deployment SQL Server on Linux for SQL DBA.
09:45:00 Michael Wharton Enterprise Database Administration Deployment Best practices for managing SharePoint SQL Server Databases
09:45:00 John Martin Application Database Development Making Row Level Security and Dynamic Data Masking work for you!
09:45:00 Jamie Dixon Advanced Analysis Techniques A Gentle Introduction To Machine Learning
11:00:00 Jonathan Stewart Analytics and Visualization Data Visualization: How to truly tell a great story!
11:00:00 Todd Chittenden BI Platform Architecture, Development Administration Row Level Security in Power BI
11:00:00 Derik Hammer Enterprise Database Administration Deployment Architecting Availability Groups
11:00:00 George Walkey Enterprise Database Administration Deployment Using Powershell to Document SQL Server
11:00:00 Thomas Norman Application Database Development Database Project Makes Deployment Consistent
11:00:00 Chris Voss Professional Development From Analyst BI Day to Developer BI Night
13:15:00 Azhagappan Arunachalam Cloud Application Development Deployment Understanding U-SQL
13:15:00 Andrew Kelly Enterprise Database Administration Deployment Query Store – What is it all about?
13:15:00 Melissa Coates BI Platform Architecture, Development Administration Designing a Modern DW + Data Lake
13:15:00 Brian Carrig Enterprise Database Administration Deployment Running SQL Server in AWS
13:15:00 Dan Zaratsian Analytics and Visualization SQL on Hadoop, using Hive Spark, to analyze sports data
13:15:00 Jared Poché Enterprise Database Administration Deployment Using DMVs for Performance Root Cause
14:30:00 Solomon Rutzky Application Database Development Module Signing or: How I Learned to Stop Using EXECUTE AS and Love Certificates
14:30:00 Shannon Lowder BI Platform Architecture, Development Administration Interrogating your data sources with Biml
14:30:00 Mark Hudson Advanced Analysis Techniques Deeper Into Azure Machine Learning
14:30:00 Tracy Boggiano Enterprise Database Administration Deployment Monitoring Availability Groups
14:30:00 Patrick Keisler Enterprise Database Administration Deployment SQL Audit - Evidence Never Lies
15:45:00 Doug Purnell Enterprise Database Administration Deployment Moving from Change Tracking/Change Data Capture to Temporal Tables
15:45:00 Maxwell Myrick Strategy and Architecture The Art and Science of Designing a Mission Critical SQL Server
15:45:00 Thomas Chan Enterprise Database Administration Deployment Finding more space for your tight environment.
15:45:00 Carlos L Chacon Enterprise Database Administration Deployment The ABC's of Database Baselines
15:45:00 Mark Gordon Enterprise Database Administration Deployment SQL Server Basic Backups For Beginners

SessionID: 56618

SQL Server Transactional Replication: A Deep Dive

Back to calendar

Event Date: 11-03-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server Transactional Replication: A Deep Dive

Abstract:

Ah, SQL Server Transactional Replication. The technology everyone loves to hate. But for all the notoriety, there's some interesting technology to be had in it that might you might want to leverage. In this session, we'll explore what happens when you create a new transactional publication: what happens during a snapshot, how data gets delivered to subscribers, and how you can monitor, tweak, and tune your publications. We'll also see some common trouble spots and how to identify them. There will be plenty of examples and demos and, yes, even some PowerShell!

SessionID: 59555

Enterprise Machine Learning with R and SQL Server

Back to calendar

Event Date: 11-03-2017 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Paco Gonzalez

Title: Enterprise Machine Learning with R and SQL Server

Abstract:

R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.

SessionID: 59574

Tracking Change is the Backbone of Your Data Platform

Back to calendar

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

Speaker: Doug McClurg

Title: Tracking Change is the Backbone of Your Data Platform

Abstract:

Features or concepts like Change Tracking, Change Data Capture, Temporal Tables, and other similar delta systems are complex and may carry a stigma or misapprehension in your organization around performance or security or cost. Even if you do not directly implement these features or methods absolutely, most information systems rely on tracking changes especially from legacy line of business applications. I'm here to show you robust techniques for implementing delta systems in SQL Server to increase the trustworthiness of your data warehouse. I will also steer you away from common pitfalls.

SessionID: 59600

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

Back to calendar

Event Date: 11-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: 59651

Embedding Power BI In Your Web Application

Back to calendar

Event Date: 11-03-2017 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Pritesh Ostwal

Title: Embedding Power BI In Your Web Application

Abstract:

Embed power BI reports in asp .net and JavaScript based apps using Portal and embedded Power BI

SessionID: 56898

SQL Backups: Choosing the right solution for your environment

Back to calendar

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

Speaker: Jamie Wick

Title: SQL Backups: Choosing the right solution for your environment

Abstract:

Backing up databases is (arguably) the most important maintenance task for any database administrator. But the question is: Which solution should you choose for creating and managing your backups? In this session we'll discuss the options available and demonstrate 2 of the solutions in action (Ola Hallengren's DatabaseBackup and Minionware's Minion Backup).

SessionID: 56944

SQL Server on Linux for SQL DBA.

Back to calendar

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

Speaker: Slava Murygin

Title: SQL Server on Linux for SQL DBA.

Abstract:

For the last 25 years SQL Server DBAs 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: 57558

Best practices for managing SharePoint SQL Server Databases

Back to calendar

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

Speaker: Michael Wharton

Title: Best practices for managing SharePoint SQL Server Databases

Abstract:

SharePoint Server uses SQL databases but not like a convention relational database. This session looks at some of the differences between SharePoint databases and default settings. What kinds of maintenance jobs to run and why its not a good idea to tweak the indexes.

SessionID: 59366

Making Row Level Security and Dynamic Data Masking work for you!

Back to calendar

Event Date: 11-03-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: John Martin

Title: Making Row Level Security and Dynamic Data Masking work for you!

Abstract:

Azure SQL DB has had Row Level Security and Dynamic Data Masking for a while now, SQL Server 2016 brings that on-premises. But just how can you use it, what changes do you need to make to your model to get the most from it?

These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong.

In this session we will look at how you can get the most out of these features and retain the performance of your system.

SessionID: 59567

A Gentle Introduction To Machine Learning

Back to calendar

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

Speaker: Jamie Dixon

Title: A Gentle Introduction To Machine Learning

Abstract:

Machine Learning is certainly a hot topic these days. For example, Microsoft is all-in in its company transformation from "a PC on every desktop" to "deep learning in every software". There are tons of product offerings in and out of the Microsoft stack and cloud and it can be a bit daunting to separate all of the noise from the signal. In this session, we are going to look at the fundamentals of machine learning - the building blocks of Deep Learning, Artificial Intelligence, and Cognitive Apps.

Some familiarity of computing programming, statistics, and manipulating tabular data will help you get the most out of this session.

SessionID: 56368

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 11-03-2017 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 56414

Row Level Security in Power BI

Back to calendar

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

Speaker: Todd Chittenden

Title: Row Level Security in Power BI

Abstract:

Power BI is the latest and greatest BI delivery service from Microsoft. This session will help you understand the concepts and DAX functions needed to create dynamic models for either internal use for your own company, or for a multi-tenant deployment. Power BI Desktop models and Tabular models will be discusses as we look at some common business scenarios for securing you Power BI.

SessionID: 56613

Architecting Availability Groups

Back to calendar

Event Date: 11-03-2017 - Session time: 11:00: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: 57020

Using Powershell to Document SQL Server

Back to calendar

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

Speaker: George Walkey

Title: Using Powershell to Document SQL Server

Abstract:

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

SessionID: 58099

Database Project Makes Deployment Consistent

Back to calendar

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

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

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

SessionID: 59473

From Analyst BI Day to Developer BI Night

Back to calendar

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

Speaker: Chris Voss

Title: From Analyst BI Day to Developer BI Night

Abstract:

You are a data analyst by trade. Your SQL skills are likely used to write research queries, do quality control for the query results, and churning out reports. However, you're now concerned with loading and manipulating data in the database. You're now asked to write statements that don't start with SELECT. In short, you're becoming a SQL developer.

This session will provide you with some high-level essential resources, from additional T-SQL query operators to SQL Server Data Tools and data modeling knowledge to warehousing basics, to help you navigate this uncharted territory...coming from a speaker who has been in the same position. You will come out of the session eager to use these resources to moonlight as or transition to a developer in the SQL Server space, ideally blending this developing skill set with your analyst skill set to create a well-rounded data professional!

SessionID: 56531

Understanding U-SQL

Back to calendar

Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Azhagappan Arunachalam

Title: Understanding U-SQL

Abstract:

With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL. In this session, we#39;ll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,). We#39;ll go over step-by-step in getting started with U-SQL, and review some use case scenarios.

SessionID: 56595

Query Store – What is it all about?

Back to calendar

Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

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

Designing a Modern DW + Data Lake

Back to calendar

Event Date: 11-03-2017 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Designing a Modern DW + Data Lake

Abstract:

Join us for a discussion of strategies and architecture options for implementing a modern data warehousing environment.  We will explore advantages of augmenting an existing data warehouse investment with a data lake, and ideas for organizing the data lake for optimal data retrieval. We will also look at situations when federated queries are appropriate for employing data virtualization, and how federated queries work with SQL Server, Azure SQL DW, Azure Data Lake, and/or Azure Blob Storage. This is an intermediate session suitable for attendees who are familiar with data warehousing fundamentals.

SessionID: 59558

Running SQL Server in AWS

Back to calendar

Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

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

SQL on Hadoop, using Hive Spark, to analyze sports data

Back to calendar

Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Dan Zaratsian

Title: SQL on Hadoop, using Hive Spark, to analyze sports data

Abstract:

This presentation will focus on the technology techniques that can be used to analyze data within Hadoop. I'll demonstrate a few SQL examples using Apache Spark and Apache Hive, discuss best practices, when to use one over the other, and additional tricks and tips. ​

SessionID: 59826

Using DMVs for Performance Root Cause

Back to calendar

Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jared Poché

Title: Using DMVs for Performance Root Cause

Abstract:

What are your first steps when you hear one of your SQL Servers is having a performance problem? In this demo-driven session, we will discuss key DMVs that can provide us data quickly. We will examine a number of example queries that can lead us to a quick root cause analysis in a number of different situations. This session will be kept at a very functional level, and should be accessible for anyone interested in SQL Server performance.

SessionID: 58047

Module Signing or: How I Learned to Stop Using EXECUTE AS and Love Certificates

Back to calendar

Event Date: 11-03-2017 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Solomon Rutzky

Title: Module Signing or: How I Learned to Stop Using EXECUTE AS and Love Certificates

Abstract:

Often enough we need to grant higher-level than ideal permissions to a Login or Role that are necessary to perform a task. For example, someone needs to start a SQL Agent job without being able to edit any jobs. Or, a task needs data from one of the DMVs that requires the "VIEW SERVER STATE" permission, but you don't want the user to see everything that is made available by that permission. When ownership-chaining doesn't work, the common solution is to use EXECUTE AS (i.e. Impersonation). Sometimes this works, but cross-DB tasks often require enabling cross-DB ownership chaining and/or TRUSTWORTHY, which are security risks.

Module Signing is more flexible and more secure, but requires a Certificate or Asymmetric Key. Those can be confusing to work with, and the security mechanism isn't intuitive.

Come learn how to have more secure, granular control over permissions that covers cross-DB tasks and Dynamic SQL. See what signing can do, understand how certificates work, and rejoice.

SessionID: 59358

Interrogating your data sources with Biml

Back to calendar

Event Date: 11-03-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

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

Deeper Into Azure Machine Learning

Back to calendar

Event Date: 11-03-2017 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Mark Hudson

Title: Deeper Into Azure Machine Learning

Abstract:

Azure Machine Learning enables far more than supervised 2-class classifications and continuous value predictions. Azure ML clusters unsupervised data. Azure ML analyzes free form text for entity recognition, sentiment analysis, or topic detection. Azure ML even provides Jupyter Notebooks with fully functional R and Python environments. This sessions demonstrates some of these capabilities to help you solve some of your business problem.

SessionID: 59572

Monitoring Availability Groups

Back to calendar

Event Date: 11-03-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

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

SQL Audit - Evidence Never Lies

Back to calendar

Event Date: 11-03-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

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

Moving from Change Tracking/Change Data Capture to Temporal Tables

Back to calendar

Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

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.

SessionID: 58154

The Art and Science of Designing a Mission Critical SQL Server

Back to calendar

Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Maxwell Myrick

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

Abstract:

When asked to design a critical database solution, too many people pick an HA feature assuming it will be the right fit for the application. This can result in a costly and disappointing design that does not meet your availability goals.

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 designing systems.

SessionID: 59629

Finding more space for your tight environment.

Back to calendar

Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Chan

Title: Finding more space for your tight environment.

Abstract:

If you do not have enough harddisk space and do not want buy more space, one way to get more space is compress the tables and also do some house keeping.

I am going use T-SQL script to generate script to compress each tables and release the free space by shrinking the datafiles. And in the final I will defragment the indexes and update the statistics, since shrink datafile is not fragmentation aware task.

SessionID: 61196

The ABC's of Database Baselines

Back to calendar

Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Carlos L Chacon

Title: The ABC's of Database Baselines

Abstract:

The numbers on the monitor go up and then they go down. Which numbers are the most important? How do I know if the change I made is helping my environment? This sessions reviews some of the important areas to understand before you start making changes to your environment and how to measure them.

SessionID: 62716

SQL Server Basic Backups For Beginners

Back to calendar

Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mark Gordon

Title: SQL Server Basic Backups For Beginners

Abstract:

If you just started using SQL Server and may be unsure of the need for backups or even how to do them, this is for you. It is very basic and will cover recovery models and backup types. In addition, I will demonstrate backups and a restore.