Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 35
This session is geared for people who write SQL and have little to no experience with Execution Plans; we will go over how to read an execution plan, how to improve server performance based on the results and common things to watch out for.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA-1

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is a primer to understanding the differences and advantages between Analysis Services and PowerPivot; which scenarios to use analysis services vs. PowerPivot and how both serve to provide a perfect BI platform addressing short term vs. long term BI needs of organizations. We will focus on the differences between the two storage methods that are available for creating a BI Semantic Model, OLAP and Tabular, including a deep-dive into comparing Analysis Services vs. PowerPivot on topics such as security, hierarchies, KPIs and scalability. Understand when you should use PowerPivot in comparison with SQL Services Analysis Services (OLAP) so you are equipped to create robust Self Service BI applications in your organization.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-2

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Why creating SQL Server performance baselines is important. Methods and approaches for baselining. How you can make use of baselines. Tools and applications that can help.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-1

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this introductory session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-2

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Unlike SSIS 2008, there are a number of developer improvements in SSIS Denali, beyond the rounded corners and new icons.  This session will explore the changes and how they improve the developer experience. 
Speaker:

Session Type:
Regular Session

Track:
DEV-1

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you will be introduced to some simple PowerShell techniques, and see how to combine them to create an event-driven listener job running in SQL Server Agent service. Designed to be accessible to database administrators and database developers, you will see how easy it is to create useful scripts in PowerShell.
Speaker:

Session Type:
Regular Session

Track:
DEV-1

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA-1

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

With SSRS we can quickly generate reports that can be exported to multiple formats.  What happens when you want to extend your report  with custom code?  Perhaps you need a custom authentication layer, custom access to data requiring .Net code, or you want to extend some of the controls that come out of the box with SSRS.
In this session we will see an example of extending SSRS  to use a .Net library for a data provider allowing us to use a custom .Net business layer for our report.  We will also show an example extension to the SSRS graph control allowing us to make design graphs for SSRS.  Custom code is a great alternative for those considering using toolkits like Nevron or Dundas toolkits to extend their SSRS graphing capabilities
Speaker:

Session Type:
Regular Session

Track:
DEV-1

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Having consistent, regular, verified backups are only a starting point. When failures happen - and they will happen - can you recover your database?  In this presentation we will dive into the mechanics of database restores and discuss how choices made previously in database/server/backup design can have profound effects on how (& what) you can recover.  We will also discuss spectacular ways to fail miserably... all in the hopes of preventing those same failures in the future. 
Speaker:

Session Type:
Regular Session

Track:
DBA-2

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Working with data is core to what we do as developers. With the release of the Microsoft SQL Azure Database cloud offering, developers have a new set of options and features that make it possible to take full advantage of the scalability and availability of this platform. In this webcast, we take a look at what SQL Azure means for developers and show how to create and manage a database in the cloud. We also explore the tools and the practices for using the tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV-2

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft has a number of certifications for SQL Server.  They cover the DBA, developer and business intelligence skills.  But, does anyone take them seriously?  In this session, see the tracks for SQL Server certifications and discover what you need to know about the exams.  Which track will be right for you?  What steps should you take?  How do you get going?  And what value will they bring to your career? 
Speaker:

Session Type:
Regular Session

Track:
Prof Develop

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment. 
Speaker:

Session Type:
Regular Session

Track:
DBA-1

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Prof Develop

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will explore the many and varied uses of the map report item in Reporting Services. From providing geographic analytics to diagramming locations on a warehouse floorplan, the map report item – when combined with SQL Server spatial data types - can be used in a variety of ways to create spatial representations of your data. We may even look at a game or two created using the map report item. 
Speaker:

Session Type:
Regular Session

Track:
Prof Develop

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

A comparison of SQL HA & DR options, by a practitioner who has implemented & managed all the SQL HA and DR approaches (& various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up & running & optimized for managed-services customers. We will compare trade-offs between the various SQL HA & DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.


Speaker:

Session Type:
Regular Session

Track:
DBA-1

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will provide an overview of what PerformancePoint is, where it came from, and how do you get it.  We will also discuss what’s changed in the 2010 release (including with the latest SP1 update).  Along with this we will go over the Dashboard Designer tool showing you how to install it and explain what it is used for.  Then hold on to your seats, I will build out and deploy a fully functional and interactive dashboard.  Along the way I will provide insight from the trenches including tips and tricks along with experience from client deployments.
Speaker:

Session Type:
Regular Session

Track:
BI-1

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Understand the basics of SQL Server locking including lock modes, lock granularity and lock escalation.  Also what is blocking, why should you be concerned and what you can do about it.
Speaker:

Session Type:
Regular Session

Track:
DBA-2

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Data mining provides a powerful tool for predictive analysis. These capabilities are available free as part of your SQL Server license. Unlock this powerful analytical tool to assist with decision making, cross-selling, and data analysis, and other areas within your organization.
Speaker:

Session Type:
Regular Session

Track:
BI-1

Level: Intermedia

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Just starting or thinking of starting a data warehousing project but not sure where to begin.  Or still not sure if your organization needs a data warehouse.  This discussion is geared towards answering the what and why (or why not) of data warehousing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI-2

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Just getting started with SQL Server Integration Services (SSIS)?  Not sure where to start? Or have you been using SSIS for a little while now and are still trying to figure out the basics.  The biggest barrier to learning something new is figuring out the first few steps.  We will discuss what SSIS is and a few lessons learned.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DEV-2

Level: Beginner

Session Code:

Date: November 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 35
SQLSaturday