Nr: 57
SQLSaturday #57 - Houston 2011
SessionID: 28488
Understanding Storage Systems and SQL Server
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Wesley Brown
Title: Understanding Storage Systems and SQL Server
Abstract:
SessionID: 28771
Data Mining in Action: A case study
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 5
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: 29198
Keeping up with the JOINes
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: Brian Dudley
Title: Keeping up with the JOINes
Abstract:
Very few queries can be written without an Inner Join, but Full Outer Joins and few and far between. This session will cover the less common join scenarios through slides and code samples. Learn to use the data model and requirements to recognize the join type. Come away with the confidence to give examples and incorporate the new material in your own queries.
SessionID: 29199
Power up the Charts -- Adding code to SSRS
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: Brian Dudley
Title: Power up the Charts -- Adding code to SSRS
Abstract:
SQL Server Reporting Services provides very robust graphing and charting components. However, there are times when the features are not enough. SSRS exposes the chart and data objects and allows additional manipulation with code. This session starts with the basics, giving hints for coding and debugging, then provides some great examples influenced by production projects.
SessionID: 29882
Best Practices for SQL Server on VMWare
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Dean Richards
Title: Best Practices for SQL Server on VMWare
Abstract:
This presentation will explore the fundamentals of running SQL Server in a VMWare environment. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks and cover best practices for maintaining optimum performance in the VM.
SessionID: 29938
Ask Why My Query So Slow?
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Jason Wong
Title: Ask Why My Query So Slow?
Abstract:
I will elaborate on the following topics in detail by presenting real-world code examples, why they are inefficient and what is the solution.
Configuration:
- RAM (Memory)
- RAID (IO)
- Concurrency –
• Dirty Read
• Phantom Read
• Non-repeatable Read
• Blocking
Code:
- inline function (and expression)
- select *
- compiled to incorrect plan
- recompile plan
- union (union all)
- missing join
- type implicit conversion
- unfiltered delete (truncate)
- like operator (and execution plan and index)
- missing, unused, redundant indexes
- query hint
- database version compatibility
- locking, blocking (isolation level)
- not in, in, exists, not exists
- schema naming convention
SessionID: 30057
So What Can I Do With PowerShell?
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Eric Humphrey
Title: So What Can I Do With PowerShell?
Abstract:
SessionID: 30087
Zero to cube in 1 hour
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Erin Welker
Title: Zero to cube in 1 hour
Abstract:
In this session, we'll walk through the steps for creating a multidimensional schema (star schema) for a subject area we're all familiar with, load the tables we create via SSIS, and build an SSAS cube to facilitate analytical analysis. The session is almost completely demo-driven, and will hopefully inspire you to go home and build your first BI solution to facilitate your own analysis.
SessionID: 30229
Clustering for Mere Mortals.
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Geoff Hiten
Title: Clustering for Mere Mortals.
Abstract:
Learn about clustering in current SQL Server and Windows Server releases. Failover Clustering is a fundamental step for any High Availability SQL implementation. Learn how Clustering works, what are the new requirements for Failover Clustering, and how you can make the most of this feature.
SessionID: 30230
Bad SQL
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 1
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: 30554
Putting the Development back in SharePoint Develop
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Jeremy Beckham
Title: Putting the Development back in SharePoint Develop
Abstract:
The goal of this session is to discuss how to structure and plan a Visual Studio solution for a SharePoint development project. I will discuss some of the coding patterns and practices that we at Envoc have found lead to a high quality product for our clients. We'll talk about how these patterns and practices allow us to bring a diverse skill set to our project teams due to the minimization of touch points with SharePoint and how automated integration tests help us troubleshoot deployment issues.
SessionID: 30702
T-SQL Code Sins: The Worst Things We Do to Code
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: Jennifer McCown
Title: T-SQL Code Sins: The Worst Things We Do to Code
Abstract:
It's impossible to follow every best practice all the time. "Code sins" are those things we do to our code that are either so horrendous that they can't be borne, or that have such tremendous consequences that your stored procedures wish they'd never been created. Attendees will hear about the most common code sins that make code difficult to read, support, run and extend, and practical strategies for reversing the trend.
SessionID: 30703
Women in Tech:Why are we still talking about this?
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Jennifer McCown
Title: Women in Tech:Why are we still talking about this?
Abstract:
If you find yourself rolling your eyes at another Women in Technology talk, then this panel session is DEFINITELY for you. WIT talks aren't exclusively for women, aren't time set aside for complaining about injustices. WIT talks ARE about finding new ways to make the exciting and lucrative IT field more accessible for our friends, and our children.
SessionID: 30997
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: John Cook
Abstract:
SessionID: 31106
SQL Server 2008 for Developers
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: John Sterrett
Title: SQL Server 2008 for Developers
Abstract:
Are you still on SQL Server 2005 and wonder what you are missing? Did you upgrade to SQL Server 2008 and haven’t had the time to check out the new features? In one hour you will see demos that give an overview of the new features for developers included with SQL Server 2008. This presentation will include Management Studio (SSMS) Enhancements, T-SQL enhancements, Table Value Parameters, Merge and more…
SessionID: 31107
Evaluate your daily checklist using CMS and PBM
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: John Sterrett
Title: Evaluate your daily checklist using CMS and PBM
Abstract:
You will walk away from this session with an understanding of how to use the Policy Based Management and Central Management Server to complete a daily checklist against your whole SQL Server farm. We will cover the basics to evaluate, monitor and apply best practice policies, which are included out of the box with SQL Server 2008. We will also make custom policies to cover additional best practices to evaluate daily checklist items. Finally, we will combine Policy-Based Management and Central Management Server with the Enterprise Policy Management Framework on codeplex to automate the monitoring process and create manager friendly reports to moni
SessionID: 32268
What's new in Reporting Services R2
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Patrick LeBlanc
Title: What's new in Reporting Services R2
Abstract:
In this session Patrick shows you the new features in Reporting Services R2. You will learn how to use the Map control, Sparkline, Indicator, and Data Bars. See the new report builder 3.0. Learn about shared Data sets and report parts.
SessionID: 32269
SSIS: Configuring, Deploying and a Little Tuning
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Patrick LeBlanc
Title: SSIS: Configuring, Deploying and a Little Tuning
Abstract:
SessionID: 32375
Visual Studio 2010 Database Projects
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Randy Knight
Title: Visual Studio 2010 Database Projects
Abstract:
Managing DDL scripts has always been one of the biggest challenges facing Database Developers. How do you keep your Development, Test, Stage, and Production Environments in sync? Why aren't databases tightly integrated into source control systems like application code is? Visual Studio 2010 Database projects solve all these problems and more. In this session, we will learn how to use Visual Studio to treat database objects as the first-class citizens they have always been.
SessionID: 32593
Microsoft Entity Framework 4.0 for DBAs
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 4
Speaker: Rob Vettor
Title: Microsoft Entity Framework 4.0 for DBAs
Abstract:
Recently, Microsoft released the Entity Framework and is now recommending development teams implement it in their applications to bridge data and objects.
Come and better understand the Entity Framework, as we …
• Explore Entity Framework 4.0 and show how it works
• Demonstrate various ways to build and maintain Entity Data Models and mappings
• Walk through examples that interact with the model, including LINQ, Entity SQL and Stored Procedures
• Explore its on permissions, connections, transactions, performance, security and concurrency
SessionID: 32620
DBA Repository Update 2010 Using SSIS and SSRS
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Rodney Landrum
Title: DBA Repository Update 2010 Using SSIS and SSRS
Abstract:
SessionID: 32709
Stored procedure tracing using the xml datatype
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Russel Loski
Title: Stored procedure tracing using the xml datatype
Abstract:
When running a stored procedure it is difficult to record what is happening. In this session we will develop logger code in T-SQL to add to your stored procedures. We will use the xml datatype to record parameter values, variable values and debug statements. We will look at the "For xml" statement as well as the xml datatype methods, especially the modify method. Finally we will look at how to read the logs when finished.
SessionID: 32732
Mirroring: The Bear Necessities
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Ryan Adams
Title: Mirroring: The Bear Necessities
Abstract:
SessionID: 32733
Manage Your Shop with CMS and Policy Based Managem
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Ryan Adams
Title: Manage Your Shop with CMS and Policy Based Managem
Abstract:
In this presentation we talk about Central Management Server and how it can help you manage a disperse
environment. We will also cover what Policy Based Management is and how you can leverage its power to
better manage your environment. With PBM we'll see what it can and cannot do to help you enforce
standards in your enterprise. We will cover and demonstrate PBM for the beginner from creating and
evaluating policies to receiving alerts on policy violations.
SessionID: 32848
Beginning Powershell for DBAs 1.0
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Sean McCown
Title: Beginning Powershell for DBAs 1.0
Abstract:
The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.
SessionID: 32849
Beginning Powershell for DBAs 1.5
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Sean McCown
Title: Beginning Powershell for DBAs 1.5
Abstract:
If you were in the 1.0 session you’ll love this one. In this session we’re going to pick up where we left off and really get into some real SQL Server admin tasks. We’ll start with some more advanced basics to enhance your knowledge of powershell, and then apply them directly to SQL Server. By the end of this session you won’t be an expert, but my goal is to make you competent enough to be able to understand blogs and articles about powershell.
SessionID: 32850
It’s not called Wussyshell
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Sean McCown
Title: It’s not called Wussyshell
Abstract:
Powershell is the enterprise DBAs best friend. It’s the only way to get your environment completely under control with very little effort. You can easily build templates that extend what you’ve already got and you can use them to bring hundreds, or even thousands of servers into compliance with next to no effort. Learn how to manage a very large environment with powershell from a DBA who does it every day. Here you’ll learn how to build a system of templates that you can use to manage all levels of configuration and alerting. You’ll learn how to gather and alert on almost every aspect of your server as well as manage and standardize them.
SessionID: 32851
Deploying SSIS packages with Powershell
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Sean McCown
Title: Deploying SSIS packages with Powershell
Abstract:
Managing SSIS packages in large environments can be a real challenge in large shops. This session will show you how to deploy, transfer, monitor, standardize, and automate your SSIS package environment using Powershell. You’ll learn how to keep many data marts in perfect synch, deploy packages to multiple servers, consolidate packages to a single server, enforce naming and security standards, and much more.
SessionID: 33369
SQL Azure and Me!
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Anthony {Tex} Moreign
Title: SQL Azure and Me!
Abstract:
» How can “I/Me/My” get started with Microsoft Azure offerings.
» Starts with a lap around the various offering of Microsoft Azure – then focuses on SQL Azure, in particular.
» This is meant to be a beginners overview – with links to more info.
SessionID: 33516
Parallel Query Execution Deep Dive
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Boles
Title: Parallel Query Execution Deep Dive
Abstract:
What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
SessionID: 33519
Advanced TSQL Solutions
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Boles
Title: Advanced TSQL Solutions
Abstract:
SessionID: 33561
Execution Plan Basics
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Thomas LeBlanc
Title: Execution Plan Basics
Abstract:
This will be a Beginner to Intermediate session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window?
SessionID: 33562
Transition from DBA to BI Architect
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Thomas LeBlanc
Title: Transition from DBA to BI Architect
Abstract:
SessionID: 33593
Dynamic SSIS with Expressions and Configurations
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Tim Mitchell
Title: Dynamic SSIS with Expressions and Configurations
Abstract:
Never hard-code a connection string or file path again! In this session, we'll look at several ways to introduce dynamic logic into your packages by way of the SSIS expression language, package configurations, and variables. Learn how to reuse tasks, components, and containers by replacing static settings with dynamic and flexible properties.
SessionID: 33640
Tableau: Delivering Self-Serve BI
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 5
Speaker: Tim Costello
Title: Tableau: Delivering Self-Serve BI
Abstract:
Description: rapid-fire visual analysis. ad hoc query capability.
easy interactive dashboard building. No, this insn't going to be an
hour of buzzword bingo. This time we will actually deliver on the
promise of self service BI. Using SQL in conjunction with a visual
analysis tool like Tableau we can help our users find the questions
they didn't know they wanted to answer. This session will be demo
heavy and will highlight best practices in data visualization and
dashboard design.
SessionID: 33693
Compliance, Auditing and Encryption in Sql Server
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 6
Speaker: Thomas Norman
Title: Compliance, Auditing and Encryption in Sql Server
Abstract:
I have this database which must meet all of these governmental regulations. Just like the government to make life a lot harder but wait, now they say I most also meet International regulations. Can this be true? Why me? Let's look at what we can do to help us pass audits and comply with the laws around us. We will explore the features in SQL Server 2008 which help us.
SessionID: 33737
A PowerShell Cookbook for DBAs
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 7
Speaker: Trevor Barkhouse
Title: A PowerShell Cookbook for DBAs
Abstract:
This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of "recipes," stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008/2008R2. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.
SessionID: 33739
Deadlock Detection, Troubleshooting, Prevention
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 1
Speaker: Trevor Barkhouse
Title: Deadlock Detection, Troubleshooting, Prevention
Abstract:
SessionID: 33934
Documenting Your Integrated Microsoft BI Solution
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: William E Pearson III
Title: Documenting Your Integrated Microsoft BI Solution
Abstract:
Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document. In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.”
SessionID: 33936
Getting Started with MDX
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 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: 34495
SQL Server DMV Overview
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 3
Speaker: William Assaf
Title: SQL Server DMV Overview
Abstract:
SessionID: 34534
Zen Coding
Event Date: 29-01-2011 - Session time: 00:00:00 - Track: Track 2
Speaker: Brian Rigsby
Title: Zen Coding
Abstract:
Learn the philosophy, mindset, and attitude of a professional, principled, disciplined software developer.