Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 42
This introduction to PowerShell is different than most.  Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of "recipes," stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008/2008R2.  You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques. 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

I will elaborate on  the following topics in detail by presenting real-world code examples, why they are inefficient and what is the solution.
Configuration:
1.	RAM (Memory)
2.	RAID (IO)
3.	Concurrency – 
•	Dirty Read
•	Phantom Read
•	Non-repeatable Read
•	Blocking
Code:
1.	inline function (and expression)
2.	select * 
3.	compiled to incorrect plan  
4.	recompile plan 
5.	union (union all)
6.	missing  join 
7.	type implicit conversion  
8.	unfiltered delete (truncate)
9.	like operator (and execution plan and index)
10.	missing, unused, redundant indexes 
11.	query hint 
12.	database version compatibility 
13.	locking, blocking (isolation level)
14.	not in, in, exists, not exists 
15.	schema naming convention 
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

How do you tell good code from bad?  Bad SQL code makes the system work harder for the same results.  Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity.  Extreme Bad SQL can bring a server to a grinding halt.   This presentation shows you how and why certain commonly used SQL constructions are Bad SQL.  Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

The time has come where DBAs can no longer afford to ignore powershell.  Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell.  This session will take you from nothing  and explain what powershell is all about.  I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else.  So in this session I’m going to show you the basics you need to get your powershell career started.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

If you were in the 1.0 session you’ll love this one.  In this session we’re going to pick up where we left off and really get into some real SQL Server admin tasks.  We’ll start with some more advanced basics to enhance your knowledge of powershell, and then apply them directly to SQL Server.  By the end of this session you won’t be an expert, but my goal is to make you competent enough to be able to understand blogs and articles about powershell.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation will explore the fundamentals of running SQL Server in a VMWare environment. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks and cover best practices for maintaining optimum performance in the VM.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn about clustering in current SQL Server and Windows Server releases. Failover Clustering is a fundamental step for any High Availability SQL implementation.  Learn how Clustering works, what are the new requirements for Failover Clustering, and how you can make the most of this feature.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

I have this database which must meet all of these governmental regulations.  Just like the government to make life a lot harder but wait, now they say I most also meet International regulations.  Can this be true?  Why me?  Let's look at what we can do to help us pass audits and comply with the laws around us.  We will explore the features in SQL Server 2008 which help us.  
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will focus on using real world data ( no Adventureworks) taken through the life cycle of a data mining application. Topics will include the details of data mining methodology fine tuyning mining models and validating discoveries 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Advanced

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

At its heart, the DBA Repository solution employs SSIS and SSRS and in late 2009 was updated for performance and resiliency. This session will cover the original solution, published in SQL Server Magazine, plus the latest enhancements which will delve into some interesting uses of package variables and MERGE in SSIS along with some new reports.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

As an enterprise application grows and load increases, some concurrency issues are bound to surface. Deadlocks are one of the more aggravating of this class of problems. Fortunately, each release of SQL Server includes better tools for troubleshooting deadlocks. Trevor will provide a strong foundation on deadlocks and then demonstrate approaches for handling them in SQL Server 2000, 2005, and 2008/2008R2.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Managing SSIS packages in large environments can be a real challenge in large shops.  This session will show you how to deploy, transfer, monitor, standardize, and automate your SSIS package environment using Powershell.  You’ll learn how to keep many data marts in perfect synch, deploy packages to multiple servers, consolidate packages to a single server, enforce naming and security standards, and much more.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Intermedia

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document.   In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.” 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Never hard-code a connection string or file path again! In this session, we'll look at several ways to introduce dynamic logic into your packages by way of the SSIS expression language, package configurations, and variables. Learn how to reuse tasks, components, and containers by replacing static settings with dynamic and flexible properties.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

You will walk away from this session with an understanding of how to use the Policy Based Management and Central Management Server to complete a daily checklist against your whole SQL Server farm. We will cover the basics to evaluate, monitor and apply best practice policies, which are included out of the box with SQL Server 2008. We will also make custom policies to cover additional best practices to evaluate daily checklist items. Finally, we will combine Policy-Based Management and Central Management Server with the Enterprise Policy Management Framework on codeplex to automate the monitoring process and create manager friendly reports to moni
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

This will be a Beginner to Intermediate session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?
 
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session 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 2

Level: Beginner

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Powershell is the enterprise DBAs best friend.  It’s the only way to get your environment completely under control with very little effort.  You can easily build templates that extend what you’ve already got and you can use them to bring hundreds, or even thousands of servers into compliance with next to no effort.  Learn how to manage a very large environment with powershell from a DBA who does it every day.  Here you’ll learn how to build a system of templates that you can use to manage all levels of configuration and alerting.  You’ll learn how to gather and alert on almost every aspect of your server as well as manage and standardize them.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Advanced

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

Very few queries can be written without an Inner Join, but Full Outer Joins and few and far between. This session will cover the less common join scenarios through slides and code samples. Learn to use the data model and requirements to recognize the join type. Come away with the confidence to give examples and incorporate the new material in your own queries.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: January 29

Time: 12:00 AM - 1:00 AM

Room: TBD

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