sqlsathistory

Nr: 32

Back to Main list

SQLSaturday #32 - Tampa 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron Nelson	Track 5	PowerShell for Data Professionals
00:00:00	Adam Jorgensen	Track 5	Zero to Cube in 60 Minutes
00:00:00	Andy Warren	Track 4	Social and Not So Social Networking for the DBA
00:00:00	Brian Knight	Track 1	Introduction to SSIS
00:00:00	Brian Knight	Track 1	Iron Chef Competition: Loading a Data Warehouse
00:00:00	Brian Knight	Track 1	Rapid BI Development with Pragmatic Works
00:00:00	Bayer White	Track 4	Getting Started with AppFabric Caching (Velocity)
00:00:00	Christian Loris	Track 1	SSIS and Slowly Changing Dimensions
00:00:00	Chad Miller	Track 5	PowerShell ETL
00:00:00	Jack Corbett	Track 3	Why Should I Use Stored Procedures?
00:00:00	Dmitri Korotkevitch	Track 2	Getting familiar with SQL Server Storage Engine
00:00:00	David Taylor	Track 6	Using SSRS with Trending Reports
00:00:00	Eric Wisdahl	Track 1	SSIS - A Beginning Framework
00:00:00	Nathan Heaivilin	Track 7	Introduction to Execution Plans
00:00:00	Herve Roggero	Track 4	SQL Azure
00:00:00	Janis Griffin	Track 6	Tuna Helper for SQL Server DBA's
00:00:00	Janis Griffin	Track 3	Real-World Performance Tuning
00:00:00	Jeffrey Garbus	Track 3	Bad, less Bad, not Bad; rewriting bad SQL Code
00:00:00	Jeffrey Garbus	Track 2	Choosing Indexes for Performance
00:00:00	Jonathan Kehayias	Track 2	Real Time Problem Identification with Event Notifi
00:00:00	Jorge Segarra	Track 3	Policy-Based Management 101
00:00:00	Jorge Segarra	Track 2	SQL University 101:Starting the SQL Journey
00:00:00	Jason Strate	Track 4	Using XML to Query Execution Plans
00:00:00	Jason Strate	Track 2	ABCs of CTEs
00:00:00	Kathy Malone	Track 7	Access SQL Back-End Gets Better Option
00:00:00	Mike Davis	Track 1	Advanced Parameters in SSRS 2008
00:00:00	Michael Stark	Track 7	SQLServer 2008 Spatial Data
00:00:00	Michael Antonovich	Track 7	XML 101 for the SQL Developer
00:00:00	Mark Landry	Track 6	Building a Near-Realtime Operational Dashboard
00:00:00	Michael Mollenhour	Track 5	Accurate MDX RoadTrip
00:00:00	Michael Ruland	Track 2	SSIS users: Turbocharge your ETL with expressor
00:00:00	Troy Gallant	Track 6	Introduction to Transactional Replication
00:00:00	Patricia (Pat) Baxter	Track 6	5 Resolutions to Build Your Professional "Brand"
00:00:00	Plamen Ratchev	Track 3	Common SQL Programming Mistakes
00:00:00	Plamen Ratchev	Track 3	Refactoring SQL for Performance
00:00:00	Patrick LeBlanc	Track 5	SQL Server Data Compression 101
00:00:00	Ronald Dameron	Track 5	Database Hardening via PowerShell
00:00:00	Scott Klein	Track 4	Developing with SQL Azure
00:00:00	Geoff Hiten	Track 2	Clustering for Mere Mortals
00:00:00	Scott Gleason	Track 1	PGP encryption using SSIS
00:00:00	Telmo Sampaio	Track 7	SQL Server Beyond Relational
00:00:00	Kevin Boles	Track 7	SQL Server Service Broker
00:00:00	Kevin Boles	Track 4	Care and Feeding of TempDB
00:00:00	Elijah Baker	Track 3	Database Table Partitioning, The Next Step
00:00:00	Vikas Hawaldar	Track 6	Data Mining and Predictive Analysis using SQL 2008

SessionID: 28399

PowerShell for Data Professionals

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Aaron Nelson

Title: PowerShell for Data Professionals

Abstract:

In this session we will learn to perform several everyday DBA tasks like backing up user databases, scripting table objects and evaluating disk space usage with PowerShell. For each task we will explore the benefits of using PowerShell over the standard method. Only a basic understanding of PowerShell or DOS is needed. This session should serve as a good introduction to PowerShell for database users. The goal is to get data professionals feet wet using PowerShell.

SessionID: 28508

Zero to Cube in 60 Minutes

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Adam Jorgensen

Title: Zero to Cube in 60 Minutes

Abstract:

Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and answer many questions you have about building cubes the right way, the first time.

SessionID: 28727

Social and Not So Social Networking for the DBA

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Andy Warren

Title: Social and Not So Social Networking for the DBA

Abstract:

Should you be networking? In this session we'll talk about why you should be building a network now, how to build it, and how to keep track of and quantify your network. Along the way we'll talk about the most common social networks, why you should consider blogging, and some exercises you can do to strengthen your networking skills.

SessionID: 29086

Introduction to SSIS

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Brian Knight

Title: Introduction to SSIS

Abstract:

This session will get you past the learning curve of SSIS. Brian covers creating an end to end package that covers many of the concepts in SSIS. He covers, looping over a set of files, processing each file and then archiving. You won't want to miss this if you're new to SSIS.

SessionID: 29087

Iron Chef Competition: Loading a Data Warehouse

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Brian Knight

Title: Iron Chef Competition: Loading a Data Warehouse

Abstract:

In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). You'll see a battle between two SSIS experts (Brian Knight and Adam Jorgensen), attempting to load the data warehouse the best way. You'll see varying architectures and best practices from each of the presenters and you decide who wins the Iron Chef competition.

SessionID: 29088

Rapid BI Development with Pragmatic Works

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Brian Knight

Title: Rapid BI Development with Pragmatic Works

Abstract:

In this session, you’ll learn how to use a series of free and pay components in your tool belt to improve the speed of your SSIS development. You’ll learn how to code packages faster with templates in BI xPress and how tasks and transforms built into Task Factory can take hours off your SSIS runtime.

SessionID: 29365

Getting Started with AppFabric Caching (Velocity)

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Bayer White

Title: Getting Started with AppFabric Caching (Velocity)

Abstract:

Let's face it, reading and writing data with SQL Server can be expensive and has scaling this type of architecture has its implications that need to be considered upfront. This is one of the reasons Microsoft has included caching within its future AppFabric Framework. Caching is not a new methodology because we can use it currently in applications built on top of ASP.Net out of the box, however there are still scaling issues that AppFabric Caching (ACF), formerly Velocity addresses. As database developers, it is important to identify with new trends that may affect database integration and this presentation does just that. First we will learn the basics of AFC, how to install, how to scale, and how data driven solutions can benefit from it.

SessionID: 29527

SSIS and Slowly Changing Dimensions

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Christian Loris

Title: SSIS and Slowly Changing Dimensions

Abstract:

What are SCDs? How do I manage them? SSIS Provides an SCD Wizard which can make your life easier. It also has problems which we'll show you how to work around.

SessionID: 29573

PowerShell ETL

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Chad Miller

Title: PowerShell ETL

Abstract:

In this sesssion we will look at performing common data loading tasks with Powershell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.

SessionID: 29597

Why Should I Use Stored Procedures?

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Jack Corbett

Title: Why Should I Use Stored Procedures?

Abstract:

With the proliferation of ORM Tools like Linq To SQL, NHibernate, there has been a move to no longer use stored procedures for Data Access, I personally disagree. This will be a professional and polite open discussion starting with why I believe stored procedures are the best way to access data in SQL Server. Alternate view points welcome.

SessionID: 29934

Getting familiar with SQL Server Storage Engine

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Dmitri Korotkevitch

Title: Getting familiar with SQL Server Storage Engine

Abstract:

You need to know how SQL Server works internally if you want to design the effective solutions. This session will give the overview of how SQL Server stores data internally; what criteria query optimizer uses when choose the index and provide some guidelines how to design tables and indexes to improve the performance of the database solutions.

SessionID: 30030

Using SSRS with Trending Reports

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: David Taylor

Title: Using SSRS with Trending Reports

Abstract:

Utilizing only T-SQL and algebra, I will engage the attendees in a discussion of teasing trends out of data buried within SQL Server, without having to learn the intricacies of Data Warehousing and MDX Querying. It is my hope that my methods can be used and expanded upon in your field, and I invite those who use SQL Server in any environment to come join the discussion.

SessionID: 30125

SSIS - A Beginning Framework

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Eric Wisdahl

Title: SSIS - A Beginning Framework

Abstract:

Most developers would agree that every SSIS solution will have the same fundamental outline. A basic framework will expedite the process by handling the common tasks between the systems while allowing the developer to concentrate on the task at hand. This framework will consist of many items, including but not limited to setting up package configurations, logging, audit trails, error handling, naming standards, etc. This session will present an example framework which can be used as the basis for future SSIS Package.

In response to previous comments, the majority of the material will be presented via demos.

SessionID: 30301

Introduction to Execution Plans

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Nathan Heaivilin

Title: Introduction to Execution Plans

Abstract:

This session will cover the basics the different types of execution plans, how to generate them, and how to read them.

SessionID: 30335

SQL Azure

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Herve Roggero

Title: SQL Azure

Abstract:

In this session we will discuss SQL Azure at a high level including development lifecycle, production, security, auditing and general limitations.

SessionID: 30442

Tuna Helper for SQL Server DBA's

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Janis Griffin

Title: Tuna Helper for SQL Server DBA's

Abstract:

Janis Griffin has over 20 years of DBA experience including design, development and implementation of many critical database applications. Prior to Confio, Janis held DBA positions in the Telecom Industry (15 yrs), working with both real-time network routing databases and OLTP business to business applications. Janis was Principal Architect and Sr. Manager, mentoring other DBAs on best practices in database performance tuning.

SessionID: 30443

Real-World Performance Tuning

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Janis Griffin

Title: Real-World Performance Tuning

Abstract:

Confio Software (Janis Griffin, Sr. DBA Product Architect) and Soaring Eagle Consulting (Jeff Garbus, Principal) will conduct a demonstration of “Real-World Performance Tuning” using the Ignite Suite from Confio. In this demonstration and discussion, Janis Griffin and Jeff Garbus will show the audience how using Response-Time Analysis and Wait-Types in SQL Server to quickly diagnose and identify performance bottlenecks in SQL Server 2000,2005, and 2008. Ignite may also be used for cross-platform monitoring and performance tuning on Oracle, Sybase and DB2-LUW.

SessionID: 30667

Bad, less Bad, not Bad; rewriting bad SQL Code

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Jeffrey Garbus

Title: Bad, less Bad, not Bad; rewriting bad SQL Code

Abstract:

This session reviews rewriting a bad chunk of data migration code. Your speaker wrote the original code at 1:30 am, rewrote it with disgust at 2am, and wrote it nicely the next evening. We will review why the dozens of reqasons the first 2 passes are bad, followed by some firm coding recommendations.

SessionID: 30668

Choosing Indexes for Performance

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Jeffrey Garbus

Title: Choosing Indexes for Performance

Abstract:

Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

SessionID: 30877

Real Time Problem Identification with Event Notifi

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Jonathan Kehayias

Title: Real Time Problem Identification with Event Notifi

Abstract:

Event Notifications are a hidden gem in SQL Server 2005, just waiting to provide you with real time information about problems inside of SQL Server. This session will provide a brief overview of the Service Broker components used by Event Notifications and then dive into how to build a monitoring solution for common problems in SQL Server like blocking and deadlocks that capture the needed information for troubleshooting in real time and provide email notification that a problem exists.

SessionID: 31013

Policy-Based Management 101

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Jorge Segarra

Title: Policy-Based Management 101

Abstract:

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

SessionID: 31014

SQL University 101:Starting the SQL Journey

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Jorge Segarra

Title: SQL University 101:Starting the SQL Journey

Abstract:

On my blog I've started a project called SQL University aimed at folks looking to learn SQL Server from the ground up. This session will start at ground level tasks and resources all database professionals should know. This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources!

SessionID: 31158

Using XML to Query Execution Plans

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Jason Strate

Title: Using XML to Query Execution Plans

Abstract:

SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your finger tips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases.

Prerequisites Understanding of basic T-SQL coding Understanding of basic XQuery statements

Goals:

1. Discuss information available in an execution plan
2. Demonstrate use of XQuery to query execution cache
3. Demonstrate methods to performance tune

SessionID: 31160

ABCs of CTEs

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Jason Strate

Title: ABCs of CTEs

Abstract:

Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.

Prerequisites Understand of basic T-SQL coding

Goals: Provide an understanding of the purpose and use of CTEs for recursion and derived tables Define the pro’s and con’s to using CTEs in recursion and for derived tables Demonstrate real-world examples detailing methods for using CTEs to solve coding challenges

SessionID: 31403

Access SQL Back-End Gets Better Option

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Kathy Malone

Title: Access SQL Back-End Gets Better Option

Abstract:

Hear how Access 2010 and SharePoint 2010 can be used to better manage your Access applications, reducing the load on your SQL Server. SharePoint 2010 manages security, backup, and deployment of the Access aps, and makes it possible to use the Access ap in the browser without having Access on the client machine and in untrusted mode. And because of the way Access now caches, it becomes a tool of choice for large number of records queries and reports (40,000-160,000 records), reducing the load on your SQL Servers. Finally, see a tool for finding the Access applications in your environment so you can prioritize making them more managed.

SessionID: 31671

Advanced Parameters in SSRS 2008

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Mike Davis

Title: Advanced Parameters in SSRS 2008

Abstract:

In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures.

SessionID: 31773

SQLServer 2008 Spatial Data

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Michael Stark

Title: SQLServer 2008 Spatial Data

Abstract:

An overview of the new spatial geography data types in SQL Server 2008. Following the overview will be a demonstration of creating queries with spatial data as input and results. Finally, we will wire up a real world example into Bing Maps using ASP.Net.

SessionID: 31799

XML 101 for the SQL Developer

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Michael Antonovich

Title: XML 101 for the SQL Developer

Abstract:

This session is designed as a lead-in to the session by Scott Klein. It defines what XM is and how it differs from regular HTML, It looks at how to define data type variables and columns in SQL to store XML, how to output XML from existing table structures. It also covers how to use OPENXML, how to create and use your own namespaces, and the difference between typed XML and untyped XML.

SessionID: 31951

Building a Near-Realtime Operational Dashboard

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Mark Landry

Title: Building a Near-Realtime Operational Dashboard

Abstract:

Using Analysis Services, ASP.NET, AJAX callbacks for refresh, Dundas grids and charts, and Notification Services for alerts, this session will show how to integrate a variety of MS technologies to create a state-of-the-art dashboard system. This particular dashboard implementation is currently in use by Norfolk Southern railroad to monitor intermodal shipments. The concepts could be applied to monitoring any operational system. It also shows how cubes can be used for more than just decision support.

SessionID: 31962

Accurate MDX RoadTrip

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Michael Mollenhour

Title: Accurate MDX RoadTrip

Abstract:

In this session I will demonstrate MDX with SQL Analysis Services. This session will demonstrate the analytic powers incorporated into the SQL AS Engine using MDX. I will start with basic concepts of MDX and move to more Advanced calculations.

SessionID: 32023

SSIS users: Turbocharge your ETL with expressor

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Michael Ruland

Title: SSIS users: Turbocharge your ETL with expressor

Abstract:

Microsoft SQL Server Integration Services (SSIS) users who are writing too much complex code to transform data, struggling with application performance or having trouble integrating diverse data sources will benefit from learning about the expressor semantic data integration system -- an affordable, enterprise-class alternative to SSIS. They will learn how American Tower improved the data loading times for its data warehouse and enabled its developers to perform complex data transformations in a single process by migrating from Microsoft SSIS to expressor.

SessionID: 32132

Introduction to Transactional Replication

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Troy Gallant

Title: Introduction to Transactional Replication

Abstract:

SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some of the primary reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution.

SessionID: 32147

5 Resolutions to Build Your Professional "Brand"

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Patricia (Pat) Baxter

Title: 5 Resolutions to Build Your Professional "Brand"

Abstract:

The start of a new year offers us the opportunity to “take stock” of what may or may not be helping us to achieve our personal and professional goals. One thing we may forget to assess is our “professional brand”. Your professional brand can help you to distinguish and position your personal portfolio of experience, skills and knowledge as unique and of value to customers and in the marketplace. This session looks at five actions to take that align your professional brand with your career goals, and can help your clients, peers, and managers see the tangible and intangible benefits of working with you.

SessionID: 32250

Common SQL Programming Mistakes

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Plamen Ratchev

Title: Common SQL Programming Mistakes

Abstract:

Become a better SQL coder by learning the most common pitfalls in the SQL language. Both inexperienced and experienced SQL developers and DBAs can get caught by many of these. Practical examples and internal logical processing explanation will help you understand why mistakes happen and how to develop good SQL coding practices to avoid them.

SessionID: 32251

Refactoring SQL for Performance

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Plamen Ratchev

Title: Refactoring SQL for Performance

Abstract:

Many people live by the motto “If it’s not broken, don’t fix it”. But if you believe that you are missing all enhancements introduced in newer versions of SQL Server (2005/2008). These new features can help you develop better solutions with improved performance, scalability, and maintainability. Learn how to craft a better query using the new MERGE statement, ranking functions, and more. Practical examples with tips and tricks.

SessionID: 32282

SQL Server Data Compression 101

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Patrick LeBlanc

Title: SQL Server Data Compression 101

Abstract:

In this session I will explain SQL Server Data compression (Page and Row), provide scripts and tips that will help you identity the compression state that should be configured in your Warehouse environment and also provide demo scripts showing you how to configure compression at the Table and Index level.

SessionID: 32638

Database Hardening via PowerShell

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 5

Speaker: Ronald Dameron

Title: Database Hardening via PowerShell

Abstract:

Database Hardening via PowerShell. I will demonstrate how I use PowerShell to handle the issues encountered in a Fortune 50 corporate environment that has over 500 database servers and 3600 databases.

SessionID: 32835

Developing with SQL Azure

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Scott Klein

Title: Developing with SQL Azure

Abstract:

Cloud computing is gaining momentum. Knowing how to develop applications for the cloud is important. This session will discuss how to develop applications with SQL Azure, and It will focus on two areas when developing application for SQL Azure, the .NET side and the SQL side.

SessionID: 33031

Clustering for Mere Mortals

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 2

Speaker: Geoff Hiten

Title: Clustering for Mere Mortals

Abstract:

Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier.

SessionID: 33116

PGP encryption using SSIS

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 1

Speaker: Scott Gleason

Title: PGP encryption using SSIS

Abstract:

In this session I'll show you how SSIS can use a scripted task or execute task to encrypt or decrypt a file. All examples will be in C#..

SessionID: 33364

SQL Server Beyond Relational

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Telmo Sampaio

Title: SQL Server Beyond Relational

Abstract:

Participate in an architecture review showcasing the use of SQL Server 2008 Spatial features and the filestream data. The session will focus on a pre-defined solution architecture using SQL Server 2005 with pure relational data and after a brief introduction of new features in SQL Server 2008, changes will be presented and discussed with the group, culminating in a new architecture.

SessionID: 33478

SQL Server Service Broker

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 7

Speaker: Kevin Boles

Title: SQL Server Service Broker

Abstract:

We will take a look at SQL Service Broker, the built-in asynchronous messaging subsystem provided with SQL Server. We will examine new terminology as well as get a grounding in how we can setup and use Service Broker for messaging applications. We live in an increasingly interconnected world and having a system that can handle intermittent connections and asynchronous processing can solve many business problems. And if MySpace can use it to pass hundreds of millions of messages around their system per day, it can probably do whatever you need it to do as well! Plenty of code in this presentation too.

SessionID: 33479

Care and Feeding of TempDB

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 4

Speaker: Kevin Boles

Title: Care and Feeding of TempDB

Abstract:

EVERY SQL Server uses tempdb, many of them extensively. Suboptimal configuration is a leading cause of poor performance. We will cover how to have an optimal configuration for your environment and also how to effectively monitor various tempdb metrics.

SessionID: 33800

Database Table Partitioning, The Next Step

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 3

Speaker: Elijah Baker

Title: Database Table Partitioning, The Next Step

Abstract:

In this session I will go over some of the techniques that I have used to implement database partitioning in a 2 TB OLTP database. This session will be about now that you have decided to use partitioning how do you determine what partition key to use? If my table is using multiple search criteria at different times how do I choose a partitioning key? What tables should I Partition? How should my partitions be stored?

SessionID: 33836

Data Mining and Predictive Analysis using SQL 2008

Back to calendar

Event Date: 23-01-2010 - Session time: 00:00:00 - Track: Track 6

Speaker: Vikas Hawaldar

Title: Data Mining and Predictive Analysis using SQL 2008

Abstract:

The session will introduce the attendees to the basics of Data Mining and Predictive analysis. It will go over the basic building blocks of SQL 2008 Data Mining Engine and will provide an example of Data Mining project lifecycle.

This site is open source. Improve this page.