sqlsathistory

Nr: 431

Back to Main list

SQLSaturday #431 - Spartanburg 2015

Start Time (24h) Speaker Track Title
08:15:00 William E Pearson III Business Intelligence Getting Started with Analysis Services 2012 Tabular
08:15:00 Justin Randall Enterprise Database Administration Deployment SQL Server Performance Fundamentals: Building and Maintaining a Solid Foundation
08:15:00 Andy Leonard Data Integration Designing an SSIS Framework in 2015
08:15:00 Dale Burnett Application Database Development The Basics of SQL Injection
08:15:00 John Morehouse Professional Development Social Networking Is Alive!!!
08:15:00 Mike Lawell Application Database Development Execution Plans for Mere Mortals
09:30:00 Brandon Leach Enterprise Database Administration Deployment Data Pages, Allocation Units, IAM chains... Oh My! - Storage Inte
09:30:00 William E Pearson III Business Intelligence Getting Started with MDX
09:30:00 Geoff Hiten Professional Development Smart Rats Leave First
09:30:00 Kathi Kellenberger Application Database Development T-SQL Window Function Performance
09:30:00 John Welch Data Integration Advanced Scripting Using SSIS Script Tasks and Components
09:30:00 John Morehouse DevOps Database Continuous Delivery Your Salvation!
10:45:00 Rob Volk Application Database Development Tame Your Unruly Data...With Constraints!
10:45:00 Justin Randall Professional Development Building Your Yellow Brick Road: Directing Your Path to a Success
10:45:00 Andy Leonard Data Integration Using BIML as an SSIS Design Patterns Engine
10:45:00 John Deardurff Application Database Development What's your Character Data Type?
10:45:00 Andrew Maxwell Enterprise Database Administration Deployment Clustering... the SQL Server Way
10:45:00 Patrick LeBlanc Business Intelligence Everything you Want to know about Power BI dependency on Office 3
13:15:00 Thomas Norman DevOps Converting Unreliable Deployments Into Consistent Releases
13:15:00 Geoff Hiten Application Database Development What’s your Imperative doing in my Declarative?
13:15:00 Ed Watson Enterprise Database Administration Deployment Performance Tuning for Mere Mortals Part I
13:15:00 Ed Watson Enterprise Database Administration Deployment Backup Strategies are for Losers!
13:15:00 John Deardurff Application Database Development The PROCESS of queries
13:15:00 Paco Gonzalez Data Integration Tone Analysis with HDInsight and Azure Machine Learning
13:15:00 Kiran Math Business Intelligence Introduction To R for SQL Developers
14:30:00 Wayne Sheffield Application Database Development Table Vars and Temp Tables – What you NEED to Know!
14:30:00 Ryan Brickey Enterprise Database Administration Deployment DBA’s1st Date - Getting to know a new environment
14:30:00 Jake Switzer Business Intelligence R with AzureML
14:30:00 Jim Christopher Business Intelligence Closing the SSIS Package Management Story with BIPS
14:30:00 John Morehouse Enterprise Database Administration Deployment Only You Can Prevent Database Fires!
14:30:00 Karlyn LeBlanc Professional Development Balancing Work and Home to Create a Better You
14:30:00 Julie Smith Data Integration Master Data Management with MDS, DQS and SSIS
15:45:00 Dave Turpin Enterprise Database Administration Deployment De-Mystifying Query Plans: Focus on the Cardinality Estimator
15:45:00 miguel Cebollero Application Database Development SQL Server 2014 In-Memory Programming
15:45:00 Monica Rathbun Professional Development I'm It - Survival Techniques for the Lone DBA
15:45:00 Patrick LeBlanc Business Intelligence Introduction to the Power BI Desktop
15:45:00 John Welch DevOps Testing Data and Data-Centric Applications
15:45:00 Julie Smith Data Integration Azure Data Factory: My Data Wandered Lonely as a CLOUD.

SessionID: 36226

Getting Started with Analysis Services 2012 Tabular

Back to calendar

Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Business Intelligence

Speaker: William E Pearson III

Title: Getting Started with Analysis Services 2012 Tabular

Abstract:

The Analysis Services 2012 Business Intelligence Semantic Model (BISM) unifies Multidimensional (OLAP) and Tabular (relational) options for organizational BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson introduces Microsoft Business Intelligence 2012 and the Business Intelligence Semantic Model ("BISM"). He then overviews the Tabular model, beginning with the creation of a project with SQL Server Data Tools (“SSDT”), and continuing from the data import steps to the creation and management of calculations, measures and Key Performance Indicators (“KPIs”). Finally, he provides insight to the creation and maintenance of perspectives and hierarchies, as well as other considerations involved in working with Tabular.

SessionID: 36576

SQL Server Performance Fundamentals: Building and Maintaining a Solid Foundation

Back to calendar

Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Justin Randall

Title: SQL Server Performance Fundamentals: Building and Maintaining a Solid Foundation

Abstract:

Achieving great performance from your SQL Servers can be elusive. Yet for most production systems it starts with the right resources, correct configuration, and ongoing maintenance. In this session you will learn the basics of building and maintaining robust, healthy SQL Servers. You will also become familiar with the fundamentals of SQL Server performance monitoring to vastly improve your ability to detect and correct performance issues before your users know about them

SessionID: 36836

Designing an SSIS Framework in 2015

Back to calendar

Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Data Integration

Speaker: Andy Leonard

Title: Designing an SSIS Framework in 2015

Abstract:

Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building on his previous work in the field of Data Integration Life Cycle Management (DILM) and SSIS Frameworks development, a Data Integration Architect with 10 years of SSIS experience explains the what, why, and how of an SSIS Catalog-integrated Framework that delivers metadata-driven package execution, connections management, and parameter configuration.

In this session, you will learn:

SessionID: 38364

The Basics of SQL Injection

Back to calendar

Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Dale Burnett

Title: The Basics of SQL Injection

Abstract:

The vulnerability of SQL based database systems to injection attacks is one of the top data security issues today. In this session I explain how SQL Injection works and demonstrate SQL injection on a test ASP.NET website. I will close the session with information on how to prevent injection attacks and provide resources for more detailed information.

SessionID: 39289

Social Networking Is Alive!!!

Back to calendar

Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Professional Development

Speaker: John Morehouse

Title: Social Networking Is Alive!!!

Abstract:

Social Networking and Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter? Can you believe Susie moved to that company? Do any of those sound familiar? No? Never heard of Twitter or LinkedIn? Have no fear, this is the session for you! Social networking can be a very confusing and intimidating place. What makes it even worse, is when you have no clue even where to start. In this session, we will go over different facets of Social Networking and Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. For example, did you know you can get help from some of the top minds in the SQL Server profession by using the #SQLHELP hash tag for free? We will show you how! We'll be covering that and more using Facebook, LinkedIn and Twitter.

SessionID: 40361

Execution Plans for Mere Mortals

Back to calendar

Event Date: 26-09-2015 - Session time: 08:15:00 - Track: Application Database Development

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

For beginning database professionals, execution plans can be intimidating. This session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes 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 and save it for analysis and comparison after modifications.

SessionID: 36210

Data Pages, Allocation Units, IAM chains... Oh My! - Storage Inte

Back to calendar

Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Leach

Title: Data Pages, Allocation Units, IAM chains... Oh My! - Storage Inte

Abstract:

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. In this session we’ll take a look at how objects such as tables and indexes are stored in the data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.

SessionID: 36230

Getting Started with MDX

Back to calendar

Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Business Intelligence

Speaker: William E Pearson III

Title: Getting Started with MDX

Abstract:

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.

SessionID: 36552

Smart Rats Leave First

Back to calendar

Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Professional Development

Speaker: Geoff Hiten

Title: Smart Rats Leave First

Abstract:

IT jobs are notoriously short-lived, with most only lasting a few years. Very few people keep a single employer for their entire career. Knowing when, why, and how to leave your job is as important a career step as finding new work. Learn about how to use job transitions as opportunities to develop your career.

SessionID: 38508

T-SQL Window Function Performance

Back to calendar

Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Kathi Kellenberger

Title: T-SQL Window Function Performance

Abstract:

Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

SessionID: 39102

Advanced Scripting Using SSIS Script Tasks and Components

Back to calendar

Event Date: 26-09-2015 - Session time: 09:30:00 - Track: Data Integration

Speaker: John Welch

Title: Advanced Scripting Using SSIS Script Tasks and Components

Abstract:

SSIS has many great built-in tasks and components. Sometime, though, you need to go further than what they allow. Come to this session to see how far you can stretch the scripting capabilities of SSIS.

SSIS offers significant capabilities out-of-the-box. However, many data movement projects have needs that go above and beyond the common scenarios. Have you ever needed to calculate running totals during your ETL process? What about using dynamically updated business rules during processing to determine what data is valid? These things, and much more, can be accomplished using the script task and component within SSIS. During this session, we will demonstrate several scripts in SSIS (including the ones mentioned above) that show how to take full advantage of the capabilities of SSIS. This session is intended for people who have worked with and understand SSIS, and have a basic understanding of .NET development.

SessionID: 39287

Database Continuous Delivery Your Salvation!

Back to calendar

Event Date: 26-09-2015 - Session time: 09:30:00 - Track: DevOps

Speaker: John Morehouse

Title: Database Continuous Delivery Your Salvation!

Abstract:

Continuous Integration Delivery isn’t a new concept. Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up. Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I'll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments. We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.

SessionID: 36220

Tame Your Unruly Data...With Constraints!

Back to calendar

Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data...With Constraints!

Abstract:

Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!

SessionID: 36651

Building Your Yellow Brick Road: Directing Your Path to a Success

Back to calendar

Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Professional Development

Speaker: Justin Randall

Title: Building Your Yellow Brick Road: Directing Your Path to a Success

Abstract:

For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.

SessionID: 36834

Using BIML as an SSIS Design Patterns Engine

Back to calendar

Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Data Integration

Speaker: Andy Leonard

Title: Using BIML as an SSIS Design Patterns Engine

Abstract:

Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session.

SessionID: 37361

What's your Character Data Type?

Back to calendar

Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Application Database Development

Speaker: John Deardurff

Title: What's your Character Data Type?

Abstract:

This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.

SessionID: 38409

Clustering... the SQL Server Way

Back to calendar

Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Maxwell

Title: Clustering... the SQL Server Way

Abstract:

Beginning with a two node Windows cluster with shared storage, I will walk you though setting up SQL Server as a clustered resource.

SessionID: 39041

Everything you Want to know about Power BI dependency on Office 3

Back to calendar

Event Date: 26-09-2015 - Session time: 10:45:00 - Track: Business Intelligence

Speaker: Patrick LeBlanc

Title: Everything you Want to know about Power BI dependency on Office 3

Abstract:

For most users, you will sign up to use Power BI and never know that Office 365 is the background. For organizations that want to leverage the advanced features of Power BI, you MAY need to perform certain configurations within Office 365. Since most people do not realize that Office 365 is used under hood of Power BI, we will show you how to properly prepare your organization for the new Power BI service. In this demo heavy session we will dispel the myth that you may not need Office 365 to access the full capabilities Power BI. For most users, you will sign up to use Power BI and never know that Office 365 is the background. For organizations that want to leverage the advanced features of Power BI, you MAY need to perform certain configurations within Office 365. Since most people do not realize that Office 365 is used under hood of Power BI, we will show you how to properly prepare your organization for the new Power BI service. In this demo heavy session we will dispel t

SessionID: 36225

Converting Unreliable Deployments Into Consistent Releases

Back to calendar

Event Date: 26-09-2015 - Session time: 13:15:00 - Track: DevOps

Speaker: Thomas Norman

Title: Converting Unreliable Deployments Into Consistent Releases

Abstract:

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or the incorrect version. Each database is made up of a lot of objects in different environments. When you create an object like a table or stored procedure, you need to get this object deployed into each environment. Together we will discover how to separate each object for proper order deployment while releasing only objects which have changed. Deployments can cause you trouble but we will provide a reliable deployment and version control process.

SessionID: 36266

What’s your Imperative doing in my Declarative?

Back to calendar

Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Application 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: 36272

Performance Tuning for Mere Mortals Part I

Back to calendar

Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Watson

Title: Performance Tuning for Mere Mortals Part I

Abstract:

In this first part of a two part series, we look at performance tuning from the very beginning. You're a new DBA, you want to be a DBA, or you've been declared an "Accidental DBA" and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now? The application is running slowly. Can you help them? Do you even know where to begin to help them? In this session we'll cover how to handle performance tuning from the very beginning, when the user says "The database is slow."

SessionID: 36273

Backup Strategies are for Losers!

Back to calendar

Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Watson

Title: Backup Strategies are for Losers!

Abstract:

Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy!

SessionID: 37362

The PROCESS of queries

Back to calendar

Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Application Database Development

Speaker: John Deardurff

Title: The PROCESS of queries

Abstract:

This session focuses on the PROCESS of queries and how this effects Optimization, Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.

SessionID: 37565

Tone Analysis with HDInsight and Azure Machine Learning

Back to calendar

Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Data Integration

Speaker: Paco Gonzalez

Title: Tone Analysis with HDInsight and Azure Machine Learning

Abstract:

People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning

SessionID: 39126

Introduction To R for SQL Developers

Back to calendar

Event Date: 26-09-2015 - Session time: 13:15:00 - Track: Business Intelligence

Speaker: Kiran Math

Title: Introduction To R for SQL Developers

Abstract:

In this session we will explore

  1. Installation of R and R Studio
  2. R basics
  3. Power of R
  4. Getting data from databases and other sources.
  5. Managing Data frame using package dplyr
  6. Visualization of Data using Graphic package ggplots
  7. In-Database R in SQL Server 2016

SessionID: 36215

Table Vars and Temp Tables – What you NEED to Know!

Back to calendar

Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Wayne Sheffield

Title: Table Vars and Temp Tables – What you NEED to Know!

Abstract:

Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"

SessionID: 36237

DBA’s1st Date - Getting to know a new environment

Back to calendar

Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ryan Brickey

Title: DBA’s1st Date - Getting to know a new environment

Abstract:

With more entry level DBA positions becoming available, and non-DBA’s shifting into DBA roles, you may find yourself in a position where you need to become familiar with a new server environment quickly and efficiently but not know where to begin. In this session we will review some standard practices and personal experiences that have helped efficiently identify and spec out a new environment.

SessionID: 38096

R with AzureML

Back to calendar

Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Business Intelligence

Speaker: Jake Switzer

Title: R with AzureML

Abstract:

SessionID: 38738

Closing the SSIS Package Management Story with BIPS

Back to calendar

Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Business Intelligence

Speaker: Jim Christopher

Title: Closing the SSIS Package Management Story with BIPS

Abstract:

Existing SSIS automation solutions are focused on forward-motion activities: creating packages and pushing them to the server. Little or no thought is given to the management of the packages once they are in production - existing tooling offers nothing to help you understand and manage a live, money-printing ETL workflow based on SSIS packages.

BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell. It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it. In short, the goal of BIPS brings a devops perspective to managing your SSIS packages.

In this session, you will learn how to leverage BIPS in your own environment. Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell.

SessionID: 39288

Only You Can Prevent Database Fires!

Back to calendar

Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: John Morehouse

Title: Only You Can Prevent Database Fires!

Abstract:

Do you find yourself constantly putting out "fires"? Can't take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as "fire prevention" to stop the "fire fighting". We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!

SessionID: 39396

Balancing Work and Home to Create a Better You

Back to calendar

Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Balancing Work and Home to Create a Better You

Abstract:

If you are a working professional there is a chance that your career has interrupted your life and you've forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.

SessionID: 39538

Master Data Management with MDS, DQS and SSIS

Back to calendar

Event Date: 26-09-2015 - Session time: 14:30:00 - Track: Data Integration

Speaker: Julie Smith

Title: Master Data Management with MDS, DQS and SSIS

Abstract:

Join Audrey Hammonds and Julie Smith present lessons learned from their most recent projects using the Microsoft Master Data Management tools. This session covers automated batch processing as well as the data stewardship workflow.

SessionID: 36276

De-Mystifying Query Plans: Focus on the Cardinality Estimator

Back to calendar

Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Turpin

Title: De-Mystifying Query Plans: Focus on the Cardinality Estimator

Abstract:

The SQL Server optimizer is an engineering marvel. The intelligence that is built into the product is mind bending. But, sometimes queries don't run as expected. Without a basic understanding of statistics and the cardinality estimator you'll never know why.

This session will walk through an anomaly of the cardinality estimator called The Ascending Key Problem. A major focus of the discussion will include how the optimizer uses statistics to estimate row counts, which is ultimately used to build optimal query plans.

At the end of this session you will know how to assess the state of the statistics for your indexes and columns; you will know how to look at your query plans in a way that will help prevent poor query performance BEFORE the query executes; and you will better understand how the optimizer estimates row counts.

SessionID: 36393

SQL Server 2014 In-Memory Programming

Back to calendar

Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Application Database Development

Speaker: miguel Cebollero

Title: SQL Server 2014 In-Memory Programming

Abstract:

SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.

SessionID: 37777

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Professional Development

Speaker: Monica Rathbun

Title: I'm It - Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 39044

Introduction to the Power BI Desktop

Back to calendar

Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Business Intelligence

Speaker: Patrick LeBlanc

Title: Introduction to the Power BI Desktop

Abstract:

Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.

SessionID: 39104

Testing Data and Data-Centric Applications

Back to calendar

Event Date: 26-09-2015 - Session time: 15:45:00 - Track: DevOps

Speaker: John Welch

Title: Testing Data and Data-Centric Applications

Abstract:

Testing applications that depend on data can be hard. Everyone agrees that testing is vital, but knowing what to test and how to test it is challenging. Come to this session for a methodology for testing your data, and the applications that use it.

Testing is vital to fast, successful delivery of software and information today. While application testing is generally well understood, data centric testing is not. The success of many applications depends on them producing valid, correct data, yet this is often tested as an afterthought, or not tested at all. During this session, we will discuss how to test the data produced by applications or data movement processes. We’ll cover how to determine the accuracy and quality of your data, and how to incorporate the testing into your data lifecycle. The focus will be on what you need to test, and the techniques for validating that the data produced is accurate.

SessionID: 39543

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

Back to calendar

Event Date: 26-09-2015 - Session time: 15:45:00 - Track: Data Integration

Speaker: Julie Smith

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

Abstract:

This is an absolute beginner session on Azure Data Factory. I will cover basic terms and operations and show how to move your data the Azure way.