Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 25
Solid-state technologies are changing the way that SQL users run their databases. DBA’s are achieving significant TCO savings through performance enhancements, reliability improvements, and reduced energy and real estate costs using solid-state technologies.  Solid state is changing the way datacenters look and how SQL performs.

1)	On overview of solid state technology options for SQL Server
2)	Why solid state makes a difference?
3)	An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each:
4)	Customer proof: Wine.com case study
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Your CIO's top priority in 2010 is probably Business Intelligence. If you don't know what BI is, or are trying to deliver it directly from your OLTP database, you need to find out what you're getting into.  BI is all about helping your business users make better decisions, faster. Find out what it will take to deliver what your CIO is asking for.
BI from your OLTP database has problems - it requires technical knowledge of your data model, compromises your line of business application responsiveness, and won't perform well. The solution to all of those issues is to construct a Data Warehouse based on Dimensional Modeling. I'll show you why normalized OLTP databases have problems supporting BI, and how Kimball method Data Warehouses don't. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

The secret to designing compelling report solutions is in the ingredients and the technique. Learn to apply proven design patterns and best practices to create a reporting solution masterpiece. These techniques employ expressions, parameters, custom programming and years of field experience. This presentation is based in-part from our forthcoming Wrox Press Book: Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, learn how to set up standard and data-driven subscriptions using Report Manager. We discuss creating file-share, email, and null subscriptions; and how to deal with potential issues with parameters and security. We also demonstrate a sophisticated Microsoft ASP.NET-based application that creates subscriptions by calling the SSRS Web Services API.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Data Architecture – a “Corner Stone” of Enterprise Architecture -As the organizations across the globe, aggressively pursues their strategic objectives; a key strategy and method is required in this pursuit, and that is ‘Data/Information Availability’. Accurate, reliable and available information enables the organization to make timely and better business decisions. 

We have seen many differing methodologies over the years with CRM, Portals, B2B efforts and score carding capabilities. The need for well structured and quality information is more important than ever. As a result, we are seeing a significant acceptance and synergy relative to the importance and value having a robust Data Architecture.

Most organizations today have a co
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Modern day computing power along with SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data.  This presentation will demonstrate how to use Analysis Services to incorporate these complex algorithms seamlessly into your databases, from transactional processing to integration, data analysis and performance management.  Attendees will be shown how to create a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample application that seamlessly uses the mining model.   Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Integration Services is Microsoft’s Extract Transform Load/Data Integration (ETL/DI) tool, replacing DTS.  SSIS is a very powerful and complex tool that can read data in from virtually any source, transform and mash that data however you like, then send it out to virtually any type of destination.  Understand how SSIS can be used to do just that – from the basics.  Find out how to get started using SSIS, hear what it’s really good at, and figure out what things you need a hacker’s spirit to accomplish with it.  This session is demo heavy; Tasks, expressions, precedence constraints, text files, Excel, SQL, data type conversions, performance, scripts, configurations, scheduling, and more will be covered with examples.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

The SCD Wizard included in Integration Services is easy to use, and has all the features you need for smaller, simple dimension processing. However, it is not the easiest component to adjust, and doesn't perform very well with larger dimensions. This session will cover three alternative techniques for processing changes to dimension tables within SSIS: "rolling your own SCD" with Lookups and Conditional Splits, using the T-SQL MERGE statement, and the Kimball Method SCD component. The strengths and weaknesses of each technique will be described and demonstrated.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is targeted for those who have found themselves accidentally responsible for the SQL Server databases where they work, or are generally new to SQL Server. We'll cover the basics of Backup and Restore processes as well as a high overview of HA architectures available including Database Mirroring, Clustering, Replication, and Log Shipping. Scripts will be provided for immediate use in your own environment as a take-away from this presentation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will explore different DMV and how they can be used to obtain information about your SQL Server environment. There will be a number of demo's. In these demos different DMV's will be used provide different infomation about how your SQL Server instance is running. Peeking under the covers is now only a DMV away.



Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

High volume contiguous ETL is always problematic, and even more so when near-real-time is desired. This presentation goes through a solution collects and aggregates security audit data for nearly 400000 machines, a contiguous 24x7 stream of nearly 200 events per second, using a budget tight solution that involves SQL Express, Service Broker and Database Mirroring.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment.  Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea.  Like all problems in the database world there are no hard set answers as to if virtualization is a good idea, but there are some times when virtualizing a SQL Server is a good idea, and can save you some money.  There are some other times when you will be shooting yourself in the foot and shouldn’t.  We’ll be focusing on when how to make this decision, and how to gather the metrics that you need in order to come to this decision.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Use the right tool from your SQL toolbox to maintain those indexes, determine which indexes are being used (and more importantly which ones are NOT being used), and get recommendations on indexes to create all from Dynamic Management Views. Walk away with scripts you can use in your environment IMMEDIATELY.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Visual Studio Database Edition (VSDB) offers many benefits for the deployment process as well as the development of database updates. You may know it by its nickname - the "Data Dude". It provides for declarative style of approaching updates in a collaborative environment. This tool has been undergone significant enhancements recently and has many compelling features. We'll view some the key functional areas of the tool, discuss best practices, and take a look at what features companies could take advantage of.

VSDB is free to download for use with Visual Studio 2008 Developer and Team Suite Edition.  It is also included as part of the Visual Studio 2010 Premium edition.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn the fundamentals of MDX query design for Analysis Services cubes. Migrate your SQL skills to this simple and elegant language that will enable you to unlock the awsome power of a cube and to gain deep insight from a single version of the truth. Learn to develop dynamic, advanced reports by parameterizing MDX queries using expressions and custom code.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

A look at the basic Nested Sets versus Adjacency List models.  Why Nested sets model hierarchies and Adjacency List model trees.   This will stress the need for constraints to prevent cycles in either model.  The problems of hierarchical aggregation -- Nested Sets requires one set-oriented query and Adjacency List requires iterations or recursion. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Interpreting SQL performance counters and OS related counters is an essential skill for a SQL DBA.  In this session, we will discuss most relevant OS and SQL performance counters, vital signs, and preferred threshold values. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will show how to achieve 99.9999 High Availability of SQL Server database on physical cluster and on Cloud.• SQL Server 2008 cluster Deployment• SQL Server 2008 Mirroring• Sql Server cloud deplyment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

"R2"? What does THAT mean? Is this a "full" release or not? Buck Woody, Microsoft's real-world DBA and all around Gadfly will regale you with the explanation of such acronyms as "DAC", "UCP" and "MDW", and he'll explain what StreamInsight, Master Data Services and PowerPivot can really do for you. You'll take a quick tour of the features you should know about in SQL Server 2008 R2, the version of SQL Server that just couldn't wait for another year.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Come hear Buck Woody, Microsoft's "Real World DBA" give a marketing-free introduction to SQL Server for the Oracle professional. No experience in SQL Server is necessary - we'll cover the basics of SQL Server Architecture using Oracle concepts as a guide. If you're an Oracle professional and you want to add SQL Server to your "knowledge arsenal", come hear this overview. You'll also get a list of resources that will enable you to research further.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: May 22

Time: 12:00 AM - 1:00 AM

Room: TBD

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