Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 20
Like great grilling, great SSAS starts with fundamentals.  We'll cook Rachel Ray's ingredients on the SSAS grill, showing all the basics for creating SSAS dimensions, measure groups, and performing basic calculations.  Add a lettuce, tomato, mayonnaise, and you have a tasty cube!
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

“The system is slow. It was much faster last week! This is taking forever.” Statements like these from users can be frustrating for any DBA, unless you have the data to prove how the system regularly performs. In this session we will cover some of the tools and techniques freely available to SQL Server DBAs for capturing baselines that can be used for measuring performance, capacity planning and understanding usage patterns. We also discuss how these utilities and their data can be used to identify warning signs and troubleshoot performance issues. Long-term collection and storage methods for data are reviewed to help you create a plan for building your own repository when you get back to the office on Monday. Tools covered include: Windows
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

There is no hotter term right now than cloud computing, however, exactly what this means is a mystery to many. We will begin by defining what cloud computing is and the benefits the technology offers the DBA. You may see the benefits of the cloud, but are not comfortable trusting your sensitive data to this nebulous cloud. The goal of this session is to provide you a blueprint to design and build your own SQL Server cloud, where you can control the server availability and performance reliability, yet still take advantage of the resource elasticity and hardware flexibility of the cloud.  In this session, I will show you how to use features like the resource governor, dynamic management views, policy based management and others to automate yo
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

For the Analytical Business User, we will explore some SQL syntax tricks and advanced techniques that will help you better take advantage of your application data. The goal of this session will be to learn how analytical functions, common table expressions and special keywords (e.g., PIVOT) can assist you in turning your data into useful business information! Furthermore, we will use Sales-based performance measure/trending style reports for our exploration of these tips...
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

When queried, most database professionals would mention normalized as one of the most important characteristics that tell the difference between a good and bad database design. I won't disagree in the least, but there is so much more to be considered.  Even if you did a great job of normalization, poor naming, poorly implemented keys, too many or too few indexes, and so on can derail your design.  In this session I will present seven primary characteristics of a design that differentiates between an ugly design that will have your colleagues nitpicking you to death and one that will have them singing your praises. Characteristics such as comprehendible, documented, secure, well performing, and more (including normalized, naturally) will be 
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

DMVs - Dynamic Management Views and Functions are the DBA’s looking glass into the internals of SQL Server. They will give a DBA a snapshot on how the database is performing and potential problem areas. In this session, we will review a number of DMVs describing the types of information that can be captures and how it might be used. This review will include index statistics, query performance, memory utilization to name a few.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Start with a simple proposition: a process is either working or waiting.  You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more.  When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked.  After attending this session, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases.  Stop guessing, start knowing!
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem.  We don't always know how to do this easily and consistently.  This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: June 11

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

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

A discussion involving the various touch points between SQL Server and AD: ADSI - loading AD user information into 
SQL Server for application integration; Registering SQL Server in AD for both browsing and replication; how to 
configure SQL Server to use Kerberos authentication; the use of service principal names on both server and client 
sides.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

How your business applications interact with the corporate database directly can have a dramatic impact on how successful you are, and one of the biggest issues is performance with large databases.  By designing the application to use asynchronous messaging for non-critical updates you can focus performance concerns to where the timeliness is critical.  SQL Server Service Broker handles the asynchronous requests quickly and efficiently, and minimizes the conflicts with your critical updates.  This session will walk you through the steps to get Service Broker up and running and providing a consistent delivery of your business data.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

No matter how much we prepare, when disaster strikes we all feel a moment of panic. For some that panic quickly passes as we get down to work to fix the problem. For others the panic continues to grow as we search for a solution. Of course back up is crucial, but in this session I will provide useful real world best practices that will show how to recover from disaster and more importantly how to prepare for the inevitable. Specifically how to recover from common disaster scenarios. For example, what to do when the master database is corrupt, a drive array with half your database files fails, a hardware failure, a SQL injection attacks wipes out whole tables and many more.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

The paradox of Business Intelligence: it's one of the few tech sectors that actually grows during recessions, and yet, satisfaction levels with BI investments remain on average quite poor. Also, BI remains the domain of specialists, off-limits to most of us. Why do these conditions persist when the funding, and therefore the business need, only continues to grow? In this session I will demonstrate how PowerPivot is opening the world of BI to a broader audience (& range of applications). The only prereqs: curiosity, and fondness for numbers :) I will explain how PowerPivot impacts & benefits you depending on role (analyst, DBA, BI Pro, etc.), show off its capabilities in real-world usage, and field as many q's as you can muster :)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

You have mastered the art of linking a dataset to a table in SQL Server Reporting Services. You have solid, reliable reports that you and others depend on. Learn how to take them from basic to "wow", using features such as tablix, lists, images, and charts. At the end of this session, you will be familiar with:
- Report properties such as headers, footers and backgrounds 
- Tablix properties such as ToolTip and NoRows 
- How to build and customize a matrix 
- How to effectively use lists, an often-overlooked feature 
- Adding charts to make reports visually appealing and easy to understand 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Partitioning from A to Z 
We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Advanced

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

DBA’s traditionally have a library of T-SQL scripts which they use in automating their job.  PowerShell, Microsoft’s newest scripting language, can take those T-SQL scripts to the next level.  PowerShell and the SMO (Server Management Objects) library allow a DBA to create scripts that will interact with the OS and SQL Server at the same time. In this session we reveal the power of automating SQL Server with PowerShell by reviewing a number of scripts that have been migrated from T-SQL to PowerShell.  This session will include scripts that will backup databases, interrogate a server, and script out objects from a database.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. This session will dig into many of the otherwise-hidden issues that can kill performance, including prevention, detection, and resolution of these problems.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you feel that you are overworked and always fighting fires and never can get ahead? In this session, I will help you identify what is important to your job and how to find the time to address those critical tasks.  I will share scripts to automate those tasks that are central to all DBAs and discuss how to establish a methodology to quickly automate daily database chores.  The flip side of automation is auditing.  Routine auditing your server is essential to avoid nasty surprises that can lead to a loss of control.  We will create an auditing system using features within SQL Server, including Policy Based Management and scripts that will provide you peace of mind to enjoy your work and maybe even life beyond the office. 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: June 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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