sqlsathistory

Nr: 49

Back to Main list

SQLSaturday #49 - Orlando 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Aaron Nelson	Powershell	The Dirty Dozen: PowerShell Scripts for Busy DBAs
00:00:00	Aaron Nelson	Powershell	PowerShell 2.0 Beyond the Dirty Dozen
00:00:00	Adam Jorgensen	BI	Zero to Dashboard in 60 minutes
00:00:00	Andy Warren	Misc	Introduction to SQL Server Statistics
00:00:00	Argenis Fernandez	DBA2	Multi-Server Management with SQL Server 2008+
00:00:00	Brandie Tarvin	DBA	SQL Backups Recovery
00:00:00	Brian McDonald	BI	Reporting Services Delivery Mechanisms (mini)
00:00:00	Brian McDonald	Misc	Documenting BI (mini)
00:00:00	Brandie Tarvin	TSQL	Troubleshooting Tips (MINI)
00:00:00	Chad Miller	Powershell	ETL with PowerShell
00:00:00	Jack Corbett	Misc	Profiling: It's Okay in SQL Server
00:00:00	David Waugh	Sponsor Demo	Response Time Analysis of SQL Server Performance
00:00:00	Dmitri Korotkevitch	Performance	Locking and Blocking for Developers
00:00:00	Louis Davidson	TSQL	Database Design Fundamentals
00:00:00	Ed Wilson	Powershell	Windows PowerShell Best Practices for SQL DBA’s
00:00:00	Eric Wisdahl	SSIS	SSIS Configurations, Expressions and Constraints
00:00:00	Eric Wisdahl	SSIS	SSIS - Data Flow Buffer Breakdown
00:00:00	Nathan Heaivilin	Performance	Introduction to Execution Plans
00:00:00	Jose Chinchilla	SSIS	Learning SSIS under 1 hour
00:00:00	Jeffrey Garbus	Performance	Choosing Indexes For Performance
00:00:00	Jonathon Moorman	TSQL	Everything you wanted to know about IDENTITY colum
00:00:00	John Welch	SSIS	Moving Data with SQL Azure and SSIS
00:00:00	Jorge Segarra	DBA2	Policy-Based Management in a Nutshell
00:00:00	Kendal Van Dyke	DBA2	Transactional Replication: Beyond The Basics
00:00:00	Ken Simmons	DBA	Configuration Domination: Taking Control of SQL (M
00:00:00	Ken Simmons	DBA2	Automating Routine Maintenance
00:00:00	Devin Knight	BI	Introduction to Analysis Services
00:00:00	Maximo Trinidad	Powershell	Working with SQL Server - SQLPS
00:00:00	Mike Davis	BI	R2 Reporting Services, The New Stuff
00:00:00	Michael Stark	TSQL	Spatial Queries in SQL 2008
00:00:00	Michael Antonovich	TSQL	XML 101 for the SQL Developer
00:00:00	Michael Antonovich	BI	BI Pivot Tables Charts, Not a 1 Tool Exercise
00:00:00	Mike Walsh	DBA2	As a DBA, Where Do I Start?!
00:00:00	Michael Mollenhour	BI	Securing your Data Warehouse
00:00:00	Troy Gallant	DBA2	Log Shipping vs. Replication; the Great Debate
00:00:00	patrick thompson	Misc	Parts of Facebook: Cassandra and MapReduce
00:00:00	patrick thompson	DBA2	Cassandra, Mongo and Mapreduce (MINI)
00:00:00	Plamen Ratchev	Performance	How to Make a Killer Presentation (MINI)
00:00:00	Plamen Ratchev	TSQL	Zen and the Art of Writing SQL Query - Part 1
00:00:00	Plamen Ratchev	TSQL	Zen and the Art of Writing SQL Query - Part 2
00:00:00	Patrick LeBlanc	SSIS	CDC + SSIS = SCD
00:00:00	Patrick LeBlanc	SSIS	Speaking, Should I? (MINI)
00:00:00	Jared Nielsen	Misc	SQL and SEO - Making Money with SQL Server
00:00:00	Pam Shaw	DBA	Tips Tricks for Dynamic SSRS Reports
00:00:00	Rafael Salas	SSIS	Planning your ETL architecture with SSIS
00:00:00	Rodney Landrum	DBA	DBA Script Thumb 2010
00:00:00	Ronald Dameron	Powershell	Why a DBA Should Learn PowerShell (MINI)
00:00:00	Ronald Dameron	Powershell	Automate Login Administration Compliance Reports
00:00:00	Andrew Szalaji	Sponsor Demo	expressor data integration software product demons
00:00:00	Scott Schledwitz	Sponsor Demo	Information Builders
00:00:00	Scott Klein	Misc	Developing Applications with SQL Azure
00:00:00	Shawn McGehee	Sponsor Demo	Red Gate Software - Ingeniously simple tools
00:00:00	Thomas LaRock	Performance	What Are You Waiting For?
00:00:00	Kevin Boles	Performance	SQL Server Memory Deep Dive
00:00:00	Kevin Boles	Performance	SQL Server Partitioning from A to Z
00:00:00	Said Salomon	DBA	Data Encryption and Key Management in SQL
00:00:00	Tim Beamer	DBA	Designing a highly available SQL Environment
00:00:00	Timothy McAliley	Misc	ITIL V3 for the Database Administrator
00:00:00	Wes Dumey	BI	Data Warehousing with SQL Server 2008
00:00:00	Kathi Kellenberger	DBA	Optimize Resources with MAP
00:00:00	Kathi Kellenberger	Sponsor Demo	Women in Technology (WIT)

SessionID: 28407

The Dirty Dozen: PowerShell Scripts for Busy DBAs

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Powershell

Speaker: Aaron Nelson

Title: The Dirty Dozen: PowerShell Scripts for Busy DBAs

Abstract:

For DBAs PowerShell provides a simple but powerful way to automate everyday tasks. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of PowerShell to easily find Servers short on space, Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

SessionID: 28408

PowerShell 2.0 Beyond the Dirty Dozen

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Powershell

Speaker: Aaron Nelson

Title: PowerShell 2.0 Beyond the Dirty Dozen

Abstract:

Now that you’ve learned the basics of PowerShell we’ll dive a little deeper and learn to develop scripts that help you get the most out of SQL Server. We’ll take a look at advanced functions, event logging and error handling. Then put everything together in a nice package and create our own modules to deploy to profiles across our entire SQL Server environment.

SessionID: 28525

Zero to Dashboard in 60 minutes

Back to calendar

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

Speaker: Adam Jorgensen

Title: Zero to Dashboard in 60 minutes

Abstract:

Build your first PerformancePoint dashboard along with Adam in this demo rich session. We’ll cover how PerformancePoint works and then build some great content together.

SessionID: 28719

Introduction to SQL Server Statistics

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Misc

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

Multi-Server Management with SQL Server 2008+

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA2

Speaker: Argenis Fernandez

Title: Multi-Server Management with SQL Server 2008+

Abstract:

Learn how to manage multiple instances of SQL Server with the different tools that SQL Server 2008 and 2008 R2 offer. We will discuss Central Management Servers, multiserver querie, Utility Control Point, Policy-Based Management and SQLPS (the Powershell SQL mini-shell). 3rd party tools will be discussed as time permits.

SessionID: 29102

SQL Backups Recovery

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Brandie Tarvin

Title: SQL Backups Recovery

Abstract:

Backing up SQL Server is not just about database files anymore. This session gives a brief refresher of basic database backup techniques then moves to a discussion about all the other SQL components you should be backing up (and may have forgotten about). Bring your horror stories to share with all. Session also covers the order in which to restore / recovery your database backups.

SessionID: 29278

Reporting Services Delivery Mechanisms (mini)

Back to calendar

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

Speaker: Brian McDonald

Title: Reporting Services Delivery Mechanisms (mini)

Abstract:

On demand reporting is the most common type of report request using SQL Server Reporting Services, but did you know that there are other options available to you? In this mini session, Brian is going to go over all of the delivery mechanisms built into SQL Server Reporting Services that will allow you to take full advantage of Microsoft’s robust reporting platform.

SessionID: 29279

Documenting BI (mini)

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Brian McDonald

Title: Documenting BI (mini)

Abstract:

Sherri McDonald will be presenting a tool that documents your major SQL Server components and the "entire" BI stack. Your team can now view historical data from SQL Server Databases, Integration Services, Analysis Services and Reporting Services in a format that is easy to navigate and understand. See a visual snapshot of your environment that includes images of their SSIS packages, ER Diagrams as well as an Impact Analysis Object Lineage.

SessionID: 29344

Troubleshooting Tips (MINI)

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: TSQL

Speaker: Brandie Tarvin

Title: Troubleshooting Tips (MINI)

Abstract:

Join ace DBA and troubleshooter Brandie Tarvin for a fast and furious look at some ways you might get to the bottom of a problem in a hurry. Just fifteen minutes and you could learn something that might save the day (or get cheaper car insurance!).

SessionID: 29575

ETL with PowerShell

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Powershell

Speaker: Chad Miller

Title: ETL with PowerShell

Abstract:

In this session we will look at performing common data loading tasks with Powershell. A basic understanding of PowerShell is helpful, but not necessary. Specific topics covered include importing structured files, XML, WMI objects and ADO.NET data sources.

SessionID: 29605

Profiling: It's Okay in SQL Server

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Jack Corbett

Title: Profiling: It's Okay in SQL Server

Abstract:

Learn how to use SQL Server Profiler/Trace to troubleshoot SQL Server performance and errors. This session will cover how to use Profiler to capture SQL Server events, creating server-side traces, creating custom templates, saving trace data, and interpreting trace data.

SessionID: 29807

Response Time Analysis of SQL Server Performance

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Sponsor Demo

Speaker: David Waugh

Title: Response Time Analysis of SQL Server Performance

Abstract:

Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response Time based performance analysis to solve the most difficult performance related issues. Designed for the SQL Server DBA, Developer or anyone concerned with performance.

SessionID: 29924

Locking and Blocking for Developers

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Performance

Speaker: Dmitri Korotkevitch

Title: Locking and Blocking for Developers

Abstract:

Locking, blocking, waits.. Why developers should care? Those things are for DBA. But what if you don't have DBA in the team? What if DBA complaints directly to your boss? This session will provide you an overview how SQL Server Lock Manager works; how different isolation levels affect the system; gives you bird-eye view of SQLOS and Sql Server Waits; provide you the guidelines how to minimize the locking, avoid deadlocks and improve concurrency of the system. It also shows you a couple of basic methods how to troubleshot problems related with locking and concurrency.

SessionID: 30008

Database Design Fundamentals

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: TSQL

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

Windows PowerShell Best Practices for SQL DBA’s

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Powershell

Speaker: Ed Wilson

Title: Windows PowerShell Best Practices for SQL DBA’s

Abstract:

Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences.

SessionID: 30130

SSIS Configurations, Expressions and Constraints

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: SSIS

Speaker: Eric Wisdahl

Title: SSIS Configurations, Expressions and Constraints

Abstract:

This session will look in depth at some of the more powerful aspects of Integrations Services: Expressions, Package Configurations, and Precedence Constraints. A short tutorial will show the users how to build up a package structure to allow logging to a remote location determined through configurations as well as capturing errors, destroying the error file if no errors are present and emailing a configurable user if any errors are found.

SessionID: 30132

SSIS - Data Flow Buffer Breakdown

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: SSIS

Speaker: Eric Wisdahl

Title: SSIS - Data Flow Buffer Breakdown

Abstract:

An advanced session which will attempt to break down areas of the data flow buffer. In examining how the buffers are built and used, the user will begin to understand if, how and why package performance will be impacted when new transformations or columns are added. The session will further take a look at the effects of parallel package and parallel task execution.

SessionID: 30302

Introduction to Execution Plans

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Performance

Speaker: Nathan Heaivilin

Title: Introduction to Execution Plans

Abstract:

This is an introductory level session on execution plans. You will learn how to read them, what a number of the operators are, and then some real world example of how to use them, things to look for, and ways to make your queries run more efficiently.

SessionID: 30607

Learning SSIS under 1 hour

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: SSIS

Speaker: Jose Chinchilla

Title: Learning SSIS under 1 hour

Abstract:

In this session I will cover the most important SSIS control flow and data flow tasks to jumpstart DBAs into SSIS in SQL Server 2008. The session will focus on loading a de-normalized Data Warehouse from different sources.

SessionID: 30665

Choosing Indexes For Performance

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Performance

Speaker: Jeffrey Garbus

Title: Choosing Indexes For Performance

Abstract:

Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

SessionID: 30680

Everything you wanted to know about IDENTITY colum

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: TSQL

Speaker: Jonathon Moorman

Title: Everything you wanted to know about IDENTITY colum

Abstract:

A look at the various properties of identity columns. We will discuss how identity columns behave in triggers and replication. We will look at the property functions and catalog views to retrieve metadata about identity columns. We will also see how to override default identity information and specify a value, and reseed an identity column.

SessionID: 30938

Moving Data with SQL Azure and SSIS

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: SSIS

Speaker: John Welch

Title: Moving Data with SQL Azure and SSIS

Abstract:

SQL Azure allows you to host your data in SQL Server in the cloud. That provides some big benefits in scalability and management. However, it leaves open the question, “How do you get your data into / out of the cloud?” At some point, you are going to need to move data to or from an on-premise store to SQL Azure. In this session, we’ll discuss the available options for this, including SSIS, the Sync Framework, and BCP. We’ll cover the pros and cons for each. We’ll drill into one of the options, SSIS, in detail, and review performance options and potential issues that you may encounter when doing this.

SessionID: 31028

Policy-Based Management in a Nutshell

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA2

Speaker: Jorge Segarra

Title: Policy-Based Management in a Nutshell

Abstract:

We will be learning an overview of this powerful new feature in SQL Server 2008 and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Servers!

SessionID: 31270

Transactional Replication: Beyond The Basics

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA2

Speaker: Kendal Van Dyke

Title: Transactional Replication: Beyond The Basics

Abstract:

Transactional replication can support synchronizing from as few as a hundred to as many as hundreds of millions or more of changes a day across multiple servers. However, replication is more than clicking your way through wizards; Monitoring and tuning are required to achieve optimal performance and the number of processes involved increase the likelihood that problems can (and usually will) occur. This session is for DBA already familiar with the basics of transactional replication and looking to go beyond the setup wizards to gain a deeper understanding of the technology. We'll cover monitoring techniques, calibrating performance, and troubleshooting common replication problems plus share some tricks and tips.

SessionID: 31286

Configuration Domination: Taking Control of SQL (M

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Ken Simmons

Title: Configuration Domination: Taking Control of SQL (M

Abstract:

We all know that every environment is different, so how can we expect the default SQL Server installation to be optimized for each one. In this session, we will look at some of the configuration options you can change after you have installed SQL Server to maximize performance, security, and reliability. We will also cover the configuration changes you should make that are often overlooked after your server or your database has been upgraded.

SessionID: 31288

Automating Routine Maintenance

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA2

Speaker: Ken Simmons

Title: Automating Routine Maintenance

Abstract:

You have installed SQL Server in your environment, but now what? Unfortunately, far too many servers are neglected after SQL Server has been installed and the applications are up and running. In order to sustain a SQL Server instance that provides optimum performance, it requires constant maintenance. Luckily, you can use the same tools within SQL Server to automate maintenance tasks that you use to meet the business needs of the organization. This session will cover the tasks you need to perform in order to maintain a healthy instance of SQL Server as well as the tools you can use to automate them.

SessionID: 31407

Introduction to Analysis Services

Back to calendar

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

Speaker: Devin Knight

Title: Introduction to Analysis Services

Abstract:

In this session you will learn some of the basics to getting you started with Analysis Services. Key terms and as well as best practices will be discussed for developing an Analysis Services Cube.

SessionID: 31643

Working with SQL Server - SQLPS

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Powershell

Speaker: Maximo Trinidad

Title: Working with SQL Server - SQLPS

Abstract:

Will demo a series of way to take advantage of SQL Server 2008 - SQLPS to work with you different version so SQL Servers. See how powerfull the POSH command prompt can be to monitor and manage your SQL Servers. I will also demo the Invoke-SQLCmd cmdlet. There will be lots of samples.

SessionID: 31685

R2 Reporting Services, The New Stuff

Back to calendar

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

Speaker: Mike Davis

Title: R2 Reporting Services, The New Stuff

Abstract:

In this session Mike shows you the new features in Reporting Services R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts. Learn how to drill down from the US level to the state level using the map controls.

SessionID: 31771

Spatial Queries in SQL 2008

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: TSQL

Speaker: Michael Stark

Title: Spatial Queries in SQL 2008

Abstract:

A quick tour of the spatial data features of SQL Server 2008. Will create several different queries to determine geographic proximity between points. The second half of the session is devoted to wiring SQL Server spatial data into Bing Maps using ASP.Net.

SessionID: 31796

XML 101 for the SQL Developer

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: TSQL

Speaker: Michael Antonovich

Title: XML 101 for the SQL Developer

Abstract:

This session defines what XM is and how it differs from regular HTML, It looks at how to define data type variables and columns in SQL to store XML, how to output XML from existing table structures. It also covers how to use OPENXML, how to create and use your own namespaces, and the difference between typed XML and untyped XML.

SessionID: 31798

BI Pivot Tables Charts, Not a 1 Tool Exercise

Back to calendar

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

Speaker: Michael Antonovich

Title: BI Pivot Tables Charts, Not a 1 Tool Exercise

Abstract:

This session begins with a simple SQL database with several related tables. It then shows how to import those tables to create a simp;le cube in Analysis Services. Given a simple, but functional cube, the session then goes into Excel to use the cube in Pivot Tables and Pivot Charts. Finally, you will see how easy it is to publish those Excel Pivot Tables and Pivot Charts into SharePoint using Excel Services to protect the calculation methods while allowing anyone with a browser to see and use your results.

SessionID: 31888

As a DBA, Where Do I Start?!

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA2

Speaker: Mike Walsh

Title: As a DBA, Where Do I Start?!

Abstract:

Whether you are new to the role of DBA, being "forced" to take on its responsibility or joining a new company with previous experience, knowing where to start can often mean the difference between success or failure. In this chat, Mike will help us wade through the noise that attacks a DBA and figure out just what our priorities should be. By focusing on the "itties" of Database Administration (Recoverability, Availability - Health Performance - , Security and Reliability) we can see a natural priority form. Throughout this interactive discussion we will also look at some of the available tools and scripts to help see where our environments rate. Mike emphasizes our role as "Protector of the Data" as a DBA throughout.

SessionID: 31961

Securing your Data Warehouse

Back to calendar

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

Speaker: Michael Mollenhour

Title: Securing your Data Warehouse

Abstract:

In this Session Mike will demonstrate how to leverage Active Directory Groups and Users to secure your DataWarehouse. He will demonstrate how to secure both Column and row level info in Transactional queries all the way to AS Queries.

SessionID: 32129

Log Shipping vs. Replication; the Great Debate

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA2

Speaker: Troy Gallant

Title: Log Shipping vs. Replication; the Great Debate

Abstract:

Many SQL Server DBA's are tasked with the responsibility of choosing an appropriate disaster recovery, reporting, or failover solution for their organization. Much of the time the choice comes down to replication versus log shipping. And while both solutions can be extremely effective, there are both subtle major differences between them that can guide you to choose one over the other. This presentation gets to the nuts and bolts of the two technologies, and helps you make an educated recommendation and implementation.

SessionID: 32152

Parts of Facebook: Cassandra and MapReduce

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: patrick thompson

Title: Parts of Facebook: Cassandra and MapReduce

Abstract:

Apart from Google, Facebook is the 800lb Gorrilla in the internet space. They process 135TB of click data day, 1.2 million images a second. How do they do it? This session will look at two of the tools in the Facebook toolbox and talk about what makes them tick and how they fit with a Sql environment.

SessionID: 32153

Cassandra, Mongo and Mapreduce (MINI)

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA2

Speaker: patrick thompson

Title: Cassandra, Mongo and Mapreduce (MINI)

Abstract:

It's not always an all SQL Server world. Come see some benchmarks and tips on when and where they alternatives are best used.

SessionID: 32257

How to Make a Killer Presentation (MINI)

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Performance

Speaker: Plamen Ratchev

Title: How to Make a Killer Presentation (MINI)

Abstract:

The naked truth about engaging your audience in a lively and entertaining presentation where both speaker and attendees have fun. Note that neither the presenter or the attendees will be naked for this great how-to session!

SessionID: 32260

Zen and the Art of Writing SQL Query - Part 1

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: TSQL

Speaker: Plamen Ratchev

Title: Zen and the Art of Writing SQL Query - Part 1

Abstract:

Writing a query is an art! Simplicity, focus, and practice is all it takes. Understand the logical processing of a query and discover the art of writing simple and efficient queries. It is a journey that starts with FROM and ends with ORDER BY!

SessionID: 32261

Zen and the Art of Writing SQL Query - Part 2

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: TSQL

Speaker: Plamen Ratchev

Title: Zen and the Art of Writing SQL Query - Part 2

Abstract:

Become a Zen master in the art of writing SQL queries! Explore the advanced topics of grouping, pivoting, and ranking with practical hands-on examples. Aggregating at multiple levels, transposing one or more columns, and isolating ranges may all seem like difficult tasks. Learning the fundamentals and applying simple steps will show you the way to master SQL query writing!

SessionID: 32262

CDC + SSIS = SCD

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: SSIS

Speaker: Patrick LeBlanc

Title: CDC + SSIS = SCD

Abstract:

Building dimensions using the Slowly changing dimension wizard in SSIS is simple and quick. However its performance and flexibility is questionable. Even further, when trying to perform incremental loads of your Dimensions using the aforementioned approach or a custom approach prior to Change Data Captured (CDC) offered certain challenges. In this session Patrick will show you how to utilize CDC and SSIS to incrementally load Type I and Type II dimensions using features that are all native to SQL Server 2008.

SessionID: 32263

Speaking, Should I? (MINI)

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: SSIS

Speaker: Patrick LeBlanc

Title: Speaking, Should I? (MINI)

Abstract:

I have been speaking for a while now. My first speaking engagement was at the inaugural Baton Rouge SQL Server User Group in May 2008. Was I nervous? Sure I was, but I quickly realized that I enjoyed it. Should you cross the line of attendee to speaker? Join me as I share my experiences as a speaker and what I think it takes to become a good speaker. You never know, you may realize that you should be speaking instead of in the audience.

SessionID: 32344

SQL and SEO - Making Money with SQL Server

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Jared Nielsen

Title: SQL and SEO - Making Money with SQL Server

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

Tips Tricks for Dynamic SSRS Reports

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Pam Shaw

Title: Tips Tricks for Dynamic SSRS Reports

Abstract:

This session we will present methods to create very dynamic reports. We will demonstrate data driven formatting and layouts. We will review how to setup data sources that are more portable as well as see how templates make it easier to have more consistent report formats. We will review emailing reports and how this can be integrated into your current application.

SessionID: 32501

Planning your ETL architecture with SSIS

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: SSIS

Speaker: Rafael Salas

Title: Planning your ETL architecture with SSIS

Abstract:

The complexity and importance of Extract, Transform and Load (ETL) projects are often underestimated, and the consequences of a poorly planned and executed ETL project will inevitably lead to maintenance nightmares, low reliability of the system, or worse yet, to the failure of the project.

In this session, we will use ETL best practices to make a requirements checklist you can use in your next ETL implementation, and will demonstrate how you can use SSIS to implement and meet such requirements. If you already learned the basics about SSIS and now want to take your ETL solutions to the next level, or if you became an SSIS developer/architect by accident and wonder what do you need to succeed, then this is the right session for you.

SessionID: 32623

DBA Script Thumb 2010

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Rodney Landrum

Title: DBA Script Thumb 2010

Abstract:

This session will present a top 10 (maybe 20) list of queries and tools that DBAs can use daily. The idea is that everything is included on a single 1G or less thumb drive to be portable. From simple T-SQL statements to full blown SSIS packages, the session demonstrates how to interogate, diagnose, report on, and resolve issues that are most prevalent for DBAs: disk space, security, backup locations, database and server documentation, performance and much more. All queries, which are SQL 2000, 2005 and 2008 tried and true will be made available in the session to copy to your own thumb drive. If you are lucky you might even receive a free coveted thumb to store the queries.

SessionID: 32641

Why a DBA Should Learn PowerShell (MINI)

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Powershell

Speaker: Ronald Dameron

Title: Why a DBA Should Learn PowerShell (MINI)

Abstract:

Powershell is the newest scripting language from Microsoft and it goes across the Windows platform, including SQL Server. So it's new and exciting, but is it ready for prime time? Is it worth the effort to learn? How will it help you? Join PowerShell advocate and user Ron Dameron for a quick discussion of why he things knowing Powershell is a key skill for a SQL Server DBA.

SessionID: 32642

Automate Login Administration Compliance Reports

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Powershell

Speaker: Ronald Dameron

Title: Automate Login Administration Compliance Reports

Abstract:

Are your internal auditors asking that the administration of SQL Server logins be handled by a third party other than the DBAs? Is your Compliance and Audit departments asking you to determine if password policies are being enforced, who are sysadmins on your servers, who owns databases? If so, come to this session to learn how to complete these tasks quickly and efficiently using PowerShell and SQL PowerShell Extensions (SQLPSX).

SessionID: 32797

expressor data integration software product demons

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Sponsor Demo

Speaker: Andrew Szalaji

Title: expressor data integration software product demons

Abstract:

What do you do when SSIS can’t handle your data volumes or data sizes? Join expressor software for a discussion and demonstration of their data integration software. expressor software allows organizations to reuse the most labor-intensive elements of data integration projects, deliver superior data processing performance, and reap significant cost savings in both development and project lifecycle management and in hardware and software licensing.

SessionID: 32820

Information Builders

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Sponsor Demo

Speaker: Scott Schledwitz

Title: Information Builders

Abstract:

Learn more about Information Builders

SessionID: 32826

Developing Applications with SQL Azure

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Scott Klein

Title: Developing Applications with SQL Azure

Abstract:

This session will provide and detailed look at developing applications with SQL Azure. It will begin by providing an overview of existing functionality SQL Azure provides, then delve in to utilizing the features and technology to migrate existing applications as well as develop new applications with SQL Azure.

SessionID: 32913

Red Gate Software - Ingeniously simple tools

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Sponsor Demo

Speaker: Shawn McGehee

Title: Red Gate Software - Ingeniously simple tools

Abstract:

In this session Shawn McGehee, DBA and former developer and Friend of Red Gate, will illustrate the disk space,processing time and integrated feature benefits of using SQL Backup and show how best to manage database changes within SSMS using Red Gate’s new tool SQL Source Control. Engage in this lunchtime session for your chance to win one of two free licenses for SQL Source Control and other Red Gate swag.

SessionID: 33068

What Are You Waiting For?

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Performance

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

SQL Server Memory Deep Dive

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Performance

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

SQL Server Partitioning from A to Z

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Performance

Speaker: Kevin Boles

Title: SQL Server Partitioning from A to Z

Abstract:

We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.

SessionID: 33649

Data Encryption and Key Management in SQL

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Said Salomon

Title: Data Encryption and Key Management in SQL

Abstract:

Overview of data encryptions and key management that is build into SQL 2005 and later. Topics that will be cover include: transparent column data encryption techniques, Transparent Data Encryption (TDE) new in 2008, use of keys (symmetrical and asymmetrical), what is a database master key, use of certificates in combination with key management, how to backup and safeguard keys.

SessionID: 33653

Designing a highly available SQL Environment

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Tim Beamer

Title: Designing a highly available SQL Environment

Abstract:

SQL Server is the database engine supporting the Line-of-Business applications that run your business, so how do you make sure it is always up and providing those critical services? This session will look at several alternatives for designing and implementing a highly availble architecture for your SQL environment. Options will be presented to give a range of availability scenarios based on Service Level Agreements, as well as budget.

SessionID: 33664

ITIL V3 for the Database Administrator

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Misc

Speaker: Timothy McAliley

Title: ITIL V3 for the Database Administrator

Abstract:

Information Technology Infrastructure Library (ITIL) Version III is a public/non-proprietary framework that describes Best Practices in IT Service Management. Conducting database administration within an ITIL framework can improve change management, reduce operational risks, stabilize your environment and pose challenges. Learn the conceptual basics of the Information Technology Infrastructure Library, Version 3 (ITIL V3), the responsibilities and deliverables of DBAs in an ITIL shop, and review a few examples of scaled deployments of the ITIL V3 process framework.

SessionID: 34485

Data Warehousing with SQL Server 2008

Back to calendar

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

Speaker: Wes Dumey

Title: Data Warehousing with SQL Server 2008

Abstract:

In this session you will learn about using Microsoft SSIS and SQL Server 2008 to host a data warehouse. We will work through an introduction to data warehousing and look at how we can use the Microsoft tools to build a small data warehouse.

SessionID: 34703

Optimize Resources with MAP

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: DBA

Speaker: Kathi Kellenberger

Title: Optimize Resources with MAP

Abstract:

Are you looking for tools to plan and optimize your database resources and investments? See how the Microsoft Assessment and Planning (MAP) Toolkit 5.0 can help you optimize your SQL Server infrastructure and accelerate migration planning to SQL Server 2008 R2. Learn how to inventory your infrastructure for discovery of SQL Server databases and engine instances—information you can use to optimize hardware and database resources, reduce administrative costs and streamline software licensing needs--all essentials for cost effective IT planning and operations.

SessionID: 34705

Women in Technology (WIT)

Back to calendar

Event Date: 16-10-2010 - Session time: 00:00:00 - Track: Sponsor Demo

Speaker: Kathi Kellenberger

Title: Women in Technology (WIT)

Abstract:

This is a general round table discussion about women in technology. This presentation is open to men as well.

This site is open source. Improve this page.