Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 50
It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements.  However, the best solution can only be provided if the database professional is getting all the answers.  This session is a case study into many of Disaster Recovery options that we as database professionals have.  Understand the answers to the important questions that  we should be asking to provide the best solution not only for the database but for the business as well.  As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is. 
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Azure Big Data Prof Dev

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session discusses how we can deliver a better BI product if we learn to better communicate with the business user and get then to think differently about data and about their needs.

Attendees will gain an understanding of how to initiate conversations and begin a process of increasing the quality of user requirements. They will also learn how to start and develop this process to get user buy in. The end goal is to fully utilize BI capabilities to reduce costs, improve performance or identify new business opportunities.
Speaker:

Session Type:
Regular Session

Track:
Azure Big Data Prof Dev

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server on VMware???  Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
APP DEV / DBA

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

From the expect disasters of failed hardware, malicious and unintentional data corruption, to the more unusual disasters of HVac failures, water main breaks, and fire, we will walk through case studies of each type, discuss what went right and what went wrong with the disaster recovery plan and how to plan better in the future. This session is intended to be interactive, to have you thinking about your own environment and what you need to put into place to help you successfully recover from disasters.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

You have migrated your SQL Server database to Windows Azure SQL Database (AKA SQL Azure), and you have migrated your application to Windows Azure. Now what? As the load on your database begins to increase, the need to scale your new SQL Database instance becomes a realization. In this demo-filled session we'll explore SQL Federation, Microsoft's solution for cloud database scalability. This session will look at the scalability model for the cloud and how SQL Federation solves the scale-out issue. We'll look at the architecture of SQL Federation and you can apply SQL Federation to your cloud database solution.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Azure Big Data Prof Dev

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the new features of SQL Server 2012 is columnstore indexes, where the storage of index data is “turned on its head”. We will look into how this feature is implemented internally, how it can greatly improve query performance in the right environment, what the current limitations are, and how to implement workarounds for those limitations.
Speaker:

Session Type:
Regular Session

Track:
BIA / DBA

Level: Advanced

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over FORTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
DBA/BIA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

DQS and the DQS Cleansing Transformation
Speaker:

Session Type:
Regular Session

Track:
BIA / BID

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems.  In this session I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BIA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Delphix is a new tool that is coming to market for SQL Server. This product virtualizes at the database level and makes refreshing and or creating new copies of databases for developers very quick and easy. This tool will save you time and storage. It is an amazing tool. I do not work for Delphix I just believe that this tool is one of the most useful tools that I have seen in a long while. This product also has great ROI as you will see in the session
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
APP DEV

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover a selection of topics and decision criteria for designing SSAS solutions for performance and scalability. This session is geared primarily towards Multidimensional SSAS, however in many cases Matt will cover how options may impact Tabular as well.

Topics include:

-Parent-Child vs. Natural Hierarchies
-Star vs. Snowflake schemas
-Many to Many relationships
-Partitioning
-Aggregation Designs
-Processing schemes
Speaker:

Session Type:
Regular Session

Track:
DBA/BIA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Tabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you'll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you'll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel, SSRS and other reporting tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BIA

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

With 2012 Extended Events became much easier to use and is a great way to find out more of what is going on in the database.  This 
presentation will show how you can use Extended Events to find out about items like Deadlocks and Query Performance.  We will create a 
new Event and I will show you how you can use the data collected to report commonly monitored statistics.
Speaker:

Session Type:
Regular Session

Track:
BIA / DBA

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Analyzing File IO Stalls and Wait Stats can really help you understand why performance on your server is poor and point you in the right direction towards improving the situation! Very helpful scripts will be provided along with discussions and references to help you understand what are two of the most important tools in my performance analysis toolbag!
Speaker:

Session Type:
Regular Session

Track:
APP DEV / DBA

Level: Advanced

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Analysis Expressions (DAX) is the language of PowerPivot and the BISM Tabular Model. Review the basics of the DAX language and get introduced to evaluation context: including row and filter context. Learn why different cells return different results based on the same formula. Understanding evaluation context is the driving force behind releasing the potential to create truly dynamic DAX formulas. The demo will walk through various examples the DAX query language and demo row and filter context
Speaker:

Session Type:
Regular Session

Track:
BIA / DBA

Level: Advanced

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BIA / DBA

Level: Beginner

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will focus on the differences in address format and structure around the world and how that can place in the effective storage of "useful" address data within the Enterprise. In addition, we’ll discuss how address data is "mangled" to be stored and how it can impact the overall quality level of any tool used for address validation and correction internationally. With 240+ countries and territories around the world, this is not a small consideration.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
APP DEV

Level: Intermedia

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing.  You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes.  We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes.  There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BIA

Level: Advanced

Session Code:

Date: April 27

Time: 12:00 AM - 1:00 AM

Room: TBD

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