Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 40
Synchronous and asynchronous components, memory buffers, data type choices. Tuning the data flow is all about choices. In this session we'll explore some of the choices that can give you the biggest performance boosts in your ssis data flow. Together we'll walk through creating a performance baseline, the differences between synchronous and asynchronous components and a few simple patterns we can implement to improve performance in our SSIS packages.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance/Security

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

A chance for both new and seasoned speakers to present for 5 minutes on their favourite topic. Prizes awarded for the best and most entertaining lightning talk.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
MISC

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance/Security

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities, and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This is the initial session of a set of detailed Best Practices presentations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

See how to deliver the next generation of Business Intelligence software and analyze data using drag and drop operations. We will look using a Silverlight front end with interactive data analysis for uncovering new trends. Learn how to build interactive dashboards with multiple views of the same data, data binding, analyzing unstructured data, combining charts and Pivot tables into one project and more. Join Russ Fustino in this very informative developer oriented session. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance/Security

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

In warfare, understanding your enemy is a supreme advantage. The same is true when it comes to protecting SQL Server. We’ll get into the mindset of an attacker, looking at the methods and techniques attackers use to go after SQL Server. Once we understanding the threats, we’ll then examine defensive techniques to secure and protect our SQL Servers, using both new and creative methods, as well as the tried and true.
Speaker:

Session Type:
Regular Session

Track:
Performance/Security

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Who wouldn’t want to create unbelievable dashboards that executives can get excited about?  PerformancePoint Services is perfect tool for creating interactive dashboards viewable from inside SharePoint.  In this session Devin will talk you through getting up and running with PerformancePoint and how to create a basic Dashboard including a KPI, Scorecard and Report.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Imagine your business with fewer integration projects, coming in on time and under budget.  Let us further imagine your business making great decisions based on the right data at the right time.  In this session we will explore the concepts of data quality, as well as some of the tools and initiatives which relate to scoring your data and correcting your business processes for data input.  This is NOT a presentation on Data Quality Services, although we will look at how this new tool might fit within your data quality initiatives.  Return to the office informed and invigorated with the knowledge that bad data can be overcome!  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

In today's economic times, we are being asked to do more with less. Less budget, less hardware and yet our data needs keep growing! So how do we keep our database infrastructure humming along given these restrictions? In this session we will talk about different options of consolidation including: database-level consolidation, instance-level consolidation, and virtualization. Additionally we will also talk about some of the tools and methods you can use today to help you consolidate your SQL Server environment and do more with less!
Speaker:

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

There are a number of encryption options in SQL Server and this session will talk about many of them, looking briefly at TDE, hashing, encryption keys, and SSL encrpytion.
Speaker:

Session Type:
Regular Session

Track:
Performance/Security

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

So you been using Execution Plans for a little while and want to know more. This session will look deeper into Nested, Merge and Hash Joins. What to look for in the memory grants will be discussed. Using MAXDOP and Cost Threshold will be demostrated to understand parallel plans. Demostrations will show Aggregate Iterators and how to find out if the optimizer is smarter than us. 2012 enhancements to execution plans will be shown throughout the demos
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance/Security

Level: Advanced

Session Code:

Date: June 09

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

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

FileTable and Statistical Semantic Search In SQL 2012
It’s like having the biggest junk drawer EVER.  That’s often what our “Document Repositories” become.  You know you have that golden nugget of information that you’re searching for, and it’s in there somewhere, but you can’t find it. This session explores a new feature of SQL 2012 called Statistical Semantic Search. It's like having a closet organizer on staff at all times.  While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. New scenarios we will look into will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
New in 2012

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

It is easy to schedule full backups to run each night, but is that the right decision for your organization?  You say you have a backup strategy, but what is your recovery strategy?  Do you have a well-executed recovery plan?  

In this session Tim Radney will cover several methods for performing much needed backups and how to recover those backups.  Full, Differential, File Group, Transaction logs and recovery the tail end of a the log.  He will discuss industry best practices and hopefully cause you to validate and test your current strategy.
Speaker:

Session Type:
Regular Session

Track:
MISC

Level: Intermedia

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Do your eyes glaze over at the mention of tuples, domains, or even basic SQL terms?  Have you moved to SQL Server from MS Access, or Excel, or other non-relational database products?  This session will help explain the basics of set theory and relational theory using actual Lego blocks.  We will illustrate terms and concepts such as joins, unions, and set-based operations, and how you can translate them into actual SQL.  If you're an absolute beginner to SQL, or feel overwhelmed by the baggage of computer data models, or would just like to play with Legos, you'll both enjoy and learn something during this session.
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft’s SQL Server team has provided a unique set of capabilities for Business Intelligence. With Power Pivot, Power View, and SQL Server Reporting Services (SSRS) provides a full breadth of capabilities that can be utilized to mash up data across the enterprise. In this session we will walk through the product stack and determine how they can be utilized within your organization to provide greater insight into your business data.      
Speaker:

Session Type:
Regular Session

Track:
DEV

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and Q&A so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome new feature!
Speaker:

Session Type:
Regular Session

Track:
MISC

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Excel Services is an extremely powerful tool that you can use inside your environment to help improve workflow and collaboration. Some of the topics discussed will include the service application, associating the application with your SharePoint site, data connections and the unattended service account. We will also talk about how PowerPivot for Excel translates into the SharePoint experience including setup, deployment and what happens in the background. Most of the time will be spent talking about PowerPivot and this exciting new technology.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

Accidents happen, and when they happen to our computer systems, they are disasters. Steve Jones will talk about the disasters that are likely to occur in your computer systems and the steps you can take to minimize the impact to your environment. Tools used: SQL Backup Pro, SQL Virtual Restore, SQL Monitor
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA

Level: Beginner

Session Code:

Date: June 09

Time: 12:00 AM - 1:00 AM

Room: TBD

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