sqlsathistory

Nr: 34

Back to Main list

SQLSaturday #34 - Boston 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron Bertrand	Database Administration	Management Studio Tips Tricks
00:00:00	Ayad Shammout	Business Intelligence	Introducing PowerPivot (BI Self-Service) for Excel
00:00:00	Ayad Shammout	Database Administration	Building a High Availability SQL Server environmen
00:00:00	Adam Machanic	Performance Tuning	What's Really Happening on Your Server: DMV Power
00:00:00	Bala Subra	Performance Tuning	SQL Server Performance Tuning Tips
00:00:00	Bala Subra	Business Intelligence	SQL Server Reporting Services
00:00:00	Chris Bowen	Performance Tuning	Dev Overflow: What's New in ADO.NET EF 4.0?
00:00:00	Charles Hyman	Data Development	USING VSTS Database Edition and 2010 Preview
00:00:00	Dean Richards	Performance Tuning	Tuna Helper for SQL Server DBA's
00:00:00	Grant Fritchey	Performance Tuning	Best Practices for Working With Execution Plans
00:00:00	Jim O'Neil	Data Development	"Dallas": Microsoft's Data Marketplace
00:00:00	Mike Walsh	Database Administration	As a DBA, Where Do I start?
00:00:00	Mike Walsh	Performance Tuning	You Can Improve Your Own SQL Code
00:00:00	Mike Litchfield	Business Intelligence	Designing and Implementing an ETL Framework
00:00:00	Peter Tassmer	Database Administration	Storage Design For SQL Server
00:00:00	Roman Rehak	Database Administration	SQL Server Development Tips and Tricks
00:00:00	Scott Abrants	Data Development	Automating Database Deployments with Visual Studio
00:00:00	Steve Simon	Data Development	Data Access Layers: A Cornucopia
00:00:00	Steve Simon	Business Intelligence	Data Mining.. Making $mart financial decisions
00:00:00	Sunil Kadimdiwan	Business Intelligence	Visualize your data on a Map
00:00:00	Slava Kokaev	Business Intelligence	Introduction to SSIS - Developing SSIS Packages
00:00:00	Varsham Papikian	Database Administration	Use PowerShell and SQLCMD - be more effective
00:00:00	Matt Van Horn	Data Development	Developing with SQL Azure
00:00:00	Matt Van Horn	Data Development	Pivot Data Visualization

SessionID: 28373

Management Studio Tips Tricks

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Aaron Bertrand

Title: Management Studio Tips Tricks

Abstract:

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

SessionID: 28431

Introducing PowerPivot (BI Self-Service) for Excel

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Ayad Shammout

Title: Introducing PowerPivot (BI Self-Service) for Excel

Abstract:

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.

SessionID: 28432

Building a High Availability SQL Server environmen

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Ayad Shammout

Title: Building a High Availability SQL Server environmen

Abstract:

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.

SessionID: 28638

What's Really Happening on Your Server: DMV Power

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Performance Tuning

Speaker: Adam Machanic

Title: What's Really Happening on Your Server: DMV Power

Abstract:

This session is for the Type A DBAs who are serious about managing their servers as efficiently as possible. The Dynamic Management Objects--a set of views and functions that first shipped with SQL Server 2005--are a window into the inner workings of your SQL Server instance. Locked within the objects is the information you need to help you solve virtually any performance problem, quickly debug problems as they're occurring, and gain insight into what's actually happening on your server, right now. This session is a fast-paced tour of the ins, outs, whys, hows, and even pitfalls of 15 of the most important views and functions. You will learn how to understand transaction behavior, locking, wait statistics, sessions, requests, and much more.

SessionID: 29338

SQL Server Performance Tuning Tips

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Performance Tuning

Speaker: Bala Subra

Title: SQL Server Performance Tuning Tips

Abstract:

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.

SessionID: 29339

SQL Server Reporting Services

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Bala Subra

Title: SQL Server Reporting Services

Abstract:

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.

SessionID: 29424

Dev Overflow: What's New in ADO.NET EF 4.0?

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Performance Tuning

Speaker: Chris Bowen

Title: Dev Overflow: What's New in ADO.NET EF 4.0?

Abstract:

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.

SessionID: 29456

USING VSTS Database Edition and 2010 Preview

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Data Development

Speaker: Charles Hyman

Title: USING VSTS Database Edition and 2010 Preview

Abstract:

Basic show-off of how to get the most out of VSTS Database Edition aka "Data Dude"

also a dog-and pony show of 2010 and some TFS thrown in.

SessionID: 29873

Tuna Helper for SQL Server DBA's

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Performance Tuning

Speaker: Dean Richards

Title: Tuna Helper for SQL Server DBA's

Abstract:

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.

SessionID: 30266

Best Practices for Working With Execution Plans

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Performance Tuning

Speaker: Grant Fritchey

Title: Best Practices for Working With Execution Plans

Abstract:

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

SessionID: 30847

"Dallas": Microsoft's Data Marketplace

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Data Development

Speaker: Jim O'Neil

Title: "Dallas": Microsoft's Data Marketplace

Abstract:

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.

SessionID: 31881

As a DBA, Where Do I start?

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Mike Walsh

Title: As a DBA, Where Do I start?

Abstract:

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.

SessionID: 31882

You Can Improve Your Own SQL Code

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Performance Tuning

Speaker: Mike Walsh

Title: You Can Improve Your Own SQL Code

Abstract:

In this talk, Mike will show us some of the tools that come with SQL Server and how they can be used to analyze the performance of our database code. We will take a quick walk through indexing, best practices, some quick tips and then have a more in depth look at Execution Plans, IO Statistics and Profiler. Plus as a DBA, Mike can give a few pointers in working with your organization's own "Dr. No" along the way. Rough Agenda: • Review of Best Practices • Indexing/Table Structure High Level Overview • Will your queries use the index? • Query Plans don’t have to be scary • IO Statistics, Profiler • Put Them Together (Use the tools before you say, "Done!" • Interaction with the DBA (How to be a partner in performance with the DB

SessionID: 31952

Designing and Implementing an ETL Framework

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Mike Litchfield

Title: Designing and Implementing an ETL Framework

Abstract:

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.

SessionID: 32351

Storage Design For SQL Server

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Peter Tassmer

Title: Storage Design For SQL Server

Abstract:

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.

SessionID: 32630

SQL Server Development Tips and Tricks

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Roman Rehak

Title: SQL Server Development Tips and Tricks

Abstract:

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.

SessionID: 32821

Automating Database Deployments with Visual Studio

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Data Development

Speaker: Scott Abrants

Title: Automating Database Deployments with Visual Studio

Abstract:

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.

SessionID: 33159

Data Access Layers: A Cornucopia

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Data Development

Speaker: Steve Simon

Title: Data Access Layers: A Cornucopia

Abstract:

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.

SessionID: 33160

Data Mining.. Making $mart financial decisions

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Steve Simon

Title: Data Mining.. Making $mart financial decisions

Abstract:

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.

SessionID: 33263

Visualize your data on a Map

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Sunil Kadimdiwan

Title: Visualize your data on a Map

Abstract:

SSRS 2008 R2 has some exciting new features. In this session I will show you how you can use Report Builder 3.0 (new to R2) to consume spatial data and Bing maps in your Reports. I will also show Report Manager look and feel changes with Sharepoint-like interaction and menus; and other features such as Data Bars, Sparklines.

SessionID: 33845

Introduction to SSIS - Developing SSIS Packages

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Slava Kokaev

Title: Introduction to SSIS - Developing SSIS Packages

Abstract:

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

SessionID: 33848

Use PowerShell and SQLCMD - be more effective

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Varsham Papikian

Title: Use PowerShell and SQLCMD - be more effective

Abstract:

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.

SessionID: 34517

Developing with SQL Azure

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Data Development

Speaker: Matt Van Horn

Title: Developing with SQL Azure

Abstract:

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.

SessionID: 34518

Pivot Data Visualization

Back to calendar

Event Date: 30-01-2010 - Session time: 00:00:00 - Track: Data Development

Speaker: Matt Van Horn

Title: Pivot Data Visualization

Abstract:

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.

This site is open source. Improve this page.