sqlsathistory

Nr: 390

Back to Main list

SQLSaturday #390 - Philadelphia 2015

Start Time (24h) Speaker Track Title
00:00:00 David Bermingham BI 1 Everything you were afraid to ask about cluster quorums, explained
00:00:00 Kevin Feasel Dev 2 APPLY Yourself
00:00:00 Hilary Cotter BI 1 Replicaton Technologies
00:00:00 John Deardurff Advanced What's your Character Type?
00:00:00 Kevin Goff BI 1 Absolute Introductory Session on SQL Server 2014 In-Memory Optimized Databases (Hekaton)
00:00:00 Robert Pearl Advanced HealthySQL III
00:00:00 Samuel Vanga Dev 1 Automating Your SSIS Design Pattern for Faster Development
00:00:00 Wayne Sheffield BI 2 Table Vars Temp Tables - What you NEED to Know!
00:00:00 Mark Wojciechowicz BI 1 Maximizing Failure with Continuous Integration
08:30:00 Ayman El-Ghazali Dev 1 To SSAS or not to SSAS, that is the question
08:30:00 Hilary Cotter BI 2 Stress testing SQL Server
08:30:00 Steve Jones BI 1 Continuous Integration for Databases
08:30:00 Warner Chaves BI 2 The Restore Cookbook
08:30:00 Rick Heiges BI 1 Interviews and Resumes
08:30:00 Allen White BI 2 Automate Your ETL Infrastructure with SSIS and PowerShell
08:30:00 Bob Blackburn BI 1 Agile Data Warehouse Development
08:30:00 Sean McCown BI 1 Minion Maintenance and Backup Solutions
09:45:00 George Walters BI 1 Hybrid Cloud Scenarios with SQL Server 2014
09:45:00 Kevin Goff DBA 2 Change Data Capture in SQL Server 2008/2012
09:45:00 Robert Pearl BI 1 Social DBA
09:45:00 Slava Murygin Dev 2 Get Familiar with Spatial Data
09:45:00 J May BI 2 Flash and SQL Server— Re-Thinking Best Practices
09:45:00 Mark Wojciechowicz BI 1 Punishing Yourself with Continuous Delivery
09:45:00 Christopher Exley DBA 2 Master Data Services– Integration through SSIS
09:45:00 Justin Dearing Advanced Beginning PowerShell Scripting
11:00:00 James Serra BI 1 Building an Effective Data Warehouse Architecture
11:00:00 Kevin Goff Advanced Beginner TSQL
11:00:00 Judith Moffitt Dev 2 Data Meaning
11:00:00 Denny Cherry BI 2 Storage For the DBA
11:00:00 Sharon Dooley Dev 2 SQL Server 2014 Optimizer “Goodies”
11:00:00 Justin Dearing BI 1 Version control with GIT for the DBA
11:00:00 Timothy McAliley BI 1 A "101" Overview of Microsoft Power BI for Office 365
11:00:00 Kerry Tyler Dev 1 Connecting Power BI to On-Prem SSAS Tabular
12:30:00 SIOS Technology Advanced Clusters Your Way: #SANLess Clusters for Physical, Virtual Cloud Environ.
13:30:00 William Wolf Dev 2 Common Coding Mistakes and how to Mitigate them
13:30:00 Danette Riviello BI 2 Become a SQL Server Performance Detective
13:30:00 John Miner BI 1 Azure SQL Database (Software As A Service)
13:30:00 Sebastian Meine BI 1 SQL Server Cryptology - A Primer
13:30:00 Jason Brimhall BI 2 Getting to Know Your DB
13:30:00 Sharon Dooley Advanced What's an execution plan and why does it matter?
13:30:00 Bill Emmert BI 1 What's New in SQL Server vNext
13:30:00 Sean McCown BI 2 Monster Text Manipulation: Regular Expressions for the DBA
13:30:00 Karen Lopez DBA 1 Panel: Will the DBA Job of the Future Still Involve DBAs?
14:45:00 Chris Bell BI 1 Optimizing Protected Indexes
14:45:00 Paul Rizza BI 1 Shortcuts to Building SSIS in .Net
14:45:00 Warren Sifre DBA 2 Leveraging CDC and SSIS for ODS/DM/DW Loads
14:45:00 Wayne Sheffield Dev 2 Crazy Things Developers Do
14:45:00 David Maxwell BI 1 DBA 911 - Database Corruption
14:45:00 Dan Clark DBA 2 Creating a Solid Data Model for PowerPivot
14:45:00 Ike Ellis Dev 1 60 Reporting Tips in 60 Minutes
16:00:00 Samuel Vanga DBA 2 From Zero to Loading a Data Warehouse
16:00:00 Konstantin Melamud BI 1 Performance Tuning - Analyzing Execution Plans
16:00:00 Randy Knight BI 1 But it worked great in Dev! Perfomance for Devs
16:00:00 Karen Lopez Beginner The Ticking Timebombs in Your Databases
16:00:00 Ravi Gudlavalleti Dev 1 Visual Studio Online for cost effective code and Project Mgmt
16:00:00 Chris Bell Advanced You Want Me To Do What? SQL Security Basics
16:00:00 Adam Belebczuk BI 1 Availability Groups 101: An Introduction

SessionID: 12412

Everything you were afraid to ask about cluster quorums, explained

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 1

Speaker: David Bermingham

Title: Everything you were afraid to ask about cluster quorums, explained

Abstract:

In this deep dive Cluster MVP Dave Bermingham will take a look at cluster quorum options and how they have evolved over the years. Starting with Disk only quorums and ending with Cloud Witness, by the end of this session you should understand this most commonly misunderstood cluster concept and be ready to tackle your next AlwaysOn Availability Groups deployment or AlwaysOn Failover Cluster Instance implementation. Multisite and SANLess clusters will be discussed as well as the implications of Dynamic Quorum and Dynamic Witness.

SessionID: 14224

APPLY Yourself

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Dev 2

Speaker: Kevin Feasel

Title: APPLY Yourself

Abstract:

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

SessionID: 14991

Replicaton Technologies

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 1

Speaker: Hilary Cotter

Title: Replicaton Technologies

Abstract:

Replication is a native SQL Server component which is used for copying, distribution and aggregating data between databases and servers. In this presentation SQL Server MVP discusses the different replication types and technologies and their sweet points. He also shows common use cases, gotcha's, and performance tuning and troubleshooting techniques.

SessionID: 17216

What's your Character Type?

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Advanced

Speaker: John Deardurff

Title: What's your Character 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: 18346

Absolute Introductory Session on SQL Server 2014 In-Memory Optimized Databases (Hekaton)

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 1

Speaker: Kevin Goff

Title: Absolute Introductory Session on SQL Server 2014 In-Memory Optimized Databases (Hekaton)

Abstract:

Hekaton is Microsoft’s code word for their new OLTP in-memory, optimized data processing option for frequently-used tables in SQL Server 2014. In certain instances, Hekaton can yield performance gains of over 10x. This session will cover the benefits of Hekaton, why developers and DBAs would want to use Hekaton, and the different options for creating Hekaton tables. We’ll also look at the native-code stored procedure optimizations when using Hekaton. Additionally, this session will show the range and limitations of Hekaton and how it differs from traditional SQL Server tables (such as transaction handling). Along the way, the session will have several code demonstrations where we’ll look at performance benchmarks. If you’ve heard about Hekaton and in-memory optimizations and terms such as ‘latch and lock free structures’ and wondered what it all means, this session is for you!

SessionID: 23555

HealthySQL III

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Advanced

Speaker: Robert Pearl

Title: HealthySQL III

Abstract:

Are your SQL Servers Healthy? Are all the SQL Servers you manage, healthy running optimally and has the high availability that is expected? How do you know for sure? Have you checked on the health of your SQL Servers lately? What is a HealthCheck, and how do we perform one? If you are a DBA, then you ought to know! Well Pearl Knows. Robert Pearl talks about the importance of regular health checks of your SQL Server(s). We will talk about the need to create a baseline and provide some time-tested ways to determine if your SQL Servers are healthy and prove it to your managers, clients and heaven forbid, your IT auditors. Using various tools and scripts, you will come out of this session feeling much better :-)

SessionID: 23915

Automating Your SSIS Design Pattern for Faster Development

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: Dev 1

Speaker: Samuel Vanga

Title: Automating Your SSIS Design Pattern for Faster Development

Abstract:

Once you finish designing the SSIS packages needed for your project, the process of creating those packages is mostly redundant and time-consuming. As the source or target systems go through changes (even as small as a column rename), you’re forced to modify the packages.

BI Markup Language (BIML), which is a free plugin, removes the pain-points involved in manual development by programmatically generating packages. In this session, you’ll learn the basics of BIML and see how you can use it along with metadata to create packages automatically. You’ll also see how easy it is to regenerate the packages when the system changes. You’ll leave the session with knowledge of BIML’s building blocks and a principle I call “D[ee]MOB” that helps you automate SSIS development in your environment.

SessionID: 27774

Table Vars Temp Tables - What you NEED to Know!

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 2

Speaker: Wayne Sheffield

Title: Table Vars 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 represent 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: 35780

Maximizing Failure with Continuous Integration

Back to calendar

Event Date: 06-06-2015 - Session time: 00:00:00 - Track: BI 1

Speaker: Mark Wojciechowicz

Title: Maximizing Failure with Continuous Integration

Abstract:

Continuous Integration (CI) is an Agile methodology which enables teams to quickly find bugs in their code and fix them before they reach production. The goal of CI is to always have a working product that can be deployed at any time. Through its practice, developers fail faster and more often than ever before, allowing the developer to fix problems while they are fresh in the mind. This session will cover the basics of CI and show how this can be implemented in a Business Intelligence environment.

SessionID: 10103

To SSAS or not to SSAS, that is the question

Back to calendar

Event Date: 06-06-2015 - Session time: 08:30:00 - Track: Dev 1

Speaker: Ayman El-Ghazali

Title: To SSAS or not to SSAS, that is the question

Abstract:

Have you every wondered if you should be using SSAS? Are you curious about learning the basics? Then this is the talk for you! Join us as we explore the basics of Multi-Dimensional and Tabular SSAS solutions. We will connect solutions with Excel and demonstrate how Power View and other data visualizations work. After this session you will feel more comfortable starting your own solutions with SSAS.

SessionID: 14989

Stress testing SQL Server

Back to calendar

Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 2

Speaker: Hilary Cotter

Title: Stress testing SQL Server

Abstract:

How high can we go? Frequently in your career as a DBA you will be asked how much load can your SQL Server support. In this session, SQL Server MVP Hilary Cotter, shows you how to Microsoft tools to stress test your application and determine what your bottlenecks are and how high you can ramp up your workload.

SessionID: 24554

Continuous Integration for Databases

Back to calendar

Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 1

Speaker: Steve Jones

Title: Continuous Integration for Databases

Abstract:

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately.

SessionID: 27651

The Restore Cookbook

Back to calendar

Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 2

Speaker: Warner Chaves

Title: The Restore Cookbook

Abstract:

How do you restore a database that has lost a file? How do you recover from a lost transaction log? How do you get rid of corruption in the fastest time?

At some point in time, these and other destructive scenarios will happen to your databases. And people will look at you and expect you to react swiftly and confidently.

Come see the scenarios and demos so you'll be prepared with the right ingredients to cook up your RESTORE recipe!

SessionID: 35686

Interviews and Resumes

Back to calendar

Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 1

Speaker: Rick Heiges

Title: Interviews and Resumes

Abstract:

Whether you are in the hunt for a new job or looking for a new employee to fit in, this session is for you. We will cover common interview techniques used today. We will discuss the goals of these techniques from the interviewer point of view and how you should respond from a job seeker point of view. We will also cover resumes and their purpose. Your resume is your first impression; make it count.

SessionID: 36037

Automate Your ETL Infrastructure with SSIS and PowerShell

Back to calendar

Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 2

Speaker: Allen White

Title: Automate Your ETL Infrastructure with SSIS and PowerShell

Abstract:

Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.

SessionID: 36097

Agile Data Warehouse Development

Back to calendar

Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 1

Speaker: Bob Blackburn

Title: Agile Data Warehouse Development

Abstract:

Long gone are the days when we had two to five years to deliver a Data Warehouse. Business Units want, need, and demand faster turnaround to start collecting on ROI. How can we take the Agile Methodology and apply it to Data Warehouse development? We will discuss how to apply it at the project level and then take a look at some data warehouse specific practices.

SessionID: 37775

Minion Maintenance and Backup Solutions

Back to calendar

Event Date: 06-06-2015 - Session time: 08:30:00 - Track: BI 1

Speaker: Sean McCown

Title: Minion Maintenance and Backup Solutions

Abstract:

The new Minion solutions are taking the SQL community by storm, and no wonder: they’re free, simple to use, and deeply configurable.

In this session I’ll show you the benefits to Minion Reindex and Minion Backup: • Simple installation and configuration for all shops, large or small • Single or multi-server installation script • Table-based configuration eliminates the need for excessive jobs • Highly customizable options • Flexible include and exclude options, including the use of regular expressions • “Statement only” option generates statements without running them • Extensive logging • Live insight into the current maintenance operation Minion Backup also provides a truly superb specialty: dynamic backup tuning. Minion Reindex and Minion Backup scale to the size of your enterprise, from one to thousands of instances. With Minion’s true configurability and enterprise features, you can do things never before possible in your maintenance routines.

SessionID: 14563

Hybrid Cloud Scenarios with SQL Server 2014

Back to calendar

Event Date: 06-06-2015 - Session time: 09:45:00 - Track: BI 1

Speaker: George Walters

Title: Hybrid Cloud Scenarios with SQL Server 2014

Abstract:

SQL 2014 has significant changes to allow seamless hybrid cloud scenarios. This session will talk about "why cloud" as well as the options available with backup, deployment, and new development scenarios with SQL 2014 and Azure.

SessionID: 18340

Change Data Capture in SQL Server 2008/2012

Back to calendar

Event Date: 06-06-2015 - Session time: 09:45:00 - Track: DBA 2

Speaker: Kevin Goff

Title: Change Data Capture in SQL Server 2008/2012

Abstract:

In this session, I'll talk about Change Data Capture (CDC) terminology and configuring a database for Change Data Capture. I'll show how to read CDC log tables, and show CDC code samples. I'll discuss CDC and SQL Server Agent jobs, and the use of CDC versus database triggers (and where triggers are still needed). Also, the impact of CDC on the transaction log and system performance will be explored. Finally, I'll talk about how to deal with schema changes, performance tuning, and using CDC in an ETL (Extract-Transform-Load) environment with SQL Server Integration Services. Time Permitting, I'll show some of the SSIS 2012 enhancements in dealing with CDC

SessionID: 23554

Social DBA

Back to calendar

Event Date: 06-06-2015 - Session time: 09:45:00 - Track: BI 1

Speaker: Robert Pearl

Title: Social DBA

Abstract:

What is a socal DBA? It's a DBA that uses social media to excel in his or her DBA career! Social media includes, but not limited to Twitter, LinkedIn, Google, SQL Server forums,community sites, and more! By using various aspects of social media to one's advantage, you can become a DBA star. Whether you're an accidental, junior or senior DBA, if you're not using social media, then you're missing out on the vast array of resources at your fingertips. Can't solve a problem, or issue? Before you call Microsoft Support, come to my session, and I will provide a ton of useful tips on how to get the answers immediately! This session is a Database Professional Development track to boost your ability to get answers when you need them!

SessionID: 27538

Get Familiar with Spatial Data

Back to calendar

Event Date: 06-06-2015 - Session time: 09:45:00 - Track: Dev 2

Speaker: Slava Murygin

Title: Get Familiar with Spatial Data

Abstract:

You've never worked with spatial data and would like to know how to do it.

We'll go through very basic SQL Server Spatial data functionality and draw some Spatial pictures using Management Studio.

SessionID: 35710

Flash and SQL Server— Re-Thinking Best Practices

Back to calendar

Event Date: 06-06-2015 - Session time: 09:45:00 - Track: BI 2

Speaker: J May

Title: Flash and SQL Server— Re-Thinking Best Practices

Abstract:

Flash storage is a game changer for virtually every app in which it is used. Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head. Contemporary IT environments should standardize their architecture including a tier of flash. Virtualized or non-virtualized, standardizing on in-server flash is vital for optimizing performance, scalability, efficiency (technical and cost), reliability, availability. Learn how flash flips the /faster bit the significant impact flash makes not just in terms of performance, but also best practices, the massive savings in licensing driven by consolidation on flash.

SessionID: 35781

Punishing Yourself with Continuous Delivery

Back to calendar

Event Date: 06-06-2015 - Session time: 09:45:00 - Track: BI 1

Speaker: Mark Wojciechowicz

Title: Punishing Yourself with Continuous Delivery

Abstract:

Do you deploy code once every couple of months, or quarters…. or years? Is deployment terrifying and fraught with catastrophes? Then why not do it more often? Continuous Delivery (CD) takes deployment to the next level, turning the terror of pushing out code into happiness, sunshine and butterflies. CD is the practice of maintaining the deployment pipeline so that new features can be delivered quickly and with fewer failures. This session will cover how to do CD in a Business Intelligence Environment.

SessionID: 36307

Master Data Services– Integration through SSIS

Back to calendar

Event Date: 06-06-2015 - Session time: 09:45:00 - Track: DBA 2

Speaker: Christopher Exley

Title: Master Data Services– Integration through SSIS

Abstract:

Building upon ‘Master Data Services – A Primer’, this presentation will show the integration of MDS through SSIS as a way to push and pull information to and from your MDS implementation. Basic MDS knowledge is helpful when attending this session.

SessionID: 36418

Beginning PowerShell Scripting

Back to calendar

Event Date: 06-06-2015 - Session time: 09:45:00 - Track: Advanced

Speaker: Justin Dearing

Title: Beginning PowerShell Scripting

Abstract:

This is a beginers powershell talk. While we will be talking about how to query and administrate SQL server with powershell, it will be a more generic talk about using PowerShell.

SessionID: 15648

Building an Effective Data Warehouse Architecture

Back to calendar

Event Date: 06-06-2015 - Session time: 11:00:00 - Track: BI 1

Speaker: James Serra

Title: Building an Effective Data Warehouse Architecture

Abstract:

You’re a DBA, and your boss asks you to determine if a data warehouse would help the company. So many questions pop into your head: Why use a data warehouse? What’s the best methodology to use when creating a data warehouse? Should I use a normalized or dimensional approach? What’s the difference between the Kimball and Inmon methodologies? Does the new Tabular Model change things? What’s the difference between a data warehouse and a data mart? Is there any hardware that is optimized for a data warehouse? Join this session for the answers to all these questions. You’ll leave with information that will amaze your boss and lead to a big raise… – or at least lead you down the correct path to adding business value to your organization!

SessionID: 18343

Beginner TSQL

Back to calendar

Event Date: 06-06-2015 - Session time: 11:00:00 - Track: Advanced

Speaker: Kevin Goff

Title: Beginner TSQL

Abstract:

SessionID: 20997

Data Meaning

Back to calendar

Event Date: 06-06-2015 - Session time: 11:00:00 - Track: Dev 2

Speaker: Judith Moffitt

Title: Data Meaning

Abstract:

Most database SQL training talks about syntax or tools. But the missing element is the most important, learning what the data means and how you can use that to write better code or to troubleshoot problems. Sure the meaning is different in every database, but the techniques to learn what the business rules are, what the data actually means to the users, and how to figure out what the column name xfp_reg could possibly mean are the same. Come join me and learn to Query With Meaning.

SessionID: 21078

Storage For the DBA

Back to calendar

Event Date: 06-06-2015 - Session time: 11:00:00 - Track: BI 2

Speaker: Denny Cherry

Title: Storage For the DBA

Abstract:

One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we see in the Storage Array with what we see on the actual server.

SessionID: 24403

SQL Server 2014 Optimizer “Goodies”

Back to calendar

Event Date: 06-06-2015 - Session time: 11:00:00 - Track: Dev 2

Speaker: Sharon Dooley

Title: SQL Server 2014 Optimizer “Goodies”

Abstract:

SQL Server 2014 introduces several new, small enhancements to the Query Optimizer. In this talk, you will learn about a new, real-time query monitoring tool, some significant changes to the way index statistics are computed, and the details of SQL Server’s new cardinality estimator. This presentation assumes knowledge of the pre-2014 Query Optimizer as well as basic query tuning techniques.

SessionID: 28346

Version control with GIT for the DBA

Back to calendar

Event Date: 06-06-2015 - Session time: 11:00:00 - Track: BI 1

Speaker: Justin Dearing

Title: Version control with GIT for the DBA

Abstract:

What does this mean to a DBA? Well. whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.

In my session. We will cover:

What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?

We will be covering using git from both the command line and Vis

SessionID: 35919

A "101" Overview of Microsoft Power BI for Office 365

Back to calendar

Event Date: 06-06-2015 - Session time: 11:00:00 - Track: BI 1

Speaker: Timothy McAliley

Title: A "101" Overview of Microsoft Power BI for Office 365

Abstract:

In this session we will do a demo-driven "101" level tour of Microsoft Power BI for Office 365, a solution hosted in the Microsoft Enterprise Cloud. We will take a look at the rich set of PowerBI capabilities, particularly the self-service BI solutions offered through Excel and Office 365. We will also take a look at ways to present levels of data analysis and data visualizations which can bring together deep levels of data insight . We will also discuss a "how to" list to get started as well as the Power BI for Office 365. This session if perfect for business / data analysts, data professionals whom are looking for a session to cover the fundamentals and take away enough information to get you jump started into the right direction.

SessionID: 37662

Connecting Power BI to On-Prem SSAS Tabular

Back to calendar

Event Date: 06-06-2015 - Session time: 11:00:00 - Track: Dev 1

Speaker: Kerry Tyler

Title: Connecting Power BI to On-Prem SSAS Tabular

Abstract:

If you've ever looked at the visualizations available in Power BI for Office 365 or the robust sharing capabilities available with the cloud service, but the requirement of uploading/storing data in the cloud was a deal-breaker, there is a new option available for you in the current Power BI Preview. The new Power BI Analysis Services Connector allows you to directly query on-premises SSAS Tabular data for display in Power BI. In this session, we'll go through installation and configuration of this Connector which can open all-new data sources for use in the cloud.

SessionID: 37455

Clusters Your Way: #SANLess Clusters for Physical, Virtual Cloud Environ.

Back to calendar

Event Date: 06-06-2015 - Session time: 12:30:00 - Track: Advanced

Speaker: SIOS Technology

Title: Clusters Your Way: #SANLess Clusters for Physical, Virtual Cloud Environ.

Abstract:

Microsoft Cluster MVP Denny Cherry will discuss how to create #SANLess clusters in environments where traditional shared storage clusters are impractical or impossible: local high performance clusters leveraging SSD and Flash-based PCIe storage and clustering in the cloud - no SAN (or SAN Admin required). He will also discuss cost-effective strategies to get HA and DR protection without a SAN.

SessionID: 22092

Common Coding Mistakes and how to Mitigate them

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: Dev 2

Speaker: William Wolf

Title: Common Coding Mistakes and how to Mitigate them

Abstract:

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.

SessionID: 35656

Become a SQL Server Performance Detective

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 2

Speaker: Danette Riviello

Title: Become a SQL Server Performance Detective

Abstract:

When your database is having performance issues, you need to quickly and accurately diagnose and resolve performance issues. Like any good detective, you need to look for clues to find “The Smoking Gun.” We will cover various tools at our disposal which can help us pinpoint and resolve issues quickly, using Dynamic Management Views (DMVs), SQL Profiler and other queries. We will discuss emergent performance issues as well as chronic issues and find ways to piece together the clues to figure out the root cause of our problems.

SessionID: 35695

Azure SQL Database (Software As A Service)

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 1

Speaker: John Miner

Title: Azure SQL Database (Software As A Service)

Abstract:

Are you tired of installing, configuring and patching Microsoft SQL Server? Azure SQL database maybe a way to move some of your existing infrastructure to the cloud.

Depending upon your companies philosophy, it might be great for development, testing, and possibly production environments.

The exciting thing about this service is that new features will be released on this platform first before trickling down to the on-premise editions.

The demonstration will show how to create and load a new database from scratch using the Azure Portal, SSMS and BCP.

SessionID: 35966

SQL Server Cryptology - A Primer

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 1

Speaker: Sebastian Meine

Title: SQL Server Cryptology - A Primer

Abstract:

So, you got told you need to encrypt "the database". Now what?

Join this session by security expert Sebastian Meine (Ph.D.) for an introduction to the fascinating world of cryptology. In this session, geared towards the DBA, you will learn the difference between symmetric and asymmetric encryption, discover what a cryptographic one-way hash function is and probe into cryptographically secure pseudo random number generation. After exploring the different definitions, you will be able to observe how to implement encryption, decryption, transparent data encryption (TDE) and hashing in SQL Server. We will pay special attention to areas where the choice of encryption technology affects your database maintenance and recovery strategies. After attending the session, you will be able to identify the right technology to use in your specific use case and you will have the basic knowledge to start implementing it immediately.

SessionID: 36062

Getting to Know Your DB

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 2

Speaker: Jason Brimhall

Title: Getting to Know Your DB

Abstract:

In this session we will explore some practical scripts to help create database documentation. We will be looking at how to make some of those documentation tasks easier, while giving you greater insight into your database(s). Attendees will be able to leave with some additional tools for their toolbox and through the use of these scripts the attendee will be able to perform these tasks faster.

SessionID: 36414

What's an execution plan and why does it matter?

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: Advanced

Speaker: Sharon Dooley

Title: What's an execution plan and why does it matter?

Abstract:

Even if you've never looked at an execution plan before, you'll come away from this talk with a good understand of why they're a critical tool in performance tuning. We'll cover how to get the plan and how to read it. We'll look at some badly performing queries and see what the execution plan tells us about how we can improve their performance.

SessionID: 36415

What's New in SQL Server vNext

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 1

Speaker: Bill Emmert

Title: What's New in SQL Server vNext

Abstract:

In this session, I will share the roadmap of SQL Server vNext. This will be a fast paced overview of what's coming both in SQL Server on-premise and Azure SQL Database. Hold your questions until the end so we can get through the feature list.

SessionID: 37776

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: BI 2

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you.

Here you’ll learn: • The most useful regular expression commands. • The appropriate times to use regular expressions. • How to use regular expressions to write code for you. • How to incorporate regular expressions into large tasks and combine them with other methods.

SessionID: 37901

Panel: Will the DBA Job of the Future Still Involve DBAs?

Back to calendar

Event Date: 06-06-2015 - Session time: 13:30:00 - Track: DBA 1

Speaker: Karen Lopez

Title: Panel: Will the DBA Job of the Future Still Involve DBAs?

Abstract:

While technologies have been changing rapidly since databases were born, the basic tasks a DBA has performed have been a stable foundation of professional database design and support.

But in the last few years, NoSQL technologies ("it's schemaless!"), cloud ("our databases are managed elsewhere!") and recent SQL Server features ("it's new and improved!") will have an impact on DBA jobs, tasks and careers.#160;

Our panel of SQL Server experts will share their #160;current experiences in the data profession.#160; They will share what they believe you should be working towards now and in the future.

SessionID: 11300

Optimizing Protected Indexes

Back to calendar

Event Date: 06-06-2015 - Session time: 14:45:00 - Track: BI 1

Speaker: Chris Bell

Title: Optimizing Protected Indexes

Abstract:

As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.

SessionID: 21807

Shortcuts to Building SSIS in .Net

Back to calendar

Event Date: 06-06-2015 - Session time: 14:45:00 - Track: BI 1

Speaker: Paul Rizza

Title: Shortcuts to Building SSIS in .Net

Abstract:

Using an Open Source project API Library this session will show how SSIS Packages can be created as easily in C# .Net as they are in BIDS. During the session real world examples will be used to show how SSIS Code can be created in BULK.

SessionID: 27576

Leveraging CDC and SSIS for ODS/DM/DW Loads

Back to calendar

Event Date: 06-06-2015 - Session time: 14:45:00 - Track: DBA 2

Speaker: Warren Sifre

Title: Leveraging CDC and SSIS for ODS/DM/DW Loads

Abstract:

One of the challenges with loading ODS/DM/DW is gathering data and reducing performance impact. Change Data Capture (CDC) is a means to capture all the changes of a given table, but how do you load this data to another Database. We will walk through the process and considerations for loading data using SSIS package and how to detect changes to the CDC Configured Tables which has been known to cause SSIS Package failures.

SessionID: 27775

Crazy Things Developers Do

Back to calendar

Event Date: 06-06-2015 - Session time: 14:45:00 - Track: Dev 2

Speaker: Wayne Sheffield

Title: Crazy Things Developers Do

Abstract:

Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn about SQL Injection attacks and how SQL can use Referential Integrity to optimze queries. Trust me... your DBA will love you for making these changes.

SessionID: 36076

DBA 911 - Database Corruption

Back to calendar

Event Date: 06-06-2015 - Session time: 14:45:00 - Track: BI 1

Speaker: David Maxwell

Title: DBA 911 - Database Corruption

Abstract:

SessionID: 36109

Creating a Solid Data Model for PowerPivot

Back to calendar

Event Date: 06-06-2015 - Session time: 14:45:00 - Track: DBA 2

Speaker: Dan Clark

Title: Creating a Solid Data Model for PowerPivot

Abstract:

A solid BI Analysis starts with the model it is based on. This session looks at best practices and avoiding common mistakes when creating the data model on which your PowerPivot and Power View reports are based. Using PowerPivot takes a change in mindset from the traditional pivot table connected to an excel sheet or SSAS cube. You will walk away with a better understanding of how to build your models and how to approach your data analysis when using PowerPivot.

SessionID: 36334

60 Reporting Tips in 60 Minutes

Back to calendar

Event Date: 06-06-2015 - Session time: 14:45:00 - Track: Dev 1

Speaker: Ike Ellis

Title: 60 Reporting Tips in 60 Minutes

Abstract:

This session will be rapid fire, fast-paced experience, focusing on all sorts of reporting tips. This session is for the YouTube generation. Do you have a short attention span? Are 15-second commercials too long to sit through? Do you want the very best reporting tips collected from watching hundreds of videos and reading a library of books, plus years of reporting experience? Come to this session. We have tips on Excel, data visualization, interviewing stake holders, organizing reporting teams, securing reports, consolidation, dashboard design, SSRS, SSIS, and T-SQL authoring. You're guaranteed to learn something actionable that will make you more effective in your career.

SessionID: 23917

From Zero to Loading a Data Warehouse

Back to calendar

Event Date: 06-06-2015 - Session time: 16:00:00 - Track: DBA 2

Speaker: Samuel Vanga

Title: From Zero to Loading a Data Warehouse

Abstract:

You're tasked to create the ETL process for a brand-new data warehouse. Where do you start? Data warehouse ETL boils down to three specific problems: Staging, Dimensions, and Facts. This session will show you solutions to these three problems. You'll first learn the fundamentals of a data warehouse before diving into creating packages and leveraging common patterns. You'll see both simple and advanced scenarios such as incrementally loading staging tables, processing type1 and type2 slowly changing dimensions, early arriving facts, snapshot fact tables, and bridge tables. If you want to create scalable and efficient SSIS packages to load a data warehouse, this session is for you.

SessionID: 35740

Performance Tuning - Analyzing Execution Plans

Back to calendar

Event Date: 06-06-2015 - Session time: 16:00:00 - Track: BI 1

Speaker: Konstantin Melamud

Title: Performance Tuning - Analyzing Execution Plans

Abstract:

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

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

SessionID: 35830

But it worked great in Dev! Perfomance for Devs

Back to calendar

Event Date: 06-06-2015 - Session time: 16:00:00 - Track: BI 1

Speaker: Randy Knight

Title: But it worked great in Dev! Perfomance for Devs

Abstract:

If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.

SessionID: 36267

The Ticking Timebombs in Your Databases

Back to calendar

Event Date: 06-06-2015 - Session time: 16:00:00 - Track: Beginner

Speaker: Karen Lopez

Title: The Ticking Timebombs in Your Databases

Abstract:

You've worked hard to build the best systems you can, and then one night you get called in to resolve a production incident. As you peer into your database, you see it: something so bad it sends shivers down your spine. How did that get in there? Who did that? Why? And how do you fix it?

In this session, we look at the workarounds, technical debt and clever designs that can cause you grief when you least expect it. We will also include perfectly fine features that can haunt you later. We will discuss how these things happen and give you tools to identify the ones that cause the most pain.

Join us: you'll keep your job, have happier users and get more rest.

SessionID: 36309

Visual Studio Online for cost effective code and Project Mgmt

Back to calendar

Event Date: 06-06-2015 - Session time: 16:00:00 - Track: Dev 1

Speaker: Ravi Gudlavalleti

Title: Visual Studio Online for cost effective code and Project Mgmt

Abstract:

Whether you are working on side project or an Enterprise grade solution, VSO is a cost effective cloud-based option that is hard to beat.

We'll look at what it is, licensing, pricing and features for developers, project managers and stake holders.

SessionID: 36422

You Want Me To Do What? SQL Security Basics

Back to calendar

Event Date: 06-06-2015 - Session time: 16:00:00 - Track: Advanced

Speaker: Chris Bell

Title: You Want Me To Do What? SQL Security Basics

Abstract:

You've done it! You have a database now! Maybe not of your own choice, but you have one. What do you do now to get it secured properly? Come learn the basics of SQL Security to start down the path of proper database protection.

SessionID: 8998

Availability Groups 101: An Introduction

Back to calendar

Event Date: 06-06-2015 - Session time: 16:00:00 - Track: BI 1

Speaker: Adam Belebczuk

Title: Availability Groups 101: An Introduction

Abstract:

One of the most talked about new features in Microsoft SQL Server is AlwaysOn Availability Groups. In this session, we'll cover the pros and cons of using Availability Groups as well as the basics of how to set them up and take advantage of readable secondary replicas. If you want to improve the availability and performance of your applications and databases, are currently using Database Mirroring, or if you're just curious about Availability Groups, then you won't want to miss this session.