sqlsathistory

Nr: 560

SQLSaturday #560 - Charlotte 2016

Start Time (24h)	Speaker	Track	Title
09:00:00	Aaron Nelson	Database Development	Achieve More in Less Time by Using the New SQL PowerShell
09:00:00	Slava Murygin	Enterprise DBA	Inside of Indexes
09:00:00	Jen Underwood	Professional Development	Analytics Industry Trends + Your Career
09:00:00	Bill Anton	BI DW	Analysis Services: Show Me Where It Hurts
09:00:00	Alex Grinberg	Enterprise DBA	Efficient table design
09:00:00	Ravi Kumar	Enterprise DBA	Administring SSIS 2012, 2014 and 2016 for DBAs
09:00:00	Angela Henry	Enterprise DBA	Lightning Talks
10:15:00	Vishal Pawar	Database Development	SSIS-Lightning fast processing using Parallel processing-Result in Power BI
10:15:00	William Wolf	Database Development	Stop Doing That! 5 Common T-SQL Anti-Patterns
10:15:00	Melissa Coates	Cloud Data Platform	Building Blocks of Cortana Intelligence Suite in Azure
10:15:00	Rushabh Mehta	Strategy and Architecture	Mastering and Enhancing Company Data
10:15:00	Sean Werick	BI DW	SQL Server 2016 and PolyBase
10:15:00	Rick Heiges	Enterprise DBA	Winning with Columnstore - A Customer Story
10:15:00	William Assaf	Database Development	SQL Server Permissions and Security Principals
10:15:00	Adam Machanic	Database Development	SQL Server 2016 "Hidden Gems"
11:30:00	Azhagappan Arunachalam	Cloud Data Platform	Getting to know U-SQL
11:30:00	Kevin Feasel	Strategy and Architecture	Big Data, Small Data, and Everything In Between
11:30:00	Thomas Norman	Enterprise DBA	Encrypting Data within Sql Server
11:30:00	Andy Leonard	BI DW	Biml and SSIS Frameworks
11:30:00	Geoff Hiten	Database Development	What’s your Imperative doing in my Declarative?
11:30:00	Bill Anton	BI DW	20 Minute Tabular Model
11:30:00	Patrick Thompson	Strategy and Architecture	Using PowerBI and SQL Server to Create Management Cadence Dashboards
12:45:00	William Assaf	Vendor Sessions	Sparkhound Jeopardy
12:45:00	John Holtz	Vendor Sessions	Maximizing Microsoft SQL Server Storage Investments
13:45:00	boB Taylor	Database Development	SQL Azure Database - No CDC, no problem!
13:45:00	Anders Pedersen	Enterprise DBA	IO Tuning 101
13:45:00	Leveat Ruse	Professional Development	Interviewing-Be So Good They Can’t Ignore You
13:45:00	Tracy Boggiano	Enterprise DBA	Query Store Primer
13:45:00	Brian Carrig	Enterprise DBA	Managing Very Large Databases with SQL Server
13:45:00	Jana Sattainathan	Database Development	Practical PowerShell for the SQL Developers and DBA's - 0 to 60 in 60 mins
13:45:00	Konstantin Melamud	Enterprise DBA	Performance Tuning - Analyzing Execution Plans
13:45:00	Luke Donley	Database Development	Managing Database Projects in Visual Studio 2013
15:00:00	William Wolf	Database Development	Service Broker - Put Me In Coach
15:00:00	Jonathan Buller	BI DW	Tips and Tricks for the SSIS Catalog
15:00:00	Chris Skorlinski	Strategy and Architecture	Replication v. AlwaysOn, the great debate
15:00:00	Kevin Feasel	Database Development	APPLY Yourself
15:00:00	Thomas Chan	Enterprise DBA	SQL Backup 102 - From basic to more
15:00:00	Carlos L Chacon	Enterprise DBA	Disaster Recovery From On Premises to Azure
15:00:00	Paco Gonzalez	Advanced Analytics	Enterprise Machine Learning with R and SQL Server

SessionID: 50518

Achieve More in Less Time by Using the New SQL PowerShell

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Database Development

Speaker: Aaron Nelson

Title: Achieve More in Less Time by Using the New SQL PowerShell

Abstract:

Let’s face it, using SQLPS prior to SQL Server 2016 was like installing training wheels on a Ducati. Then, some community feedback was incorporated before SQL 2016 shipped and presto, SQLPS is actually useful all of a sudden.

There is a faster way to manage and even SQL Servers using PowerShell. I will show you what the new features in SQLPS and why you will probably find it useful, even if you aren't a "DBA".

SessionID: 52324

Inside of Indexes

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Enterprise DBA

Speaker: Slava Murygin

Title: Inside of Indexes

Abstract:

We will go through Clustered and Non Clustered index internals. How Indexes are allocated and how SQL Server uses indexes in Select operations.

In that session we will use DBCC IND and DBCC PAGE and dig into pages' binary code to understand how SQL Server uses different kinds of Indexes.

SessionID: 52635

Analytics Industry Trends + Your Career

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Professional Development

Speaker: Jen Underwood

Title: Analytics Industry Trends + Your Career

Abstract:

This presentation covers massive waves of change throughout the analytics industry. We discuss how to keep track of key changes, planning or adapting your analytics career, and then we explore many "blue ocean" career opportunities in a new world of data. Cool topics such as Virtual Reality, Robotics, Automation, Predictive and Prescriptive Analytics, Internet of Things, Big Data, Cloud and Hybrid are explored.

SessionID: 52871

Analysis Services: Show Me Where It Hurts

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: BI DW

Speaker: Bill Anton

Title: Analysis Services: Show Me Where It Hurts

Abstract:

"It's Slow!" are probably the two most dreaded words for any database professional (right behind "You're fired!")

What's slow? Since when? Compared to what?

Join me in this "something-everyone-should-be-doing-but-isn't" session, where we will discuss baselines and performance monitoring for your SQL Server Analysis Services (SSAS) environment. We'll cover what a baseline is, what information it needs to include, and how it can help you troubleshoot immediate problems and proactively avoid them in the future. Walk away from the session with a plan that you can implemented next week to help avoid being caught off guard by SSAS performance issues and to make troubleshooting a breeze.

SessionID: 52908

Efficient table design

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Enterprise DBA

Speaker: Alex Grinberg

Title: Efficient table design

Abstract:

The importance of proper table design cannot be underestimated. Misconceptions could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session the audience will have a sensible walk-through of database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTITY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARSE column, and more.

SessionID: 53081

Administring SSIS 2012, 2014 and 2016 for DBAs

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Enterprise DBA

Speaker: Ravi Kumar

Title: Administring SSIS 2012, 2014 and 2016 for DBAs

Abstract:

Make your SSIS Life easy by learning SSIS administration. There is lots of new stuff to learn in SSIS 2012 and 2014, to name a few: SSIS Catalog, Environmental Parameters, Encrypting passwords. We will cover new upcoming features in 2016.

SessionID: 53161

Lightning Talks

Back to calendar

Event Date: 17-09-2016 - Session time: 09:00:00 - Track: Enterprise DBA

Speaker: Angela Henry

Title: Lightning Talks

Abstract:

This session will consist of two 15 minute quot;Lightning Talksquot; from two different presenters: Geoff Hiten amp; William Assaf.

SessionID: 50203

SSIS-Lightning fast processing using Parallel processing-Result in Power BI

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Database Development

Speaker: Vishal Pawar

Title: SSIS-Lightning fast processing using Parallel processing-Result in Power BI

Abstract:

SSIS package can be run in Parallel and Optimized .In this session we will learn how to improve SSIS Package performance using parallel processing and Optimization. This knowledge will encourage development of better performing packages and optimize package performance.When creating an efficient and robust solution for Extract, Transform and Load Process, Lot of things do matter especially when you are working with huge size of databases. Challenge is not only to meet functional requirements Also to look at the performance requirements. This session will also cover best practices to enhance and boost performance of a SSIS package.

You will see all result of session in Power BI real time - Time and all Batch run details

SessionID: 50208

Stop Doing That! 5 Common T-SQL Anti-Patterns

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Database Development

Speaker: William Wolf

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

Abstract:

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

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

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

SessionID: 51056

Building Blocks of Cortana Intelligence Suite in Azure

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Cloud Data Platform

Speaker: Melissa Coates

Title: Building Blocks of Cortana Intelligence Suite in Azure

Abstract:

Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.

SessionID: 51167

Mastering and Enhancing Company Data

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Strategy and Architecture

Speaker: Rushabh Mehta

Title: Mastering and Enhancing Company Data

Abstract:

Getting a good 360 degree view of organizations (customers or vendors) or doing customer centric analysis is often complicated as a result of bad data/ duplicate data / inconsistent data coming from multiple systems. In addition, there are external factors like mergers and acquisitions, inter-company relationships and other nuances that may not be captured in source systems. Getting a clear picture of customer and vendor data can not only provide a clear picture for analysis of information, but also aid in critical risk management functions. In this session, you will learn about some techniques and data services from DB that you can use to clean and enhance your data.

SessionID: 52480

SQL Server 2016 and PolyBase

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: BI DW

Speaker: Sean Werick

Title: SQL Server 2016 and PolyBase

Abstract:

This session will focus on the brand new SQL Server 2016 feature called PolyBase. PolyBase#160;is a technology that accesses and combines both non-relational and relational data, all from within SQL Server. It allows you to run queries on external data in Hadoop or Azure blob storage. The queries are optimized to push computation to Hadoop.

In this session, you will learn how to install and set up PolyBase, and how to use it once you've got it configured.

SessionID: 52718

Winning with Columnstore - A Customer Story

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Enterprise DBA

Speaker: Rick Heiges

Title: Winning with Columnstore - A Customer Story

Abstract:

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

SessionID: 53071

SQL Server Permissions and Security Principals

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Database Development

Speaker: William Assaf

Title: SQL Server Permissions and Security Principals

Abstract:

A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA's, developers and system admins.

SessionID: 53160

SQL Server 2016 "Hidden Gems"

Back to calendar

Event Date: 17-09-2016 - Session time: 10:15:00 - Track: Database Development

Speaker: Adam Machanic

Title: SQL Server 2016 "Hidden Gems"

Abstract:

By far the most important SQL Server release since the heady days of 2005, SQL Server 2016 represents a huge leap forward in a number of key areas. You've no doubt heard plenty about such features as Query Store, JSON support, Polybase, and the other big-ticket items. But there are also a number of very cool features that don't usually make the top 10 lists. In this talk you'll learn about enhancements to indexing (including both Columnstore and traditional b-tree indexes), DMVs, compression, string handling, encryption, configuration, and even timezone support. These smaller features may not be highlighted in the latest glossy ads from Microsoft's marketing department, but they're the kinds of things that add up to make your life easier. Attend this session to learn all sorts of new and different reasons to upgrade as quickly as possible.

SessionID: 50801

Getting to know U-SQL

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: Cloud Data Platform

Speaker: Azhagappan Arunachalam

Title: Getting to know 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'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'll go over step-by-step in getting started with U-SQL, and review some use case scenarios.

SessionID: 50811

Big Data, Small Data, and Everything In Between

Back to calendar

Event Date: 17-09-2016 - Session time: 11: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: 51129

Encrypting Data within Sql Server

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: Enterprise DBA

Speaker: Thomas Norman

Title: Encrypting Data within Sql Server

Abstract:

Data breaches abound! Sql Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and Sql Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data. Let’s also look at new options to hide data with Always Encrypted.

SessionID: 52278

Biml and SSIS Frameworks

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: BI DW

Speaker: Andy Leonard

Title: Biml and SSIS Frameworks

Abstract:

You’ve probably heard that it’s a data integration best practice to build small, unit-of-work SSIS packages. You’ve heard that with Biml you can create a lot of SSIS packages in very little time. You follow this advice and end up with dozens of SSIS packages. Now what? A metadata-driven SSIS Execution Framework will simplify the execution of several SSIS packages down to a simple, one-line stored procedure call. But then, how does one manage all the metadata required to populate the SSIS Execution Framework? Biml to the rescue!

SessionID: 52490

What’s your Imperative doing in my Declarative?

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: Database Development

Speaker: Geoff Hiten

Title: What’s your Imperative doing in my Declarative?

Abstract:

T-SQL is one of a minority of computer languages where you describe the results rather than code an algorithm. Unfortunately, many people use habits and constructions learned in imperative languages such as C# or Java when writing T-SQL Code. In this all-demo session we will explore several such commonly used constructions that are detrimental to SQL Server performance and scalability.

SessionID: 52873

20 Minute Tabular Model

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: BI DW

Speaker: Bill Anton

Title: 20 Minute Tabular Model

Abstract:

Are you familiar w/ SSAS Multidimensional and curious about Tabular? Having trouble deciding between cubes and tabular models? Then this is your session!

Analysis Services Tabular was introduced back in 2012, and yet it has only just started to emerge from the Proof-Of-Concept phase to a legitimate production alternative in most IT departments. Based on xVelocity, a highly compressed in-memory technology, Tabular models provide considerable performance improvements over Multidimensional models in many scenarios. And with major advancements in 2016, Tabular has never been a more appealing solution. But, as is the case with any new technology, there are certain limitations of which to be aware.

Join me in this session and learn what a Tabular model is, how it fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live step-by-step demo where we'll build and deploy a Tabular model.

SessionID: 53073

Using PowerBI and SQL Server to Create Management Cadence Dashboards

Back to calendar

Event Date: 17-09-2016 - Session time: 11:30:00 - Track: Strategy and Architecture

Speaker: Patrick Thompson

Title: Using PowerBI and SQL Server to Create Management Cadence Dashboards

Abstract:

SessionID: 54292

Sparkhound Jeopardy

Back to calendar

Event Date: 17-09-2016 - Session time: 12:45:00 - Track: Vendor Sessions

Speaker: William Assaf

Title: Sparkhound Jeopardy

Abstract:

Join us for a fun game of Sparkhound-themed Jeopardy, where we will choose three contestants from the audience for high-stakes game where your answers must be in the form of a query. The audience can win prizes too if our brave contestants can’t. Learn some PowerShell, SQL, and trivia while you’re at it!

SessionID: 54305

Maximizing Microsoft SQL Server Storage Investments

Back to calendar

Event Date: 17-09-2016 - Session time: 12:45:00 - Track: Vendor Sessions

Speaker: John Holtz

Title: Maximizing Microsoft SQL Server Storage Investments

Abstract:

2016 is the year of All-Flash for primary storage and Dell EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.

SessionID: 50172

SQL Azure Database - No CDC, no problem!

Back to calendar

Event Date: 17-09-2016 - Session time: 13:45:00 - Track: Database Development

Speaker: boB Taylor

Title: SQL Azure Database - No CDC, no problem!

Abstract:

Azure SQL Database, No CDC No Problem! Come see how I solved that lack of CDC in SQL Azure Database by leveraging a new feature in SQL Azure database and SQL Server 2016- Temporal tables. In this in depth 300/400 level session I will demonstrate the techniques that I created to simulate CDC in SQL Azure Database. We will examine the code that implements the solution, the code that automatically writes code for you and a wizard that makes it simple to consume.

SessionID: 51188

IO Tuning 101

Back to calendar

Event Date: 17-09-2016 - Session time: 13:45:00 - Track: Enterprise DBA

Speaker: Anders Pedersen

Title: IO 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 now 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 t his 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: 52319

Interviewing-Be So Good They Can’t Ignore You

Back to calendar

Event Date: 17-09-2016 - Session time: 13:45:00 - Track: Professional Development

Speaker: Leveat Ruse

Title: Interviewing-Be So Good They Can’t Ignore You

Abstract:

From the basics to the advanced, we will explore techniques that will ensure you leave a positive impression and help you land that role!

SessionID: 52495

Query Store Primer

Back to calendar

Event Date: 17-09-2016 - Session time: 13:45:00 - Track: Enterprise DBA

Speaker: Tracy Boggiano

Title: Query Store Primer

Abstract:

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

SessionID: 52630

Managing Very Large Databases with SQL Server

Back to calendar

Event Date: 17-09-2016 - Session time: 13:45:00 - Track: Enterprise DBA

Speaker: Brian Carrig

Title: Managing Very Large Databases with SQL Server

Abstract:

If some of your databases have grown to over 1TB and it has become a challenge to maintain them - or if you are anticipating what to do in the future when they do - then this talk is for you! In this session, I will provide some practical advice on managing VLDBs with SQL server, focusing on common problem areas for new and experienced DBAs alike, including index maintenance, integrity checks, archival, backups and restores.

SessionID: 52960

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

Back to calendar

Event Date: 17-09-2016 - Session time: 13:45:00 - Track: 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: 52991

Performance Tuning - Analyzing Execution Plans

Back to calendar

Event Date: 17-09-2016 - Session time: 13:45:00 - Track: Enterprise DBA

Speaker: Konstantin Melamud

Title: Performance Tuning - Analyzing Execution Plans

Abstract:

Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations.

In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation

SessionID: 53104

Managing Database Projects in Visual Studio 2013

Back to calendar

Event Date: 17-09-2016 - Session time: 13:45:00 - Track: Database Development

Speaker: Luke Donley

Title: Managing Database Projects in Visual Studio 2013

Abstract:

Microsoft’s Visual Studio 2013 provides a great way for database project teams to manage databases within the Software Development Lifecycle. Learn how it enables you to create, manage, source control, schema compare, and deploy database objects. In this presentation, I will break down the feature set of database development in Visual Studio 2013 then walk through a demo and offer some tips for SQL database developers to effectively manage their databases.

SessionID: 50210

Service Broker - Put Me In Coach

Back to calendar

Event Date: 17-09-2016 - Session time: 15:00:00 - Track: Database Development

Speaker: William Wolf

Title: Service Broker - Put Me In Coach

Abstract:

This session is an introduction to Service Broker basics and how you can use it to for an alternative to ETL, batch processing and other asynchronous operations. Service Broker allows you to process your data asynchronously in a single instance. It makes for a near real time ETL process.

We will start off with the basic components of Service Broker. Then use what we have learned to configure it to process some real life data using American Football Plays on a single database deployment. In addition, we will then use Service Broker as a replication alternative to show the ETL capabilities using databases on two separate instances.

At the end of this session, you will have the knowledge to use Service Broker for batch processing, ETL or even an alternative to replication.

SessionID: 50435

Tips and Tricks for the SSIS Catalog

Back to calendar

Event Date: 17-09-2016 - Session time: 15:00:00 - Track: BI DW

Speaker: Jonathan Buller

Title: Tips and Tricks for the SSIS Catalog

Abstract:

With the introduction of the SSIS Catalog in SQL Server 2012, we can now manage our SSIS package execution and monitor performance and logs in a much easier manner than executing packages from the file system. In this session, we'll walk through setting permissions for SSIS read-only access, executing packages from T-SQL or stored procedures, viewing the logs generated during a package execution, writing custom messages to the logs, and many other tips to make your use of the catalog easier!

SessionID: 50773

Replication v. AlwaysOn, the great debate

Back to calendar

Event Date: 17-09-2016 - Session time: 15:00:00 - Track: Strategy and Architecture

Speaker: Chris Skorlinski

Title: Replication v. AlwaysOn, the great debate

Abstract:

Join Microsoft bloggers Chris Skorlinski, ReplTalk and Curt Mathews, SQLAlwaysOn in great debate, Replication v. AlwaysOn. They’ll go head to head on topics such as High Availability, Disaster Recovery, Performance, and Customization. Bring your own questions and join the discussion to help learn how these technologies can best be used in your company or organization.

SessionID: 50814

APPLY Yourself

Back to calendar

Event Date: 17-09-2016 - Session time: 15:00:00 - Track: Database Development

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.

SessionID: 52782

SQL Backup 102 - From basic to more

Back to calendar

Event Date: 17-09-2016 - Session time: 15:00:00 - Track: Enterprise DBA

Speaker: Thomas Chan

Title: SQL Backup 102 - From basic to more

Abstract:

We will start with the importance of backup for a database administrator.

The second part will cover backup/recovery strategy and the three backup types including a demo. The last part will cover the other techniques not considered as a normal backup process but can be used for it like attach/detach, import/export, replication and disaster recovery (log shipping).

SessionID: 53462

Disaster Recovery From On Premises to Azure

Back to calendar

Event Date: 17-09-2016 - Session time: 15:00:00 - Track: Enterprise DBA

Speaker: Carlos L Chacon

Title: Disaster Recovery From On Premises to Azure

Abstract:

Recovery in the cloud is now easier and more convenient than ever. This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure. We will focus on the IAAS offerings.

SessionID: 54117

Enterprise Machine Learning with R and SQL Server

Back to calendar

Event Date: 17-09-2016 - Session time: 15:00:00 - Track: Advanced Analytics

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.

This site is open source. Improve this page.