Nr: 62
SQLSaturday #62 - Tampa 2011
SessionID: 28413
SQL Smackdown: SSIS vs. PowerShell
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: Aaron Nelson
Title: SQL Smackdown: SSIS vs. PowerShell
Abstract:
In this session, you’ll learn how to load a database using SQL Server Integration Services (SSIS) and PowerShell. You'll see a battle between two database experts (Mike Davis and Aaron Nelson), attempting to load the database in the fastest, simplest, and most reliable way. You'll see side-by-side solutions developed in each language. In the end you decide which works best for you and who wins the SQL Smackdown.
SessionID: 28520
Iron Chef SQL Server
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: Adam Jorgensen
Title: Iron Chef SQL Server
Abstract:
In this session, you’ll learn how to load a data warehouse using SQL Server Integration Services (SSIS). You'll see a battle between two SSIS experts (Adam Jorgensen and a surprise guest GURU), attempting to load the data warehouse the best way. You'll see varying architectures and best practices from each of the presenters and you decide who wins the Iron Chef competition.
SessionID: 29050
Troubleshooting with the SQL Server 2008 DC MDW
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Bill Ramos
Title: Troubleshooting with the SQL Server 2008 DC MDW
Abstract:
In this session you will learn about the SQL Server 2008 R2 data collector and management data warehouse for troubleshooting your problem situations with your SQL Server. I'll demonstrate several problem scenarios and how the MDW reports can help you identify the root cause.
SessionID: 29076
Accelerating BI Development with BI xPress
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Brian Knight
Title: Accelerating BI Development with BI xPress
Abstract:
In this session, Brian Knight will show you how to accelerate your BI development lifecycle with BI xPress. You’ll see how to implement advanced SSIS frameworks, implement code reusability in SSIS and write MDX calculation code in seconds with this must have time saving application.
SessionID: 29149
Page And Row Compression How, When, and Why
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Bradley Ball
Title: Page And Row Compression How, When, and Why
Abstract:
Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.
SessionID: 29266
SQL Server 2008 R2 Parallel Data Warehouse
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Brian Mitchell
Title: SQL Server 2008 R2 Parallel Data Warehouse
Abstract:
We will cover an overview of the functionality of SQL PDW. PDW is a highly scalable appliance for Enterprise data warehousing. We will discuss how PDW partitions large tables across multiple physical nodes, each having its own dedicated CPU, memory, storage, and each running its own instance of SQL Server in a parallel shared nothing design.
SessionID: 29280
Reporting Services 2008
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Brian McDonald
Title: Reporting Services 2008
Abstract:
SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this introductory session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access.
SessionID: 29330
Introduction to SSIS
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: Bradley Schacht
Title: Introduction to SSIS
Abstract:
In this session we will help get you past the learning curve of SSIS. We will cover the basics of the development environment, the control flow and data flow. We will show you how to create an end to end package to demostrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS. Co-Presenter: Sherri McDonald
SessionID: 29363
Cool Tricks to Pull from your SSIS Hat:
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: Julie Smith
Title: Cool Tricks to Pull from your SSIS Hat:
Abstract:
Variables, For Each Loops, and the SSIS Expression Language. This presentation is geared toward the developer new to SSIS who has mastered the dataflow, and is now looking for elegant ways to automate his/her solutions. This presentation will cover some useful SSIS features commonly used to add flexibility and elegance to more advanced ETL solutions. It will demonstrate short case studies of commonly encountered, real world business scenarios and solutions.
SessionID: 29574
SQL Server PowerShell Extensions (SQLPSX)
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Chad Miller
Title: SQL Server PowerShell Extensions (SQLPSX)
Abstract:
SessionID: 29603
Why I Use Stored Procedures
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Jack Corbett
Title: Why I Use Stored Procedures
Abstract:
In today's environment many developers are extolling the merits of ORM tools like NHibernate, Linq to SQL, and Entity Framework. Jack will share the reasons why he still believes that stored procedures are the best way to access data in SQL Server. When the session is over you will be able to discuss the issues with developers and have resources to show why you think stored procedures can improve application performance, data security, and code maintenance.
SessionID: 29854
Implementing auditing in SQL Server
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: David Dye
Title: Implementing auditing in SQL Server
Abstract:
SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
SessionID: 29923
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Dmitri Korotkevitch
Abstract:
Stored procedures are slow? SQL Server is overloaded? Maybe it's time to upgrade the server. But maybe all you need to do is the code refactoring.
This session shows how to replace several common procedural style patterns in T-SQL code with set-based approaches. It demonstrates how to gain huge performance improvements using CTE, table-valued functions, TVP, MERGE operator, OUTPUT clause and other modern T-SQL constructs. No PowerPoint slides. Presentation is based on the real examples and real code.
SessionID: 29941
DBA 101
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Don Stevic
Title: DBA 101
Abstract:
When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
SessionID: 30029
To click or to type, that is the question
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: David Taylor
Title: To click or to type, that is the question
Abstract:
When adminstering SQL Server, in SSMS are you a clicker or a typer? This session explores the use of the GUI vs. using scripting in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed. Tasks are illustrated through the use of the Day-to-Day section of Brad McGeehee's Sure DBA Checklist at http://www.bradmcgehee.com , Used with Permission and Great Thanks.
SessionID: 30034
Windows PowerShell 2.0 Best Practices for DBA's
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Ed Wilson
Title: Windows PowerShell 2.0 Best Practices for 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: 30133
SSIS Data Flow Buffer Breakdown
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Eric Wisdahl
Title: SSIS Data Flow Buffer Breakdown
Abstract:
SessionID: 30162
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Eddie Wuerch
Abstract:
SessionID: 30233
Bad SQL
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Geoff Hiten
Title: Bad SQL
Abstract:
How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.
SessionID: 30401
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Ira Warren
Abstract:
SessionID: 30430
Sql Server Service Broker - An Overview
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Janis Griffin
Title: Sql Server Service Broker - An Overview
Abstract:
Service Broker can be used to simplify messaging between applications and assist in asynchronous programming by queuing messages and/or events. This presentation will explain how to use the Service Broker services, discuss its many components and show why you’ll benefit from using it. Several case studies will illustrate an elegant way to maintain data across multiple servers and show how to reduce dependencies between related programs and/or data structures.
SessionID: 30663
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Jeffrey Garbus
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: 30863
SSIS Cafeteria
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: James McAuliffe
Title: SSIS Cafeteria
Abstract:
SSIS can be tricky sometimes. You've probably encountered some behaviours that make you scratch your head, throw up your hands, or even something unprintable. Well, me too!. Over the years of working with SSIS, I have acquired a collection of tips and tricks around areas like: Working with Excel, both as a source and destination, why does this package run so fast on this server and not even run on this other one? How can I compare packages? We will start the session by selecting , cafeteria style, from the topics of interest to the attendees, pick four or five, and drill down from there. Bring your questions!
SessionID: 30873
SQL Server Auditing 101
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Jonathan Kehayias
Title: SQL Server Auditing 101
Abstract:
Auditing user activity in SQL Server has become a hot topic lately. From SOX and PCI to HIPPA, the security of personal data, and the ability to track who accessed the data and how has become extremely important. In this session, SQL Server MVP Jonathan Kehayias covers the various methods available in SQL Server 2000, 2005, and 2008 to accomplish this task including SQL Trace in SQL Server 2000 and 2005, and the new Server Audits in SQL Server 2008.
SessionID: 30947
Do You Know the Data Flow?
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: John Welch
Title: Do You Know the Data Flow?
Abstract:
SessionID: 31025
Policy-Based Management in a Nutshell
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 6
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: 31268
DR Availability,You're Wanted in the Recovery Room
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Kendal Van Dyke
Title: DR Availability,You're Wanted in the Recovery Room
Abstract:
There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA’s) lump disaster recovery (DR) high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and based on what? It’s incredibly important that you understand the decision tree that helps you pick the right one(s) for your business, and that you can explain the choices clearly to the stakeholders. It’s not as complicated as it sounds, but it is complicated – and in this hour presentation we’ll give you a high level understanding of the options, the costs, complexities, reasons for using each of them.
SessionID: 31772
Spatial Data in SQL 2008 and Bing
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Michael Stark
Title: Spatial Data in SQL 2008 and Bing
Abstract:
A demonstration of SQL Geography Data Type in SQL Server 2008. We will constuct queries to easily match data by geographic location. Then we will wire this query up to an ASP.Net using Javascript and Handlers. Finally, we will wire this query up to a windows phone 7 device.
SessionID: 31793
Introduction to PowerPivot for Excel
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Michael Antonovich
Title: Introduction to PowerPivot for Excel
Abstract:
This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables.
SessionID: 31950
MDX 201
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Mark Landry
Title: MDX 201
Abstract:
SessionID: 31992
Where should I be encrypting my data
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Denny Cherry
Title: Where should I be encrypting my data
Abstract:
In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.
SessionID: 32127
Introduction to Transactional Replication
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 6
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: 32256
Building Hierarchy Solutions with SQL Server 2008
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Plamen Ratchev
Title: Building Hierarchy Solutions with SQL Server 2008
Abstract:
Hierarchical solutions used to be “reserved” for experts in the theory of trees and graphs. Not anymore! Learn how the new data type HIERARCHYID in SQL Server 2008 helps to simplify storage and manipulation of hierarchies. Practical examples and comparison with traditional methods like nested sets, adjacency list, and materialized path.
SessionID: 32379
Become a Bilingual DBA! Oracle for the SQL Server
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Randy Knight
Title: Become a Bilingual DBA! Oracle for the SQL Server
Abstract:
SessionID: 32622
DBA Repository Update 2010 Using SSIS and SSRS
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Rodney Landrum
Title: DBA Repository Update 2010 Using SSIS and SSRS
Abstract:
SessionID: 32639
Why Learn PowerShell?
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Ronald Dameron
Title: Why Learn PowerShell?
Abstract:
I will detail my reasoning why any IT Pro working in the Microsoft space would benefit from learning PowerShell. I will demonstrate how you can use PowerShell in conjunction with SQL, WMI, and SMO to automate repetitive tasks and better manage your workload. I will also share my thoughts on the best ways to learn PowerShell.
SessionID: 32721
SSIS and SSRS Better Together
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Russel Loski
Title: SSIS and SSRS Better Together
Abstract:
SessionID: 32765
Developing Date and Role-Playing Dimensions
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Sandra Mueller
Title: Developing Date and Role-Playing Dimensions
Abstract:
Every data warehouse needs a date dimension to help users slice and dice data. What should be included in the dimension, what is enough and what is too much? Should you use the wizard to generate the dimension for you; what are the advantages and disadvantages? We will explore a generic date dimension load script, loading a custom table and configuring SSAS to use the table as the time dimension. Finally we will address the advantages of role-playing dimensions to make an Order Date, Ship Date, Received Date exposed to users as opposed to multiple date dimensions.
SessionID: 32819
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Scott Schledwitz
Abstract:
SessionID: 33272
Efficient Datawarehouse Design
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Dr. Suresh Rajappa
Title: Efficient Datawarehouse Design
Abstract:
Design tips and tricks on implementing enterprise datawarehose and common pitfalls to avoid. This session also provides the realworld examples
SessionID: 33525
SQL Server Memory Deep Dive
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Kevin Boles
Title: SQL Server Memory Deep Dive
Abstract:
SessionID: 33600
You inherited a database Now What?
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Tim Radney
Title: You inherited a database Now What?
Abstract:
SessionID: 33652
ITIL V3 for the Database Administrator
Event Date: 15-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Timothy McAliley
Title: ITIL V3 for the Database Administrator
Abstract: