Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 38
In this session, Ben will show you a basic overview of developing with C# presented from the perspective of a DBA. This webinar will provide basic information on the .Net framework as well as how to present data, and best practices.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
1202 (Auditorium 2)

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, Donny Johns will show you how to accelerate your BI development lifecycle with BI xPress. You’ll see how to implement advanced SSIS frameworks, implement code reusability in SSIS and write MDX calculation code in seconds with this must have time saving application. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI (Auditorium 1) -1102

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

The current job market is extremely competitive. Unfortunately getting the job offer is not enough –new employees are expected to delivering ROI immediately. It becomes critical for them to take an ownership of the system in a matter of days to keep the position they won. 

This session shows how to analyze the system state using wait statistics, DMO and performance counters. It demonstrates how specific resource bottlenecks relate to design and code issues, shows how to pinpoint the most problematic queries and detect anti-patterns and design issues in the system

The session is targeted to both DBAs and Developers who want to become familiar with the necessary techniques helping to take an ownership and detect issues in the system.
Speaker:

Session Type:
Regular Session

Track:
1404

Level: Intermedia

Session Code:

Date: April 30

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:
1406

Level: Advanced

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

I will demonstrate how to develop MS Excel BI Dashboards in the following ways: 
1. Workbook style with Office data connections stored on local PC or networked document drive
2. excel services style using Reports Library SP 2007 for storage of the Office data connections & workbook that excel services will render
3. Convert excel pivot table into excel OLAP formulas
4. Discuss SP 2010 BI Center
5. Discuss references to cap off session.
Speaker:

Session Type:
Regular Session

Track:
1400

Level: Intermedia

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is designed to help you build a professional development plan using the same techniques that are used for building business plan. We'll talk about obtaining and managing resources, setting realistic goals, tracking progress, and what to do when you get off plan. At the end of this session you should be ready to spend a few hours building a plan that will help you move your career forward to a goal that you've selected.
Speaker:

Session Type:
Regular Session

Track:
1404

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session hosted by Chris Albrektson we will have several different speakers present a unique “tip or trick” that will help you succeed in your day to day BI tasks. Each mini-session will last about 5-10 minutes. The entire session will cover all aspects of the BI stack (SSRS, SSIS, SSAS) so everyone should attend.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1402

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, attendees will learn how to create simple, yet effective dashboards using some of the new tools added to SSRS 2008 R2. Shawn will also discuss some dashboard best practices. 
Speaker:

Session Type:
Regular Session

Track:
1402

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will demonstrate “How to build data mining solutions to address predictive analytics needs of your organizations” . This is a basic session and intended to target audience with none or limited exposure to Data Mining.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1400

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

During this presenatation the speaker will demonstrate various functionality of Excel Data Mining Addin.
The presentation will also go over real life scenarios to demonstrate the application of Excel DM addin.
Attendees will be able to see the role of Excel Data Mining Addin during the lyfecycle of a Data Mining and Predictive Analysis project.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1400

Level: Intermedia

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn the basics of why data recovery is the most important factor in designing your backup strategies. Brandie discusses what business considerations are most important and how to weed the out the unessential requirements to obtain information you need to get your job done. 
Speaker:

Session Type:
Regular Session

Track:
1402

Level: Intermedia

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA’s) lump disaster recovery (DR) & high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and based on what? It’s incredibly important that you understand the decision tree that helps you pick the right one(s) for your business, and that you can explain the choices clearly to the stakeholders. It’s not as complicated as it sounds, but it is complicated – and in this hour presentation we’ll give you a high level understanding of the options, the costs, complexities, & reasons for using each of them.
Speaker:

Session Type:
Regular Session

Track:
1406

Level: Intermedia

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Having trouble finding a position or make yourself visible in today's market?
This session will provide tips to help build up your existing brand or land the next job!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1202 (Auditorium 2)

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

The ability to audit in SQL server has been available for quite some time using different tools and techniques.  This session will outline several methods to implement audtiting, but will focus primarily on SQL Audit.
SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits. 
Speaker:

Session Type:
Regular Session

Track:
1404

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Overcome the barriers of traditional training and seminars with this Quick Start to building a cube and power pivot solutions. This all demo session will get you started and answer many questions you have about building cubes and reports the right way, the first time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI (Auditorium 1) -1102

Level: Intermedia

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session Mike shows how a complete BI solution is built from the transactional system to the finished Cube and reports. He will go over the steps involved in planning a BI solution and how to make your project successful. You will get an understanding of the roles SSIS, SSAS, and SSRS play in building a BI solution.
Speaker:

Session Type:
Regular Session

Track:
BI (Auditorium 1) -1102

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this beginner session, Dustin will introduce the audience to Multi Dimensional Expression language. Attendees will learn about MDX query syntax, how to write a basic MDX query, and about more advanced MDX queries involving time and hierarchies.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
1202 (Auditorium 2)

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables. 


Speaker:

Session Type:
Regular Session

Track:
1400

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will help get you past the learning curve of SSIS. We will cover the basics of the development environment, the control flow and data flow. We will show you how to create an end to end package to demonstrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI (Auditorium 1) -1102

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing & redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution as well as alternatives we may wish to realize.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
1404

Level: Beginner

Session Code:

Date: April 30

Time: 12:00 AM - 1:00 AM

Room: TBD

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