Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 24
With all the great new features added to SSIS in SQL Server 2012 it is important to understand how they can make your development life easier.  This session will not only highlight what is new in SSIS but also show how your existing solutions can be adapted to utilize the latest features.  Topics will include changes to usability, deployment, configuration and management.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Good Code, Bad Code.  It can be the difference between a server running smoothly and an unresponsive piece of junk.  This session digs into what makes some SQL code perform faster and scale better.  Session is almost all interactive demo.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Every organization that stores data stores dirty data, and suffers with how best to handle this unpleasant fact.Organizations must rely on people to deal with data problemseither by paying them to clean it or paying them to work around it. Either way it is costly and only becomes more so over time. Finally with the release of SQL Server 2012, there is a tool to help. Learn how to use the key parts of Data Quality Services: how to create a Knowledge Base, how to create Data Cleansing Projects to cleanse data both in the DQS client and inside SSIS 2012, and how DQS Matching Projects can integrate with Master Data Services for de-duplication of data. Session focuses on DQS, but also explains how DQS, MDS, and SSIS work together.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology.  Discussed will be design decisions for snapshot, transactional, and merge replication.  Also discussed will be agent profiles and optimizations for replication.  What type of replication to use to solve specific business needs will also be covered.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Advanced

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Power View has the capability of creating eye-popping visualizations within SharePoint 2010.  It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions.  In this session you will learn how to design your own dazzling reports using Power View.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

As a BI Administrator or report designer, you've probably been asked many times by the business to create a dashboard to present some data. What makes a good dashboard though? The more information, the better? The more colors, the better? In this session you will get tips about designing dashboards, graphs, tables, gauges and maps with the goal of how you can impress your end user with the most efficient designed reports. This session is less technical than others, since it covers aspects and tips that you can take into consideration to create your reports as clear, understandable and usable as possible. The session consists of some general tips and tricks, followed by examples of designs and how to optimize these.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 08

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 4

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

The first 24 months are extremely important in our careers when we’ve been offered the opportunity to take on the ‘DBA’ role.  To be successful, it takes a solid foundation of general concepts, career development, training, fearlessness, confidence, and mentorship from more experienced professionals.

Organization, planning, and having a roadmap to where you are going will be crucial to your success.  This session will bring these topics together so you can set your GPS to success avenue.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

WARNING: Do not quit your job after this presentation. Have you ever thought about becoming an Independent Contractor? Would you like to transition from Full Time Employment to Consulting? Do you want to know how to get started? If so, then this lively session is for you. The session will cover the basics of running a consulting business and a selling yourself as a Technical Resource. We will conclude with an open discussion about the business side of technology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Businesses depend on reliable data that can be managed effectively and shared through-out the enterprise. In this session we will look at the how Master Data Services 2012 can provide a solid platform for your organization's master data management implementation. We will spend a majority of the session building a model, loading it with data and then refining it to highlight the features and capabilities that are available both out-of-the-box and through the excel plug-in.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

As systems grow and evolve, we need tools to help manage these changes, including tracking changes to the database schemas, producing scripts to synchronize the changes between servers, and refactoring the corresponding application code based on the new structures. You'll see how you can use tools in Visual Studio and SSDT to help manage these changes better.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Peanut Butter and Mayonnaise? No, Policy Based Management  What can it do for me?  Do I really need it?  How do I install and configure it?  How can it help me to pass audits?  Who is that masked man you got into my database. You mean each server can really be configured the same.  Let's explore Policy Based Management and what it has to offer us in better management of our Sql Servers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

I don't know how the Sql Server will perform!  You can't do that! Yes, we can!  Yes, we did! It runs better than our physical server.  Need to add a CPU in less than 5 minutes, no problem. Need more memory, sure.  Give me 5 minutes.  Thin provisioning, thick provisioning? Can I put as many Sql Servers as I want on the Host?  What is a Host and a Guest? What is causing my Sql Server to run slow, is it the virtual, operating system or Sql Server? How do I know? What is the licensing for Sql Server? How do you monitor it? How is it working? Let’s find all of these answers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will discuss and show the benefits of utilizing compression.  I will be demonstrating native SQL Compression as well as a third party tool.  I will show examples of my real world testing and share the numerous benefits of SQL Compression.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQL Saturday favorite and is always packed full. Don't miss it **
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

AlwaysOn is the new High Availability technology suite for Microsoft SQL Server 2012 that allows for multiple HA and DR solutions along with hardware reuse and reporting scale-out.  Learn what AlwaysOn can do and how it works.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Advanced

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Take your relational data warehouse query performance all the way to ELEVEN!!  The Column Store Index is a new feature that allows for stunning performance.  We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.
Speaker:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

Agile development is all the rage, but how do the principles apply to database administrators? This presentation will introduce the basics of the Agile Manifesto, and explain how they can be applied to non-development IT work, such as database administration, maintenance, and support. We’ll cover scrum (one of the most popular development methodologies) and kanban, and identify some of the common struggles with implementing them in an organization. This is an interactive discussion; please bring your tales of success and your horror stories.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: September 08

Time: 12:00 AM - 1:00 AM

Room: TBD

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