sqlsathistory

Nr: 61

Back to Main list

SQLSaturday #61 - DC 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Michael Coles	DBA/DEV Advanced	Introduction to SQL Server Spatial Data
00:00:00	Michael Coles	Professional Development	Sell Yourself Into An Interview!
00:00:00	Andy Leonard	Professional Development	Some Thoughts on Managing Teams
00:00:00	Andy Leonard	Database Development	Introduction to Incremental Loads
00:00:00	Allen White	DBA/DEV Advanced	Gather SQL Server Performance Data with PowerShell
00:00:00	Allen White	DBA/DEV Advanced	Automate Policy-Based Management using PowerShell
00:00:00	Edwin Sarmiento	DBA/DEV Advanced	DBA Disaster Recovery Techniques To Keep Handy
00:00:00	Edwin Sarmiento	Professional Development	Presentation WOW!
00:00:00	Tim Chapman	DBA/DEV Advanced	Writing faster queries
00:00:00	Jana Sattainathan	DBA	Partitioning in SQL Server 2005/2008
00:00:00	Jose Chinchilla	BI	Business Intelligence: Decaffeinated Please!
00:00:00	Jose Chinchilla	Professional Development	Get Cert! Get Cred!
00:00:00	Joseph D'Antoni	Database Development	Deploying Data Tier Applications with SQL 2k8 R2
00:00:00	Jeremiah Peschka	DBA	Fundamentals of SQL Server Internals
00:00:00	Joel Cochran	Database Development	SSIS for real: A walk through a real world project
00:00:00	Joel Cochran	Database Development	Intro to C# for the SSIS Script Component
00:00:00	John Welch	BI	Processing Flat Files with SSIS
00:00:00	John Sterrett	Database Development	Monitor your SQL Server farm with PBM and CMS
00:00:00	Karen Lopez	Database Development	Database Design Contentious Issues
00:00:00	Kevin Goff	BI	Applied MDX in OLAP applications
00:00:00	Kevin Goff	BI	Introduction to PowerPivot
00:00:00	Kendra Little	DBA	Table Partitioning: Evaluation, Planning, Options
00:00:00	Matt Van Horn	BI	SSRS Interactive Reports
00:00:00	Jared Nielsen	DBA/DEV Advanced	SQL and SEO - the FUZION of data and marketing
00:00:00	Sandra Mueller	DBA	Data Files and Transaction Logs – Beyond the GUIs
00:00:00	Sergey Pustovit	DBA	SQL Server Performance Related DMVs
00:00:00	Thomas LaRock	DBA	Performance Tuning Made Easy
00:00:00	Steve Radich	Professional Development	A better way to store and archive SQL Backups
00:00:00	William E Pearson III	BI	Design and Implement BI Like Edison!

SessionID: 28468

Introduction to SQL Server Spatial Data

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA/DEV Advanced

Speaker: Michael Coles

Title: Introduction to SQL Server Spatial Data

Abstract:

SQL Server 2008 introduced support for new spatial data features -- providing powerful visualization capabilities to your users. In this course attendees will learn the basics of the Geography and Geometry data types, spatial indexing, and spatial calculations. We will also explore more advanced uses for spatial data: loading spatial data into SQL Server from other formats, the new Map control in SSRS, and using online mapping software like Bing Maps to visualize SQL Server spatial data.

SessionID: 28469

Sell Yourself Into An Interview!

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Michael Coles

Title: Sell Yourself Into An Interview!

Abstract:

In today's economy job seekers need to take advantage of every opportunity. In this session attendees will learn how to take advantage of unprecedented opportunities to market themselves to potential employers (and the world at large!) We'll cover topics including fine-tuning your resume, managing your online presence and responding to the toughest interview questions. We'll also discuss how you can turn simple steps, like asking your interviewer questions and sending a follow-up note, into unparalleled opportunities to close the deal.

SessionID: 28663

Some Thoughts on Managing Teams

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Andy Leonard

Title: Some Thoughts on Managing Teams

Abstract:

Are you a member of a team of database professionals? Are you part of a developer team? Do you manage or lead a team? This presentation is for you. Andy Leonard shares experiences, war stories, and lessons learned from years of managing and leading teams.

SessionID: 28666

Introduction to Incremental Loads

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Database Development

Speaker: Andy Leonard

Title: Introduction to Incremental Loads

Abstract:

This session if for SSIS developers and DBAs. Attend and learn more about Transact-SQL and SSIS design patterns for loading data incrementally. The session includes two demos: Incremental Loads in Transact-SQL; and Incremental Loads in SSIS.

SessionID: 28905

Gather SQL Server Performance Data with PowerShell

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA/DEV Advanced

Speaker: Allen White

Title: Gather SQL Server Performance Data with PowerShell

Abstract:

We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 28907

Automate Policy-Based Management using PowerShell

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA/DEV Advanced

Speaker: Allen White

Title: Automate Policy-Based Management using PowerShell

Abstract:

The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.

SessionID: 28976

DBA Disaster Recovery Techniques To Keep Handy

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA/DEV Advanced

Speaker: Edwin Sarmiento

Title: DBA Disaster Recovery Techniques To Keep Handy

Abstract:

Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it's a mission critical one.This session will focus on being prepared for and dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery

SessionID: 28977

Presentation WOW!

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Edwin Sarmiento

Title: Presentation WOW!

Abstract:

So you open up PowerPoint, create your slides and get ready to present. Sure, you know exactly how to do this - you've done it a lot of times in the past - but there’s more. Leveraging on the experiences learned from presenting at worldwide conferences such as SQL PASS Community Summit, TechEd, DevTeach and the likes, this session will look at what needs to be considered when creating powerful presentations that shine.

SessionID: 29449

Writing faster queries

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA/DEV Advanced

Speaker: Tim Chapman

Title: Writing faster queries

Abstract:

Poor database performance is Achilles' heel of any system. Better and faster hardware can improve systems to a certain point. However, for truly great performing systems, there is no substitute for properly written queries and designed indexes. In this session we'll take a look at some common query performance killers, along with some no so obvious things that we can do to our queries to make them as fast as possible.

SessionID: 30420

Partitioning in SQL Server 2005/2008

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Jana Sattainathan

Title: Partitioning in SQL Server 2005/2008

Abstract:

Starting with SQL Server 2005, Microsoft has made a significant effort to truly streamline partitioning data to be on par with industry leading databases like Oracle. The potential was not fully harnessed by the SQL Server community primarily due to the lack of any user interface associated with partitioning and due to lack of cohesive documentation. For many, Kimberly Tripp’s white paper on “Partitioned Tables and Indexes in SQL Server 2005” is generally regarded as a primary guiding source that bridges the void in MS documentation. Come and get a quick start on partitioning. It is simple and efficient. Manageability and performance come part and parcel.

SessionID: 30600

Business Intelligence: Decaffeinated Please!

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: BI

Speaker: Jose Chinchilla

Title: Business Intelligence: Decaffeinated Please!

Abstract:

For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at risk of failure.In this session attendees will learn some of the basic concepts that are key in understanding BI and DW. I will go over my 10 rules of wisdom for a successful BI solution intended as a roadmap to get you started.

SessionID: 30601

Get Cert! Get Cred!

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Jose Chinchilla

Title: Get Cert! Get Cred!

Abstract:

Obtaining a certification may be a dreaded and stressing process for some people. Most people fail because of their failure to plan a realistic roadmap towards their goals and not necessarily because they lack the skills. This session will focus on establishing a roadmap towards certification success for the MCTS and MCITP programs of SQL Server and Business Intelligence. I will do a quick overview of my recent success obtaining 4 certifications in 30 days and how you can achieve similar goals. But why certify? Join me to find out the opportunities you may be missing on!

SessionID: 30650

Deploying Data Tier Applications with SQL 2k8 R2

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Database Development

Speaker: Joseph D'Antoni

Title: Deploying Data Tier Applications with SQL 2k8 R2

Abstract:

Data Tier Applications (DAC Packs) are a new feature in SQL 2008 R2, that alllow developers to better simplify environmental management. In this demo, I will define the requirement surrounding DAC packs, then build and deploy a sample.

SessionID: 30741

Fundamentals of SQL Server Internals

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Jeremiah Peschka

Title: Fundamentals of SQL Server Internals

Abstract:

Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.

SessionID: 30901

SSIS for real: A walk through a real world project

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Database Development

Speaker: Joel Cochran

Title: SSIS for real: A walk through a real world project

Abstract:

In this presentation I will walk though a complete real-world SSIS project that pulls data from an AS/400 and converts it to a SQL Server destination. In addition to specific AS/400 conversion issues I will also cover topics like dynamic OLEDB connections, and creating an effective work flow. Along the way we'll take a look at how I use Derived Columns, Conditional Split, Lookup, and Script components to solve every day conversion issues.

SessionID: 30902

Intro to C# for the SSIS Script Component

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Database Development

Speaker: Joel Cochran

Title: Intro to C# for the SSIS Script Component

Abstract:

The Script Component is an extremely powerful element in SSIS because it brings in the full capability of the .NET Framework. With first-class development tools and languages like C# you can solve problems that previously required very complex SQL or Expressions. If you'd like to learn enough C# to more effectively use the Script Component for Transformations, then this session is for you.

SessionID: 30951

Processing Flat Files with SSIS

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: BI

Speaker: John Welch

Title: Processing Flat Files with SSIS

Abstract:

When doing data integration, a common requirement is to work with flat files, whether for importing data into a system from an external source, or to export it to provide to other systems. SQL Server Integration Services (SSIS) supports flat files, but there can be a number of challenges when working with them. This is particularly true if your flat files have multiple data formats contained in a single file, the data has complex formatting, or the files have inconsistent formatting. This session will help you to be more efficient when working with these types of files. You’ll learn to handle missing delimiters in the files, and parsing files that have multiple data formats.

SessionID: 31104

Monitor your SQL Server farm with PBM and CMS

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Database Development

Speaker: John Sterrett

Title: Monitor your SQL Server farm with PBM and CMS

Abstract:

This talk will give you an introduction into monitoring SQL Server using Policy Based Management and Central Management System which is provided out of the box with SQL Server 2008. I will then show you how you can combine these features with the Enterprise Policy Management Framework on codeplex to provide monitoring for your whole SQL Server farm. This topic assumes you know nothing about PBM and CMS and will include lots of examples with only a few PowerPoint slides.

SessionID: 31191

Database Design Contentious Issues

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Database Development

Speaker: Karen Lopez

Title: Database Design Contentious Issues

Abstract:

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * SOAs, Ontologies, ESBs, New TLAs and Shoe Strings * What is Logical? What is Physical? Why Do We Care? * Who Calls the Shots and Who Does What? * Implementing Party/party role...and others. Bring your votes, your debates, and your opinions.

SessionID: 31342

Applied MDX in OLAP applications

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: BI

Speaker: Kevin Goff

Title: Applied MDX in OLAP applications

Abstract:

Learning the basics of MDX is one thing - learning how to incorporate MDX into custom OLAP applications is sometimes more difficult. In this session, I'll show different examples on using MDX inside SSRS reports, PerformancePoint Services dashboards, and even inside Excel.

SessionID: 31345

Introduction to PowerPivot

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: BI

Speaker: Kevin Goff

Title: Introduction to PowerPivot

Abstract:

Are you trying to get a handle on what PowerPivot can do? Are you also interested in knowing PowerPivot's limitations? Would you like to know how to integrate PowerPivot with Sharepoint 2010? Are you a little confused about where PowerPivot "fits" in the Microsoft BI stack? Are you unsure about how DAX formulas work? This intro session is almost like a "PowerPivot for Mere Mortals", where I'll take same data from 2 sources and showcase several of PowerPivot's capabilities.

SessionID: 31506

Table Partitioning: Evaluation, Planning, Options

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Kendra Little

Title: Table Partitioning: Evaluation, Planning, Options

Abstract:

Does SQL Server's table partitioning feature offer performance improvements, manageability benefits, or both? Table partitioning is a significant investment: it's important to understand many aspects of the feature to evaluate where it might be useful to applications. This session will cover basic concepts of table partitioning. We'll discuss where the feature can be applied, its benefits, and changes that partitioning may require to existing database schema. Special considerations for management of partitioned tables will be discussed, as well as potential changes to query optimization and plans. New SQL 2008 R2 features for partitioning will be included in the discussion.

SessionID: 31618

SSRS Interactive Reports

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: BI

Speaker: Matt Van Horn

Title: SSRS Interactive Reports

Abstract:

I will show how to take advantage the interactive features of SQL Reporting Services to allow your users to drill down from summaries to the details that drive them. Address some of the simple to implement features that can make your existing reports much more useable to your end users. Topics to be covered include: Graphing, Interactive Sorting, Grouping, and Drilldown Reports.

SessionID: 32342

SQL and SEO - the FUZION of data and marketing

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA/DEV Advanced

Speaker: Jared Nielsen

Title: SQL and SEO - the FUZION of data and marketing

Abstract:

Bringing marketing together with technology is a fine art that involves high tech tools, real life solutions, and most important human buy-in from the marketing and IT departments. This lecture will delve into the use of the latest SQL Server 2005 and SQL Server 2008 technologies including recursive common table expressions (CTE), hierarchical data models, and CLR stored procedures for the IT side of the house while also delving into the use of analytics, webmaster monitoring tools, web marketing tactics and search engine optimization techniques for the more marketing minded. Neither SQL nor SEO are four letter words and they go together perfectly! So too can your IT and marketing departments as you tackle the new age of IT Marketing.

SessionID: 32762

Data Files and Transaction Logs – Beyond the GUIs

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Sandra Mueller

Title: Data Files and Transaction Logs – Beyond the GUIs

Abstract:

Performance of SQL Server poor? One cause may have been that starting file size that you didn't think was important because it will auto-grow. Why is auto-grow bad? Why shouldn't files be auto-shrunk? Why keep that free space in the files? Explore the physical structure of a database, how table structure effects use of memory and key mistakes to avoid. Additionally, dive into the transaction log process - VLFs, auto-recovery and lock escalation. Solid foundation for Programmers and Administrators!

SessionID: 32890

SQL Server Performance Related DMVs

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Sergey Pustovit

Title: SQL Server Performance Related DMVs

Abstract:

There are number of tools available on the market for the SQL Server performance troubleshooting. But do we use the full power of the internal SQL Server Data Management Views (DMVs)? Some very challenging issues can be solved using DMVs. What the Dynamic Management Views are? How diagnostics data is getting populated? Using the examples we are going to talk about diagnostic data analysis using T-SQL queries against SQL Server DMVs.

SessionID: 33072

Performance Tuning Made Easy

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Thomas LaRock

Title: Performance Tuning Made Easy

Abstract:

Performance tuning is hard, everyone knows that. Attend this session and learn how to define, measure, and analyze performance issues as well as implementing changes and also how to make sure those changes continue to have the desired effects. In short, I break down performance tuning into pieces that anyone can understand. Leave this session knowing what actions to take when you get back to work on Monday.

SessionID: 33237

A better way to store and archive SQL Backups

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Steve Radich

Title: A better way to store and archive SQL Backups

Abstract:

How do you verify your daily backup can be restored? What if you need to restore a backup from several days ago instead of the latest? How many backups should you keep? I've adopted a Tower of Hanoi tape rotation schedule to meet our disk-to-disk backup needs, at first that sounds simple but it's actually MUCH more complex than it sounds - Learn about the strategy I use, the scripts we use to backup (with reports of success/failure and automatic retries for any failure), how we validate backups, and how we decide which backups to keep and which we erase to free up disk space.

SessionID: 33966

Design and Implement BI Like Edison!

Back to calendar

Event Date: 04-12-2010 - Session time: 00:00:00 - Track: BI

Speaker: William E Pearson III

Title: Design and Implement BI Like Edison!

Abstract:

As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence solutions.

This site is open source. Improve this page.