Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 51
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:
SSIS/SSRS

Level: Advanced

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Created for the seasoned developer, this session explores the features that can, literally, save hours of work.  Learn how to create your own templates all the way to special DevEnv switches you can use to quickly reconfigure your environment.  These are the super tips that can turn a ten minute task into ten seconds.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
.NET I

Level: Advanced

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “self-service BI” as a concept. We then provide a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service …”
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

 Gain exposure to the Server side of PowerPivot with Microsoft BI Architect and SQL Server MVP Bill Pearson. The targeted audience of this session includes professionals who will be planning, deploying and maintaining the server side of PowerPivot. Among other BI architects and developers, this overview will be of particular interest to SharePoint Admins who are new to capabilities for sharing and managing PowerPivot applications created with PowerPivot for Excel.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SharePoint

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Have you ever wondered who made a change to your structures or data?  Do you need to find out who has permissions to do what in your system?  This session will take you on a tour of auditing for internal, SOX or HIPPA Compliance.  


How much of a summary do you need?  Or will this work?  I will go into some data forensics as well, but to keep it within the time limit, I will structure it to structural changes, not so much the data itself, though the same techniques apply.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS/SSRS

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Multi-core processors are becoming pretty prevalent for most business user's workstations these days. This trend has increased the benefits for developer's to take advantage of multiple threads in applications. While not every application will benefit from being multi-threaded this programming tool should be in every .NET developers tool belt. Unfortunately in my experience the majority of .NET developers are not comfortable with this programming paradigm and are afraid to ask. This session dives into the basics behind threads, outlines all the different threading options in .NET, and then walks through programming examples using .NET 2.0 and 4.0. 
Speaker:

Session Type:
Regular Session

Track:
.NET II

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Most database professionals know (from firsthand experience) that there continues to be a "data explosion". Databases are getting larger, and working with Very Large DataBases (VLDB's) is becoming more commonplace. The focus of this session is to identify some key guidelines for the design, management, and ongoing optimization of VLDB's. 

Special attention will be paid to the following areas: 
* query design 
* logical and physical data structures 
* maintenance & backup strategies 

Speaker:

Session Type:
Regular Session

Track:
SQL Admin II

Level: Beginner

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Business Connectivity Services (BCS), formerly Business Data Catalog, is a SharePoint 2010 service that allows developers to read and write data to and from external line-of-business (LOB) systems. In this session you will learn best practices in developing BCS solutions, including when to use BCS for your SharePoint projects, choosing the right type of BCS solution, securing your BCS solutions, and development techniques to use when creating your BCS solutions.
Speaker:

Session Type:
Regular Session

Track:
SharePoint

Level: Intermedia

Session Code:

Date: August 06

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SQL Admin II

Level: Beginner

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

The whiz-bang visual designer features of the Entity Framework demo well, and may even work for small projects, but anyone who's worked with EF knows that on larger projects, the design surface quickly becomes unusable and a bottleneck to your development process. Thankfully, the Entity Framework team has heard our anguished cries and introduced a new API for defining your EF models, dubbed "Code-First". In this presentation, Brian will guide you through building a true POCO model, basic mapping techniques, and leveraging conventions to keep your mappings DRY.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
.NET II

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way your organization functions. In this non-technical session Carlos Bossy will show you what a BI project looks like and how it is different from other IT projects, how to determine the ROI of a BI project, the makeup of a good BI team, how to define the success of a BI implementation, and how to fix a BI project gone bad. You will also learn how to evaluate your BI & Analytical Strategy and you should leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: August 06

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 rely on a metadata mart. The end result a greatly reduced TCO(development effort) for generating the code required vs manual coding. 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:
SSIS/SSRS

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Introduced as a part of the Sql Server 2008 R2 platform, StreamInsight is Microsoft's Complex Event Processing (CEP) engine. It allows you to analyze and process large volumes of data - think tens to hundreds of thousands of events per second - with sub-second response time. It's as close to real time as you can get without quantum entanglement! The Sql Server engine may be fast ... but it's just not that fast. 
This presentation will introduce core CEP concepts and sample uses cases and then dive into kinkiness with real-time data, including hosting StreamInsight, getting data into (and out of) the engine, how time is handled, writing queries in Linq and how to extend the StreamInsight engine.
It's a whole new paradigm of looking at data
Speaker:

Session Type:
Regular Session

Track:
Bonus Track

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session Jose will do an overview of the different types of hierarchies and how to design user hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will learn how to implement natural & unnatural hierarchies, balanced and ragged hierarchies, and Parent-Child hierarchies. Jose will show how to optimize SSAS hierarchies by specifying attribute and dimension types, member uniqueness, and aggregations. Jose will also do quick intro on querying hierarchies with MDX.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Advanced

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

This session explores the rich visualization capabilies of Reporting Services 2008 R2. Beyond the standard capabilities to deliver data using grid layouts (tables and matrices), Reporting Services includes Chart, Gauge, Map, Data Bars, Sparklines and Indicators visualizations.

Learn what each delivers and how to configure them to produce visually compelling reports. Furthermore, learn how the Chart is also available to developers to embed directly into .NET applications.
Speaker:

Session Type:
Regular Session

Track:
SQL Admin I

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks or packages that adhere to a pattern, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you'll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS/SSRS

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

While most enterprise applications are object-oriented, the data upon which they depend is not. Unfortunately, binding these two platforms together can result in significant amounts of lost productivity and a less than optimal solution.

Come see how you can resolve this recurring theme with the Microsoft ADO.NET Entity Framework.  In this session, we’ll…

•	Explore the Entity Framework 4, its components and see how it all works
•	Generate a business object model with database mappings, demonstrating database-first, model-first and code-only approaches
•	Walk through a variety of code examples that show how to interact with the model
•	Show how the Entity Framework automatically tracks data changes and generates updates
•	Deep-dive 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
.NET I

Level: Beginner

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you a big fan of productivity plugins like ReSharper, CodeRush and SSMS Tools Pack? Ever wondered how you can write your own plug-ins for Visual Studio or Sql Server Management Studio? Come to this session to learn about the different ways to extend these editors. We'll see how one can create extensions, add-ins and packages and add new functionality to  Visual Studio and Sql Server Management Studio.
Speaker:

Session Type:
Regular Session

Track:
Bonus Track

Level: Intermedia

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you want to learn or have a refresher on the fundamentals of object-oriented programming and C#? This session is perfect for the DBA who must occasionally code and the developer who wants a deeper understanding of C# and OOP.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
.NET II

Level: Beginner

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

Integrated metadata is a required element of all RDBMSs. In addition to ANSI INFORMATION_SCHEMA and metadata on implementation-specific features like indexes, SQL Server also offers a very powerful extended properties feature. In this talk, I cover using the basic metadata combined with extended properties and demonstrate practical usage to organize and document a system's design and monitor the health of a system's compliance with design rules.
Speaker:

Session Type:
Regular Session

Track:
SQL Admin II

Level: Beginner

Session Code:

Date: August 06

Time: 12:00 AM - 1:00 AM

Room: TBD

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