Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 29
We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

We will be getting back to the basics of Microsoft SQL Server and looking in depth at all of the object types within SQL Server as well as the commands to work with them.

All to often people focus on the advanced high end parts of SQL Server without getting a good grounding in the basics of SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases.  Learn the options with SQL server, what each choice will do for you and when to use each one.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture , via SSIS, that relys on a metadata mart. The end result a greatly reduced TCO(developemnt effort) for generating the code required vs manual cosing. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we'll look at using Visual Studio Database Edition tools in Visual Studio 2008 and 2010 to develop and deploy databases. We'll review how to manage your database changes, publish incremental changes to a development database, and how to deploy your database into a production environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

The DBA can be the last line of defense guarding the integrity of their company’s data. Taking this responsibility seriously will make you more successful in your job. This session will discuss how the DBA can proactively ensure the data in their transactional system is clean and correct. The presenter will take a comprehensive view of this crucial aspect of the DBA’s job, drawing on many real-life examples. The topics covered will include table design, transactions, change management, and coding standards. She will explain how these distinct topics are actually part of an integrated approach to data protection. The presenter will also describe how pessimism and vigilance can be valuable traits for a DBA. 
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

With the introduction of Report Builder in Reporting Services 2005, end users were given the tools to create self-service Reporting Services reports quickly and easily. 

In this session we will discuss concepts of the Report Model including Entities, Attributes, Roles and other components. We will discuss organization and security within the Report Model to protect data and create a logical view for the business. Then we will cover the methods for creation of an over an existing database and modify them to support specific needs. Once we deploy the Report Model we will build reports and see how the evolution of the Report Builder has enhanced the self-service reporting experience.  
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Come learn how to use Integration Services to create an ETL (Extract, Transform, and Load) solution for populating
your data marts/data warehouse. This session will cover best practices for dimension and fact table 
loading, package configurations, package variables, error and event handling, and SSIS package deployments.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Come learn how to create your first cube using SSAS.  In this session, we will start from scratch and
create an Analysis Services solution including setting up the data  source, data source view, dimensions, hierarchies, 
attribute relationships, and creating some custom measures.  At the end of the session we will browse the cube using Excel
to create some ad-hoc reports.

Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: February 19

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 5

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

You can't develop software in 2010 without considering the impact of running applications in the cloud instead of your own servers. Microsoft has expanded SQL Server to the cloud with SQL Azure. In this session, we'll take a look at SQL Azure and how to get started with it. We'll cover best practices of developing solutions based around SQL Azure. Finally, we'll cover what features that SQL Azure doesn't have and things that you have to know when developing applications for the Azure platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

After creating and activating a Database Mirror, how do you manage and monitor your Mirror?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

An overview of Database Mirroring.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

We'll touch on SQL Profiler and review its best practices so that you don't impact the production system while gathering data. We'll take a deep dive into server-side traces (SQL Trace) and show how you can run a constant server-side trace with little impact on the production system. We'll also examine the things that I look for when troubleshooting performance issues.
Speaker:

Session Type:
Regular Session

Track:
Track 5

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

Server monitoring can be expensive and is generally licensed for only critical production servers. In this session, learn how to utilize Powershell along with SMO to not only be proactive, but productive in monitoring the servers in your environment.  Attendees will come away from the session with an understanding of how to read the server event logs, check backups, and collect performance metrics.  This will be useful for general monitoring in your environment and can also be used for collecting data in a physical to virtual migration.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

This will be a 100 level class that discusses the basics of powershell, how to set it up, how to use it, and how it will help the DBA be more productive.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come.  We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster.  We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

In this sessions, you will learn about the various data collection strategies that are available for SQL Server 2008 R2 and with System Center Operations Manager to help you in troubleshooting and capacity planning for your applications. You'll see what strategies you can use during application development, deployment, and operating in production. You'll also learn how to use the data collected for capacity planning.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: February 19

Time: 12:00 AM - 1:00 AM

Room: TBD

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