Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 39
Attribute discretization is an oft-overlooked feature in Analysis Services that allows us to automatically create a manageable number of groups of attribute values that are clearly separated by boundaries. Discretization can help us to make it easier for information consumers to work with large numbers of possible attribute member values. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson discusses the varied options, the design (and other) considerations involved, and best practices surrounding the use of this capability. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS and BI

Level: Intermedia

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker:

Session Type:
Regular Session

Track:
MISC

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

In this presentation we will walk though utilizing Microsoft SQL Azure, a scalable cloud database service built on SQL Server technologies, and the Microsoft Sync Framework, a comprehensive synchronization platform, to build a highly available and scalable collaboration business application. Along the way we will discuss the capabilities and challenges of building such an application using the current frameworks.
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

SMO gives us an exremely powerful library that can be used to perform a slew of SQL Server tasks.  Using this library we can build tools to automate daily tasks and even build apps that might not be easy to do or even possible with SSMS/TSQL.  In this session I will teach you, the non-programmer DBA, how to build an SMO application that performs some SQL Server health checks and reports back to you in a nice GUI tool.  We will go over some basic OOP information but the bulk of this session will be hands on building/demoing. No .NET experience is required. The less experience you have with .NET development the better!!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, Bryan Soltis will demonstrate deploying a Kentico CMS application to Windows Azure. Topics covered will include converting a Kentico CMS site to a web application, adding and configuring a Windows Azure web role, implementation and configuration of Windows Azure storage accounts, deployment of a Kentico CMS database to SQL Azure, and deploying the application to Windows Azure. Bryan will demonstrate several code examples, real world applications, and best practices in developing Kentico CMS in the cloud.
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Advanced

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS and BI

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

One of the biggest hurdles  in any organization is migrating from DEV to PROD with minimal issues.  In this session Brad will help get you over the learning curve of making dynamic SSIS packages to make this transition easier.  Topics of discussion will include using all the different types of package configurations, the SSIS expression language and variables.  After diving into each of these topics Brad will talk about best practices as well as the pros, cons and limitations of using each type of configuration.  At the end of this session you will be able to configure your SSIS packages to be as simple to modify and move without even opening a package!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS and BI

Level: Intermedia

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

For those attendees who want to attend the Entity Framework version 4.1 session, but aren’t quite sure what Entity Framework is, and how to get started with the basics, this talk with some background info and basic demos will get you up to speed. This will use the traditional EF approach of creating a model using a designer based on an existing or new database.
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

Originally released with Visual Studio 2010 and .NET Framework v4, Entity Framework v4 has seen a remarkable evolution in the past year or so. In April, Microsoft released version 4.1. Most notably, there is now great support for Code First development. This talk will delve into the use of Code First in Entity Framework v4.1 and will be very code focused. Developers will learn how they can use the Entity Framework APIs to create applications that use Entity Framework features to access relational databases without the need to use designers to create the model. It is in essence a "code only" approach, which has many benefits, including for testability and long-term evolution of your code.
Speaker:

Session Type:
Regular Session

Track:
MISC

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window? 


Speaker:

Session Type:
Regular Session

Track:
Performance

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

When you get your app running… and even more so when published… you are most likely feeling pretty good and on cloud 9. It feels great, doesn’t it? Here are a few suggestions in this chapter to make you feel even better. Of course, more work is needed. Getting your app noticed in marketplace will not happen automatically or optimally by publishing alone. There specific suggestions I will offer up to help the cause. So, grab a deep breath and get ready to settle in and focus on making more money. Make all the time you have invested so far, well worth it. Many of the suggestions are common sense when you think them through, but are a few I found out the hard way and hopefully will save you some pain.  Topics include: Marketing Basics,  Gettin
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Windows Phone Garage

Level: Intermedia

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you will learn why you need a Data Warehouse, how to plan for one, and what the key steps to developing one.  You will learn conceptually how you can leverage the Microsoft BI Stack to design and implement a Data Warehouse.  This session will focus more on the concepts of development rather than demonstrating the development itself.
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Azure is part of the Windows Azure platform: a suite of services providing hosted computing, infrastructure, Web services, Reporting services and data services. The SQL Azure component provides the full relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft datacenters around the globe. We will go over how it works and what it has to offer.
Speaker:

Session Type:
Regular Session

Track:
DBA and TSQL

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

Take advantage of the Open XML format and the .NET SDK to construct and manipulate documents, allowing for simplified interactions with Office documents. This session covers the Open XML format, the Open XML SDK, and shows some examples of how to apply this in real world solutions.  We’ll also discuss the role of some of the SharePoint Office Services.
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Intermedia

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we’ll take a look at how to load data into SQL Server using various data sources such as: text, csv, table.  We’ll also load data from XML files; update data inside of XML files; and even kick off SSIS packages all from PowerShell.  Finally we'll re-use our newly found XML scills to modify an SSIS package before we run it.
Speaker:

Session Type:
Regular Session

Track:
MISC

Level: Intermedia

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time.  Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.
Speaker:

Session Type:
Regular Session

Track:
Performance

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will look at examining execution plans as a method for performance tuning. With the execution plan we can see the exact type of operation performed, and, more than that, we can look at the differences in what the optimizer thought the query would cost vs what it actually cost to perform the query. By examining the plans we have a road map for determining what type of improvements we should be striving for in order to make the particular statement more optimal.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance

Level: Intermedia

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

This fast-paced session will construct a PowerPivot for SharePoint dashboard, analyzing a humorous, everyday problem-set. Beginning with installing PowerPivot for Excel and concluding with a working, interactive dashboard, this session will prepare attendees to leverage PowerPivot to load data from disparate, related sources. Limitations for creating good relationships, and the construction of good dimensions will be covered. Finally, surfacing the assembled data using slicers, charts and tables. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
MISC

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

Predictive analytics is no longer exclusively for those shops that have the resources to design and implement an entire BI architecture. In this session, we will review a class of modeling problems that are not only quite powerful, but are amenable to implementation via relatively simple T-SQL querying. All it takes to get started is the data available in your OLTP system, a basic understanding of the math, and a bit of imagination…
Speaker:

Session Type:
Regular Session

Track:
DBA and TSQL

Level: Intermedia

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will showcase how a DBA can be ready for any problems that might occur in their environment. Steve Jones will talk about how you can develop a well thought out backup and recovery solution for all kinds of disasters, learn about practicing restores, and the value of regularly running checks for corruption in your databases..
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 04

Time: 12:00 AM - 1:00 AM

Room: TBD

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