Nr: 52
SQLSaturday #52 - Colorado 2010
SessionID: 28774
Data Mining in Action: a Case Study
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: BI
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 methodology an introduction to details of DMX, managing output and validating discoveries
SessionID: 29348
Putting Traces SQL Profiler To Work
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev
Speaker: Brandon Tucker
Title: Putting Traces SQL Profiler To Work
Abstract:
SessionID: 29349
SSIS + DBAs = ?
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: PD/DBA
Speaker: Brandon Tucker
Title: SSIS + DBAs = ?
Abstract:
SessionID: 29399
Real-time Data Integration Architecture
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev/BI
Speaker: Carlos Bossy
Title: Real-time Data Integration Architecture
Abstract:
SessionID: 29400
Essentials of a Business Intelligence Architecture
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: BI
Speaker: Carlos Bossy
Title: Essentials of a Business Intelligence Architecture
Abstract:
SessionID: 29482
Managing a 0 Downtime Shop
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA
Speaker: Chris Shaw
Title: Managing a 0 Downtime Shop
Abstract:
Data is becoming more and more critical with the needs of business every day. Technology has enabled businesses to have a global reach much easier than ever before. With the growing needs to increase revenue every avenue will be explored. The outcome of this growth is the need for your database to be online with no downtime if any at all. This session is designed to visit the issues of managing a database that is online around the clock and maintenance time is scarce. We will talk about the challenges you could face each and every day, the maintenance issues such as when, where and how to trim it.
SessionID: 29606
Introduction to Triggers
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev/BI
Speaker: Jack Corbett
Title: Introduction to Triggers
Abstract:
This session will give a brief overview of the different types of triggers available in SQL Server (DDL DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers shoul d and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes.
After attending this session a person will:
- Identify different types of triggers and when to use them.
- Be able to identify when a trigger is the right solution
- Be able to write triggers that perform well
SessionID: 29607
Why I Use Stored Procedures
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev
Speaker: Jack Corbett
Title: Why I Use Stored Procedures
Abstract:
SessionID: 29884
Query Tuning - Get it Right the First Time
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA
Speaker: Dean Richards
Title: Query Tuning - Get it Right the First Time
Abstract:
Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query
every time by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement or
database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct
tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 30250
Dr. DMV: How to Use Dynamic Management Views to Mo
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Glenn Berry
Title: Dr. DMV: How to Use Dynamic Management Views to Mo
Abstract:
SessionID: 30252
Getting Started With SQL Azure
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev
Speaker: Glenn Berry
Title: Getting Started With SQL Azure
Abstract:
SQL Azure is Microsoft's solution for hosting basic SQL Server relational databases in the cloud. Microsoft continues to add new features in each Azure Service Update that makes SQL Azure a more viable solution. For smaller databases that don't require features such as Reporting Services, Analysis Services, or Full Text Search, it can be an easy to use technology that can save lots of money in hardware, license and maintenance costs. This session shows you how to configure, connect to, and manage a SQL Azure database, both from SQL Server Management Studio and from a .NET application, and it gives best practices and tips on how to get the most benefit from SQL Azure.
SessionID: 30426
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA
Speaker: Janis Griffin
Abstract:
SessionID: 30427
SQL Server Service Broker – An Overview
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev/BI
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: 30504
PowerShell for the Reluctant DBA / Developer
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA
Speaker: Jason Horner
Title: PowerShell for the Reluctant DBA / Developer
Abstract:
This presentation will provide a brief overview of how to get started with powershell and will be demo intensive.
Demo topics will include common challenges that database professional's face including: basic code generation, deployment automation, and database discovery. We will also attempt to touch on automation and general script development best practices.
SessionID: 30524
Extended Events, Work Smarter Not Harder
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA
Speaker: Jason Strate
Title: Extended Events, Work Smarter Not Harder
Abstract:
SessionID: 30526
Do SQL Server Certifications Really Matter?
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: PD/DBA
Speaker: Jason Strate
Title: Do SQL Server Certifications Really Matter?
Abstract:
Microsoft has a number of certifications for SQL Server. They cover the DBA, developer and business intelligence skills. But, does anyone take them seriously? In this session, see the tracks for SQL Server certifications and discover what you need to know about the exams. Which track will be right for you? What steps should you take? How do you get going? And what value will they bring to your career?
SessionID: 30695
T-SQL Brush-up:The Best Things You Forgot You Knew
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev
Speaker: Jennifer McCown
Title: T-SQL Brush-up:The Best Things You Forgot You Knew
Abstract:
You’re a good SQL professional – you attend conferences and webinars, you read articles and books, you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Come and revisit old favorites, and brush up on new T-SQL features and enhancements like MERGE, OVER, and PARTITION BY. This session is chock full of code examples, including before-and-after demos and how-to illustrations.
SessionID: 30697
T-SQL Code Sins
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev
Speaker: Jennifer McCown
Title: T-SQL Code Sins
Abstract:
SessionID: 30770
The importance of data strategy
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA
Speaker: Jeremy Lowell
Title: The importance of data strategy
Abstract:
Data is not a by-product of a new wiz-bang application. Databases are not just a container for the shiny new website. Databases do not exist simply to be managed. Data is the reason for creating the applications and the IT infrastructure to support it.
According to TDWI poor data quality costs businesses in excess of $6 billion per year. The cost of good data existing in multiple systems and business processes to work around or with poor or multiple copies of the same data is likely much higher.
This session will address the data in your environment instead of the container that it lives in. We will look at Master Data Services in SQL Server 2008 R2 and how it can help your organization rethink and help define your data strategy.
SessionID: 31334
Best practices for designing databases for perfo
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Kevin Cox
Title: Best practices for designing databases for perfo
Abstract:
SessionID: 31335
What is in SQL 2008 R2
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev
Speaker: Kevin Cox
Title: What is in SQL 2008 R2
Abstract:
This session covers the features in SQL 2008 R2, including PowerPivot, StreamInsight, Parallel Data Warehouse and more.
SessionID: 31543
Teaching SQL People to Speak Suit
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: PD/DBA
Speaker: Michelle Poolet
Title: Teaching SQL People to Speak Suit
Abstract:
SessionID: 31546
Introduction to Analysis Services
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: BI
Speaker: Marc Beacom
Title: Introduction to Analysis Services
Abstract:
By now you have probably already heard about Analysis Services. Maybe you've even said to yourself that you were going to learn more about it but just haven't found the time. The biggest barrier to learning something new is figuring out the first few steps. But where do you begin? Come learn those first few steps by attending this presentation. We will discuss what Analysis Services is, where it shines and more importantly, how to get started.
SessionID: 31779
Data Partitions for Optimization Retention
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: PD/DBA
Speaker: Michelle Poolet
Title: Data Partitions for Optimization Retention
Abstract:
Covering the What, Why, Who, Where, When How of partitioning data and databases, this lively, audience-interaction-based discussion of partitioning is sure to keep you on your toes and asking questions. From distributed database systems to schemes used to partition data tables, for both transactional databases and data warehouses, Ms. Poolet will lead the audience through the thought processes and steps needed to get a handle on your largest data stores.
SessionID: 32020
Work/Life Balance? Just A Myth?
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: PD/DBA
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? I will share the tips, tricks and tools I’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: 32672
Introduction to SSRS 2008
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: BI
Speaker: Rob Schafer
Title: Introduction to SSRS 2008
Abstract:
Most organizations in a SQL Server environment know about Report Services and are aware of its basic functionality. In this session, we will discuss authoring and deploying reports as well as managing and securing your Reporting Services 2008 environment. Attend this session to see how to get your reporting environment up and running efficiently and securely, and take a look at the added functionality and features in SSRS 2008.
SessionID: 32950
The Modern Resume: Building Your Brand
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: PD/DBA
Speaker: Steve Jones
Title: The Modern Resume: Building Your Brand
Abstract:
Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today's modern world, and take advantage of the tools offered by blogging, social networking, and more.
SessionID: 33210
Reporting Services 2008 R2 - Report Parts
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev/BI
Speaker: Steve Wake
Title: Reporting Services 2008 R2 - Report Parts
Abstract:
SQL Server 2008 R2 Reporting Services included a new feature that allows you to create a library of report parts that can be shared and used to create and update reports. In this session you will see demos of how to create these report parts, how to access the report parts library and how to include them in other reports.
SessionID: 33598
Exploring the SSIS API
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev/BI
Speaker: Tim Mitchell
Title: Exploring the SSIS API
Abstract:
SessionID: 33599
Building an ETL Framework with SSIS
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: BI
Speaker: Tim Mitchell
Title: Building an ETL Framework with SSIS
Abstract:
SessionID: 33689
Compliance, Auditing and Encryption in Sql Server
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Thomas Norman
Title: Compliance, Auditing and Encryption in Sql Server
Abstract:
I need to get this database in compliance. What do I do? We will take a look at several different features of Sql Server 2008 which will help you get the database to be able to pass audits. We will take a look at Transparent Data Encryption, Security, Auditing and Policy Based Management. Let's pass this audit.
SessionID: 33691
Policy Based Management
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Thomas Norman
Title: Policy Based Management
Abstract:
SessionID: 33756
SQL Encryption and You
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Todd Kleinhans
Title: SQL Encryption and You
Abstract:
When do you need your data encrypted? After providing a brief history and intro to encryption and cryptography, we will look at several ways to secure your SQL Server data and systems. Topics include: column level encryption, transparent data encryption (TDE), third party tools, and enterprise key management (EKM) using hardware security modules (HSM)s.
SessionID: 33787
Zero to "MERGE" in 60 Minutes
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: Dev/BI
Speaker: Troy Ketsdever
Title: Zero to "MERGE" in 60 Minutes
Abstract:
SQL Server 2008 saw the introduction of the new MERGE DML statement. In this session, we'll take a look at the basic syntax and capabilities of the command. Once we have reviewed some simple examples, we'll dive into some of the more advanced uses (abuses?) of the command, reinforcing our understanding by looking at more complex examples.
SessionID: 33788
So... You've Inherited "The DB From Heck"
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: DBA2
Speaker: Troy Ketsdever
Title: So... You've Inherited "The DB From Heck"
Abstract:
It's nice when, as database developers, we have a clean slate to work with. Most of the time, however, we inherit and must support existing designs and implementations. To add to the challenge, more often than not documentation of the database doesn't exist or is out-of-date with respect to the production system.
In this session, we'll look at some tools, techniques, and scripts that will accelerate your understanding of that beast you're now in charge of supporting and extending.
SessionID: 33915
Intro to MDX
Event Date: 25-09-2010 - Session time: 00:00:00 - Track: BI
Speaker: William E Pearson III
Title: Intro to 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.