Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 36
Producing a good looking report will wow your business users even if your data isn't all that impressive. If you've ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008 R2. With the knowledge in this session, you won't ever need to show a plain, boring report again!
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

We will cover some basics about setting up simple replication tests and dive into what happens to the underlying meta-data when changes are replicated.  A good opporunity to see a demonstration style explanation of what goes on 'under the hood' during replication.  Scripts will be provided.
Speaker:

Session Type:
Regular Session

Track:
Advanced

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Profiler (and its underlying subsystem, SQL Trace) is a tool for recording a SQL Server instance's activity. This diagnostic and performance data is valuable for troubleshooting and characterizing a system's workload. Like any powerful tool, misuse can be quite harmful, so great care must be exercised. This session will teach you how to efficiently configure, run, and analyze the data from traces, while minimizing the overhead of the data collection and avoiding common pitfalls.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Beginner

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

The purpose of this session is to review Analysis Service's security model and explore ways it can be effectively used to deliver complex security requirements.  Topics to be addressed include administrative security, dimension data security, cell-data security, and even dynamic security techniques.
Speaker:

Session Type:
Regular Session

Track:
Advanced

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.
 
Speaker:

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will introduce techniques of integrating algorithm output with production data. Example code and lab will use data sets beyond Adventureworks.Topics include: Applying multiple models Developing a scorecarding system Assessing the most effective model Track population stability and algorithm performance over time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we'll cover all the pieces of a classic Kimball style data mart (Star schema, fact tables, dimension tables).  We'll talk about the data warehouse bus architecture and how it can be used to quickly create data marts with conformed dimensions.  We'll talk about what it means to have conformed dimensions and why it's important.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Beginner

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

We will take a look at what needs to be done to get Reporting Services up and running and how the Server actually works.  We will also look at what features the different designers provide and how to know which Viewer Control with your application.
Speaker:

Session Type:
Regular Session

Track:
Beginner

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

There are times as a DBA that you need help from other DBA’s, especially if you’re the only DBA around. We will talk about the various ways of getting help (Twitter, SQL Server Central, StackOverflow). We will talk about how to ask for help (and the ways not to).
Speaker:

Session Type:
Regular Session

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Quick - what’s the difference between LEFT and RIGHT OUTER JOINs? How do you know that a NULL in your result set is from the table data or is the result of the join? If you’ve ever struggled with the ins and outs of joins and join syntax then this presentation is perfect for you. This presentation presents a straight-forward and logical approach to understanding and visualizing joins and focuses heavily on the “how” and “why” of the various join types. 
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Starting in the SQL Server Denali release, data takes on a new life in the business intelligence world.  Often forgotten, data management needs to be an integral part of your reporting systems.  Learn how Microsoft has made your life easier by incorporating external parameters, environments, and groupings into Integration Services.  They have also included impact analysis and data lineage, which can be tied to tables and SSIS packages.  Two additional newcomer products, data quality services and master data services, complete the quartet.  This session will use the first Community Technical Preview of SQL Server Denali to describe and demonstrate the enhancements to the four products that make up EDIM.
Speaker:

Session Type:
Regular Session

Track:
Futures

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how, when and why you may want to incorporate CLR functionality into the database.
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Mirroring can be an integral part of your high availability and disaster recovery planning. We’ll cover what mirroring is, how it can fit into an HA/DR plan, the rules surrounding its use, configuration via the GUI and T-SQL, as well as how to monitor mirroring. This presentation is designed to not only give you an overview of mirroring, but to also walk you through a basic implementation. At the end you will have learned what mirroring is, how it can fit into your environment, what business requirements it solves, and how to configure it.
Speaker:

Session Type:
Regular Session

Track:
Administrator

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

What is SQL Server? It's just software.  What is SQL Server for?  At its simplest, it lets you store data safely, and get it back out again.  Is there a right way to say "SQL"? Yes, actually! In this session we will work with the tools to show you around SQL Server, and explore what it can do.  If you're looking to get into databases, this is your session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Beginner

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we are going to take a surgical approach to why I as a DBA fear ugly ORM's. Even though you can use views and stored procs as plastic surgery for an ugly case of ORM, there is only so much you can do if it is ugly on the inside. Slides generally bore me, so we will only be looking at a couple before we put on our scrubs and hit the OR(M) to perform an uglyectomy to create an ORM we can live with.

Technologies: I'll be using Entity Framework 4, Linq, MVC2 and a variety of virtual surgical tools.
I ranked this session as beginner with regards to the topic of ORM's. My session makes assumptions you know about execution plans, traces, the optimizer and other non-beginner topics in SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Developer

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

In Nov.2010, Microsoft officially released SQL Server 2008 R2 PDW Edition. Parallel Data Warehouse is a true MPP (massive parallel processing) platform featuring an ultra shared nothing architecture.  PDW is capable of delivering very fast query performance and can house up to 500 TB of data.
This session will overview both the HW and SW architecture of the PDW appliance.  It will explain how Microsoft and HP have engineered a solution using commodity HW and SW that can compete with more expensive platforms like TeraData and ExaData.  Additionally, SQL DBAs will see where their current skillset is applicable to managing a PDW appliance.
Speaker:

Session Type:
Regular Session

Track:
Futures

Level: Intermedia

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
Speaker:

Session Type:
Regular Session

Track:
Developer

Level: Advanced

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Administrator

Level: Advanced

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session you’ll learn how to use PowerPivot to create self-service BI in your organization. We will learn how to combinie data from heterogenous data sources and then create reports/dashboardsfor end users to consume and collboarate in SharePoint 2010. We will also cover when you should use PowerPivot in comparison with SQl Server Analysis Services (OLAP) so you are equiped to create robust Self Service BI applications in your organization. 
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

Want to automatically store your database schema in a version control system (VCS)? Want to make changes across your database or server with less labor? Want to compress your backups using 7zip and PowerShell. Figure out memory allocation on an active/active cluster? How about download many files in the background? Come learn what is possible with PowerShell.
Speaker:

Session Type:
Regular Session

Track:
Beginner

Level: Beginner

Session Code:

Date: April 02

Time: 12:00 AM - 1:00 AM

Room: TBD

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