sqlsathistory

Nr: 557

SQLSaturday #557 - Minnesota 2016

Start Time (24h)	Speaker	Track	Title
08:00:00	Dan English	Business Intelligence	What#39;s new in SQL Server 2016 for Business Intelligence
08:00:00	Andy Galbraith	Database Administration	Does it Hurt When I Do This? Performing a SQL Server Health Check
08:00:00	Phil Ekins	Database Administration	Availability Groups: Monitoring and Alerting
08:00:00	Dave DuVarney	Business Intelligence	Building Metadata Driven ETL Solutions with BIML
08:00:00	Brian Larson	Business Intelligence	Life on the Road: the Mobile Report Publisher
08:00:00	Paul Timmerman	Cloud Application Development Deployment	SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud
08:00:00	Jason Strate	Database Development	Indexing Fundamentals for Microsoft SQL Server
08:00:00	Mike Fulkerson		Makin’ Data with Azure Data Factory
09:25:00	Phillip Labry	Business Intelligence	Let's Build a Tabular Solution
09:25:00	Dave Bland	Business Intelligence	SSAS: What is it and How do I get started using it
09:25:00	Eric Zierdt	Database Development	How I deleted 1 billion records without anyone noticing.
09:25:00	Aaron Cutshall	Database Development	The Lost Science of Set Theory
09:25:00	Adam Jorgensen	Professional Development	The future data professional - Hacking your growth!
09:25:00	Mark Vaillancourt	Cloud Application Development Deployment	It#39;s Elastic! Boogie Woogie Woogie!
09:25:00	Brian Larson	Business Intelligence	Calculate, Aggregate amp; Filter: Truly Understanding DAX
09:25:00	Ed Leighton-Dick	SQL Server	Understanding SQL Server 2016 Always Encrypted
10:40:00	Ben Thul	Database Development	Hierarchical Queries
10:40:00	Ross McNeely	SQL Server	Information Management Framework
10:40:00	George Bryant	Business Intelligence	So this is Power BI. What now?
10:40:00	Chuck Hieber	Database Administration	SQL Server Tips and Tricks from a lazy DBA
10:40:00	Steve Hughes	Business Intelligence	Consumption Based Architecture and MSBI
10:40:00	David Klee	Strategy and Architecture	Advanced SQL Server on VMware Features
10:40:00	Cathrine Wilhelmsen	Business Intelligence	Level Up Your Biml: Best Practices and Coding Techniques
10:40:00	Anton Rozenson	Database Development	Architecture, Components and Goals of Data warehouse solution
12:15:00	Sean Barry	SQL Server	DELL EMC Sponsor - Maximizing Microsoft SQL Server Storage Investments
13:30:00	Brian Beswick	Business Intelligence	SSAS 2016 Tabular - Diving into the new features
13:30:00	Todd Blatti	SQL Server	Accelerating DevOps Using Data Virtualization
13:30:00	Aaron Cutshall	Business Intelligence	Battle Scars: Porting a SQL Server app to an MPP system
13:30:00	Matt Stenzel	Big Data	HDInsight - Hadoop for the Commoner
13:30:00	Jes Schultz	Cloud Application Development Deployment	SQL Server in Azure: Essentials for the Database Administrator
13:30:00	Riley Major	SQL Server	SQL Server 2016 - New Feature Preview
13:30:00	Jason Strate	Database Administration	Managing SQL Server Performance with Extended Events
14:45:00	Jared Zagelbaum	Database Administration	Automated Restore Script Output for Ola Hallengren’s Maintenance Solution
14:45:00	Eric Zierdt	SQL Server	SQL Server Quiz Show
14:45:00	Zane Brunette	Database Development	Cardinality estimation and how it affects your execution plan
14:45:00	Rachael Martino	Business Intelligence	Power BI Performance Tips
14:45:00	Brian Hansen	Database Administration	Get Your Optimizer to Give up All Its Secrets
14:45:00	Doug Lane	Professional Development	Getting Started Making Technical Videos
14:45:00	Jason Horner	Business Intelligence	Dimensional Modeling Design Patterns: Beyond the Basics
14:45:00	Jim Dorame	Database Administration	JSON for the DBA
16:00:00	Maxwell Myrick	Database Administration	Insider Secrets to Securing the Budget You Need
16:00:00	Cecil Spivey	SQL Server	Free SQL Server Tools
16:00:00	David Klee	Database Administration	Virtual SQL Servers. Actual Performance.
16:00:00	Ginger Grant	Business Intelligence	Introducing the R Language to the Data Professional
16:00:00	Michael DeFehr	Database Development	Query Plans and Indexes in SQL Server 2016
16:00:00	Rowland Gosling	Big Data	Apache Spark and SQL Server: Perfect Together!
16:00:00	Jim Horn	SQL Server	Ask the Experts Panel
16:00:00	Mark Vaillancourt	Business Intelligence	Shape It: Shaping and Modelling Data With Power BI Desktop

SessionID: 49946

What#39;s new in SQL Server 2016 for Business Intelligence

Back to calendar

Event Date: 01-10-2016 - Session time: 08:00:00 - Track: Business Intelligence

Speaker: Dan English

Title: What#39;s new in SQL Server 2016 for Business Intelligence

Abstract:

SessionID: 49976

Does it Hurt When I Do This? Performing a SQL Server Health Check

Back to calendar

Event Date: 01-10-2016 - Session time: 08:00:00 - Track: Database Administration

Speaker: Andy Galbraith

Title: Does it Hurt When I Do This? Performing a SQL Server Health Check

Abstract:

How often do you review your SQL Servers for basic security, maintenance, and performance issues? Many of the servers I "inherit" as a managed services provider have quite a few gaping holes. It is not unusual to find databases that are never backed up, servers with constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that even have too much!)

Come learn how to use freely available tools from multiple layers of the SQL Server stack to check your servers for basic issues like missing backups and CheckDB as well as for more advanced issues like page life expectancy problems and improper indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!

SessionID: 50086

Availability Groups: Monitoring and Alerting

Back to calendar

Event Date: 01-10-2016 - Session time: 08:00:00 - Track: Database Administration

Speaker: Phil Ekins

Title: Availability Groups: Monitoring and Alerting

Abstract:

So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Did you know it failed over last night?

This session will answer all these questions and more, and will show you what should you be looking at to ensure no surprises... We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and policies to show what to monitor in your AG and how to setup alerts so you know when to take action.

SessionID: 50493

Building Metadata Driven ETL Solutions with BIML

Back to calendar

Event Date: 01-10-2016 - Session time: 08:00:00 - Track: Business Intelligence

Speaker: Dave DuVarney

Title: Building Metadata Driven ETL Solutions with BIML

Abstract:

ETL development can consume a significant portion of time in Data Warehousing initiatives. It can also be very cumbersome to change ETL patterns across a large number of objects. This session will look at how BIML + metadata can be leverage to significantly reduce ETL development time.

SessionID: 53588

Life on the Road: the Mobile Report Publisher

Back to calendar

Event Date: 01-10-2016 - Session time: 08:00:00 - Track: Business Intelligence

Speaker: Brian Larson

Title: Life on the Road: the Mobile Report Publisher

Abstract:

The new Mobile Report Publisher provides an efficient and effective tool for creating data visualizations to be consumed on tablets and smartphones. This session will take you through the authoring of mobile visualizations including tips and tricks to create the most effective presentations on a small footprint. We will also explore best practices concerning when to author visualizations with the Mobile Report Publisher and when to utilize other tools in the arsenal.

SessionID: 53602

SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud

Back to calendar

Event Date: 01-10-2016 - Session time: 08:00:00 - Track: Cloud Application Development Deployment

Speaker: Paul Timmerman

Title: SQL Server Hybrid Cloud Strategy: Best Of Both Worlds With On-Prem + Cloud

Abstract:

For years it seemed that the only message SQL Server professionals were hearing was quot;to the Cloud.... you must get to the Cloud!quot;. However, if you work in a highly regulated industry, or one simply averse to change, this likely was not an option for you. The good news is, Microsoft heard your feedback and has been busy incorporating Cloud connectivity, compatibility, and functionality into the box product.

Come spend the hour with me and you’ll learn how to leverage the power of the Cloud with your on-premises SQL Server install. We’ll cover backup and restore options with Windows Azure Storage, using Windows Azure VMs for high availability, how to store your data files in Windows Azure Storage, and more. We’ll start with SQL Server 2012 and work our way up to the most recently released bits for SQL Server 2016. You can have the best of both worlds with a SQL Server Hybrid Cloud strategy!

SessionID: 53624

Indexing Fundamentals for Microsoft SQL Server

Back to calendar

Event Date: 01-10-2016 - Session time: 08:00:00 - Track: Database Development

Speaker: Jason Strate

Title: Indexing Fundamentals for Microsoft SQL Server

Abstract:

Having the right indexes supporting your databases is a critical need. But how do you determine what indexes are most effective? Should you have single or multi-column indexes? Should the index be filtered? What are included columns and columnstore indexes and when should they be used? In this session, we explore various ways to implement indexes and provide the performance expected out of your databases.

SessionID: 54137

Makin’ Data with Azure Data Factory

Back to calendar

Event Date: 01-10-2016 - Session time: 08:00:00 - Track:

Speaker: Mike Fulkerson

Title: Makin’ Data with Azure Data Factory

Abstract:

What’s Data Factory? Isn’t it just SSIS in the cloud? If you’re an ETL developer or looking for solutions to efficiently integrate your on-prem. data with Azure then you should know what Data Factory is. Over the last 20 years I’ve worked with BCP, DTS, SSIS, and now Data Factory. We’ll talk about when and how to use Data Factory. I’ll demo using Data Factory to pull data from on-prem. sources, transform it, and land it in Azure SQL DB.

SessionID: 49931

Let's Build a Tabular Solution

Back to calendar

Event Date: 01-10-2016 - Session time: 09:25:00 - Track: Business Intelligence

Speaker: Phillip Labry

Title: Let's Build a Tabular Solution

Abstract:

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data. This is a demo heavy session and you should be able walk away knowing how to create your own tabular model.

SessionID: 49983

SSAS: What is it and How do I get started using it

Back to calendar

Event Date: 01-10-2016 - Session time: 09:25:00 - Track: Business Intelligence

Speaker: Dave Bland

Title: SSAS: What is it and How do I get started using it

Abstract:

This session with provide a high level overview of what SQL Server Analysis Services is and what you need to know to get started. It will cover the fundamentals of Dimensions, Measures, how to view the data as well as the role of SSAS in the enterprise. The sessions with also provide a few scenarios demonstrating the benefits of using SSAS.

SessionID: 49995

How I deleted 1 billion records without anyone noticing.

Back to calendar

Event Date: 01-10-2016 - Session time: 09:25:00 - Track: Database Development

Speaker: Eric Zierdt

Title: How I deleted 1 billion records without anyone noticing.

Abstract:

In this session we will give an overview of what Table Partitioning is, how can it be used to move large amounts of data quickly and how can it be used with a data archiving strategy to quickly and easily drop archived data from a table. We will discuss the practical applications of table partitioning using scripts to generate new table partitions, move a partition to another table and discussion on how this can benefit you. In this demo heavy session, attendees will be provided with scripts to get setup quickly so they can begin using the strategies to take control of rapid data archival

SessionID: 50012

The Lost Science of Set Theory

Back to calendar

Event Date: 01-10-2016 - Session time: 09:25:00 - Track: Database Development

Speaker: Aaron Cutshall

Title: The Lost Science of Set Theory

Abstract:

Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.

SessionID: 53333

The future data professional - Hacking your growth!

Back to calendar

Event Date: 01-10-2016 - Session time: 09:25:00 - Track: Professional Development

Speaker: Adam Jorgensen

Title: The future data professional - Hacking your growth!

Abstract:

We are in a new industrial revolution. Data is the new innovation lever and companies are all seeking new ways to use it to catapult them forward. Incremental growth or improvement are no longer optional. The current needs of the business world are outpacing the technology expertise of most of its technical leadership. Learn how to rethink your own development and get the right capabilities for an amazing future in data! Leave with a roadmap for building out your modern personal development plan.

SessionID: 53584

It#39;s Elastic! Boogie Woogie Woogie!

Back to calendar

Event Date: 01-10-2016 - Session time: 09:25:00 - Track: Cloud Application Development Deployment

Speaker: Mark Vaillancourt

Title: It#39;s Elastic! Boogie Woogie Woogie!

Abstract:

Azure SQL Database provides fantastic scalability and flexibility for your data tier. You can scale it up with ease when you need more power and scale it down again when load returns to normal. With the pay as you go model, you pay for each database based on performance characteristics. But when you have a scaled out architecture of hundreds, thousands, or tens of thousands of databases, how can you keep costs from spiraling out of control? How can you query across all of those databases? How can you MANAGE so many databases? How can you write your application to make the right decisions about where to put which data? This session will introduce you to four key pieces of this overall story: Elastic Database Pools, Elastic Query, Elastic Database Jobs, and the Elastic Database Tools .Net library. With these tools, you take your Azure SQL Database data tier to the next level of scale and manageability.

SessionID: 53589

Calculate, Aggregate amp; Filter: Truly Understanding DAX

Back to calendar

Event Date: 01-10-2016 - Session time: 09:25:00 - Track: Business Intelligence

Speaker: Brian Larson

Title: Calculate, Aggregate amp; Filter: Truly Understanding DAX

Abstract:

To get the most from our SSAS Tabular and Power BI models, we must be able to create robust DAX expressions. This requires a solid conceptual understanding of DAX expressions, especially the interaction of aggregates and filters with the Calculate() function. In this session, we will also look at time analytics and hierarchies within DAX expressions. As we explore the ins and outs of DAX expressions, we will call out new features and functionality available in DAX in SQL Server 2016.

SessionID: 53606

Understanding SQL Server 2016 Always Encrypted

Back to calendar

Event Date: 01-10-2016 - Session time: 09:25:00 - Track: SQL Server

Speaker: Ed Leighton-Dick

Title: Understanding SQL Server 2016 Always Encrypted

Abstract:

Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs. Does that sound too good to be true? It isn’t - Always Encrypted is an incredible feature - but like any new technology, it does have some limitations. In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

SessionID: 49942

Hierarchical Queries

Back to calendar

Event Date: 01-10-2016 - Session time: 10:40:00 - Track: Database Development

Speaker: Ben Thul

Title: Hierarchical Queries

Abstract:

Employee/manager relationships, family trees, and the like are all hierarchical data. In this session, we'll look at a common way to represent such relationships, common methods of querying them, and how we can leverage the hierarchyid datatype to make queries go a lot easier and faster!

SessionID: 49975

Information Management Framework

Back to calendar

Event Date: 01-10-2016 - Session time: 10:40:00 - Track: SQL Server

Speaker: Ross McNeely

Title: Information Management Framework

Abstract:

In this session, Ross McNeely will discuss the need for a strong approach towards Information Management, and which tools will help you deliver solutions. The focus of the presentation will be on leveraging SQL Server 2016, and Azure data platforms within an Information Management Framework. Major components of the framework include Information Strategy, Information Asset Management, Enterprise Data Management, and Business Intelligence. Information Strategy will include Governance, and how to define strategies for data, query, and business intelligence platforms. Information Asset Management will cover data linage, and security. Enterprise Data Management will dive into Data Architecture. Business Intelligence will include designing for predictive, prescriptive, and performance analytics.

SessionID: 50141

So this is Power BI. What now?

Back to calendar

Event Date: 01-10-2016 - Session time: 10:40:00 - Track: Business Intelligence

Speaker: George Bryant

Title: So this is Power BI. What now?

Abstract:

Everyone is talking about Power BI. People are starting to use and interact with Power BI. That is a good thing, Power BI is fun! As an organization however, what do I do now and how do I handle a periodically changing beast? Here is what to consider...

SessionID: 53466

SQL Server Tips and Tricks from a lazy DBA

Back to calendar

Event Date: 01-10-2016 - Session time: 10:40:00 - Track: Database Administration

Speaker: Chuck Hieber

Title: SQL Server Tips and Tricks from a lazy DBA

Abstract:

Good managers believe lazy people don#39;t work hard. Great managers realize that a lot of lazy people get their work done, just more efficiently. The right lazy person will find YOU a quicker, easier way to accomplish the same amount.

In this session, I will show you several of the tips and tricks I have picked up and use to make my life easier. From keyboard shortcuts to some lesser-known SSMS built-in tools, I hope to make your life easier, and make you a lazy DBA, too!

SessionID: 53546

Consumption Based Architecture and MSBI

Back to calendar

Event Date: 01-10-2016 - Session time: 10:40:00 - Track: Business Intelligence

Speaker: Steve Hughes

Title: Consumption Based Architecture and MSBI

Abstract:

As the tools available for BI and data warehousing continue to improve, it should change the way we ultimately deliver BI solutions. Microsoft#39;s BI solutions help us keep data closer to the source. As data and BI architects, we need to design solutions that can support this model. Consumption Based Architecture is one such architecture. The goal of this architecture is to plan and design solutions that minimize ongoing maintenance and enable users quicker and more complete access to data. Some highlights are how tabular models and PowerPivot support this process and where does MDM for BI fit in. Ready to discuss the quot;death of enterprise data warehousesquot;? Join the conversation in this session.

SessionID: 53828

Advanced SQL Server on VMware Features

Back to calendar

Event Date: 01-10-2016 - Session time: 10:40:00 - Track: Strategy and Architecture

Speaker: David Klee

Title: Advanced SQL Server on VMware Features

Abstract:

The world's most powerful virtualization platform, VMware vSphere, contains a number of hidden gems that DBAs can use to make their SQL Servers more highly available and perform better. The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as to how this enhances your SQL Server environment.

SessionID: 53887

Level Up Your Biml: Best Practices and Coding Techniques

Back to calendar

Event Date: 01-10-2016 - Session time: 10:40:00 - Track: Business Intelligence

Speaker: Cathrine Wilhelmsen

Title: Level Up Your Biml: Best Practices and Coding Techniques

Abstract:

Is your Biml solution starting to remind you of a bowl of tangled spaghetti code? Good! That means you are solving real problems while saving a lot of time. The next step is to make sure that your solution does not grow too complex and confusing - you do not want to waste all that saved time on future maintenance!

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code with include files and the CallBimlScript method. Make your code easier to read and write by utilizing LINQ (Language-Integrated Queries). Share code between files by using Annotations and ObjectTags. And finally, if standard Biml is not enough to solve your problems, you can create your own C# helper classes and extension methods to implement custom logic.

Start improving your code today and level up your Biml in no time!

SessionID: 54080

Architecture, Components and Goals of Data warehouse solution

Back to calendar

Event Date: 01-10-2016 - Session time: 10:40:00 - Track: Database Development

Speaker: Anton Rozenson

Title: Architecture, Components and Goals of Data warehouse solution

Abstract:

Developers are building Data warehouse solutions to satisfy business requirements. Good developers design solutions with flexibility in mind anticipating requirement’s changes. Great developers deliver solutions that exceed requirements, performance expectations and are long term manageable.

In this session we will learn design patterns that allow for delivery of flexible and sustainable solutions through Data Warehouse life cycle avoiding making common architectural mistakes. We will answer What? How? and Why? questions about capturing data, designing ODS, ETL, dimensional Data warehouse, symantec and presentations layers.

SessionID: 54730

Back to calendar

Event Date: 01-10-2016 - Session time: 12:15:00 - Track: SQL Server

Speaker: Sean Barry

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, DELL EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, DELL 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: 50000

SSAS 2016 Tabular - Diving into the new features

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Brian Beswick

Title: SSAS 2016 Tabular - Diving into the new features

Abstract:

Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.

SessionID: 50003

Accelerating DevOps Using Data Virtualization

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: SQL Server

Speaker: Todd Blatti

Title: Accelerating DevOps Using Data Virtualization

Abstract:

DevOps is the melding of application development, testing, and IT operations. All tasks from infrastructure to coding to testing to transition into production must be automated so that new features and fixes can be continuously delivered.

Constraining DevOps is data. Databases and applications have grown enormous and complex. quot;Storage is cheapquot; is a lie. Provisioning a full environment for each developer or tester on each task of each project appears unrealistic, when each might require several terabytes of storage. And so everyone is limited to working in a small handful of shared environments that are refreshed only every few months, and code quality suffers.

Data virtualization is the solution. Virtual databases and file-systems only consume space from deltas, so it is possible to provision multiple terabytes for megabytes. Coders and testers have full environments fast in which to develop and test, improving code quality. Learn about the technical details behind this solutio

SessionID: 50014

Battle Scars: Porting a SQL Server app to an MPP system

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Business Intelligence

Speaker: Aaron Cutshall

Title: Battle Scars: Porting a SQL Server app to an MPP system

Abstract:

Battle scars are proof of the struggles endured and won. Find out about one particular battle in porting a SQL Server application to Netezza. In this session, we’ll review Big Data platform options and the differences between them. We’ll see how Massively Parallel Processor (MPP) systems (like Netezza) are different from Symmetric Multi-Processor (SMP) systems (like SQL Server) and witness the lessons learned in the struggle.

SessionID: 52742

HDInsight - Hadoop for the Commoner

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Big Data

Speaker: Matt Stenzel

Title: HDInsight - Hadoop for the Commoner

Abstract:

Setting up a Hadoop cluster can be a long, expensive and frustrating experience. Adding nodes can take days, weeks, or months. What if you could have a Hadoop cluster up and running in 20 mins and could add nodes in minutes? Come to this demo heavy session on provisioning HDInsight and wrangle some data!

SessionID: 53052

SQL Server in Azure: Essentials for the Database Administrator

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Jes Schultz

Title: SQL Server in Azure: Essentials for the Database Administrator

Abstract:

With the constant expansion and improvement of Microsoft Azure, there are several data options available - including SQL Server VMs and SQL Database. As a database administrator, what do you need to know to use them effectively? In this session, I'll cover why you want to use SQL Server in Azure, what to know before you choose a service, and how to effectively perform administrative tasks such as backups, restores, and automating tasks.

SessionID: 53615

SQL Server 2016 - New Feature Preview

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: SQL Server

Speaker: Riley Major

Title: SQL Server 2016 - New Feature Preview

Abstract:

SQL Server 2016 is here. Curious what all the hype is about?

We#39;ll take a stroll down memory lane to remind us how far we#39;ve come and then explore some of the brand new features.

Time travel with Temporal Tables. Watch the gears turn with Live Query Statistics. Go shopping in the Query Store. And impress your developer friends with some freshly minted JSON.

Maybe we#39;ll even figure out how to bottle up that new version smell.

SessionID: 53622

Managing SQL Server Performance with Extended Events

Back to calendar

Event Date: 01-10-2016 - Session time: 13:30:00 - Track: Database Administration

Speaker: Jason Strate

Title: Managing SQL Server Performance with Extended Events

Abstract:

One of a DBA#39;s primary responsibilities is managing the performance of a SQL Server environment. When performance problems arise, DBAs need to have the correct tools in place to be able to dig in and discover the issues that are occurring. Although it#39;s one of the newer tools in the DBA toolbox, Extended Events is one of the most powerful tools available. In this session, we will discuss performance management responsibilities for DBAs and provide a foundation, through Extended Events, to understand and resolve performance issues.

SessionID: 50307

Automated Restore Script Output for Ola Hallengren’s Maintenance Solution

Back to calendar

Event Date: 01-10-2016 - Session time: 14:45:00 - Track: Database Administration

Speaker: Jared Zagelbaum

Title: Automated Restore Script Output for Ola Hallengren’s Maintenance Solution

Abstract:

This session is designed to be useful to two different audiences:

1.Those implementing Ola Hallengren’s Maintenance Solution for the first time. (Or don't even know what the Maintenance Solution is!) 2.Those that have been using it for awhile, but might have a hole in their DR plan – what to restore when a resource goes offline.

We will do an overview of the maintenance solution to start, then get down and dirty with the guts of the extension. What I am presenting is a custom extension that works out of the box for jobs created using the maintenance solution. The scripts will add an additional job step to all DatabaseBackup jobs which will output a text file that contains the most current restore scripts for each database in the instance. If you don't know what I just described in that last paragraph, you should come to this session and that will be explained as well!

SessionID: 50357

SQL Server Quiz Show

Back to calendar

Event Date: 01-10-2016 - Session time: 14:45:00 - Track: SQL Server

Speaker: Eric Zierdt

Title: SQL Server Quiz Show

Abstract:

You are invited to be a participant on the SQL Server Quiz Show; this interactive session will test your knowledge on many different areas of SQL Server. We will be using an online tool to allow you to submit your answers to questions via mobile device or laptop, but don#39;t worry, total scores are only shown to yourself, so you don#39;t have to worry about competing against others.

This session promises to be fast paced and fun and hopefully you will even learn something. This session will also be of value to people who need to interview or be interviewed for SQL Server positions as the questions may be the type of things you might hear in an interview.

SessionID: 50806

Cardinality estimation and how it affects your execution plan

Back to calendar

Event Date: 01-10-2016 - Session time: 14:45:00 - Track: Database Development

Speaker: Zane Brunette

Title: Cardinality estimation and how it affects your execution plan

Abstract:

What is cardinality estimation and how statistics affect your execution plan. In this session we'll cover the mechanics behind cardinality estimation and why it is so critical to query performance. We will also be discussing some of the changes that were made to the estimator in SQL Server 2014 and how you can benefit from these changes.

SessionID: 53468

Power BI Performance Tips

Back to calendar

Event Date: 01-10-2016 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Rachael Martino

Title: Power BI Performance Tips

Abstract:

It is quick and easy to build large, complex data models in Power BI (based on Power Pivot). However, building a model that performs well might seem hit or miss unless you are aware of how Power BI manages your data. This session provides design techniques and tips that will have you building your own models to deliver solutions without those nasty performance surprises!

SessionID: 53556

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 01-10-2016 - Session time: 14:45:00 - Track: Database Administration

Speaker: Brian Hansen

Title: Get Your Optimizer to Give up All Its Secrets

Abstract:

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We#39;ll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn#39;t do it as well as might be hoped), you can write more efficient SQL statements.

SessionID: 53592

Getting Started Making Technical Videos

Back to calendar

Event Date: 01-10-2016 - Session time: 14:45:00 - Track: Professional Development

Speaker: Doug Lane

Title: Getting Started Making Technical Videos

Abstract:

Topics we#39;ll cover include: The essential steps of planning, shooting, editing, and publishing your video; the best video-making gear to buy for any budget, and how to get the most out of that gear; how to make your video stand out from the rest on platforms like YouTube and Vimeo; how videos have a unique way of connecting you and your material to your audience.

You#39;ll hear my insider tips and lessons I#39;ve learned from years of creating technical training videos. You#39;ll learn mistakes that even experienced video creators make, and how to avoid them. We#39;ll also tear down the myths and misconceptions that are holding you back from getting started.

SessionID: 53600

Dimensional Modeling Design Patterns: Beyond the Basics

Back to calendar

Event Date: 01-10-2016 - Session time: 14:45:00 - Track: Business Intelligence

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond the Basics

Abstract:

Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.

In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.

SessionID: 53668

JSON for the DBA

Back to calendar

Event Date: 01-10-2016 - Session time: 14:45:00 - Track: Database Administration

Speaker: Jim Dorame

Title: JSON for the DBA

Abstract:

In SQL Server 2016 Microsoft has include native handling of JSON. What does that mean? What is JSON? Why do I care? Will there be knives and hockey masks? Come to this session and you will learn what JSON is, where and how it is used and why as a DBA you need to know this.

SessionID: 50061

Insider Secrets to Securing the Budget You Need

Back to calendar

Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Database Administration

Speaker: Maxwell Myrick

Title: Insider Secrets to Securing the Budget You Need

Abstract:

How many times has a lack of budget for hardware, training, or expert assistance caused problems for you in designing, implementing, and maintaining a great SQL Server environment? Come to this session to learn effective ways to secure the budget you need instead of being consistently required to do more with less, or worse – nothing. The good news is that there are several simple and practical things you can do to vastly improve your ability to get the budget you need when you need it. You will hear how to think like an executive from someone who was one for many years so you can begin to influence decisions at the right level to get what both you and your SQL Server infrastructure need.

SessionID: 50549

Free SQL Server Tools

Back to calendar

Event Date: 01-10-2016 - Session time: 16:00:00 - Track: SQL Server

Speaker: Cecil Spivey

Title: Free SQL Server Tools

Abstract:

Everybody loves a free lunch. Come to this session to learn about all the SQL Server freebees.

SessionID: 50759

Virtual SQL Servers. Actual Performance.

Back to calendar

Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Database Administration

Speaker: David Klee

Title: Virtual SQL Servers. Actual Performance.

Abstract:

Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

SessionID: 53171

Introducing the R Language to the Data Professional

Back to calendar

Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Business Intelligence

Speaker: Ginger Grant

Title: Introducing the R Language to the Data Professional

Abstract:

Interest in the R language is has grown along with the amount of data being accumulated. As Microsoft is now incorporating the R language into SQL Server 2016, the language is going to be a required skill for all data professionals in the near future. The demand for R skills is high as it routinely makes the list of the most in-demand languages to learn. In this class users will get hands on instruction in Microsoft R Open. Students will learn how to create a simple program with graphical output, incorporate R in stored procedures within SQL Server 2016, and how to call an R program within Azure ML.

Session Agenda • History and Introduction to the R Language. • Walk through of Microsoft R Open • Class Exercise of writing Hello World in R • When and How to uses R Language Libraries • Class Exercise of R code with Graphical Output • Common uses and best fit for R programs • Develop R program for Data Integration. • Integration of R code into SQL Server 2016 • Adding R to

SessionID: 53357

Query Plans and Indexes in SQL Server 2016

Back to calendar

Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Database Development

Speaker: Michael DeFehr

Title: Query Plans and Indexes in SQL Server 2016

Abstract:

Data access can be easy to set up in your applications with wizards and ORMs, but sometimes your queries are just not as fast as you think they should be – especially on those tables that are getting bigger and bigger. In this session, we will take a peek under the hood and see how SQL server answers the questions you ask of it. This is an introductory session, but it will be jam-packed with demos and useful tips that you will be able to use to make your applications more responsive.

SessionID: 53506

Apache Spark and SQL Server: Perfect Together!

Back to calendar

Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Big Data

Speaker: Rowland Gosling

Title: Apache Spark and SQL Server: Perfect Together!

Abstract:

We’ll examine how to leverage big data to extend SQL Server particularly around archive patterns. Demos include moving data into Hadoop for query and batch processing as wells as leveraging Spark for fast batch processing.

SessionID: 53654

Ask the Experts Panel

Back to calendar

Event Date: 01-10-2016 - Session time: 16:00:00 - Track: SQL Server

Speaker: Jim Horn

Title: Ask the Experts Panel

Abstract:

A panel of SQL Server experts take on all questions..

SessionID: 54081

Shape It: Shaping and Modelling Data With Power BI Desktop

Back to calendar

Event Date: 01-10-2016 - Session time: 16:00:00 - Track: Business Intelligence

Speaker: Mark Vaillancourt

Title: Shape It: Shaping and Modelling Data With Power BI Desktop

Abstract:

In this demo-rich session, we will delve into using various data sources (SQL Server, Excel, Folder, Enter Data, and more) to Get Data into Power BI Desktop. We will shape and clean that data using the fantastic transformation options available in the Query interface (based on Power Query). We will show how to use M (Power Query Formula Language) to create useful, reusable functions and perform meaningful transformations not supported by the graphical interface. We will discuss the basics of Dimensional Modelling and apply those practices to our Power BI Desktop model. By the end of the session, we will have created a meaningful, useful data model from multiple data sources using the outstanding functionality provided by Power BI Desktop.

This site is open source. Improve this page.