Nr: 40
SQLSaturday #40 - South Florida 2010
SessionID: 28391
PowerShell for the Data Professional
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA4
Speaker: Aaron Nelson
Title: PowerShell for the Data Professional
Abstract:
SessionID: 28519
Introduction to SharePoint 2010 BI and PowerPivot
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI1
Speaker: Adam Jorgensen
Title: Introduction to SharePoint 2010 BI and PowerPivot
Abstract:
SessionID: 28804
Multi-Server Management with SQL Server 2008+
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA1
Speaker: Argenis Fernandez
Title: Multi-Server Management with SQL Server 2008+
Abstract:
SessionID: 29225
Disaster Recovery Planning for Hurricane Alley
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Brent Ozar
Title: Disaster Recovery Planning for Hurricane Alley
Abstract:
Brent will cover the basics of SQL Server’s DR options including log shipping, mirroring, replication and more. He’ll explain the pros and cons of each, and teach you how to pick the right method for your application. You'll also learn some of the things that burned him during several hurricanes and role swaps. No DRP experience required - Brent will show you the ropes.
SessionID: 29226
BLITZ! One Hour SQL Server Takeovers
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Brent Ozar
Title: BLITZ! One Hour SQL Server Takeovers
Abstract:
You're minding your own business in your corner office - well, no, you're a DBA, so it's just your cubicle - when somebody says, "Did you know about this SQL Server over here?" Suddenly, you have to find out what the server's doing, how it was set up, and whether things are working correctly. In this real-time session, Brent will show you how he tackles unknown servers in 60 minutes to find problems, take an inventory, and set the server up for easier management down the road.
SessionID: 29376
You don't need Talent to Succeed
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Misc
Speaker: Hector Hernandez
Title: You don't need Talent to Succeed
Abstract:
You don't need Talent to Succeed, but Everything else Counts
This session helps you trigger our natural abilities that go unused for years. Once you discover that these are already part of you (us), you will be able to apply them to advance your career, your relationships and your life. You can manage your career and your life—it’s not about balance. Talent is overrated.
SessionID: 29388
T-SQL 0-60 (zero- sixty from Standing 2 Sprinting)
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Dev
Speaker: @ccatto Catto
Title: T-SQL 0-60 (zero- sixty from Standing 2 Sprinting)
Abstract:
In T-SQL 0 - 60 we'll discuss Transact SQL for SQL Server. We'll discuss four major sections:
1 IDE (SSMS) Queries http://tinyurl.com/cattotsql1
2 Query View vs. Design View http://tinyurl.com/cattotsql2
3 Stored Procedures http://tinyurl.com/cattotsql3
4 Sky is the Limit (advanced topics). http://tinyurl.com/cattotsql4
At the end of the seesion we'll understand how to query data in SSMS using T-SQL
SessionID: 29599
Don't Be Trigger Happy: Safe Use of Triggers
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA1
Speaker: Jack Corbett
Title: Don't Be Trigger Happy: Safe Use of Triggers
Abstract:
SessionID: 29703
Getting Out from Behind the Curtain - The New DBA
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA1
Speaker: David Levy
Title: Getting Out from Behind the Curtain - The New DBA
Abstract:
SessionID: 29804
Sneak Preview: SAPIEN's Visual PowerShell 2011
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA4
Speaker: David Corrales
Title: Sneak Preview: SAPIEN's Visual PowerShell 2011
Abstract:
Preview SAPIEN Technologies’ new dedicated PowerShell editor: Visual PowerShell 2011
The next generation in PowerShell graphical user interface (GUI) creation. Visual PowerShell 2011 builds upon PrimalForms 2009 and adds a plethora of new features and enhancements. New additions include Script Debugging, Multi-Form Support, Built in Console, Snippets and more.
The demonstration will cover:
- Creating GUIs for PowerShell
- Creating SQL Query GUIs using the Database Browser
- Packaging your GUIs and scripts into executables
- Cover new features such as Snippets, PowerShell Console, WMI Browser and more
- Creating Projects for Multi-Form GUIs
- Integrated Help and PrimalSense
SessionID: 29928
Locking and Blocking for Developers
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA2
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: 29929
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Dmitri Korotkevitch
Abstract:
The purpose of this session is sharing this experience helping to avoid some of the typical issues for the systems working under heavy load. The session gives the overview of how SQL Server stores data, what criteria Query Optimizer uses choosing the index, how data is locking - essential knowledge when you expect system to handle thousands transactions per second.
SessionID: 29930
Getting familiar with Query Optimizer
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Dmitri Korotkevitch
Title: Getting familiar with Query Optimizer
Abstract:
Why my queries are so slow? Why SQL does not use that index? What "Hash Match" means? Do we really need to upgrade the hardware?
It's essential to know how query optimizer works if you want to design effective solutions. This session will give you an overview of how query optimizer generates query plans, how to read them, how SQL Server executes queries and show a few optimization tricks.
SessionID: 29943
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Misc
Speaker: Don Gabor
Abstract:
Networking can be tough for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop you’ll learn to make professional connections that will pay off for years to come. Best-selling author and networking expert, Don Gabor will guide you through the conversation process to make networking will be easier and more productive. Networking can be tough for many technical people, but approaching and talking to colleagues is one of the most valuable take-aways you can get at an IT conference. In this 1-hour SQLSaturday workshop you’ll learn to make professional connections that will pay off for years to come.
SessionID: 30332
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Azure
Speaker: Herve Roggero
Abstract:
Let's talk Azure!!! SQL Azure is the Microsoft SQL Server database in the cloud and it comes packed with cool capabilities. Let's review its performance footprint and how to go about designing high performance applications with SQL Azure. We will discuss Sharding, network latency, asynchronous operations and much more! Some of this content is taken directly out of the upcoming book on Pro SQL Azure, from APress.
SessionID: 30333
Building a Shard for SQL Azure using .NET 4.0
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Azure
Speaker: Herve Roggero
Title: Building a Shard for SQL Azure using .NET 4.0
Abstract:
SessionID: 30598
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA3
Speaker: Jose Chinchilla
Abstract:
Change Data Capture (CDC) is one of the newest features available for SQL Server 2008 which allows you to easily track and keep history of all DML (Data Manipulation Language) changes on user tables such as INSERT, DELETE, and UPDATE without additional overhead. One of the most important benefits of this feature is that it allows you to see the data before after an UPDATE statement which allows you to recover data overwritten or deleted quickly without the need of a database restore.
On this presentation we will go over the steps necessary to configure CDC and do an overview of some real world scenarios where this feature can be applied such as Business Intelligence, Disaster Recovery, Auditing, Debugging, Documentation and more.
SessionID: 31020
SQL University 101: Starting the SQL Journey
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA3
Speaker: Jorge Segarra
Title: SQL University 101: Starting the SQL Journey
Abstract:
On my blog I've started a project called SQL University aimed at folks looking to learn SQL Server from the ground up. This session will start at ground level tasks and resources all database professionals should know (we won't be covering basic T-SQL in this session, just tasks and concepts). This session is aimed at entry-level folks but anyone is welcome to attend to sharpen up their basic skills and resources!
SessionID: 31021
SQL University 201: Managing a SQL Server pt 2
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA3
Speaker: Jorge Segarra
Title: SQL University 201: Managing a SQL Server pt 2
Abstract:
In our 101 session we did a high level overview of the world of SQL Server and how things work within that environment. In this session we'll dive a little deeper and talk about important tasks expected of a DBA such as backups and restores, general maintenance, understanding various resources and virtualization of SQL Server. Attending the 101 session is not a pre-requisite so feel free to join us and continue our SQL Server education!
SessionID: 31047
Introduction to SQL Azure
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Azure
Speaker: Joe Healy
Title: Introduction to SQL Azure
Abstract:
SessionID: 31640
Working with SQL Server - SQLPS
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA4
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: 31641
Using PowerShell with SQL Server Agent
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA4
Speaker: Maximo Trinidad
Title: Using PowerShell with SQL Server Agent
Abstract:
SessionID: 31676
Advanced Parameters in SQL Server Reporting Servic
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI1
Speaker: Mike Davis
Title: Advanced Parameters in SQL Server Reporting Servic
Abstract:
In this session Mike shows parameters in many different ways including stored procedure, cascading, Default Values, Available Values, Multi value with the Split Functions in Stored Procedures, and custom code.
SessionID: 31677
Dynamically Configuring SSIS Packages
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI1
Speaker: Mike Davis
Title: Dynamically Configuring SSIS Packages
Abstract:
In this session, you’ll learn how to control your SSIS packages in a more powerful way by using expressions. The expression language is a bit of an elusive language that can be used to make any component in SSIS dynamic. Then, you’ll learn how to use configuration files to externalize the configuration of your package and lastly how to pass variables into a package. Also learn how to use parent child packages and environment variables.
SessionID: 31679
Understanding the SSIS Data Flow
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI1
Speaker: Mike Davis
Title: Understanding the SSIS Data Flow
Abstract:
SessionID: 31965
Building Blocks to Analysis Services
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI2
Speaker: Michael Mollenhour
Title: Building Blocks 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: 31966
Taking SSIS to the Next Level
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI2
Speaker: Michael Mollenhour
Title: Taking SSIS to the Next Level
Abstract:
This session will show you some of the more complex feature available in SSIS. These features can help your packages run more smoothly and handle problem areas better. See how to enable features like checkpoints and transactions on your packages. You will also learn how to use the native logging features to track package executions.
SessionID: 32135
Log Shipping vs. Replication; the Great Debate
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA3
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: 32136
Introduction to Transactional Replication
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA3
Speaker: Troy Gallant
Title: Introduction to Transactional Replication
Abstract:
SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution.
SessionID: 32341
SQL and SEO - More Money Per Query
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Misc
Speaker: Jared Nielsen
Title: SQL and SEO - More Money Per Query
Abstract:
SessionID: 32348
Tips Tricks for dynamic SSRS Reports
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI1
Speaker: Pam Shaw
Title: Tips Tricks for dynamic SSRS Reports
Abstract:
SessionID: 32613
The DBA Script Thumb
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA1
Speaker: Rodney Landrum
Title: The DBA Script Thumb
Abstract:
SessionID: 32614
DBA Repository Update 2010 Using SSIS and SSRS
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI2
Speaker: Rodney Landrum
Title: DBA Repository Update 2010 Using SSIS and SSRS
Abstract:
SessionID: 32633
Automate ID Administration w/ PowerShell SQLPSX
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA4
Speaker: Ronald Dameron
Title: Automate ID Administration w/ PowerShell SQLPSX
Abstract:
I will demonstrate how I automated ID provisioning using PowerShell, SQLPSX, and our corporate standard job scheduler.
SessionID: 32634
Why SQL Server DBAs should learn PowerShell
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA4
Speaker: Ronald Dameron
Title: Why SQL Server DBAs should learn PowerShell
Abstract:
I will detail my reasoning why a DBA would benefit from learning PowerShell. I will demonstrate how a DBA can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage their workload.
SessionID: 32831
Developing Application with SQL Azure
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Azure
Speaker: Scott Klein
Title: Developing Application with SQL Azure
Abstract:
This session will dive into what it takes to develop application for SQL Azure.
SessionID: 32920
Cool Stuff with SSRS
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI1
Speaker: Shervin Shakibi
Title: Cool Stuff with SSRS
Abstract:
This session will provide a great detailed look at SSRS.
SessionID: 33010
Insight Into Your Indexes With DMVs
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA1
Speaker: Tim Ford
Title: Insight Into Your Indexes With DMVs
Abstract:
SessionID: 33012
Top 10 SQL Mistakes and Mis-Steps
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA1
Speaker: Tim Ford
Title: Top 10 SQL Mistakes and Mis-Steps
Abstract:
Join this beginner-level session in which we'll go over common mistakes made by new and seasoned SQL Server Professionals alike. Learn how to avoid these issues before they happen.
SessionID: 33362
Mapping with SQL Server 2008, Silverlight and Bing
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Dev
Speaker: Telmo Sampaio
Title: Mapping with SQL Server 2008, Silverlight and Bing
Abstract:
SessionID: 33504
SQL Server Memory Deep Dive
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI2
Speaker: Kevin Boles
Title: SQL Server Memory Deep Dive
Abstract:
SessionID: 33505
Advanced TSQL Solutions
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI2
Speaker: Kevin Boles
Title: Advanced TSQL Solutions
Abstract:
SessionID: 33506
Parallel Query Execution Deep Dive
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: BI2
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: 33659
ITIL V3 for the Database Administrator
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA3
Speaker: Timothy McAliley
Title: ITIL V3 for the Database Administrator
Abstract:
SessionID: 33808
Database Partitioning: The Basics
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Elijah Baker
Title: Database Partitioning: The Basics
Abstract:
In this session I will go over what database partitioning is and what the structures are to implement it. I will present all of the basic SQL structures that it takes to implement partitioning as well as some general discussion of how to choose the right partitioning key, use of file groups in partitioning, partitioned index alignment, and multi-partitioning.
SessionID: 34491
Creating a C# Runtime Dynamic SSIS Designer
Event Date: 31-07-2010 - Session time: 00:00:00 - Track: Dev
Speaker: Sam Abraham
Title: Creating a C# Runtime Dynamic SSIS Designer
Abstract:
SSIS enables us to quickly create deployable packages to move/manipulate data. Things do however get a bit challenging when source and destination tables are not known at package design time or when a requirement exists to have an already-deployed package support schema changes in source tables. One solution to this problem is to leverage our ability to create and execute an SSIS package dynamically in code.
In this session we will take a look at a complete project for a C# Runtime SSIS Package Designer, taking as input a set of table names and dynamically generating both destination Access tables then creating, validating, saving and executing an SSIS Package at runtime with logging enabled to demonstrate the various package steps.