Nr: 92
SQLSaturday #92 - Oregon 2011
SessionID: 28778
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Argenis Fernandez
Abstract:
SessionID: 28920
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Allen White
Abstract:
SessionID: 28922
Let Service Broker Help You Scale Your Application
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Allen White
Title: Let Service Broker Help You Scale Your Application
Abstract:
SessionID: 29028
Self-service BI with project 'Crescent'
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Benjamin Muller
Title: Self-service BI with project 'Crescent'
Abstract:
SessionID: 29034
Cube Monitoring Load Balancing in MS-Adcenter
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Bilal Obeidat
Title: Cube Monitoring Load Balancing in MS-Adcenter
Abstract:
The session is mainly a review of Cube Health Monitoring and Load Balancing in adCenter Enterprise Cube Environment. It is a detailed discussion and review of our process on achieving the following goals:
- Create a load balancer across the OLAP cubes
- Achieve better monitoring and alerting of our enterprise OLAP systems
- Increase our Up-time and monitor our SLA
- Increase our ROI of the HW
Currently AdCenter has two major services that are integrated / connected to each other: first one does the monitoring and alerting of the OLAP cubes and the second one does load balancing across the OLAP servers. The monitoring service notifies the load balancer when a server is not available so the cube balancer does not route traffic to it
SessionID: 29192
Best Practices Every SQL Server DBA Must Know
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Brad McGehee
Title: Best Practices Every SQL Server DBA Must Know
Abstract:
The focus of this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
SessionID: 29356
Hybrid Database Solutions with SQL Azure
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Buck Woody
Title: Hybrid Database Solutions with SQL Azure
Abstract:
With so much interest in Cloud technology, where does it really fit in, and what is the role of the DBA and Database Developer? What is available in SQL Azure, as it compares to SQL Server? Can you leave some data on-premise, and put other data in the cloud? Buck shows you the ins and outs of SQL Azure, how to connect to it, manage it, what the limitations are, and real-world examples of architectures that work.
SessionID: 29404
Real-time Data Warehouse and Reporting
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Carlos Bossy
Title: Real-time Data Warehouse and Reporting
Abstract:
SessionID: 29469
10 Things all BI System Administrators Should Know
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Robert Davis
Title: 10 Things all BI System Administrators Should Know
Abstract:
Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administer BI systems, you can't apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator? Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.
SessionID: 29533
Working with Server Side Traces
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Christina Leo
Title: Working with Server Side Traces
Abstract:
You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you.
First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace.
SessionID: 29684
Analyze and map spatial data with SQL Server 2008
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Deepak Puri
Title: Analyze and map spatial data with SQL Server 2008
Abstract:
With the widespread availability of location and spatial data to both consumers and corporations
(such as smartphone GPS data), there is a need to manage and analyze all this data as well.
SQL Server 2008 introduces new standards-based spatial data types and associated functionality
to the relational engine. Spatial data can be stored in the cloud using SQL Azure.
And SQL Server 2008 R2 Reporting Services allows spatial data to be visualized as Maps.
In this session, we'll explore both the SQL spatial data types and SSRS maps,
using demos to show this functionality in action. We'll also cover enhancements to
spatial functionality in the forthcoming "Denali" version of SQL Server.
SessionID: 29771
Kama Sutra of SSIS: A guide to loving ETL
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: David Eichner
Title: Kama Sutra of SSIS: A guide to loving ETL
Abstract:
SessionID: 29814
Data Warehousing Best Practices
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Doug Barrett
Title: Data Warehousing Best Practices
Abstract:
This session will describe the best practises for designing a data warehouse to get the most out of SQL Server. Doug has worked in data warehousing for 12 years and will blend experience, with best practises and recommendations from Microsoft's Fast Track program. Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
SessionID: 29972
Devs are from Mars, Report Servers are from Venus
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Doug Lane
Title: Devs are from Mars, Report Servers are from Venus
Abstract:
SessionID: 30043
Management Data Warehouse and Custom Collectors
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Edwin Quick
Title: Management Data Warehouse and Custom Collectors
Abstract:
SessionID: 30048
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Aaron Allison
Abstract:
SessionID: 30068
Scripting in SSIS
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Erik Monchen
Title: Scripting in SSIS
Abstract:
Can't find the component to use in your SSIS control flow or data flow? You might want to consider to script it yourself! One of the most flexible components in SSIS is the script task. This session covers the basics of the SSIS script task, what you can do with it and some tips and tricks how to use it.
SessionID: 30080
You’re My Density: Making Sense of Statistics
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Erin Stellato
Title: You’re My Density: Making Sense of Statistics
Abstract:
The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.
SessionID: 30297
Intro to SQL Server Mirroring and Log Shipping
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Harry Chandra
Title: Intro to SQL Server Mirroring and Log Shipping
Abstract:
In this introductory session, we will go through an overview of SQL Server Mirroring and Log Shipping. We will do a brief overview of the parts and modes of database Mirroring. You will also be introduce to Log Shipping and how it works. We will have a demo part of the session where we will go through step-by-step on how to set up Mirroring and Log Shipping. By the end of this session, you should have a general understanding and ability to deploy database Mirroring and Log Shipping.
SessionID: 30327
Deeper JOINs
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Rob Farley
Title: Deeper JOINs
Abstract:
There's so much more to know about joins than INNER, OUTER, CROSS. Understanding other kinds of joins, and the impact of decisions about how you write them can seriously impact your T-SQL effectiveness. A bunch of myths to dispel here too! No slides here - just demos. We'll create slides as we go.
SessionID: 30340
Advanced indexing
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Hugo Kornelis
Title: Advanced indexing
Abstract:
SessionID: 30449
Looney Tuner? No, there IS a method to my madness!
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Janis Griffin
Title: Looney Tuner? No, there IS a method to my madness!
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, 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: 30776
Reporting Services 201: From Basic To WOW!
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Jes Schultz
Title: Reporting Services 201: From Basic To WOW!
Abstract:
SessionID: 31198
Database Design Contentious Issues
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 31508
No More Bad Dates: Working With Dates and Times
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Kendra Little
Title: No More Bad Dates: Working With Dates and Times
Abstract:
SessionID: 31552
Introduction to Analysis Services
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
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: 31923
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Mitchell Bottel
Abstract:
SessionID: 32066
Extended Events – New Age of Profiling
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Neil Hambly
Title: Extended Events – New Age of Profiling
Abstract:
Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions, so we need to understand the differences it has to profiler "old guard" and why we should be using this new feature for this purposeI'll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectivelyFollow me to the "new age" of understanding your systems activity
SessionID: 32170
Models, Cubes Marts: how why to choose
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Paul Turley
Title: Models, Cubes Marts: how why to choose
Abstract:
SessionID: 32171
So you've built a cube...Now what? MDX essentials
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Paul Turley
Title: So you've built a cube...Now what? MDX essentials
Abstract:
SessionID: 32519
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Rick Morelan
Abstract:
SessionID: 32549
Bad Indexes
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Rob Farley
Title: Bad Indexes
Abstract:
I'm sure you've been told seeks are better than scans. I'm sure you've been told that a covering index is ideal. I'm sure you've been told small arrows are better than thick ones. Get the whole story.
SessionID: 32556
Exploring SQL 2008's MERGE
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Rob Garrison
Title: Exploring SQL 2008's MERGE
Abstract:
MERGE is a new capability in SQL Server 2008. This session will start with the basics of what MERGE is and then dig into how it works and how it compares to using traditional INSERT/UPDATE semantics. You should come away from this session with a good understanding of MERGE, ready to implement it in your environment.
SessionID: 32970
SQL Server And Oracle
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Steve Moss
Title: SQL Server And Oracle
Abstract:
SQL Server And Oracle: Tips, Tricks and Traps for Working In A Heterogeneous DB Environment
In this session I will present and discuss managing an environment that includes both SQL Server (our main development platform is .Net/SQL Server) and Oracle in which data moves in both directions. The session is organized in 3 major sections:
Getting Data Out Of Oracle into SQL Server
Getting Data into Oracle from SQL Server
Managing Differences between the environments
SessionID: 32974
SSIS Package Design: Choosing the Right Components
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Sopheap Suy
Title: SSIS Package Design: Choosing the Right Components
Abstract:
SessionID: 33007
Database Development: Keep It Agile, Not Fragile
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Dev Nambi
Title: Database Development: Keep It Agile, Not Fragile
Abstract:
Does your company use agile development? It can deliver more value to customers with lower project risk. However, it can also make the system design change rapidly, and require frequent software rollouts. This session will focus on best practices for DBAs and developers to make design, testing and deployments easier. Keep your systems agile, not fragile!
SessionID: 33665
The Periodic Table of Dynamic Management Objects
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Tim Ford
Title: The Periodic Table of Dynamic Management Objects
Abstract:
SessionID: 33818
Columnstore Indexes in SQL Server Denali
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Vern Rabe
Title: Columnstore Indexes in SQL Server Denali
Abstract:
SessionID: 33828
Parallelism in SQL Server
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: Victor Isakov
Title: Parallelism in SQL Server
Abstract:
SQL Server 2008 R2 supports up to 256 logical processors! Intel has released CPUs that support 10 cores and hyper-threading. So a quad-socket commodity server can easily support 80 logical processors. It's time for DBAs and Developers to understand how parallelism works in SQL Server! There are a lot of myths and misconceptions about how parallelism works in SQL Server and, more importantly, how to troubleshoot and solve parallelism problems. CXPACKET waits are not necessarily bad! In this session, Victor Isakov (MCT, MCM, MCA) will cover how parallelism works before presenting how to detect, troubleshoot and solve parallelism problems.
SessionID: 34692
Multi-threading TSQL
Event Date: 08-10-2011 - Session time: 00:00:00 - Track:
Speaker: John Huang
Title: Multi-threading TSQL
Abstract:
Can T-SQL be run in multi-threaded manner? Yes, this session will explain how to use TSQL to implement multi-threading application, including process control, resource access, execution ordering, synchronization, semaphore, etc. If you are looking for a solution to turn your processes to run in parallel, you should not miss this session.