Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 61
Whether you are new to the role of DBA, being "forced" to take on its responsibility or joining a new company with previous experience, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the "itties" of Database Administration (Recoverability, Availability - Health & Performance - , Security and Reliability) we can see a natural priority form. Throughout this interactive discussion we will also look at some of the available tools and scripts to help see where our environments rate. Mike emphasizes our role as "Protector of the Data" as a DBA throughout.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA2

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Are your internal auditors asking that the administration of SQL Server logins be handled by a third party other than the DBAs? Is your Compliance and Audit departments asking you to determine if password policies are being enforced, who are sysadmins on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX).  
Speaker:

Session Type:
Regular Session

Track:
Powershell

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

You have installed SQL Server in your environment, but now what? Unfortunately, far too many servers are neglected after SQL Server has been installed and the applications are up and running. In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them.
Speaker:

Session Type:
Regular Session

Track:
DBA2

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

This session begins with a simple SQL database with several related tables.  It then shows how to import those tables to create a simp;le cube in Analysis Services.  Given a simple, but functional cube, the session then goes into Excel to use the cube in Pivot Tables and Pivot Charts.  Finally, you will see how easy it is to publish those Excel Pivot Tables and Pivot Charts into SharePoint using Excel Services to protect the calculation methods while allowing anyone with a browser to see and use your results.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

It's not always an all SQL Server world. Come see some benchmarks and tips on when and where they alternatives are best used.
Speaker:

Session Type:
Regular Session

Track:
DBA2

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Building dimensions using the Slowly changing dimension wizard in SSIS is simple and quick. However its performance and flexibility is questionable. Even further, when trying to perform incremental loads of your Dimensions using the aforementioned approach or a custom approach prior to Change Data Captured (CDC) offered certain challenges. In this session Patrick will show you how to utilize CDC and SSIS to incrementally load Type I and Type II dimensions using features that are all native to SQL Server 2008.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
Speaker:

Session Type:
Regular Session

Track:
Performance

Level: Advanced

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

We all know that every environment is different, so how can we expect the default SQL Server installation to be optimized for each one. In this session, we will look at some of the configuration options you can change after you have installed SQL Server to maximize performance, security, and reliability. We will also cover the configuration changes you should make that are often overlooked after your server or your database has been upgraded.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Overview of data encryptions and key management that is build into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will learn about using Microsoft SSIS and SQL Server 2008 to host a data warehouse.   We will work through an introduction to data warehousing and look at how we can use the Microsoft tools to build a small data warehouse.   
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently). 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
TSQL

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will present a top 10 (maybe 20) list of queries and tools that DBAs can use daily. The idea is that everything is included on a single 1G or less thumb drive to be portable. From simple T-SQL statements to full blown SSIS packages, the session demonstrates how to interogate, diagnose, report on, and resolve issues that are most prevalent for DBAs: disk space, security, backup locations, database and server documentation, performance and much more. All queries, which are SQL 2000, 2005 and 2008 tried and true will be made available in the session to copy to your own thumb drive. If you are lucky you might even receive a free coveted thumb to store the queries. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server is the database engine supporting the Line-of-Business applications that run your business, so how do you make sure it is always up and providing those critical services? This session will look at several alternatives for designing and implementing a highly availble architecture for your SQL environment. Options will be presented to give a range of availability scenarios based on Service Level Agreements, as well as budget.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide and detailed look at developing applications with SQL Azure. It will begin by providing an overview of existing functionality SQL Azure provides, then delve in to utilizing the features and technology to migrate existing applications as well as develop new applications with SQL Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Misc

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Sherri McDonald will be presenting a tool that documents your major SQL Server components and the "entire" BI stack.  Your team can now view historical data from SQL Server Databases, Integration Services, Analysis Services and Reporting Services in a format that is easy to navigate and understand.  See a visual snapshot of your environment that includes images of their SSIS packages, ER Diagrams as well as an Impact Analysis Object Lineage. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Misc

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will look at performing common data loading tasks with Powershell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Powershell

Level: Intermedia

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

A look at the various properties of identity columns.  We will discuss how identity columns behave in triggers and replication.  We will look at the property functions and catalog views to retrieve metadata about identity columns.  We will also see how to override default identity information and specify a value, and reseed an identity column.
Speaker:

Session Type:
Regular Session

Track:
TSQL

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

What do you do when SSIS can’t handle your data volumes or data sizes? Join expressor software for a discussion and demonstration of their data integration software. expressor software allows organizations to reuse the most labor-intensive elements of data integration projects, deliver superior data processing performance, and reap significant cost savings in both development and project lifecycle management and in hardware and software licensing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Sponsor Demo

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

The naked truth about engaging your audience in a lively and entertaining presentation where both speaker and attendees have fun. Note that neither the presenter or the attendees will be naked for this great how-to session!
Speaker:

Session Type:
Regular Session

Track:
Performance

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn more about Information Builders
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Sponsor Demo

Level: Beginner

Session Code:

Date: October 16

Time: 12:00 AM - 1:00 AM

Room: TBD

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