Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 30
The goal of Good SQL is to avoid procedural. The more taht can be put into declarative code, the better the optimizer can do its job. This will cover the use of CASE expressions, overlapping UNIQUE constraints, state transition constraints, and  Kusnetsov's temporal constraints.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Bonus

Level: Advanced

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Join Jonathan Gardner in a discussion about the project management process and how understanding the process can help increase the chances of delivering a top quality work product.  Learn the questions to ask to prevent scope creep and manage stakeholders from a DBA and highly experience project manager.
Speaker:

Session Type:
Regular Session

Track:
Bonus

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Profiler (and its underlying subsystem, SQL Trace) is a tool for recording a SQL Server instance's activity. This diagnostic and performance data is valuable for troubleshooting and characterizing a system's workload. Like any powerful tool, misuse can be quite harmful, so great care must be exercised. This session will teach you how to efficiently configure, run, and analyze the data from traces, while minimizing the overhead of the data collection and avoiding common pitfalls.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 1

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Analysis Services performance troubleshooting can appear more art than science - there are no query plans to view for optimization, server configuration documentation can be sparse and getting consistent results with specific query tests does not always yield the results you desire.  How can you know you can meet the SLAs for the user experience?  What is the performance elbow on the number of concurrent users?  Did my new aggregation or partition actually make a difference?

This session will go into details on how to configure a performance monitoring environment, how to gather data and then interpret results into actionable steps, allowing attendees to answer these questions.  Assumes some experience with Analysis Services and MDX
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you have a highly visible online application where you cannot sustain a database outage?  How do you handle the planned outages needed for basic maintenance such as patching?  In this session I will share some methods utilizing SQL Server features to provide 100% up-time.  We will also discuss issues with using clusters as part of an uptime strategy.  Finally we will spend some time discussing how Denali can help improve this up-time by utilizing “Always On” features.
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

We'll cover the basics of setting up your CMS, including: "What you need to consider when planning your CMS",  "How to find SQL Servers in your environment",  "How to get the servers you find into CMS" and  "How CMS can help you proactively manage your environment".
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 1

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

It’s impossible to follow every best practice all the time. “Code sins” are those things we do to our code that are either so horrendous that they can’t be borne, or that have such tremendous consequences that your stored procedures wish they’d never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Developer

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

We often run a fine line between how much space we need, and how much space we have for our databases. Having too much drive space can be a waste of resources; however, running out of space is an obvious issue. Let’s find a way to straddle the line and determine just how much space we really need, give ourselves a bit more than that, and make it a regular process to baseline, then continue to monitor, make adjustments along the way if needed, and ultimately plan for just enough space to get us through the year on budget. We’ll talk about a stand-alone tool that I used to determine space use for baseline, continued monitoring of the space used, and ensuring we have enough but not too much space. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 2

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will explore various options for data and process management leveraging System Center Orchestrator, System Center Service Manager, PowerShell, SQL 2008 R2, SSRS, as well as other Microsoft offerings. One of the demonstrations will highlight an existing production infrastructure where managed data is remotely collected from various sources (Hyper-V, Windows Host OS, Storage, Network, and Security, even Guest Virtual Machine SQL databases), stored in SQL 2008 R2, reported via SSRS, and presented via an intranet SharePoint portal.
Speaker:

Session Type:
Regular Session

Track:
DBA 1

Level: Intermedia

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system. 

Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online.  Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. Denali AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot!  Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic ConnectionString fail-over using a real web app to see how well that feature works.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 1

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know and love inner join, outer join, in and exists. But, there are a several other TSQL operators that do not get as much press as the rest. Expand your TSQL tool belt with Intersect, Except, Cross Apply, and Outer Apply. You'll get practical examples that you can use on Monday morning!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Developer

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduced in SQL 2005, Common Table Expressions, or CTEs, are temporary result sets that offer increased flexibility in your T-SQL coding and provide a simple syntax for recusive queries.  In this session for intermediate T-SQL coders, learn how to use CTEs to improve the readability and maintainability of your most complex queries.
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 1

Level: Intermedia

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server 2008 and 2008 R2 features designed to make a DBA’s life easier.  If you aren’t using CMS, PBM, EPM, MDW, UCP or DAC – come learn what they are and the potential benefits for managing your environment. 
Speaker:

Session Type:
Regular Session

Track:
DBA 2

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Remember Baloo the bear from the Jungle Book? Well we are going to get down to the "bear" necessities of mirroring and more. Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 2

Level: Intermedia

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Start with the basic method for modeling a hierarchy with sets instead of mimicking pointer chains. Then we will get to some fancier tricks with the model. Finally, spend some time on data integrity. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Developer

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the most talked about features slated for the next release of SQL Server, a whole new way of storing data, speeding up some queries ten fold. Come listen to Conor Cunningham talk about this new feature. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Objective of session is to show with examples when and what and how and if to implement table compression.  Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking.  Come to the session to see the results -- they were surprising to me!  
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

Synchronous and asynchronous components, memory buffers, data type choices, Oh My! Tuning the data flow is all about choices. In this session we'll walk through some of the choices that can give you the biggest performance boosts in your ssis data flow. Together we'll work through the differences between synchronous and asynchronous components. We'll highlight components that should be avoided and explore alternates that can help us create the fastest data flow possible.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: October 01

Time: 12:00 AM - 1:00 AM

Room: TBD

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