sqlsathistory

Nr: 19

Back to Main list

SQLSaturday #19 - East Iowa 2009

Start Time (24h)	Speaker	Track	Title
00:00:00	Chris Sutton	App Dev II	An Introduction to ASP.NET MVC
00:00:00	Chuck Heinzelman	App Dev II	SQL Server 2008 R2 - Moving to the Next Level
00:00:00	Chuck Heinzelman	App Dev II	SQL Server 2008 - Practical Uses for New Features
00:00:00	Keith Dahlby	App Dev I	Introduction to PowerShell
00:00:00	Louis Davidson	BI / Relational Theory	Database Design Patterns
00:00:00	Janis Griffin	App Dev I	Tuna Helper - A Proven Process for Tuning SQL
00:00:00	Jessica Moss	BI / Relational Theory	Building Reports in SQL Server Reporting Services
00:00:00	Jessica Moss	BI / Relational Theory	Extract, Transform, and Load your Data Warehouse
00:00:00	Jessica Moss	BI / Relational Theory	Introduction to SSAS Dimensions
00:00:00	Alex Kuznetsov	App Dev II	2 Years of Database Unit Testing: Lessons Learned
00:00:00	Tim Plas	Administrative / Platform	High-Availability Options for Microsoft SQL Server
00:00:00	Zakir Durumeric	Administrative / Platform	Introduction to Database Mirroring
00:00:00	Zakir Durumeric	App Dev II	SQL Server 2008: The New and Cool...
00:00:00	Zakir Durumeric	Administrative / Platform	Service Broker: A Brief Introduction
00:00:00	Aaron King	Administrative / Platform	The Benefits of SQL Azure
00:00:00	Alex Kuznetsov	App Dev II	Defensive database programming
00:00:00	Louis Davidson	BI / Relational Theory	Database Design
00:00:00	Jason Strate	App Dev I	Drive Your Way to the DMV
00:00:00	Jason Strate	App Dev I	Improving Daily Imports with Partitioned Tables
00:00:00	Jason Strate	App Dev I	ABCs of CTEs
00:00:00	Jason Strate	App Dev I	Extended Events, Work Smarter Not Harder
00:00:00	Tim Ford	Administrative / Platform	Tips Tricks For Administering SQL Server

SessionID: 29007

An Introduction to ASP.NET MVC

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev II

Speaker: Chris Sutton

Title: An Introduction to ASP.NET MVC

Abstract:

ASP.NET MVC is Microsoft's implementation of an old design pattern, which fits web development better than ASP.NET does. It simplifies multiple aspects of web development that were complex in ASP.NET. It also gives ASP.NET developers a better and more accurate abstraction layer over the web. For example it doesn't use the problematic ViewState object. It removes most of the overly complex page lifecycle and it simplifies the ability to unit test web requests.

In this presentation we'll explain the MVC terminology and then we'll explore how to work with Controllers, Actions, Views and the Model. Then we'll walk though a real but simple ASP.NET MVC site so you can leave this session with enough knowledge to start a new ASP.NET MVC project.

SessionID: 29457

SQL Server 2008 R2 - Moving to the Next Level

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev II

Speaker: Chuck Heinzelman

Title: SQL Server 2008 R2 - Moving to the Next Level

Abstract:

SQL Server 2008 provided us with many features that developers and database administrators have been asking about for years. Separate Date and Time data types, sparse columns, FILESTREAM and compression for both data and backups have made the platform better than ever. So how do you build on a platform that strong? By adding features like multi-server management, application management and complex event processing, of course. Come along with me as we explore these new features with the August CTP of SQL Server 2008 R2.

SessionID: 29458

SQL Server 2008 - Practical Uses for New Features

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev II

Speaker: Chuck Heinzelman

Title: SQL Server 2008 - Practical Uses for New Features

Abstract:

When learning a new technology, I like to try to solve a real-world problem that will help me not only learn but also help me in my daily life. Learning SQL Server 2008 was no exception for me. Through the building of an electronic recipe box, I have taken advantage of many of the new features of SQL Server 2008 – including sparse columns, filestream, table-valued parameters, the MERGE statement and even spatial data. Come learn from my experiences as we walk through the design and development of this application – and you can even have the code when we’re done!

SessionID: 29691

Introduction to PowerShell

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev I

Speaker: Keith Dahlby

Title: Introduction to PowerShell

Abstract:

PowerShell is Microsoft's next-generation command-line shell and scripting language. In this session we will discuss why you need it, how to use it, and what makes it different from any other shell on any platform. For administrators, Microsoft is investing heavily in PowerShell as the hub for its Windows Server products, starting with Exchange 2007 and SQL Server 2008. For developers, PowerShell provides full access to .NET for Read-Eval-Print loops (REPL), rapid prototyping, object exploration and extensibility. We will take a quick look at features for both groups before diving into an interactive demo, so come prepared with questions you have or problems we can solve together.

SessionID: 29998

Database Design Patterns

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: BI / Relational Theory

Speaker: Louis Davidson

Title: Database Design Patterns

Abstract:

Beyond database design fundamentals (for example, Normalization) lies the area where you have to create "real" solutions. In this session, I will cover a good number of patterns that we commonly find useful to try to apply to the problem of building a database solution. Ideas like generalization, subclassing, single table domain tables, optional data, and more will be discussed, some of them good, some not so good (don't assume which will be which), but all that are common and/or useful for your database implementations.

SessionID: 30441

Tuna Helper - A Proven Process for Tuning SQL

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev I

Speaker: Janis Griffin

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: 30885

Building Reports in SQL Server Reporting Services

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: BI / Relational Theory

Speaker: Jessica Moss

Title: Building Reports in SQL Server Reporting Services

Abstract:

Let’s learn how to build reports in SQL Server Reporting Services 2008. This presentation will show the features of SSRS 2008 by building multiple reports. We will see how to include HTML in your reports, show various ways to present data, and make your data pop with visualizations.

SessionID: 30886

Extract, Transform, and Load your Data Warehouse

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: BI / Relational Theory

Speaker: Jessica Moss

Title: Extract, Transform, and Load your Data Warehouse

Abstract:

One data warehouse buzzword that often gets used is "ETL", also known as extract, transform, and load. But what does this really mean from a data warehousing perspective and how do we use SQL Server Integration Services to perform these ETL functions? This session will answer these questions and show solutions to common ETL problems.

SessionID: 30887

Introduction to SSAS Dimensions

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: BI / Relational Theory

Speaker: Jessica Moss

Title: Introduction to SSAS Dimensions

Abstract:

This session will provide an introduction to dimensions in SQL Server Analysis Services 2008. We will discuss the different types of dimensions and how to create dimension attributes, hierarchies, and properties. Finally, we'll discuss the different properties of dimensions used to create more performant SSAS processing and querying.

SessionID: 32482

2 Years of Database Unit Testing: Lessons Learned

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev II

Speaker: Alex Kuznetsov

Title: 2 Years of Database Unit Testing: Lessons Learned

Abstract:

This presentation is based on two years of real life experience with database unit testing.

I will explain in which cases database unit testing is most useful. I will show how we test selects, modifications, and error handling. Also I will demonstrate which common maintenance problems arise when we cover our source code with unit tests and how to deal with them. Duration: 45 minutes

SessionID: 33577

High-Availability Options for Microsoft SQL Server

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administrative / Platform

Speaker: Tim Plas

Title: High-Availability Options for Microsoft SQL Server

Abstract:

A comparison of SQL high-availability options, by a practitioner who has implemented and managed most all of the various SQL HA approaches. Tim is an operational SQL DBA, charged with keeping SQL servers up and running and optimized, for managed-services customers. We will compare trade-offs between the various SQL HA options: for complexity, usability, hardware requirements, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.

SessionID: 34526

Introduction to Database Mirroring

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administrative / Platform

Speaker: Zakir Durumeric

Title: Introduction to Database Mirroring

Abstract:

Database mirroring was introduced as a new database-scoped high-availability option in SQL Server 2005 and has quickly become a popular alternative to database clustering and log shipping. We will look at what makes database mirroring a particularly inviting option, the basics behind the technology and implementation as well as discuss first-hand the caveats we discovered during the implementation of database mirroring at the University of Iowa.

SessionID: 34527

SQL Server 2008: The New and Cool...

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev II

Speaker: Zakir Durumeric

Title: SQL Server 2008: The New and Cool...

Abstract:

My developers keep asking me when we're going to migrate to SQL Server 2008....you keep hearing about SQL Server 2008.... everything from resource governor to spatial data recognition... so what really ARE those new and cool features in SQL Server 2008 and why do you care?

SessionID: 34528

Service Broker: A Brief Introduction

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administrative / Platform

Speaker: Zakir Durumeric

Title: Service Broker: A Brief Introduction

Abstract:

Service Broker was introduced in 2005 as an asynchronous message-based communications platform for SQL Server. If configured correctly, Service Broker can be a huge time saver when developing distributed applications. However, it has also become known as one of the trickiest parts of SQL Server to setup correctly. We will go over the basic architecture of service broker and the tricks to get it implemented right, the first time.

SessionID: 34916

The Benefits of SQL Azure

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administrative / Platform

Speaker: Aaron King

Title: The Benefits of SQL Azure

Abstract:

This talk will focus on the benefits, features, sign up, code examples and ease of use of SQL Azure. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Azure.

SessionID: 34924

Defensive database programming

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev II

Speaker: Alex Kuznetsov

Title: Defensive database programming

Abstract:

I will explain what is defensive database programming, what are its advantages, and provide several simple real life examples that show how to use it. I will demonstrate how to develop robust Transact SQL code that correctly works in high concurrency environments, gracefully handles cases of unintended use, and is easy to maintain in changing environments.

SessionID: 35108

Database Design

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: BI / Relational Theory

Speaker: Louis Davidson

Title: Database Design

Abstract:

In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming "difficulties" are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can't use an index efficiently).

SessionID: 35241

Drive Your Way to the DMV

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev I

Speaker: Jason Strate

Title: Drive Your Way to the DMV

Abstract:

Microsoft SQL Server provides a wealth of information at your fingertips through Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs). Information that was used difficult or pert near impossible to obtain is now at your fingertips. Unfortunately there are many find DMVs and DMFs mysterious. Step under SQL Servers hood and find answers to some common issues through DMVs and DMFs. From sessions to caches, this presentation will provide a walk-through of some of the more useful DMVs and a take practical look at how they can be used?

Prerequisites Understanding of database administration functions

Goals:

1. Provide a definition of key DMVs within SQL Server
2. Learn how to use DMVs to discover statistics on the s

SessionID: 35242

Improving Daily Imports with Partitioned Tables

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev I

Speaker: Jason Strate

Title: Improving Daily Imports with Partitioned Tables

Abstract:

At some point, everyone struggles with loading data to OLTP systems. The business needs the data loaded so that users can work through the data. But the users can’t afford the downtime to get the data into the production tables. In this session we’ll review this problem and how to use partitioning to alleviate this issue.

Prerequisites Basic understanding for partitioned table concepts Familiarity with OLTP systems

Goals:

1. Identify situations where partitioned tables can improve database performance
2. Demonstrate partitioned table solution for daily imports
3. Provide understanding of the pro’s and con’s to selecting partitioned tables as a import solution for an OLTP system

SessionID: 35243

ABCs of CTEs

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev I

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: 35244

Extended Events, Work Smarter Not Harder

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: App Dev I

Speaker: Jason Strate

Title: Extended Events, Work Smarter Not Harder

Abstract:

There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.

Prerequisites Understanding of performance issues that can occur in SQL Server Mid-level skills writing T-SQL code

Goals:

1. Define the architecture for Extended Events
2. Identify scenarios where Extended Event can be used to troubleshoot performance
3. Demonstrate solutions to real-world performance sce

SessionID: 35444

Tips Tricks For Administering SQL Server

Back to calendar

Event Date: 17-10-2009 - Session time: 00:00:00 - Track: Administrative / Platform

Speaker: Tim Ford

Title: Tips Tricks For Administering SQL Server

Abstract:

Having had to support a large number of SQL Server instances as a solo DBA for many years I've developed a toolbox of scripts that I rely on to give me insight into disk space, database file growth, backup status, job status, and login management. Some of these I've shared on mssqltips.com, others are seeing the public light for the first time. Attendees go home with scripts they can immediately put to use in their organizations.

This site is open source. Improve this page.