Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 24
At PDC 2009, Microsoft announced "Dallas", a Data-as-a-Service offering that leverages the Windows Azure cloud computing platform.  "Dallas" makes well-known and vetted public and commercial data sets from entties such as the Associated Press and Data.gov available to the development and data analysis communities.  This session explores getting started with "Dallas" and accessing its data sets programmatically and via Excel 2010's PowerPivot feature.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Data Development

Level: Beginner

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether you are new to the role of DBA, being "forced" to take on the responsibility of one or are starting at a new role as a DBA, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the "itties" of Database Administration (Recoverability, Availability - Health & Performance - , Security and Reliability) we can see a natural priority build. Throughout this interactive discussion we will also have a look at some of the available tools and scripts to help us see where our environments rate with the "itties" of Database Administration.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Leading your database development solution to a leaner, more automated method of development and deployment is an essential step to implementing a successful Agile/SCRUM based methodology.  Scott Abrants will take an existing SQL Server database and import it into Visual Studio Team Edition for Database Developers GDR version prepearing  it for an automated continous integration build.   Lean some of the tips and techniques that will have you well on your way to integrating with an automated build taking advanatge of the power of Visual Studio Team Edition for Database Developers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Data Development

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will focus on how best to use and access execution plans. The use of execution plans will focus on identifying and fixing common performance and execution problems within TSQL. The methods defined for using execution plans will follow a problem/solution paradigm in order to show practical ways that execution plans can help solve common problems. Access of execution plans is normally only defined as being from the Management Studio GUI. This session will show methods of access that include direct queries into the procedure cache using dynamic management views and functions and plans captured through the use of trace events defined in Profiler. Access through XQuery against the XML will be demonstrated through several practical a
Speaker:

Session Type:
Regular Session

Track:
Performance Tuning

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

 If you are new to SQL Server environment, you will learn how we are using Clustering and Mirroring technologies together to achieve High Availability and minimize data loss in the event of a disaster. This session is for you if you want to learn techniques we have used to minimize downtime while migrating from SQL Server 2005 to 2008. If you use SQL Server 2005 failover clustering and want to learn about upgrading to Windows Server 2008 and SQL Server 2008, this is the session for you.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

How often have our SQL Servers been bogged down with a myriad of users issuing lengthy and poorly constructed or poorly performing queries against our tables and views. More often than not, nearly bringing our systems to their knees. Nowhere is this truer than within the financial world where heavy number crunching is par for the course. This beginners to intermediate level hands-on presentation is aimed at the SQL Server developer and business analyst alike and will show the attendee how we have managed to eliminate 90 % of our poorly performing queries by creating data access layers which provides our end users with a suite of well developed and tuned SQL Server FUNCTIONS with which to render their data. 
Speaker:

Session Type:
Regular Session

Track:
Data Development

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Over the past few months many financial houses have been severely ‘hit’ by the current slump in the sub prime mortgage market. This has lead to severe losses and considerable client liability. Many firms are now starting to take a ‘serious look’ at the potential utilization of data mining techniques as part of their ongoing efforts to control their risk exposure. This beginner to intermediate level hands-on presentation is aimed at showing the attendee some of the ‘data mining’ prototypes solutions that we are currently developing with SQL Server 2005 / 2008, as a part of our ongoing efforts to manage our risk.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will describe the value of an ETL framework, what should be included in it, and architectural considerations. A production implementation using Sql, SSIS, ASP.Net, and SSRS will be referenced.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

ADO.NET Entity Framework (EF) can help you more easily create and maintain data-driven applications using flexible data models featuring entities and relationships.  Entity Framework 4, part of .NET Framework 4 and Visual Studio 2010, includes many new features and improvements.  This session will start with a brief introduction to EF, then focus on what’s new in EF 4, including designer improvements, persistence ignorance, model-first support, lazy loading, N-Tier, complex types, foreign keys, and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance Tuning

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This is a high level intro of how to develop for SQL Azure either using traditional ASP.Net IIS or Windows Azure as a host. I will go over the differences between SQL Azure and Azure Storage. Considerations that need to be made if using Azure Cloud Hosting with ASP.Net Authentication and session states as well as how to use SQL Azure as a Sql(Membership,Role,Profile)Provider. 

I will share the tips and tricks that I have discovered as I worked with SQL Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Data Development

Level: Beginner

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, I will cover the new PowerPivot (formerly known as Gemini Project) a data analysis add-in that delivers computational power directly within MS Excel 2010. By combining native Excel 2010 functionality with PowerPivot’s in-memory engine will allow users to interactively explore and perform calculations on large data sets. You can easily streamline the process of integrating data from multiple sources – including corporate databases, spreadsheets, reports, and data feeds.  Share and collaborate by easily publishing your analysis to SharePoint 2010 and have other users enjoy the same slicer and fast-query capabilities when working on your Excel Services reports.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session explains how to create SSIS packages and defines the basic objects 
contained in the control flow and data flow.
We will work through how to 
Create SSIS Packages, Data Sources and Package Connections 
Create Control Flow Tasks 
Use Control Flow Containers 
Use Data Flow Adapters and Transformations 


Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

A collection of little things you can do with Management Studio so you can start faster, work smarter, prevent mistakes, and present better.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Beginner

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Live Labs recently released Pivot a tool to visualize data which can allow uses to see patterns in data like never before. In this session I will provide a basic intro to Pivot and discuss how to use you existing database and the pivotcollectiontools(on codeplex) SDK that I have released to dynamically build Pivot Collections. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Data Development

Level: Beginner

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will cover many common issues, challenges and problems encountered when developing for, or administering SQL Server as well as examining best ways to modify, script and copy database objects from development to production environment. Session materials for the attendees will include custom utility tools and stored procedures written by the speaker for simplifying SQL Server development and database update deployment. 
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is for you if you want to learn tips and techniques that are used to optimize database development with special emphasis on SQL Server 2005. If you write lot of stored procedures and want to learn the tools of a DBA, this is the session for you. If you are new to SQL Server development environment, you will learn how the various constructs compare to each other and better performance can be produced every time with a brief introduction to understanding Execution Plans.
Speaker:

Session Type:
Regular Session

Track:
Performance Tuning

Level: Beginner

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will be a cornucopia of three sub-sessions. The first part will be to convince the skeptics. Why does every organization should consider SQL Server Reporting as part of its front-end solution? What will SSRS do better than a typical web application/site or a client-server application? The second portion will be a quick demo of the possibility and will be the shortest. The final part will talk about the best practices, tips from the field and will cover the implementation techniques.
Speaker:

Session Type:
Regular Session

Track:
Business Intelligence

Level: Beginner

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

A critical, but often overlooked step when deploying SQL Server is the design, layout and provisioning of storage.  In this talk, Pete will discuss storage design and layout for various  SQL workloads, I/O analysis and the methods used to gather storage performance metrics.  Other topics such as planning for storage based replication with SQL Server, storage alignment, solid state drives, stress testing and validation prior to deployment will also be discussed.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Performance Tuning

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerShell is a relatively new scripting environment from Microsoft and SQLCMD is a replacement of OSQL. Every day we perform many similar database-related tasks. Why not write once and then reuse that code multiple times? I will give an overview of Powershell and SQLCMD. Then we will see how to use them in SQL Server environment to automate repetitive tasks, write a flexible code, perform tasks while away from the computer, and perform many other time-saving activities.
Speaker:

Session Type:
Regular Session

Track:
Database Administration

Level: Intermedia

Session Code:

Date: January 30

Time: 12:00 AM - 1:00 AM

Room: TBD

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