Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 57
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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev 1

Level: Intermedia

Session Code:

Date: June 06

Time: 2:45 PM - 3:45 PM

Room: Paoli

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI 1

Level: Beginner

Session Code:

Date: June 06

Time: 11:00 AM - 12:00 PM

Room: MRP III

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!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI 1

Level: Beginner

Session Code:

Date: June 06

Time: 12:00 AM - 1:00 AM

Room:

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI 1

Level: Beginner

Session Code:

Date: June 06

Time: 8:30 AM - 9:30 AM

Room: Malvern

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev 2

Level: Beginner

Session Code:

Date: June 06

Time: 12:00 AM - 1:00 AM

Room:

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI 2

Level: Intermedia

Session Code:

Date: June 06

Time: 8:30 AM - 9:30 AM

Room: Wynnewood

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev 1

Level: Intermedia

Session Code:

Date: June 06

Time: 12:00 AM - 1:00 AM

Room:

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI 1

Level: Intermedia

Session Code:

Date: June 06

Time: 4:00 PM - 5:00 PM

Room: MRP II

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI 1

Level: Intermedia

Session Code:

Date: June 06

Time: 1:30 PM - 2:30 PM

Room: Malvern

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI 2

Level: Intermedia

Session Code:

Date: June 06

Time: 1:30 PM - 2:30 PM

Room: MRP I

That's right, attendees choose! I'll show 30 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 30 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced

Level: Intermedia

Session Code:

Date: June 06

Time: 11:00 AM - 12:00 PM

Room: Paoli

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced

Level: Beginner

Session Code:

Date: June 06

Time: 9:45 AM - 10:45 AM

Room: Paoli

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!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI 1

Level: Beginner

Session Code:

Date: June 06

Time: 11:00 AM - 12:00 PM

Room: Wynnewood

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. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI 1

Level: Beginner

Session Code:

Date: June 06

Time: 4:00 PM - 5:00 PM

Room: Malvern

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

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA 2

Level: Intermedia

Session Code:

Date: June 06

Time: 9:45 AM - 10:45 AM

Room: MRP III

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced

Level: Beginner

Session Code:

Date: June 06

Time: 12:30 PM - 1:30 PM

Room: MRP II

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.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Dev 2

Level: Beginner

Session Code:

Date: June 06

Time: 1:30 PM - 2:30 PM

Room: 30th Street

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.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Dev 1

Level: Beginner

Session Code:

Date: June 06

Time: 11:00 AM - 12:00 PM

Room: Berwyn

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. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI 1

Level: Intermedia

Session Code:

Date: June 06

Time: 8:30 AM - 9:30 AM

Room: 30th Street

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.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Dev 2

Level: Intermedia

Session Code:

Date: June 06

Time: 2:45 PM - 3:45 PM

Room: 30th Street

Sessions Found: 57
Back to Top cage-aids
cage-aids
cage-aids
cage-aids