sqlsathistory

Nr: 29

Back to Main list

SQLSaturday #29 - Birmingham 2010

Start Time (24h) Speaker Track Title
00:00:00 Aaron Nelson SQL Development PowerShell for Data Professionals
00:00:00 Aaron Nelson Database Administration 2 Virtualize This!
00:00:00 Robert Cain Business Intelligence PowerPivot for Excel and SharePoint 2010
00:00:00 Robert Cain Business Intelligence Introduction to SQL Server Integration Services
00:00:00 Barry Ralston Business Intelligence Introduction to MDX for SQL Programmers
00:00:00 Louis Davidson Database Administration Database Design Fundamentals
00:00:00 Louis Davidson Database Administration Database Design Patterns
00:00:00 Janis Griffin Database Administration Tuna Helper for SQL Server DBA's
00:00:00 Jim Wooley Database Administration 2 LINQ Kinq for the DBA Guy
00:00:00 Joe Webb SQL Development SQL Server Locking Blocking Made Simple
00:00:00 Joe Webb SQL Development Tips Tricks for Writing Better Queries
00:00:00 Kevin Grohoske Business Intelligence Location Aware Applications Using SQL Server 2008
00:00:00 Rodney Landrum Database Administration 2 DBA Repository Update 2010 Using SSRS and SSIS.
00:00:00 Geoff Hiten Database Administration Clustering for Mere Mortals.
00:00:00 Geoff Hiten Database Administration Scale-Out the DBA.
00:00:00 Sven Aelterman SQL Development FILESTREAM in Depth
00:00:00 Sven Aelterman SQL Development FILESTREAM in Breadth
00:00:00 Kevin Boles Database Administration 2 SQL Server Memory Deep Dive
00:00:00 Kevin Boles Database Administration 2 Parallel Query Execution Deep Dive
00:00:00 Vincent Mayfield Business Intelligence ASP.NET for the Enterprise with NLB and Clustering

SessionID: 28387

PowerShell for Data Professionals

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: SQL Development

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

Virtualize This!

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration 2

Speaker: Aaron Nelson

Title: Virtualize This!

Abstract:

With the list of features of SQL Server growing constantly the need to sandbox and test drive features in a separate environment that can communicate with but not interfere with your existing environment has become vital. With virtualization, setting up consistent test, dev, and even sandbox environments can happen minutes instead of hours AND be consistent with previous/ existing environments. In this session we will focus on Microsoft Virtualization solutions that you can leverage starting with your desktop/laptop and extending to your server environments. Even if you aren’t going to be doing the virtualization yourself it’s good to know what your options are.

SessionID: 28748

PowerPivot for Excel and SharePoint 2010

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Robert Cain

Title: PowerPivot for Excel and SharePoint 2010

Abstract:

PowerPivot is an exciting new technology from Microsoft that will allow users to leverage their data to answer many of their business questions. Commonly referred to as "Self Service Business Intelligence", PowerPivot consists of two components, PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010. This presentation will provide an overview of both components then dig deeper into PowerPivot for Excel 2010. Multiple demos illustrate everything from importing data to creating pivot tables and charts, as well as using techniques such as filters and calculated columns.

SessionID: 28750

Introduction to SQL Server Integration Services

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Robert Cain

Title: Introduction to SQL Server Integration Services

Abstract:

SQL Server Integration Services is Microsoft's powerful tool for doing ETL (Extract, Transform, and Load) in the Business Intelligence arena. In this introductory course you can get up to speed on the basic tools of ETL and learn how to leverage SSIS not just for Business Intelligence but for data conversion as well.

SessionID: 29196

Introduction to MDX for SQL Programmers

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Barry Ralston

Title: Introduction to MDX for SQL Programmers

Abstract:

This 100-level session will provide SQL programmers with the tools to begin querying SQL Server Analysis Services (SSAS) databases. Through examples, including the creation of an SSAS database from the AdventureWorks example database, students will have a primer of knowledge to begin using SSAS to the fullest.

SessionID: 29996

Database Design Fundamentals

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Louis Davidson

Title: Database Design Fundamentals

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

Database Design Patterns

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration

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

Tuna Helper for SQL Server DBA's

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Janis Griffin

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

LINQ Kinq for the DBA Guy

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration 2

Speaker: Jim Wooley

Title: LINQ Kinq for the DBA Guy

Abstract:

With the release of .NET 3.5 and the subsequent SP1, attention has focused upon the legitimacy of Object Relational Mapping systems. Regardless of whether you embrace LINQ to SQL, the Entity Framework, NHibernate, or any of the hundreds of other O/R Mappers, the question remains for the DBA: Is it time to consider alternatives to stored procedures? In this session, we'll introduce LINQ and discuss how programmers and DBA's can work together with these emerging technologies to build robust, performant and dynamic systems.

SessionID: 30910

SQL Server Locking Blocking Made Simple

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: SQL Development

Speaker: Joe Webb

Title: SQL Server Locking Blocking Made Simple

Abstract:

A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

SessionID: 30911

Tips Tricks for Writing Better Queries

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: SQL Development

Speaker: Joe Webb

Title: Tips Tricks for Writing Better Queries

Abstract:

Transact-SQL is not a very difficult language to learn. As long as the syntax is correct, it can be quite forgiving. However to truly get the best performance from your SQL Server, careful consideration should be given to the structure and logic of the queries. In this session, we’ll discuss some Transact-SQL tips and tricks that can be employed to help you write better queries, allowing your server to perform better.

SessionID: 31328

Location Aware Applications Using SQL Server 2008

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Kevin Grohoske

Title: Location Aware Applications Using SQL Server 2008

Abstract:

With SQL Server 2008 R2, Microsoft has added spatial capabilities that provides a developer an very powerful toolset to create dynamic and powerful location aware applications. In this demonstration we will review the available spatial capabilities, objects, and complimentary Bing services used to develop a custom spatial aware Business Intelligence application.

SessionID: 32616

DBA Repository Update 2010 Using SSRS and SSIS.

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration 2

Speaker: Rodney Landrum

Title: DBA Repository Update 2010 Using SSRS and SSIS.

Abstract:

I put together the DBA Repository a few years back and have written and spoken about it for as many years with updates and enhancements over time. At it's heart, the solution employs SSIS and SSRS and in late 2009 I updated it for performance and resiliency. You can read about the original solution in SQL Server Magazine. The latest update will be published in 2010. This will be a sneak peak at those enhancements. The session will cover some interesting uses of package variables and MERGE in SSIS with new reports as well.

SessionID: 33036

Clustering for Mere Mortals.

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration

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

Scale-Out the DBA.

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration

Speaker: Geoff Hiten

Title: Scale-Out the DBA.

Abstract:

Policy-Based Management, Central Management Server, Enterprise Policy Management Framework, and Powershell combine to allow automation of DBA tasks more than ever before. Learn how to put these pieces together to do more with less.

SessionID: 33279

FILESTREAM in Depth

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: SQL Development

Speaker: Sven Aelterman

Title: FILESTREAM in Depth

Abstract:

This session is designed to provide an introduction to FILESTREAM from installation to basic use, and then delve into how FILESTREAM can be put to use in N-Tier applications.

SessionID: 33280

FILESTREAM in Breadth

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: SQL Development

Speaker: Sven Aelterman

Title: FILESTREAM in Breadth

Abstract:

This session is a follow-up session on FILESTREAM in Depth. This session will cover how to use FILESTREAM data in a variety of scenarios, including Reporting Services and in a transactional scenario.

SessionID: 33499

SQL Server Memory Deep Dive

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration 2

Speaker: Kevin Boles

Title: SQL Server Memory Deep Dive

Abstract:

Like the title says, be prepared to get really down and dirty with memory allocations and usage in SQL Server. RAM is one of the three pillars of server performance and understanding how it is used, how you can analyze what is going on with it and how to properly adjust the the few knobs you have at your disposal are very important topics for both your server's health and performance.

SessionID: 33500

Parallel Query Execution Deep Dive

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Database Administration 2

Speaker: Kevin Boles

Title: Parallel Query Execution Deep Dive

Abstract:

What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.

SessionID: 33839

ASP.NET for the Enterprise with NLB and Clustering

Back to calendar

Event Date: 27-03-2010 - Session time: 00:00:00 - Track: Business Intelligence

Speaker: Vincent Mayfield

Title: ASP.NET for the Enterprise with NLB and Clustering

Abstract:

Most ASP.NET Developers are able to build ASP.NET Applications. However, few understand the principles of building scalable Enterprise Applications that are deployable in a Network Load Balanced or Clustered Server network configuration. This seminar targets advanced developers who desires to understand the considerations required in designing and building a scalable ASP.NET Applications. Topics covered in this seminar include: The NLB and Clustered Network Topology, Handling State, Inproc versus SQL Server State Management, Sticky Sessions, Programming Considerations, Database Considerations, and Statistics.