Nr: 51
SQLSaturday #51 - Nashville 2010
SessionID: 28405
The Dirty Dozen: PowerShell Scripts for Busy DBAs
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Administration
Speaker: Aaron Nelson
Title: The Dirty Dozen: PowerShell Scripts for Busy DBAs
Abstract:
SessionID: 28588
SQL Server 2008 R2 Utility and Data-tier Apps
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Session Mix
Speaker: Alan Brewer
Title: SQL Server 2008 R2 Utility and Data-tier Apps
Abstract:
SQL Server 2008 R2 introduced two new features that improve your ability to manage Database Engine instances. The SQL Server Utility makes it easier to find, consolidate, and manage many instances. Data-tier applications are new units for designing, deploying, and managing databases. Learn how the utility and DACs work together to make it easier for you to track and manage your instances and databases.
SessionID: 28674
Database Design for Developers
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Session Mix
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: 28714
Introduction to SQL Server Statistics
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Session Mix
Speaker: Andy Warren
Title: Introduction to SQL Server Statistics
Abstract:
SessionID: 28715
Building a Professional Development Plan
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Professional Development
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: 28773
Data Mining in Action: A case study
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Professional Development
Speaker: ANDREW MINKIN
Title: Data Mining in Action: A case study
Abstract:
This session will focus on using real world data ( no Adventureworks) taken through the life cycle of a data mining application. Topics will include the details of data mining methodology fine tuyning mining models and validating discoveries
SessionID: 28825
Monitoring Data Changes with Change Data Capture
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Administration
Speaker: Arie Jones
Title: Monitoring Data Changes with Change Data Capture
Abstract:
Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment.
SessionID: 28910
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Administration
Speaker: Allen White
Abstract:
SessionID: 28912
XQuery Basics
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Development
Speaker: Allen White
Title: XQuery Basics
Abstract:
With the introduction of the XML data type in SQL Server 2005 a new level of flexibility has been introduced to relational database environments to support loosely structured data. To get that data back requires an understanding of XQuery, the powerful query language written for XML specifically. This session will cover the basics of XQuery and help you get up to speed on this new environment.
SessionID: 28972
Introduction to MDX for SQL Programmers
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Barry Ralston
Title: Introduction to MDX for SQL Programmers
Abstract:
SessionID: 29375
From Access To SQL Server
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Development
Speaker: Jack Cannon
Title: From Access To SQL Server
Abstract:
SessionID: 29977
Realizing ROI for Business Intelligence Projects
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Douglas McDowell
Title: Realizing ROI for Business Intelligence Projects
Abstract:
Business Intelligence (BI) is IT that IT should never pay for; it should always be aligned and driven by the business. Statistics for failed data warehousing and BI projects are discouraging, but you can prevent this in your organization. In this session we cover how to assess and agree on realistic return on investment (ROI) calculations before, during and after a BI project in addition to other critical considerations that will assure your BI project remains focused on the needs for all stakeholders.
SessionID: 30003
Keynote
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Cafeteria
Speaker: Louis Davidson
Title: Keynote
Abstract:
TBA
SessionID: 30004
Stump the "Experts"
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Cafeteria
Speaker: Louis Davidson
Title: Stump the "Experts"
Abstract:
A group of "experts" will attempt to answer your burning questions about SQL Server, or pretty much anything you want to ask.
SessionID: 30248
DMV Emergency Room!
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Session Mix
Speaker: Glenn Berry
Title: DMV Emergency Room!
Abstract:
SessionID: 30321
Working with Spatial Data in SQL Server 2008
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Development
Speaker: Hope Foley
Title: Working with Spatial Data in SQL Server 2008
Abstract:
Spatial data is being pushed more and more into the forefront of our application universe. With the advent of MapPoint and Google Maps companies are consistently pushing the boundaries of what traditional databases can do. Now with SQL Server 2008 we have built in spatial data types that will make your life a little easier in the days to come. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data so that you can become the spatial data pro in your organization.
SessionID: 30523
Are You Following Your Own Best Practices?
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Administration
Speaker: Jason Strate
Title: Are You Following Your Own Best Practices?
Abstract:
SessionID: 30746
Taking Control of Your Career
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Professional Development
Speaker: Jeremiah Peschka
Title: Taking Control of Your Career
Abstract:
Raises, promotions, and job offers don't happen by accident; you need a plan. Through careful planning you can create and reach impressive goals. But what's the point of reaching your goals if nobody notices? "If you build it, they will come" doesn't apply when you're building your career.
SessionID: 30747
Fundamentals of SQL Server Internals
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Session Mix
Speaker: Jeremiah Peschka
Title: Fundamentals of SQL Server Internals
Abstract:
Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
SessionID: 30804
Make Reporting Services Work For You
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Jessica Moss
Title: Make Reporting Services Work For You
Abstract:
SessionID: 30931
Creating Custom Components for SSIS
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Professional Development
Speaker: John Welch
Title: Creating Custom Components for SSIS
Abstract:
SessionID: 31239
Fortress SQL Server
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Session Mix
Speaker: Brian Kelley
Title: Fortress SQL Server
Abstract:
SessionID: 31282
Take the Awesomeness Home: the Data Collector
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Administration
Speaker: Kendra Little
Title: Take the Awesomeness Home: the Data Collector
Abstract:
SessionID: 32457
Data Dude - Making DB developers more productive
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Development
Speaker: Robert Cain
Title: Data Dude - Making DB developers more productive
Abstract:
Whether you are a dedicated database developer, or a DBA/.Net Developer for whom database development is a secondary job, Visual Studio Database Developer edition, aka "Data Dude" can be a boon to you. In this session we'll start by reverse engineering an existing database into complete scripts to create the tables, indexes, stored procedures, and more. Deployment strategies will be covered, as well as refactoring and unit testing. Finally we'll look at the powerful data generation capabilities built into "Data Dude".
SessionID: 33000
Analysis Services 2008 End-to-End
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Craig Utley
Title: Analysis Services 2008 End-to-End
Abstract:
SessionID: 33065
DBA Survivor
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Cafeteria
Speaker: Thomas LaRock
Title: DBA Survivor
Abstract:
Congratulations! You have accepted a position as a Database Administrator. What's that? Oh, you were told that you were going to be the new DBA? No worries, I am certain you were carefully selected to be the best…of the best…of the best. Now that you have the job, what's next? What is your action plan? What do you take care of first? And how much more will you get paid?
SessionID: 33066
What Are You Waiting For?
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Administration
Speaker: Thomas LaRock
Title: What Are You Waiting For?
Abstract:
SessionID: 33098
Data Mining with PowerPivot 2010
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Professional Development
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: 33239
The Social DBA: Resources for Career Building
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Professional Development
Speaker: Stuart Ainsworth
Title: The Social DBA: Resources for Career Building
Abstract:
SessionID: 33545
Common TSQL Mistakes
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Development
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
As a long-term relational engine consultant, I have seen just about everything. Here is a colleciton of many of the most commonly found problems. We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented.
SessionID: 33862
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Wayne Snyder
Abstract:
SessionID: 33899
Design and Implement Like Edison!
Event Date: 21-08-2010 - Session time: 00:00:00 - Track: Database Development
Speaker: William E. Pearson III
Title: Design and Implement Like Edison!
Abstract:
As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence solutions.