sqlsathistory

Nr: 53

SQLSaturday #53 - Kansas City 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Ameet Phadnis	Special Topic	Integrate LOB SQL Data into my portal
00:00:00	Arie Jones	Developer	Going Spatial!
00:00:00	Arie Jones	DBA Beyond 101	Take Control with Resource Governor
00:00:00	Bill Fellows	Professional Development	Open Networking
00:00:00	Bill Fellows	Professional Development	Open Networking
00:00:00	Bill Fellows	Professional Development	Open Networking
00:00:00	Bill Fellows	Developer	CLR in SQL Server: A love story in 5 parts
00:00:00	Bill Graziano	DBA 101	SQL Server Administration for new DBAs and non-DBA
00:00:00	Brett Flippin	BI	Incremental ETL Processes with SSIS
00:00:00	Brian Mitchell	Special Topic	SQL Server 2008 R2 Parallel Data Warehouse
00:00:00	Carlos Bossy	BI	Data Mining with Analysis Services
00:00:00	Carlos Bossy	Bonus	Essentials of a Business Intelligence Architecture
00:00:00	Chris Shaw	DBA Beyond 101	Managing a 0 Downtime Shop
00:00:00	Dennis Graham	Bonus	Advanced topics in SSRS:
00:00:00	Dennis Graham	Bonus	Reporting against data other than databases
00:00:00	Frank Kearney	BI	Partition management in Analysis Services
00:00:00	Jeff Hattendorf	DBA Beyond 101	Database Mirroring
00:00:00	Joe Ferry	BI	Start Using MDX with SSAS 2008
00:00:00	Karen Lopez	Special Topic	Database Design Contentious Issues
00:00:00	Kushal Lal	BI	Report Model a solution for ad-hoc reporting
00:00:00	Leonard Mwangi	DBA Beyond 101	Unleashing PowerShell to you SQL Environment.
00:00:00	Marc Beacom	BI	Introduction to Analysis Services
00:00:00	Peter Trast	DBA 101	Be in control - Policy Based Management
00:00:00	Rob Kraft	DBA 101	SQL Server Security - All Things Considered
00:00:00	Russel Loski	Developer	Stored procedure tracing using the xml datatype
00:00:00	Scott Shaw	Special Topic	SQL Server in Healthcare - Healthy Relationship?
00:00:00	Steve Jones	Professional Development	The Modern Resume: Building Your Brand
00:00:00	Sandeep Khandelwal	DBA 101	SharePoint SQL Server - Marriage made in heaven
00:00:00	Thomas LaRock	DBA Beyond 101	What Are You Waiting For?
00:00:00	Sudhir Gajre	DBA Beyond 101	Strategies for Maximum Concurrency and Performance
00:00:00	Kevin Boles	Developer	Common TSQL Programming Mistakes
00:00:00	Kevin Boles	Developer	Advanced TSQL Solutions
00:00:00	Kevin Boles	Bonus	SQL Server and SANs
00:00:00	Aaron King	Special Topic	The Benefits of SQL Azure
00:00:00	Wendy Pastrick	DBA 101	Transactional Replication 101
00:00:00	Kathi Kellenberger	Bonus	What's New with Reporting Services?
00:00:00	Kathi Kellenberger	Professional Development	Women in Technology Panel Discussion

SessionID: 28371

Integrate LOB SQL Data into my portal

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Special Topic

Speaker: Ameet Phadnis

Title: Integrate LOB SQL Data into my portal

Abstract:

Ok so you have created a Portal. Now you are ready to get your LOB data into the portal. Not sure how???? This session explains how you can integrate your external SQL data into your SharePoint portal

SessionID: 28822

Going Spatial!

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Developer

Speaker: Arie Jones

Title: Going Spatial!

Abstract:

Spatial data is being pushed more and more into the forefront of our application universe. With the advent of MapPoint and Google Maps companies are consistently pushing the boundaries of what traditional databases can do. Now with SQL Server 2008 we have built in spatial data types that will make your life a little easier in the days to come. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data as well as tools such as SSRS's integrating geospatial mapping to make you the company geospatial hero. Geospatial awesomeness fro everyone!

SessionID: 28823

Take Control with Resource Governor

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA Beyond 101

Speaker: Arie Jones

Title: Take Control with Resource Governor

Abstract:

A large majority of a modern DBA's workload consists of managing the resources on their systems in order to ensure that they are being followed and resources are accessible when needed. SQL Server 2008 provides Resource Governor, which allows the DBA to discretely manage system resources in a very structured or not so structured way(Its your choice!). In this session, we will show you how to configure, monitor, and administer these features to help lower your anxiety levels while increasing your system’s availability.

SessionID: 29040

Open Networking

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Bill Fellows

Title: Open Networking

Abstract:

Brain full? Take this time to meet with fellow professionals, swap war stories, praise or slam features and trade tips. Come and go as you please

SessionID: 29041

Open Networking

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Bill Fellows

Title: Open Networking

Abstract:

Brain full? Take this time to meet with fellow professionals, swap war stories, praise or slam features and trade tips. Come and go as you please

SessionID: 29042

Open Networking

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Bill Fellows

Title: Open Networking

Abstract:

Brain full? Take this time to meet with fellow professionals, swap war stories, praise or slam features and trade tips. Come and go as you please

SessionID: 29043

CLR in SQL Server: A love story in 5 parts

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Developer

Speaker: Bill Fellows

Title: CLR in SQL Server: A love story in 5 parts

Abstract:

This session will provide an overview of the five SQL CLR objects available for SQL Server 2005-2008 and demonstrate how to create, deploy and use these objects for fun and profit.

SessionID: 29059

SQL Server Administration for new DBAs and non-DBA

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA 101

Speaker: Bill Graziano

Title: SQL Server Administration for new DBAs and non-DBA

Abstract:

This session walks through a SQL Server installation, the post setup configuration, a basic security review, configuring a maintenance plan and basic performance monitoring. All with no PowerPoint slides. Instead we'll walk through our SQL Server setup and configuration checklist and demonstrate everything we talk about. This session is great for new database administrators or part-time DBAs or anyone looking for a refresher. Experienced DBA's will learn something too! You'll get a copy of the checklist during the session and you'll get a link to download a copy for later.

SessionID: 29245

Incremental ETL Processes with SSIS

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI

Speaker: Brett Flippin

Title: Incremental ETL Processes with SSIS

Abstract:

Do you truncate and load your data every time you run your ETL processes? Do you want better performance out of your ETL processes? If you answered yes to either of those questions, this is your session. We'll be discussing some of the evils and gotchas of the "trunc and load" ETL process, why incremental ETL processes are better overall, and we'll take a look at several different implementations of incremental ETL processes using SSIS both from a data quality and a performance perspective.

SessionID: 29267

SQL Server 2008 R2 Parallel Data Warehouse

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Special Topic

Speaker: Brian Mitchell

Title: SQL Server 2008 R2 Parallel Data Warehouse

Abstract:

We will cover an overview of the functionality of SQL PDW

SessionID: 29396

Data Mining with Analysis Services

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI

Speaker: Carlos Bossy

Title: Data Mining with Analysis Services

Abstract:

Modern day computing power and SQL Server makes it possible to add sophisticated data mining models to our applications that forecast and predict, perform anomaly detection, and classify data. This presentation will demonstrate how to use Analysis Services to incorporate these complex algorithms seamlessly into your databases. Attendees will be shown how to create a data mining model using SSAS, how to use SSIS to query and load mining forecasts, and a sample web application that seamlessly uses a mining model. Take a step forward towards making BI pervasive in your organization by integrating data mining into your company’s applications...and learn how to win your fantasy football league and beat the stock market too!

SessionID: 29397

Essentials of a Business Intelligence Architecture

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Bonus

Speaker: Carlos Bossy

Title: Essentials of a Business Intelligence Architecture

Abstract:

SQL Server allows you to construct an analytic organization by creating a bona fide Business Intelligence foundation, giving you more insight into the status of the business, powerful ad-hoc reporting capabilities, dynamic analytical capabilities, and forecasts that make your psychic jealous. It's an understatement to say this requires really good data and terrific data structures. In this session, Carlos Bossy will discuss how to use SSIS to implement integration, metadata and transformations, SSAS for ad-hoc and predictive analytics, and SSRS to provide users the ability to develop their own reports. You will leave this session with a firm grasp to building a robust data architecture that achieves successful Business Intelligence.

SessionID: 29483

Managing a 0 Downtime Shop

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA Beyond 101

Speaker: Chris Shaw

Title: Managing a 0 Downtime Shop

Abstract:

Data is becoming more and more critical with the needs of business every day. Technology has enabled businesses to have a global reach much easier than ever before. With the growing needs to increase revenue every avenue will be explored. The outcome of this growth is the need for your database to be online with no downtime if any at all. This session is designed to visit the issues of managing a database that is online around the clock and maintenance time is scarce. We will talk about the challenges you could face each and every day, the maintenance issues such as when, where and how to trim it.

SessionID: 29896

Advanced topics in SSRS:

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Bonus

Speaker: Dennis Graham

Title: Advanced topics in SSRS:

Abstract:

Advanced topics in SSRS: Manage reporting, delivery options, control report execution, security, and deployment, email, and data driven headers, reporting from data warehouses, and overcoming Excels 65K wall.

SessionID: 29898

Reporting against data other than databases

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Bonus

Speaker: Dennis Graham

Title: Reporting against data other than databases

Abstract:

Reporting against non-traditional data: CPU usage, IIS, web site activity, Active Directory, file stores, data warehouses, machine specification and others if there is time.

SessionID: 30210

Partition management in Analysis Services

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI

Speaker: Frank Kearney

Title: Partition management in Analysis Services

Abstract:

This session will demonstrate a basic framework using SQL Server, SSIS and AMO to help manage your Analysis Services partitions. During this session we will show you how to automate the creation, processing and even deleting of your partitions all based on a simple metadata table stored in SQL Server.

SessionID: 30673

Database Mirroring

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA Beyond 101

Speaker: Jeff Hattendorf

Title: Database Mirroring

Abstract:

Do you need a database available all the time? Then you need database mirroring.

You can failover to the destination and back to the source at any time. If the source server crashed you can run a quick command on the destination server and you are back in business. You will become an expert in no time.

SessionID: 30917

Start Using MDX with SSAS 2008

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI

Speaker: Joe Ferry

Title: Start Using MDX with SSAS 2008

Abstract:

MDX is difficult to learn for many reasons. One reasons is that most training starts with SELECT queries without adequately developing a fundamental understanding of the coordinate system being used. Learners are left to fill in the blank in a way that is not comprehensive, consistant or comfortable. This presentation will give beginners (and those beyond) a more comfortable grasp of how to write queries.

SessionID: 31192

Database Design Contentious Issues

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Special Topic

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:

    * Implementing Party/party role
    * Natural vs. Surrogate keys
    * Today's vs. Tomorrow's Requirements
    *  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?

...and others. Bring your votes, your debates, and your opinions.

SessionID: 31379

Report Model a solution for ad-hoc reporting

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI

Speaker: Kushal Lal

Title: Report Model a solution for ad-hoc reporting

Abstract:

Non technical data consumers usually require and request results of ad hoc queries against enterprise databases. Let’s look at how report model can be a solution to providing ad hoc reporting while giving the non technical user the ability to use this model and create their ad hoc reports.

SessionID: 31495

Unleashing PowerShell to you SQL Environment.

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA Beyond 101

Speaker: Leonard Mwangi

Title: Unleashing PowerShell to you SQL Environment.

Abstract:

PowerShell is becoming the breath taking tool that helps unlock different Microsoft environments. Most people’s question is where do I start? In this session we will look into what PowerShell is, why it’s becoming a must have tool, what language it uses and how to do the real world stuff with it in your SQL environment.

SessionID: 31547

Introduction to Analysis Services

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI

Speaker: Marc Beacom

Title: Introduction to Analysis Services

Abstract:

By now you have probably already heard about Analysis Services. Maybe you've even said to yourself that you were going to learn more about it but just haven't found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.

SessionID: 32202

Be in control - Policy Based Management

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA 101

Speaker: Peter Trast

Title: Be in control - Policy Based Management

Abstract:

Getting a bit weary of developers or DBA's that cannot seem to follow well documented policies for naming conventions or server settings? Would you like to define these policies in a manner that allows SQL Server to ENFORCE them for you or, at the very least, monitor them? Policy-based management provides the ability to define policies that apply to servers, databases and other objects in your data environment. Well-defined policies can help you to control and manage change proactively.

SessionID: 32554

SQL Server Security - All Things Considered

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA 101

Speaker: Rob Kraft

Title: SQL Server Security - All Things Considered

Abstract:

Join me for a discussion of security risks in SQL Server and the tools and processes we have to mitigate those risks. The relationship of security to authentication, encryption, SQL Injection, SQL Browser, backups, auditing, compliance, data access layers, and more will be covered in brief. Attendees will leave this session knowing the pros and cons of different logon methods, and hopefully new techniques to reduce the attack surface of the SQL Servers they manage.

SessionID: 32722

Stored procedure tracing using the xml datatype

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Developer

Speaker: Russel Loski

Title: Stored procedure tracing using the xml datatype

Abstract:

When running a stored procedure it is difficult to record what is happening. In this session we will develop logger code in T-SQL to add to your stored procedures. We will use the xml datatype to record parameter values, variable values and debug statements. We will look at the "For xml" statement as well as the xml datatype methods. Finally we will look at how to read the logs when finished.

SessionID: 32802

SQL Server in Healthcare - Healthy Relationship?

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Special Topic

Speaker: Scott Shaw

Title: SQL Server in Healthcare - Healthy Relationship?

Abstract:

This session discusses the challenges and opportunities for DBAs supporting SQL in the IT Healthcare environment

SessionID: 32949

The Modern Resume: Building Your Brand

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Steve Jones

Title: The Modern Resume: Building Your Brand

Abstract:

SessionID: 32951

SharePoint SQL Server - Marriage made in heaven

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA 101

Speaker: Sandeep Khandelwal

Title: SharePoint SQL Server - Marriage made in heaven

Abstract:

The new release of SharePoint 2010 is a giant leap forward and has addressed several scalabilty issues in earlier versions of the product. Come and learn how SharePoint leverages SQL Server and enhancements made to SQL Server which made SharePoint a tremendous value proposition. Topics discussed will include High level overview of SharePoint capabilities, role of SQL Server, database overview, differences between SharePoint list and SQL Server tables and much much more... Don't miss it!!!

SessionID: 33063

What Are You Waiting For?

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA Beyond 101

Speaker: Thomas LaRock

Title: What Are You Waiting For?

Abstract:

It’s a simple question, right? But how often do you have the answer, especially for your SQL statements? Thomas LaRock from Confio Software will teach you how proper response time analysis plays a key part in the overall performance tuning process. You will learn how to define, measure, and analyze performance issues as well as implementing changes and how to make sure those changes continue to have the desired effects.

SessionID: 33262

Strategies for Maximum Concurrency and Performance

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA Beyond 101

Speaker: Sudhir Gajre

Title: Strategies for Maximum Concurrency and Performance

Abstract:

SessionID: 33548

Common TSQL Programming Mistakes

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Developer

Speaker: Kevin Boles

Title: Common TSQL Programming Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented.

SessionID: 33549

Advanced TSQL Solutions

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Developer

Speaker: Kevin Boles

Title: Advanced TSQL Solutions

Abstract:

The range of real-world queries that can be performed using set-based TSQL solutions is astounding, but many of these are not well known and if you haven't been shown the light you might never realize what is possible. Come and join me as we delve into the inner recesses and corners of the TSQL envelope using a wide variety of expressions, clauses and techniques.

SessionID: 33552

SQL Server and SANs

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Bonus

Speaker: Kevin Boles

Title: SQL Server and SANs

Abstract:

Lets dig into both the fundamentals as well as some details of how SANs work and how we can best utilize them to improve SQL Server's IO performance and reliability.

SessionID: 33780

The Benefits of SQL Azure

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Special Topic

Speaker: Aaron King

Title: The Benefits of SQL Azure

Abstract:

This talk will focus on the benefits, features, 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. Real world topics and use cases will be covered including data sync and staying vendor independent while hosting your data in the cloud.

SessionID: 33893

Transactional Replication 101

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DBA 101

Speaker: Wendy Pastrick

Title: Transactional Replication 101

Abstract:

Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring.

We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.

SessionID: 34699

What's New with Reporting Services?

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Bonus

Speaker: Kathi Kellenberger

Title: What's New with Reporting Services?

Abstract:

Reporting Services has undergone many changes with the 2008 and 2008 R2 releases. Learn how to take advantage of these new features: a much better Report Builder, enhanced performance, cool new visual components, reusable report parts and more!

SessionID: 34701

Women in Technology Panel Discussion

Back to calendar

Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Professional Development

Speaker: Kathi Kellenberger

Title: Women in Technology Panel Discussion

Abstract:

Interest in technology is decreasing among young people, yet technology is becoming ever more important in our world. How can we inspire the next generation to embrace science, engineering, and technology? Join SQL Server professionals Wendy Pastrick, Kim Tesereau, and Michelle Ufford as they discuss ways that we can encourage our kids to consider technology careers.

This site is open source. Improve this page.