Nr: 41
SQLSaturday #41 - Atlanta 2010
SessionID: 28393
PowerShell for the Data Professional
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Buckhead
Speaker: Aaron Nelson
Title: PowerShell for the Data Professional
Abstract:
SessionID: 28394
Virtualize This!
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Chastain Park
Speaker: Aaron Nelson
Title: Virtualize This!
Abstract:
With the list of features of SQL Server growing constantly the need to sandbox and test drive features in a separate environment that can communicate with but not interfere with your existing environment has become vital. With virtualization, setting up consistent test, dev, and even sandbox environments can happen in minutes instead of hours AND be consistent with previous/ existing environments. In this session we will focus on Microsoft Virtualization solutions that you can leverage starting with your desktop/laptop and extending to your server environments. Even if you aren’t going to be doing the virtualization yourself it’s good to know what your options are.
SessionID: 28745
Full Text Searching - A Guide for DBAs Devs
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Grant
Speaker: Robert Cain
Title: Full Text Searching - A Guide for DBAs Devs
Abstract:
Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server.
SessionID: 28746
Introduction to Data Warehousing / BI
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Grant
Speaker: Robert Cain
Title: Introduction to Data Warehousing / BI
Abstract:
SessionID: 28747
Off and Running with PowerPivot for Excel 2010
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Highlands
Speaker: Robert Cain
Title: Off and Running with PowerPivot for Excel 2010
Abstract:
PowerPivot is an exciting new technology from Microsoft that will allow users to leverage their data to answer many of their business questions. Commonly referred to as "Self Service Business Intelligence", PowerPivot consists of two components, PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010. This presentation will provide an overview of both components then dig deeper into PowerPivot for Excel 2010. Multiple demos illustrate everything from importing data to creating pivot tables and charts, as well as using techniques such as filters and calculated columns.
SessionID: 28891
The Art and Science of Data Modeling
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Chastain Park
Speaker: Audrey Hammonds
Title: The Art and Science of Data Modeling
Abstract:
I had a teacher once who told me that creating a great data model is one part science and two parts art. Boy, was she ever right! This session will be a look at the fundamentals of creating data models to support your business, both transactional and dimensional (warehouses). While we're at it, we'll look at some more advanced concepts and how to model your way out of some tricky situations.
Topics include:
- Normalization is beautiful - now let's discuss it in plain English
- Raising a well-adjusted database - strategies for creating an adaptable model
- All Hail Kimball - dimensions, facts, star-schema, and everything in between
- Yo Olde Bag of Tricks - patterns and ideas for modeling your way out of sticky situation
SessionID: 29506
Introduction to Merge Replication
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Buckhead
Speaker: Chris Skorlinski
Title: Introduction to Merge Replication
Abstract:
SessionID: 29507
Introduction to Change Data Capture
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Buckhead
Speaker: Chris Skorlinski
Title: Introduction to Change Data Capture
Abstract:
This sessions provides a walk through of Microsoft's newest SQL Replication feature called Change Data Capture (CDC). Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of data changes. CDC is often used by data warehouse applications to retrieve list of SQL insert and updates for a given time window.
SessionID: 29509
QA with MS SQL Escalation
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Highlands
Speaker: Chris Skorlinski
Title: QA with MS SQL Escalation
Abstract:
Here is your chance to meet face-to-face is MS SQL Support. Meet Chris Skorlinski, member of Microsoft SQL Server Escalation Service Team for QA. Learn how MS Support approaches problem solving and look into some "behind the scenes" work it takes to provide answers to your challenging problems.
SessionID: 29601
Why I Use Stored Procedures and You Should Too!
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Piedmont Park
Speaker: Jack Corbett
Title: Why I Use Stored Procedures and You Should Too!
Abstract:
SessionID: 29695
Ad Hoc Visual Analysis
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Highlands
Speaker: Dan Murray
Title: Ad Hoc Visual Analysis
Abstract:
SessionID: 29705
De-mystifying Execution Plan Analysis
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Centennial Park
Speaker: Dave Turpin
Title: De-mystifying Execution Plan Analysis
Abstract:
Too often the query plan, or how the SQL Server engine actually implements the logical query, is ignored by developers and DBAs. The reason for not trying to dive into the meaning behind the hyro-glyphic plan is simple: It's not easy to understand what all those icons mean in isolation, never mind as a collection.
This session will bridge the gap between the theory of internals, where the details are mentioned but not demonstrated, and the logical query. A series of actual query examples will show how queries are treated by the optimizer and why; what to do to identify slow performing queries, and how to make simple adjustments to allow the query to perform significantly better.
SessionID: 29747
SQL Server 2008 R2 Overview - Session 1
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Centennial Park
Speaker: David Rodriguez
Title: SQL Server 2008 R2 Overview - Session 1
Abstract:
SQL Server 2008 R2 is the next release of SQL Server with many enhancements to the Base SQL Server 2008 product. This session will overview the significant features and enhancements in SQL Server 2008 R2.
SessionID: 29748
SQL Server 2008 R2- BI Drill Down Session 2
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Centennial Park
Speaker: David Rodriguez
Title: SQL Server 2008 R2- BI Drill Down Session 2
Abstract:
This session will introduce all BI enhancements in SQL Server 2008 R2.
SessionID: 29749
SQL Server 2008 R2- DBA Drill Down Session 3
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Centennial Park
Speaker: David Rodriguez
Title: SQL Server 2008 R2- DBA Drill Down Session 3
Abstract:
This session will introduce all enhancements in SQL Server 2008 R2 relevant to DBAs. These include improvements in manageability.
SessionID: 29994
Database Design Fundamentals
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Piedmont Park
Speaker: Louis Davidson
Title: Database Design Fundamentals
Abstract:
SessionID: 29995
Database Design Patterns
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Piedmont Park
Speaker: Louis Davidson
Title: Database Design Patterns
Abstract:
Beyond database design fundamentals (for example, Normalization) lies the area where you have to create "real" solutions. In this session, I will cover a good number of patterns that we commonly find useful to try to apply to the problem of building a database solution. Ideas like generalization, subclassing, single table domain tables, optional data, and more will be discussed, some of them good, some not so good (don't assume which will be which), but all that are common and/or useful for your database implementations.
SessionID: 30103
Diagnosing Connectivity Issues with SQL Server
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Midtown
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: 30104
SQL Azure: Data in the Cloud is a Good Thing
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Midtown
Speaker: Evan Basalik
Title: SQL Azure: Data in the Cloud is a Good Thing
Abstract:
Evan will talk about how SQL Azure works behind the scenes, plus demonstrate how to use the cloud-based sibling of SQL Server. He will also discuss how to best design your applications to take advantage of the power of SQL Azure.
SessionID: 30105
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Grant
Speaker: Evan Basalik
Abstract:
SessionID: 30224
Clustering for Mere Mortals
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Buckhead
Speaker: Geoff Hiten
Title: Clustering for Mere Mortals
Abstract:
failover Clustering is the fundamental technology for High Availability in the Microsoft SQL world. Windows 2008 and SQL 2008 make Clustering easier than ever.
SessionID: 30246
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Midtown
Speaker: Glen Gordon
Abstract:
SessionID: 30439
Tuna Helper for SQL Server DBA's
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Midtown
Speaker: Janis Griffin
Title: Tuna Helper for SQL Server DBA's
Abstract:
SessionID: 30440
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Highlands
Speaker: Janis Griffin
Abstract:
SessionID: 30685
T-SQL Code Sins
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Piedmont Park
Speaker: Jennifer McCown
Title: T-SQL Code Sins
Abstract:
SessionID: 30686
T-SQL Starter Kit
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Chastain Park
Speaker: Jennifer McCown
Title: T-SQL Starter Kit
Abstract:
An introductory T-SQL course for those just beginning to use SQL Server.
SessionID: 30881
Troubleshooting SQL with Event Notifications
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Highlands
Speaker: Jonathan Kehayias
Title: Troubleshooting SQL with Event Notifications
Abstract:
SessionID: 30882
Auditing User Activity 101
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Buckhead
Speaker: Jonathan Kehayias
Title: Auditing User Activity 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: 31264
Getting started in blogging and technical speaking
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Midtown
Speaker: Kendal Van Dyke
Title: Getting started in blogging and technical speaking
Abstract:
Are you thinking of starting a blog? Or are you interested in presenting at events like SQL Saturday but not sure what to do to get started? This panel style session with established SQL bloggers will give you tips on blogging platforms, choosing topics, techniques for giving presentations, and sage advice from years of experience.
SessionID: 31265
The (Solid) State Of Drive Technology
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Midtown
Speaker: Kendal Van Dyke
Title: The (Solid) State Of Drive Technology
Abstract:
Solid State Drives are being heralded as game changers in the world of SQL IO. What was once was a costly technology only available to those with deep pockets is now becoming affordable for mainstream use. This session look at how SSDs work, how they perform compared to traditional hard drives, and highlight the things you need to consider when implementing SSDs on your SQL Servers. Be sure not to miss a live demonstration of solid state technology in action!
SessionID: 31266
Configuring SQL Access for the Web Developer
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Buckhead
Speaker: Kendal Van Dyke
Title: Configuring SQL Access for the Web Developer
Abstract:
Session Goals:
- Learn when to use SQL logins and when to use Windows Authentication
- Understand the concept of impersonation
- Learn how ASP and ASP.NET applications can be configured to use impersonation to make secure connections to SQL Server
- Learn how to configure IIS 5, 6, 7 and Windows XP, 2003, and 2008 to support impersonation
SessionID: 31453
RESTful Data
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Chastain Park
Speaker: Chris Eargle
Title: RESTful Data
Abstract:
REST is an architectural style that allows for a layered, scalable, and cacheable enterprise information system. With WCF Data Services, a database can be surfaced to a service as a REST-style resource collection that is addressable with natural URIs and can be interacted with using the usual HTTP verbs: GET, POST, PUT, and DELETE. This session will describe OData (the Open Data Protocol), the benefits it conveys, and its uses. Then we will set up a data service using an existing database that developers would then access rather than accessing the database directly.
SessionID: 31899
Loading Data In Real Time
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Highlands
Speaker: Michael Femenella
Title: Loading Data In Real Time
Abstract:
SessionID: 31900
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Centennial Park
Speaker: Michael Femenella
Abstract:
Everything I wish someone had told me when I started with SQL Server years ago. An overview of using profiler to capture events Clustered, non clustered, covering indexes, looking at query plans (rid lookup, key lookup, scans vs seeks) When to use a table variable vs temp table
SessionID: 31934
When GEO meets SQL: Hotwiring Data to Locations
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Chastain Park
Speaker: Michael Clifford
Title: When GEO meets SQL: Hotwiring Data to Locations
Abstract:
SessionID: 32022
Work/Life Balance? Just A Myth?
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Midtown
Speaker: Meredith Ryan-Smith
Title: Work/Life Balance? Just A Myth?
Abstract:
Many of us started our IT careers in the exact same way: 80-hour work weeks, routine overnight gigs, no life outside the office—this was simply what we considered “normal.” Today, with our careers underway, how do we build a life outside of our IT world? We will share the tips, tricks and tools we’ve discovered and used to create a work/life balance that allows us to feel fulfilled and refreshed outside the office while maintaining our effectiveness as successful data professionals.
SessionID: 32134
Introduction to Transactional Replication
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Chastain Park
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: 32463
Can you control your reports?
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Grant
Speaker: Ryan Duclos
Title: Can you control your reports?
Abstract:
SessionID: 32464
Common Table Expressions
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Chastain Park
Speaker: Ryan Duclos
Title: Common Table Expressions
Abstract:
Do you need recursive queries, do you want your T-SQL to be easier to read and maintain?
SessionID: 33035
Scale Out the DBA (Enterprise Policy Management)
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Buckhead
Speaker: Geoff Hiten
Title: Scale Out the DBA (Enterprise Policy Management)
Abstract:
Policy-Based Management, Central Management Server, Enterprise Policy Management Framework, and Powershell combine to allow automation of DBA tasks more than ever before. Put these pieces together to do more with less.
SessionID: 33266
Data Warehouse Assessments - What,Why, and How
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Grant
Speaker: Noah Subrin
Title: Data Warehouse Assessments - What,Why, and How
Abstract:
Have you been asked to deliver a data warehouse project? Do you need to provide access to Production data to end users? Do you see a need (or opportunity) to position data warehousing as a core technology?
If you answered yes to any of these questions, a data warehouse assessment will help you increase your chances of success. This session will discuss what factors typically make up a data warehouse assessment, as well as the opportunities and challenges that are presented.
SessionID: 33359
Introduction to Data Mining
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Grant
Speaker: Tejas Patel
Title: Introduction to Data Mining
Abstract:
Session is intended to exhibit beginners, how to use data mining capabilities of SQL server.
SessionID: 33361
What is Microsoft StreamInsight?
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 2 Highlands
Speaker: Tejas Patel
Title: What is Microsoft StreamInsight?
Abstract:
Intent of this session is to capabilities and functionalities of Streaminsight.
SessionID: 33503
SQL Server Memory Deep Dive
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Centennial Park
Speaker: Kevin Boles
Title: SQL Server Memory Deep Dive
Abstract:
SessionID: 33510
Common TSQL Programming Mistakes
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Piedmont Park
Speaker: Kevin Boles
Title: Common TSQL Programming Mistakes
Abstract:
We are going to examine a variety of oopsies MANY developers fall prey too, some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented.
SessionID: 33511
Advanced TSQL Solutions
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Piedmont Park
Speaker: Kevin Boles
Title: Advanced TSQL Solutions
Abstract:
SessionID: 34487
Solving Real World Problems With DMVs
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Piedmont Park
Speaker: Whitney Weaver
Title: Solving Real World Problems With DMVs
Abstract:
Come join Whitney Weaver as we run through scenarios where DMVs can improve the quality of your life.
This will be a code heavy session with lots of takeaways!
SessionID: 34488
A Lap Around SQL Server 2008 Master Data Services
Event Date: 24-04-2010 - Session time: 00:00:00 - Track: 1 Centennial Park
Speaker: Whitney Weaver
Title: A Lap Around SQL Server 2008 Master Data Services
Abstract:
If the words "regulatory compliance", "data governance', or "merger and acquisition" are voiced at your company you know the importance of keeping accurate master data. We have been given a new feature to help manage this in SQL Server 2008 R2, Master Data Services.
Come join Whitney Weaver as we explore the business application of this feature.