Nr: 48
SQLSaturday #48 - Columbia 2010
SessionID: 28402
The Dirty Dozen: PowerShell Scripts for Busy DBAs
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Aaron Nelson
Title: The Dirty Dozen: PowerShell Scripts for Busy DBAs
Abstract:
SessionID: 28403
PowerShell 2.0 Beyond the Dirty Dozen
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2
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: 28559
Maximizing Plan Re-use in SQL 2008
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2
Speaker: Andrew Kelly
Title: Maximizing Plan Re-use in SQL 2008
Abstract:
SessionID: 28560
Storage and I/O Best Practices for SQL Server
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session
Speaker: Andrew Kelly
Title: Storage and I/O Best Practices for SQL Server
Abstract:
SessionID: 28571
PowerSQL(CLR)
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1
Speaker: Alex Tocitu
Title: PowerSQL(CLR)
Abstract:
This session will gradually increase your awareness of the capabilities of the .NET CLR.
We will show you half a dozen how-to's for querying external system objects like event logs and performance counters.
We will continue with ways to integrate these with SSRS, SSIS, and/or Windows Forms.
SessionID: 28572
CLR 101
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2
Speaker: Alex Tocitu
Title: CLR 101
Abstract:
This session will bring you up to speed on simple CLR SQL Server objects implementations.
We will show you how to organize your environment to work with VS2010 Express and up.
We will also show you how to organize your SQL Server Express and up, for hosting deployed CLR objects.
SessionID: 28677
Database Design for Developers
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session
Speaker: Andy Leonard
Title: Database Design for Developers
Abstract:
This session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs.
SessionID: 28679
SSIS Design Patterns
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1
Speaker: Andy Leonard
Title: SSIS Design Patterns
Abstract:
This session is for experienced SSIS developers. Attend and learn the Parent-Child SSIS design pattern, how to leverage less-than-well-documented characteristics of SSIS to centralize logging, and how to pass variable values between parent and child packages by value and by reference.
SessionID: 28712
Building a Professional Development Plan
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc
Speaker: Andy Warren
Title: Building a Professional Development Plan
Abstract:
A good professional development plan has to go far beyond ‘learning more technology’, it has to encompass the wide variety of skills you need to build the next step in your career, and it has to include a variety of learning methods. We’ll discuss how much time and money you should budget when building your plan, and how the distribution of time and money changes as your career evolves. We’ll look at the growth phases you’ll encounter, learning how you learn best, how to keep up with new technology without burning out, and even how things like blogging and Twitter can be an interesting part of your plan.
SessionID: 28723
DBA 101: The Basics
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Andy Warren
Title: DBA 101: The Basics
Abstract:
Are you an "accidental" or "unintentional" DBA? Or are you a manager or developer who wants to see more into the DBA world? If you're someone who has to wear a DBA hat or someone considering it, this presentation is for you. This presentation is a beginner session intending to show the basics every DBA needs to know to do the job.
SessionID: 28994
Consolidated SQL Server Architectures
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Ben DeBow
Title: Consolidated SQL Server Architectures
Abstract:
There is more than one way to approach a consolidation effort, and you must understand the pros and cons of each. Consolidate on physical hardware? Use virtualization? Multiple instance per server or VM? How will availability be achieved for a consolidated environment? These topics and more will be addressed in this session.
SessionID: 29117
Introduction To Column Level Encryption
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2
Speaker: Bob Langley
Title: Introduction To Column Level Encryption
Abstract:
SessionID: 29246
What's New In SSRS 2008 (With Added R2 Flair)
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1
Speaker: Brett Tomson
Title: What's New In SSRS 2008 (With Added R2 Flair)
Abstract:
SessionID: 29248
T-SQL Enhancements in SQL Server 2008
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1
Speaker: Brett Tomson
Title: T-SQL Enhancements in SQL Server 2008
Abstract:
The release of SQL Server 2008 represents a paradigm shift in the way that we program T-SQL. With new commands and new data types, 2008 provides the SQL developer with a bevy of options intended to make their development tasks easier. In this session, we will explore what enhancements have been made to T-SQL including (but not limited to) row constructors, the MERGE statement, table-valued parameters as well as what new data types are available to us.
SessionID: 29362
Cool Tricks to Pull from your SSIS Hat
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1
Speaker: Julie Smith
Title: Cool Tricks to Pull from your SSIS Hat
Abstract:
Cool Tricks to Pull from your SSIS Hat: Variables, For Each Loops, and the SSIS Expression Language. This presentation will cover some useful SSIS features commonly used to add flexibility and elegance to more advanced ETL solutions. The presentation demonstrates short case studies of real world business scenarios and solutions.
SessionID: 29446
How, where, why, and when to use Dynamic SQL
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1
Speaker: Tim Chapman
Title: How, where, why, and when to use Dynamic SQL
Abstract:
SessionID: 29524
Introduction to Transactional Replication
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Chris Skorlinski
Title: Introduction to Transactional Replication
Abstract:
SQL Server Replication allows you to distribute your data across multiple servers in support of a Disaster Recovery strategy or to offload data to a Reporting server. This sessions provides an overview of design and planning needed to successfully implement Transactional Replication topology in your organization.
SessionID: 29526
Top 5 fastest ways as DBA to get fired
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc
Speaker: Chris Skorlinski
Title: Top 5 fastest ways as DBA to get fired
Abstract:
Are you new to DBA role, but would rather be a programmer? Have you been a DBA for a while but want a life changing event? Then this session is for you. I'll cover the top 5 things you as a DBA can do to get fired. If instead you want to keep your job as a DBA, attend to see what others are doing in order to get fired and open for you a job opportunity.
SessionID: 30028
To click or to type, that is the question.
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: David Taylor
Title: To click or to type, that is the question.
Abstract:
Are you a clicker or a typer? This session explores the use of scripting vs. using the GUI in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed.
SessionID: 30038
Windows PowerShell Best Practices for SQL DBA's
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session
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: 30050
Object Relational Mappers for the DBA
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc
Speaker: Eric Humphrey
Title: Object Relational Mappers for the DBA
Abstract:
SessionID: 30051
Things To Do With PowerShell SMO
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2
Speaker: Eric Humphrey
Title: Things To Do With PowerShell SMO
Abstract:
Want to automatically store your database schema in a version control system (VCS)? Want to make changes across your database or server with less labor? Learn how with PowerShell and SMO. Bonus: compress your backups using 7zip and PowerShell.
SessionID: 30109
Diagnosing connectivity issues with SQL Server
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Evan Basalik
Title: Diagnosing connectivity issues with SQL Server
Abstract:
Evan will show you how to diagnose and solve common connectivity issues. This will include covering GNEs, Kerberos, and completely inaccessible SQL Servers. He will demonstrate how to use UDLs and network traces to easily identify the problem, plus provide tips that often solve the problem in seconds.
SessionID: 30110
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1
Speaker: Evan Basalik
Abstract:
SessionID: 30225
Clustering for Mere Mortals
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Geoff Hiten
Title: Clustering for Mere Mortals
Abstract:
Learn about the major changes in clustering in recent SQL and Windows releases and how clustering is something you can implement that will actually make your work life easier.
SessionID: 30226
Bad SQL
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session
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: 30428
Tuna Helper - Proven Process for Tuning SQL
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Janis Griffin
Title: Tuna Helper - Proven Process for Tuning SQL
Abstract:
SQL statements. However, many tuning projects fail because the
process being used is inefficient. This presentation will walk through a
process Confio Software uses with great success and will include topics
such as indexing strategies, use of column statistics, SQL wait event data,
column selectivity and several more that will help the you succeed on
future tuning projects.
SessionID: 30429
SQL Server Service Broker – An Overview
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1
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. Finally a case study 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: 30602
Get Cert! Get Cred!
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc
Speaker: Jose Chinchilla
Title: Get Cert! Get Cred!
Abstract:
Obtaining a certification may be a dreaded and stressing process for some people. Most people fail because of their failure to plan a realistic roadmap towards their goals and not necessarily because they lack the skills.
This session will focus on establishing a roadmap towards certification success for the MCTS and MCITP programs of SQL Server and Business Intelligence. I will do a quick overview of my recent success obtaining 4 certifications in 30 days and how you can achieve similar goals.
But why certify? Join me to find out the opportunities you may be missing on!
SessionID: 30605
Business Intelligence: Decaffeinated Please!
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2
Speaker: Jose Chinchilla
Title: Business Intelligence: Decaffeinated Please!
Abstract:
For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at risk of failure. In this session I will go over some of the basic concepts that are key in understanding BI and DW. I will also go over the natural roadmap towards BI success, its maturity stages and some of the factors that influence a successful BI project. I will exemplify all these concepts by showcasing a successful real-world BI and DW solution.
SessionID: 30796
Make Reporting Services Work For You
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1
Speaker: Jessica Moss
Title: Make Reporting Services Work For You
Abstract:
SessionID: 30797
Who Needs a Data Warehouse?
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1
Speaker: Jessica Moss
Title: Who Needs a Data Warehouse?
Abstract:
The decision to incorporate a data warehouse into your company’s daily routine is not an easy process. This interactive session will discuss the benefits and disadvantages of having a data warehouse. As a group, we will present reporting and structural alternatives, as well as the pros and cons of building, maintaining, and using a data warehouse.
SessionID: 30929
Creating Custom Components for SSIS
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2
Speaker: John Welch
Title: Creating Custom Components for SSIS
Abstract:
SessionID: 30930
Processing Flat Files with SSIS
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2
Speaker: John Welch
Title: Processing Flat Files with SSIS
Abstract:
SessionID: 31601
Going Spatial
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1
Speaker: Matthew Campbell
Title: Going Spatial
Abstract:
SessionID: 31703
Parameter Sniffing
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session
Speaker: Alejandro Mesa
Title: Parameter Sniffing
Abstract:
Is your stored procedure, prepared statement, or ad-hoc query taking to long after a good start?
Learn what is parameter sniffing, how it could affect your query response time, and what can we do when it doesn't help. In this session we will learn about recompiling, OPTION clause, and plan guides.
SessionID: 32503
Planning your ETL architecture with SSIS
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc
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: 32504
Managing Database Schemas With VS201 DB projects
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 2
Speaker: Rafael Salas
Title: Managing Database Schemas With VS201 DB projects
Abstract:
Most developers agree that the database is the most important component in a typical application, yet the processes for managing changes to database objects as part of the development cycle are often rudimentary or inexistent.
In this session Rafael explains how you can use Visual Studio database projects to have better control over your database development cycle and reduce the risk and complexity involved in managing schema changes, testing and deployment. He will talk about the pros and cons he has experienced when using VS DB projects in his last projects, and will highlight some of the improvements available in the latest version of the tool.
This session showcases VS 2010, but most the content remains relevant for VSDB2008 GDR2
SessionID: 32767
Data Files and Transaction Logs -- beyond the GUIs
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 1
Speaker: Sandra Mueller
Title: Data Files and Transaction Logs -- beyond the GUIs
Abstract:
SessionID: 32768
OLTP (yes!) Databases and Cube Design
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2
Speaker: Sandra Mueller
Title: OLTP (yes!) Databases and Cube Design
Abstract:
SessionID: 32894
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Large Session
Speaker: Sergey Pustovit
Abstract:
SessionID: 32895
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Admin 2
Speaker: Sergey Pustovit
Abstract:
SessionID: 33097
Data Mining with PowerPivot 2010
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2
Speaker: Mark Tabladillo
Title: Data Mining with PowerPivot 2010
Abstract:
Excel provides a compelling and ubiquitous interface for Microsoft Data Mining. With new features available through PowerPivot, business users can apply the technology through a well-designed infrastructure of Microsoft technologies. This presentation will welcome any newcomers to data mining, and provide interactive demos which highlight data mining through these technologies.
SessionID: 33242
Confessions of a Data Integrator: Bad Designs
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2
Speaker: Stuart Ainsworth
Title: Confessions of a Data Integrator: Bad Designs
Abstract:
SessionID: 33243
You Got XML In My Database? What's Up With That?
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: DB Dev 1
Speaker: Stuart Ainsworth
Title: You Got XML In My Database? What's Up With That?
Abstract:
SessionID: 33863
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 1
Speaker: Wayne Snyder
Abstract:
SessionID: 33923
Getting Started with MDX
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: BI 2
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
SessionID: 33924
Attribute Discretization in Analysis Services
Event Date: 02-10-2010 - Session time: 00:00:00 - Track: Misc
Speaker: William E Pearson III
Title: Attribute Discretization in Analysis Services
Abstract: