Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 33
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 encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

How comfortable are you with your current process for designing data warehouses? Have you encountered difficulties determining how to better gather, organize, and use requirements to ensure a successful data warehouse design? This session will help by providing an agile data warehouse design process that gets targeted and meaningful requirements. The session will start by reviewing common\current data warehouse design elements and architectures. Next, the session will detail primary agile techniques and terminology. Lastly, the session will detail the use of Modelstorming using BEAM* (Business Event Analysis & Modeling) and the 7 Ws Framework.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC.  Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build.  He'll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

A lot of database professionals today  do not have a Computer-Science Degree  so they never attended a  “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific  join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

BIML--Business Intelligence Markup Language is your key to faster development of SSIS Projects. This session will guide you through initial familiarization and setup of BIML, ending with more complex demos which show the true power of BIML.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Cloud computing is one of the hot topic issues of the day and Microsoft is pushing hard to show that they are in the game to win. As such, SQL Azure is your data storage in the cloud solution. However, the platform is much different from simply a SQL Server that sits in the cloud and needs to be approached in an intelligent manner. In this fast paced session, we will be going well beyond the simple “hello world” scenario to show you how to leverage the cloud architecture for data storage as well as educate you in how the cloud works differently than your local database instance. Learn all of the functionality as well as the limitations so that you can make and educated decision when looking to move resource to a cloud based environment. This session is going to be an eye opener for sure and will have many of you dreaming of your data sitting in the cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: August 10

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:
Track 5

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *the CLOUD * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Database corruption is simply a fact of a DBA's life - if you haven't seen it yet, you will. Success or failure depends on having a solid plan to deal with different types of corruption.  In this session, we will discuss usage of related DBCC commands, monitoring for corruption with SQL Agent Alerts and Jobs, and when to restore versus repair. After attending this session, you will be able to check for corruption, identify different types of corruption, and take the appropriate measures for dealing with it. 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

With the release of SQL 2012, Analysis Services (SSAS) has seen some major changes.  An entire new method of modelling analytic data has emerged and it's called Tabular Mode Analysis Services.  In addition to that, a new semantic layer has been added to the tool, the Business Intelligence Semantic Model (BISM), which will help to bring the two modes -- Multidimensional and Tabular -- into one level playing arena.

In this session, attendees will gain understanding of what Multidimensional and Tabular modelling IS, as well as how the BISM layer helps to translate user requests to ensure no confusion is made. Attendees will also learn how to BUILD a Tabular model, and will help design a solution live during the presentation. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Lewis and Clark.  Stanley and Livingstone.  Armstrong and Aldrin.  Never bound by 9-to-5 TPS reports, they forged dauntlessly into uncharted territory, driven to discover, learn, and conquer the unknown.  This session will be nowhere near that exciting or dangerous, but will explore features of SQL Server that you may not know, and give you the tools to do your own discovery.  Learn about all those weird functions, undocumented procedures, and how to find and use them yourself.  We'll also cover how to "hack" SQL Server and possibly find even more interesting features...from the future!
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

You spent 45 minutes making your first report, but now you want more. Of course you do; everyone wants to make things pretty. Using SSRS 2012 we will look into rendering types & considerations, conditional formatting, properties you can’t live without, and why standards are good. Full of samples and demos, you can’t miss this one.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: August 10

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:
Track 6

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to see an in-the-trenches example of transitioning a SQL2005 server to a SQL2012 server? This session will review how we upgraded a SQL2005 server to a SQL2012 by utilizing Log Shipping, speedy restore operations, and quick thinking. This isn't a technical demonstration of how you COULD do something:this is a review of how we planned, organized, and executed a server upgrade. I'll include some of the problems we encountered and troubleshot before, during, and after the upgrade. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Powered by Fusion-io, Protected by SIOS: Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of high-speed Fusion ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection – at a price you can afford. Join us and you could win a $100 American Express gift card. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Many DBAs believe that a backup is the most important process to implement. For most, they soon realize that the most important process to the business is actually the restore. In this session, we’ll start by exploring some of the options in the SSMS restore wizard, but will quickly move to T-SQL to discover the power and beauty that writing the RESTORE statement can provide. In addition to the classic RESTORE DATABASE and LOG statements, we’ll work through some real world examples of how to leverage some of the lesser known syntax of the restore statement to help in both foreign and well known environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

What are FileTables?  How do they work?  What are their limitations?  These questions and more will be answered in this demo filled presentation.  We will walkthrough the configuration and implementation of this feature.  We will show you some use cases on how this fucntionality can help you manage your data in whatever forms it exists.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the most talked about new features in SQL Server 2012 is AlwaysOn Availability Groups. In this session, we will 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 & 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

Track:
Track 2

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously.  In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

Many three-letter acronyms (TLAs) adorn our database world. This session focuses on two recent additions – MDS (Master Data Services) and DQS (Data Quality Services) – explaining what the new features are and exploring how to leverage them to improve your data quality. 

High data quality is fundamental to any business analytics system. In this session, we’ll begin with an overview of data quality and the latest Microsoft tools available, and then demonstrate MDS and DQS and how to use them together for continuously improving data quality. We’ll also look at how to integrate them into your existing data-quality strategies. Data quality is everyone’s responsibility – but we can still lead the way forward. Join this session to see how.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: August 10

Time: 12:00 AM - 1:00 AM

Room: TBD

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