sqlsathistory

Nr: 498

SQLSaturday #498 - Chattanooga 2016

Start Time (24h)	Speaker	Track	Title
08:15:00	Vishal Pawar	Analytics and Visualization	Create lightning fast Dashboard with Power BI and its Components
08:15:00	Justin Randall	Enterprise Database Administration Deployment	The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags
08:15:00	Ryan Wade	BI Platform Architecture, Development Administration	Why “R” you not leveraging the power of “R” in Power BI?!?
08:15:00	Mike Robbins	Other	Building Unconventional SQL Server Tools in PowerShell
08:15:00	Shabnam Watson	BI Platform Architecture, Development Administration	A SQL Developer’s Guide to MDX Basics
08:15:00	Nathanial Gainer	Application Database Development	Upgrade your Database Development Skills with SQL Server Data Tools
09:30:00	Vladimir Oselsky	Application Database Development	Road to Better SQL Code - Advance Techniques Part 1
09:30:00	Mike Lawell	Application Database Development	Execution Plans for Mere Mortals
09:30:00	Geoff Hiten	Professional Development	Smart Rats Leave First
09:30:00	Matt Martin	Information Delivery	Advanced Error Tracking for Quick Diagnosis
09:30:00	Robert Verell	Other	16 Enhancements for SQL Server 2016
09:30:00	Aaron Nelson	Application Database Development	Achieve More in Less Time by Using SQLPS
10:45:00	Adam McDonald	Application Database Development	Data Analysis With SQL Window Functions
10:45:00	Vladimir Oselsky	Application Database Development	Road to Better SQL Code - Advance Techniques Part 2
10:45:00	Julie Smith	Cloud Application Development Deployment	Azure Data Factory: My Data Wandered Lonely as a CLOUD.
10:45:00	Robert Cain	Other	PowerShell 201: Debugging, Security, Code Signing, and Remoting
10:45:00	Rick Lowe	Enterprise Database Administration Deployment	Why Should I Care About ... Partitioned Views?
10:45:00	Kerry Tyler	BI Information Delivery	Connecting Power BI to On-Prem Data with SSAS
13:15:00	Janis Griffin	Enterprise Database Administration Deployment	Top 10 Wait Types Everyone Should Know
13:15:00	Alex Grinberg	Professional Development	SQL Server XML 101
13:15:00	Tamera Clark	BI Information Delivery	Microsoft Business Intelligence 2016 – More Love for Your Data
13:15:00	Jim Donahoe	Enterprise Database Administration Deployment	New Instance, Now what?
13:15:00	Tim Radney	Enterprise Database Administration Deployment	Azure SQL Database for the Production DBA
13:15:00	Robert Cain	Enterprise Database Administration Deployment	Zero to Hero with PowerShell and SQL Server
13:15:00	Damu Venkatesan	BI Information Delivery	Self-Service ETL with Microsoft Power Query
14:30:00	William Wolf	Application Database Development	Service Broker: Coach your processes asynchronously
14:30:00	Austin Senseman	Advanced Analysis Techniques	Context Calculation: Back to the Basics with DAX
14:30:00	Eric Peterson	Enterprise Database Administration Deployment	SQL Server Always On - The Good, The Bad and the Ugly
14:30:00	Ed Watson	BI Information Delivery	Introduction to SQL Server Integration Services
14:30:00	Dan Evans	Advanced Analysis Techniques	Perceptual Intelligence with Cortana Analytics
14:30:00	Jeff Reinhard	Enterprise Database Administration Deployment	Table Partitioning Intro and make that a sliding window too!
15:45:00	Kevin Feasel	BI Platform Architecture, Development Administration	Data Migration Using BIML
15:45:00	Eric Peterson	Enterprise Database Administration Deployment	SQL Server 2016 - New DBMS Features and examples
15:45:00	William E Pearson III	Analytics and Visualization	Pragmatic Power BI: Transforming Data
15:45:00	Naomi Williams	Professional Development	SQL Server Internals
15:45:00	Teo Lachev	BI Platform Architecture, Development Administration	What's New for BI in SQL Server 2016
15:45:00	Daniel Glenn	Other	Keys to Successful SharePoint Administration for the DBA

SessionID: 42315

Create lightning fast Dashboard with Power BI and its Components

Back to calendar

Event Date: 25-06-2016 - Session time: 08:15:00 - Track: Analytics and Visualization

Speaker: Vishal Pawar

Title: Create lightning fast Dashboard with Power BI and its Components

Abstract:

Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips

SessionID: 47112

The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags

Back to calendar

Event Date: 25-06-2016 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Randall

Title: The Sorcerer's Apprentice Guide to Configuration Options and Trace Flags

Abstract:

Microsoft markets SQL Server as a "self-tuning" RDBMS, yet you've heard there are a variety of knobs and switches available to impact performance. Are you curious to know what they are, what they do, and when to use them? In this session you will learn about server and database configuration options and trace flags that can impact performance, alter default behaviors and help your troubleshooting efforts.

SessionID: 48569

Why “R” you not leveraging the power of “R” in Power BI?!?

Back to calendar

Event Date: 25-06-2016 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ryan Wade

Title: Why “R” you not leveraging the power of “R” in Power BI?!?

Abstract:

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft has since incorporated R in Azure ML, SQL Server 2016, and Power BI.

In this session I will focus on the benefits of using R in Power BI. I will show how to leverage R for data munging (ETL) and I will also show how to leverage R to create custom visualizations. I will focus on the "Wickham stack" which is a group of very popular R packages developed by Hadley Wickham. The “Wickham stack” includes the ggplot2, dplyr, and tidyr packages. I will discuss logical use cases for using R within Power BI as well as some of the pitfalls that you may encounter.

SessionID: 49595

Building Unconventional SQL Server Tools in PowerShell

Back to calendar

Event Date: 25-06-2016 - Session time: 08:15:00 - Track: Other

Speaker: Mike Robbins

Title: Building Unconventional SQL Server Tools in PowerShell

Abstract:

Ever had records from a SQL Server database table come up missing? Maybe someone or some process deleted them, but who really knows what happened to them? Wouldn’t it be awesome to create a free tool with PowerShell that automates the task of sifting through the transaction log backups and even the active transaction log to determine when deletes occurred for a specific database and what user deleted those records along with the Log Sequence Number that the database needs to be restored to so the missing records can be recovered? During this session, PowerShell MVP Mike F Robbins will walk you through his custom SQL PowerShell module which includes functions for querying SQL Server with PowerShell from a client machine without requiring the installation of the SQL PowerShell module or snap-in, querying transaction logs for insert, update, and delete operations, and automated point in time recovery of a database by only having to specify the point in time to perform the recovery to.

SessionID: 49664

A SQL Developer’s Guide to MDX Basics

Back to calendar

Event Date: 25-06-2016 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Shabnam Watson

Title: A SQL Developer’s Guide to MDX Basics

Abstract:

In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel and SQL Server Management Studio, to use as practical examples of how to write MDX queries.

SessionID: 49667

Upgrade your Database Development Skills with SQL Server Data Tools

Back to calendar

Event Date: 25-06-2016 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Nathanial Gainer

Title: Upgrade your Database Development Skills with SQL Server Data Tools

Abstract:

SessionID: 45113

Road to Better SQL Code - Advance Techniques Part 1

Back to calendar

Event Date: 25-06-2016 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Road to Better SQL Code - Advance Techniques Part 1

Abstract:

Practical approach to writing code that runs faster and slimmer. Presentation will focus on multiple mistakes commonly made when writing T-SQL and how to correct it. Part 1 will include identification of issues by diagnosing query performance through use of execution plans and IO statistics. Focus will be on indexes, implicit conversions, improper data filtering and other issues that can cause significant performance issues but can be corrected without spending large amount of time.javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("dnn$ctr52960$Orator_CallForSpeakers_MySubmission$Button_SaveAndSubmit", ', true, "MainForm", ', false, true))

SessionID: 46477

Execution Plans for Mere Mortals

Back to calendar

Event Date: 25-06-2016 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

As a beginner database professional, execution plans are intimidating. In this session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties.

You will understand how, why and when the execution plan will be created and saved to plan cache.

Reading the execution plan will be much less intimidating as we walk through the flow and process of a graphical execution plan.

After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance tuning opportunities.

Finally, you will be able to capture the execution plan, save it for analysis and comparison after modifications have occurred.

SessionID: 48803

Smart Rats Leave First

Back to calendar

Event Date: 25-06-2016 - Session time: 09:30:00 - Track: Professional Development

Speaker: Geoff Hiten

Title: Smart Rats Leave First

Abstract:

Rats leave a sinking ship. Smart rats leave first. Changing jobs is always going to be stressful, but it can be a great opportunity for career growth. Recognizing when it is time to make a change can be the difference between taking a step up on the career ladder or having to find a "lifeboat" job. We will discuss how to recognize when it is time to move on, how to manage your job search and your current job, and finally how to exit a job professionally.

SessionID: 49574

Advanced Error Tracking for Quick Diagnosis

Back to calendar

Event Date: 25-06-2016 - Session time: 09:30:00 - Track: Information Delivery

Speaker: Matt Martin

Title: Advanced Error Tracking for Quick Diagnosis

Abstract:

In this session, we will walk through how to build a detailed error notification service for SQL Server that will trap errors, and email you a well formatted and detailed error report on what went wrong. In many organizations, you typically have SQL agent jobs running, and when failures occur, you get a generic email with a jumbled up message about the error, but it doesn't really help you understand where and at what point did your stored procedure fail.

In this class, we will introduce and go through how to pinpoint errors in real time, and how to identify troubling areas or bottlenecks in stored procedures. In the end, you will have a notification and error handling system that sends you a well formatted email alert with an html table output to show you the events that led up to the error, and what exactly the error was. This toolset has saved many developers and DBA's tons of time researching failures in jobs, and we hope it helps you too!

SessionID: 50084

16 Enhancements for SQL Server 2016

Back to calendar

Event Date: 25-06-2016 - Session time: 09:30:00 - Track: Other

Speaker: Robert Verell

Title: 16 Enhancements for SQL Server 2016

Abstract:

Microsoft announced SQL Server 2016 on April 1, 2015 and it is no joke! In this session we'll examine 16 of the new enhancements that are coming in the latest version of SQL Server that is currently available in a technology preview. there are so many enhancements that I can't cover them all in one session! So we will examine some in high level reviews and more in-depth previews such as row level security, query store, and always encrypted.

SessionID: 50561

Achieve More in Less Time by Using SQLPS

Back to calendar

Event Date: 25-06-2016 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Aaron Nelson

Title: Achieve More in Less Time by Using SQLPS

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

Data Analysis With SQL Window Functions

Back to calendar

Event Date: 25-06-2016 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Adam McDonald

Title: Data Analysis With SQL Window Functions

Abstract:

SQL Window Functions provide a great way to aggregate and analyze data very efficiently. In this session we'll go over what functions are available and look at many examples of how to use them. When you leave you'll be familiar with the concept and will be able to recognize situations where they can be extremely useful.

SessionID: 45117

Road to Better SQL Code - Advance Techniques Part 2

Back to calendar

Event Date: 25-06-2016 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Road to Better SQL Code - Advance Techniques Part 2

Abstract:

Part 2 of presentation will focus further on query optimization through reduction of data retrieved by practical use of CTEs, table variables and temp tables. Goal of this presentation is to empower developers to resolve code performance through identification and correction of issues by leveraging power of execution plans and IO statistics.

SessionID: 48218

Azure Data Factory: My Data Wandered Lonely as a CLOUD.

Back to calendar

Event Date: 25-06-2016 - Session time: 10:45:00 - Track: Cloud Application Development Deployment

Speaker: Julie Smith

Title: Azure Data Factory: My Data Wandered Lonely as a CLOUD.

Abstract:

SessionID: 49692

PowerShell 201: Debugging, Security, Code Signing, and Remoting

Back to calendar

Event Date: 25-06-2016 - Session time: 10:45:00 - Track: Other

Speaker: Robert Cain

Title: PowerShell 201: Debugging, Security, Code Signing, and Remoting

Abstract:

So you have a handle on basic PowerShell, and are ready to take the next step into deeper PowerShell. In this session we'll look at four topics critical to taking your PowerShell skills to the next level.

We'll start with some techniques for debugging the scripts you are developing. Next security will be examined, where you'll see how to properly set security for your environment. Closely associated with security is the topic of code signing, a technique that allows you to further enhance the security in your environment.

The session will wrap up with a discussion of Remoting, a technique allowing you to execute PowerShell scripts and commands against other machines on your infrastructure.

SessionID: 50006

Why Should I Care About ... Partitioned Views?

Back to calendar

Event Date: 25-06-2016 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why Should I Care About ... Partitioned Views?

Abstract:

Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away.

SessionID: 50101

Connecting Power BI to On-Prem Data with SSAS

Back to calendar

Event Date: 25-06-2016 - Session time: 10:45:00 - Track: BI Information Delivery

Speaker: Kerry Tyler

Title: Connecting Power BI to On-Prem Data with SSAS

Abstract:

SessionID: 44283

Top 10 Wait Types Everyone Should Know

Back to calendar

Event Date: 25-06-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Top 10 Wait Types Everyone Should Know

Abstract:

There are over 800 wait types in SQL Server 2014, but there are only 10 (in my experience) that are seen very often. If you can learn these 10 wait types, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait types to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.

SessionID: 45070

SQL Server XML 101

Back to calendar

Event Date: 25-06-2016 - Session time: 13:15:00 - Track: Professional Development

Speaker: Alex Grinberg

Title: SQL Server XML 101

Abstract:

XML processing become more and more a part of our daily life. Today anyone, DBA or Developer, interferes one way or another with XML-based processes. In the SQL Server XML 101 session I'll go over XML data type from "ground zero" to advanced tricks and tips. Using real life examples I'll show most efficient ways to work with an XML of any complexity and size. I'll cover the problems that you can anticipate to deal with with XML. How to: load the files using T-SQL code, dynamically retrieve and element or attribute, use different XML data types' methods and functions.

SessionID: 46783

Microsoft Business Intelligence 2016 – More Love for Your Data

Back to calendar

Event Date: 25-06-2016 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Tamera Clark

Title: Microsoft Business Intelligence 2016 – More Love for Your Data

Abstract:

Heartbroken over Microsoft’s neglect of SSRS over the years? Well the 2016 release might start healing that broken heart. This upcoming release boast a handful of great new items; from connecting SSRS PowerBI to mobile report publishing. Join me while I walk you through the best of 2016 for Business Intelligence and help you fall in love with Microsoft BI again.

SessionID: 48214

New Instance, Now what?

Back to calendar

Event Date: 25-06-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

SessionID: 48503

Azure SQL Database for the Production DBA

Back to calendar

Event Date: 25-06-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Azure SQL Database for the Production DBA

Abstract:

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

SessionID: 49691

Zero to Hero with PowerShell and SQL Server

Back to calendar

Event Date: 25-06-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Robert Cain

Title: Zero to Hero with PowerShell and SQL Server

Abstract:

PowerShell is everywhere, and that includes SQL Server. In this session we'll look at using PowerShell with both the SQL Server provider and the SMO (SQL Management Objects) library. Learn how to handle common DBA tasks, such as backups, reviewing error logs, and checking the status of SQL Jobs.

You'll also see how to perform developer tasks such as creating tables, inserting records, and querying data. Perhaps most importantly, you will learn how to read and understand the SMO object model, and translate it into PowerShell commands. Come see how to make your SQL Server Pop with PowerShell.

SessionID: 52535

Self-Service ETL with Microsoft Power Query

Back to calendar

Event Date: 25-06-2016 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Damu Venkatesan

Title: Self-Service ETL with Microsoft Power Query

Abstract:

In this session, I will introduce you to Microsoft's new self-service ETL tool "Power Query" for Excel. I will show you, how to source data from various data sources, how you can massage the data and consume the data for your use in the data pipeline. I will introduce you to "M" language that is used in Power Query. I will show you how you can discover and mash data from public data sources within Power Query. If you would like to do ETL quickly without writing SSIS packages, Power Query is the way go. Come and attend this session to learn "Power Query".

SessionID: 42309

Service Broker: Coach your processes asynchronously

Back to calendar

Event Date: 25-06-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: William Wolf

Title: Service Broker: Coach your processes asynchronously

Abstract:

This session is an introduction to Service Broker basics. Service Broker is your way to process your data asynchronously in a single instance setting as well as use as a near real time ETL. 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: 42328

Context Calculation: Back to the Basics with DAX

Back to calendar

Event Date: 25-06-2016 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Austin Senseman

Title: Context Calculation: Back to the Basics with DAX

Abstract:

The learning curve for DAX isn't a straight line - it starts off gradual and quickly gets steep. With a syntax similar to Excel, DAX seems easy enough for an Excel power user but things quickly get confusing without a good foundation in the basics of DAX. Those basics - context and calculation - are the topic for this session.

This session is for the intermediate DAX user who has produced some quality data models and DAX calculations but who is still having difficulties with functions around filtering, time intelligence, and complex calculations. We'll go through a number of practical examples that show that DAX at a fundamental level is a combination of creating filter and row CONTEXTS and then using those contexts to produce CALCULATIONS. Understanding this concept is a must to produce more complex code in DAX and it's also a very useful framework for someone just getting started.

SessionID: 42568

SQL Server Always On - The Good, The Bad and the Ugly

Back to calendar

Event Date: 25-06-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Peterson

Title: SQL Server Always On - The Good, The Bad and the Ugly

Abstract:

SQL Server Always on architecture was deployed with the SQL Server 2012 Engine.

This session will review terms for high availability and review our implementation of a 10TB data warehouse. This is an intermediate session, that will not show all of the details of setup, but will review what worked (the good), some unique features (the bad) and cover a couple of outages (the ugly) along the road to a successful deployment of the Always On architecture.

SessionID: 45431

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 25-06-2016 - Session time: 14:30:00 - Track: BI Information Delivery

Speaker: Ed Watson

Title: Introduction to SQL Server Integration Services

Abstract:

Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

SessionID: 45733

Perceptual Intelligence with Cortana Analytics

Back to calendar

Event Date: 25-06-2016 - Session time: 14:30:00 - Track: Advanced Analysis Techniques

Speaker: Dan Evans

Title: Perceptual Intelligence with Cortana Analytics

Abstract:

Cortana Analytics is a fully managed big data and advanced analytics suite that enables you to transform your data into intelligent action. Come learn more around how you can take action by going beyond looking in the rear-view mirror to predicting what’s next. Enhance your business applications with machine intelligence to evolve from simple descriptive analytics to prescriptive recommendations. See some of the new ways to infer intent with vision, face, speech, text and sentiment analysis to customize responses and drive appropriate actions in a secure, compliant and scalable way leveraging SQL Server, Azure and Power BI. Expect to leave the discussion understanding new trends in analytics and how you can apply value to your organization.

SessionID: 45943

Table Partitioning Intro and make that a sliding window too!

Back to calendar

Event Date: 25-06-2016 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Reinhard

Title: Table Partitioning Intro and make that a sliding window too!

Abstract:

I walk-through the entire process of discovering a situation that would benefit from a partitioned table, designing the partition key and scheme, and implementation. Then also creating a sliding window partition, both adding new partitions and rolling out older ones, all on an AdventureWorks table, so that all the scripts can be used by participants later for practicing.

SessionID: 42389

Data Migration Using BIML

Back to calendar

Event Date: 25-06-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kevin Feasel

Title: Data Migration Using BIML

Abstract:

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances. Sometimes, it becomes important to move that data from one database to another. SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious. Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development. This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.

SessionID: 42567

SQL Server 2016 - New DBMS Features and examples

Back to calendar

Event Date: 25-06-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Peterson

Title: SQL Server 2016 - New DBMS Features and examples

Abstract:

Microsoft has released an advanced version of SQL Server 2016.

My job as lead architect is to implement these new features, and see how they actually work. The session will cover the following subject areas and include examples of usage:

Server Setup Changes
Temporal Data Tables
Masking Data Columns
Row Level Security
Always Encrypted
Stretch Database
Always On Enhancements
In Memory Enhancements
JSON Support
Polybase into SQL Server

SessionID: 45776

Pragmatic Power BI: Transforming Data

Back to calendar

Event Date: 25-06-2016 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: William E Pearson III

Title: Pragmatic Power BI: Transforming Data

Abstract:

Once we’ve extracted data from a source, we typically need to clean, or otherwise change, that data in preparation for loading it into Power BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson will explore the options Power BI offers to unpivot, filter, sort, aggregate, and perform other needed operations to make these preparations. We’ll employ a dataset containing issues that commonly present real-world challenges, and work through the steps we can take in Power BI to transform the data to a state that works within Power BI. Moreover, we’ll define calculations, and get a glimpse of the M language that underlies transformational processes we construct.

SessionID: 46429

SQL Server Internals

Back to calendar

Event Date: 25-06-2016 - Session time: 15:45:00 - Track: Professional Development

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 49588

What's New for BI in SQL Server 2016

Back to calendar

Event Date: 25-06-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Teo Lachev

Title: What's New for BI in SQL Server 2016

Abstract:

SQL Server 2016 delivers many new data analytics and information management features and enhancements. Join this session to discover what's new for BI in Database Engine, SSRS, SSIS, SSAS, and MDS. I'll also explain the SQL Server 2016+ near-future roadmap that will help you implement new solutions and cut cost.

SessionID: 50079

Keys to Successful SharePoint Administration for the DBA

Back to calendar

Event Date: 25-06-2016 - Session time: 15:45:00 - Track: Other

Speaker: Daniel Glenn

Title: Keys to Successful SharePoint Administration for the DBA

Abstract:

Inherited SharePoint or being tasked to implement it? In this session we will start with the fundamentals of SharePoint and work our way to understanding what it looks like to be a successful SharePoint administrator. We will cover common SharePoint misconceptions use live demos to show frequently performed tasks - all to set you up for success day one. Lastly we will cover the training options and other resources available to make your job easier and more automated.

This site is open source. Improve this page.