sqlsathistory

Nr: 7

SQLSaturday #7 - Birmingham 2009

Start Time (24h)	Speaker	Track	Title
00:00:00	Brad Marshall	Business Intelligence	Getting the warm "Fuzzies" with SSIS
00:00:00	Chris Eargle	SQL Development	RESTful Data
00:00:00	Andy Warren	Database Administration	Introduction to SQL Server Statistics
00:00:00	Robert Cain	Business Intelligence	Introduction to Data Warehousing with SQL Server
00:00:00	Ken Simmons	Database Administration	SQL Server Preproduction Tasks
00:00:00	Derek Comingore	Business Intelligence	BI for a Tough Economy, Data Mining
00:00:00	Dean Richards	SQL Development	Tuna Helper- A Proven Process for Tuning SQL
00:00:00	Stuart Ainsworth	SQL Development	Confessions of a Data Integrator
00:00:00	Tejas Patel	Business Intelligence	Data Mining ASP.Net Controls Library
00:00:00	Kevin Boles	SQL Development	SQL Injection
00:00:00	Kevin Boles	Database Administration	Disk Partition Alignment/Care and Feeding TempDB
00:00:00	Kevin Boles	Database Administration	SANs and SQL Server
00:00:00	Tim Roper	Database Administration	Revitalizing a neglected SQL Server
00:00:00	Terry Webster	SQL Development	ASP.NET Databinding 101
00:00:00	Terry Webster	Business Intelligence	Using Multi-dimensional Data in SSAS in ASP.NET

SessionID: 29132

Getting the warm "Fuzzies" with SSIS

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Brad Marshall

Title: Getting the warm "Fuzzies" with SSIS

Abstract:

This session is an overview of the Fuzzy Grouping and Fuzzy Lookup transformations provided with SQL Server 2008 Enterprise Edition. We will explore how to use these tools to simplify complicated data quality issues and help standardize data input for BI systems.

SessionID: 31457

RESTful Data

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Chris Eargle

Title: RESTful Data

Abstract:

REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With ADO.NET Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE.

This session will describe RESTful Data, the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.

SessionID: 34943

Introduction to SQL Server Statistics

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Database Administration

Speaker: Andy Warren

Title: Introduction to SQL Server Statistics

Abstract:

This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more! Statistics are a key part of getting solid and repeatable performance and is easily just as important as having indexes. Whether you're a DBA or trying to get by without one, this session will give you the information you need to know.

SessionID: 34953

Introduction to Data Warehousing with SQL Server

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Robert Cain

Title: Introduction to Data Warehousing with SQL Server

Abstract:

Business Intelligence is one of the hot job skills for 2009. In this concepts talk you will learn the concepts behind building and designing data warehouses, and cut through the buzz words so you will walk away with a clear understanding of what words like dimensions, facts, and measures mean. You'll also get a peak at the tools available in SQL Server 2008.

SessionID: 35071

SQL Server Preproduction Tasks

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Database Administration

Speaker: Ken Simmons

Title: SQL Server Preproduction Tasks

Abstract:

This session will cover the tasks you need to perform before you hand over a new SQL Server to production in order to keep the server running smoothly. After this session, you should be able to create a script that best suits your organization in order to make moving a server into production a quick and easy process. While the session is geared towards new systems, many of these preproduction considerations apply to existing SQL Servers as well.

SessionID: 35090

BI for a Tough Economy, Data Mining

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Derek Comingore

Title: BI for a Tough Economy, Data Mining

Abstract:

Best Buy does it. American Express does it. Netflix does it. Microsoft is moving data mining from the unique to the routine. SQL Server Analysis Services 2008 and 2005 versions include a robust set of data mining algorithms and tools with which to harvest new insights into YOUR data. Make that marginal sale, discover a murky cost pattern, and find your truly profitable circumstances. Attendees will learn how to use two of the most applicable data mining algorithms included in the SQL Server products. Using the data mining model viewers, attendees will learn how to explore their model results. Through demonstration and lecture, the use of the Profit Chart and Lift Chart attendees will learn how to evaluate the effectiveness of

SessionID: 35093

Tuna Helper- A Proven Process for Tuning SQL

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Dean Richards

Title: Tuna Helper- A Proven Process for Tuning SQL

Abstract:

Many DBAs and Developers are faced with tuning poorly performing SQL statements. 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 time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.

SessionID: 35451

Confessions of a Data Integrator

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Stuart Ainsworth

Title: Confessions of a Data Integrator

Abstract:

Most database professionals are charged with managing, extracting, and integrating data from sources which were not designed by themselves. This session focuses on methods of dealing with "somebody else's" design choices, including a focus on dynamic SQL, datetime concerns, and data abstraction. This should be an interactive session, so feel free to bring your horror stories as well as your ideas for success!

SessionID: 35459

Data Mining ASP.Net Controls Library

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Tejas Patel

Title: Data Mining ASP.Net Controls Library

Abstract:

Intent of this session is to demonstrate use of Data Mining Web Controls Library with web applications. Data Mining Web Controls Library is a library intended to extend the data mining user experience in Microsoft SQL Server Analysis Services to the Web. This library provides a lightweight version of the data mining model viewers. Using Data Mining Web Controls, you can browse complex mining models from any computer that has Microsoft Internet Explorer installed.

SessionID: 35465

SQL Injection

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Kevin Boles

Title: SQL Injection

Abstract:

Discussion on various forms of SQL Injection attacks and some guidelines on how to avoid them.

SessionID: 35467

Disk Partition Alignment/Care and Feeding TempDB

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Database Administration

Speaker: Kevin Boles

Title: Disk Partition Alignment/Care and Feeding TempDB

Abstract:

EVERYONE can benefit from this presentation!! Improper disk alignment will rob the server of 15-50% IO throughput capability. We will cover what disk partition alignment really is, how it affects performance and how you can get it done correctly.

SessionID: 35468

SANs and SQL Server

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Database Administration

Speaker: Kevin Boles

Title: SANs and SQL Server

Abstract:

Lets get down and dirty on some fundamentals of how SANs work and how we can best utilize them to improve SQL Server's IO performance and reliability.

SessionID: 35491

Revitalizing a neglected SQL Server

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Database Administration

Speaker: Tim Roper

Title: Revitalizing a neglected SQL Server

Abstract:

This session will focus on how a SQL Server installation becomes neglected over time, how to identify neglected components, and how to revitalize the neglected installation. In many cases a client may report specific performance issues or errors, but after investigation, it becomes obvious that the underlying issue is more widespread and results from lack of maintenance or planning. Learn how to survey a SQL installation for problems, and how to correct them.

SessionID: 35494

ASP.NET Databinding 101

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: SQL Development

Speaker: Terry Webster

Title: ASP.NET Databinding 101

Abstract:

This session will demonstrate how easy it is to quickly display your data on a web page with a minimum amount of code. We will cover displaying, editing, deleting and inserting data.

SessionID: 35495

Using Multi-dimensional Data in SSAS in ASP.NET

Back to calendar

Event Date: 30-05-2009 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Terry Webster

Title: Using Multi-dimensional Data in SSAS in ASP.NET

Abstract:

This sessions will demonstrate several methods for querying multi-dimensional data and rendering the results in two-dimensional data controls. We will cover using both ADOMD.NET and SQL Server stored procedures to retrieve data from SQL Server Analysis Services multi-dimensional cubes.

This site is open source. Improve this page.