Nr: 58
SQLSaturday #58 - Minnesota 2010
SessionID: 29061
Maintenance Plans - Lessons from the Real World
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-1
Speaker: Bill Preachuk
Title: Maintenance Plans - Lessons from the Real World
Abstract:
SQL Server Maintenance plans fail - often with no fanfare or warning. Without dependable maintenance plans you can end up with no backups when disaster strikes.
In this session we will dig into real-world examples of how maintenance plans break and and how to fix them. We'll also identify the contributing factors that play a part in these failures. Armed with this knowledge, you'll get sent off with specific tips and general principles you can use to make your Maintenance Plan jobs as dependable as they can be.
SessionID: 29074
Introduction to PowerPivot
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-1
Speaker: Brian Knight
Title: Introduction to PowerPivot
Abstract:
In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office 2010 and SQL Server 2008 R2 will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.
SessionID: 29075
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-1
Speaker: Brian Knight
Abstract:
SessionID: 29092
Using Data Mining to Improve SSIS Data Loads
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-1
Speaker: Brian Larson
Title: Using Data Mining to Improve SSIS Data Loads
Abstract:
SessionID: 29803
A Single Sign-On BI Story: SAML Claims in SharePoi
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-1
Speaker: David Baldauff
Title: A Single Sign-On BI Story: SAML Claims in SharePoi
Abstract:
SharePoint 2010 offers the elusive single sign-on solution to the Microsoft BI stack. On the edge of new authorization schemes in the Enterprise, SharePoint 2010 offers a single sign-on solution via SAML Claim authentication. In this session we will run through configuring SharePoint 2010 for SAML Claims authentication using ADFS 2.0 as an Identity Provider. We will also demonstrate one solution for using Reporting Services 2008 R2 in this solution.
SessionID: 29880
Query Tuning - Get it Right the First Time
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-2
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: 29885
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-1
Speaker: Dan English
Abstract:
SessionID: 30062
Tuning SQL Code using Logical Equivalencies
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-2
Speaker: Eric Strom
Title: Tuning SQL Code using Logical Equivalencies
Abstract:
SessionID: 30063
Table Partitions for Archiving
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: Development
Speaker: Eric Zierdt
Title: Table Partitions for Archiving
Abstract:
SessionID: 30163
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: Development
Speaker: Eddie Wuerch
Abstract:
The session starts with the notion that SQL Server is not a magic box – most of what happens is well-documented and must be taken into consideration when designing or tuning databases.
SessionID: 30164
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-1
Speaker: Eddie Wuerch
Abstract:
SessionID: 30243
Self-Service Reporting/Analytics for SQL Server
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-2
Speaker: Gilbert Evans
Title: Self-Service Reporting/Analytics for SQL Server
Abstract:
If you use SQL Server Analysis Services (SSAS), you’re closer to easy-to-use, self-service business analytics than you probably realize. SwiftKnowledge’s award-winning, Microsoft-based BI software is optimized to leverage existing SSAS data cubes, which speeds deployment and minimizes expense. Give non-technical business people the insight they need, when they need it, regardless of the availability of trained IT resources – attend this session to learn how to:
• Leverage SSAS cubes, SQL relational reporting DMX data mining to easily build powerful analytics solutions
• Effortlessly create content dashboards
• Perform self-service, ad-hoc analysis
• Interactively explore large data sets
• Set up automated alerts
SessionID: 30528
Extended Events, Work Smarter Not Harder
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-2
Speaker: Jason Strate
Title: Extended Events, Work Smarter Not Harder
Abstract:
SessionID: 30530
Using XML to Query Execution Plans
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-2
Speaker: Jason Strate
Title: Using XML to Query Execution Plans
Abstract:
SessionID: 31297
SQL Server Internals and Architecture
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-1
Speaker: Kevin Kline
Title: SQL Server Internals and Architecture
Abstract:
SessionID: 31298
Top 10 Admin Mistakes on SQL Server
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-1
Speaker: Kevin Kline
Title: Top 10 Admin Mistakes on SQL Server
Abstract:
Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. In fact, wouldn’t you like to learn about those mistakes before they ever happen?
SessionID: 31593
Intro To Reporting Services(2008 R2) Report Models
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-2
Speaker: Mark Vaillancourt
Title: Intro To Reporting Services(2008 R2) Report Models
Abstract:
Report Models can be a great way to empower your end users to create their own reports through a drag and drop tool. This presentation will discuss how to create, maintain and secure SSRS Report Models. Although the focus is on implementation, we will use Report Builder 3.0 to demonstrate report model consumption. We will also cover some tips and tricks learned through real-world experience implementing and supporting report models for clients.
SessionID: 31785
Taking your Data to SQL Azure
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: Development
Speaker: Mike Benkovich
Title: Taking your Data to SQL Azure
Abstract:
SessionID: 31786
Programming with OData the Microsoft Data Stack
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: Development
Speaker: Mike Benkovich
Title: Programming with OData the Microsoft Data Stack
Abstract:
Data is the core of why we build systems and solutions and look for opportunities to automate and simplify. What are the options and when do you make the tradeoffs? In this session, we look at what's new with the Microsoft ADO.NET Entity Framework and explain how it works with Windows Communication Foundation (WCF), Representational State Transfer (REST), and RIA Data Services. We also explore the technologies and the trends that are driving the ADO.NET Entity Framework to see how to take advantage of these new technologies.
SessionID: 32035
Answers at the speed of thought with SSAS Cubes
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-2
Speaker: Mustafa Hussain
Title: Answers at the speed of thought with SSAS Cubes
Abstract:
SessionID: 32656
Dynamic Text File Creation Via Single SSIS Package
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: Development
Speaker: Ross McNeely
Title: Dynamic Text File Creation Via Single SSIS Package
Abstract:
Creating individual SSIS Packages for individual business-to-business data files is not only time consuming, but becomes a maintenance nightmare. This presentation will show you how to create a single SSIS package that can generate varying length and formatted text files. By utilizing stored procedures and executing dynamic T-SQL you will see how the time from specification to file delivery can be greatly reduced and simplified. Additional areas we will cover include the support tables to control file run times, creating file variables at run time, and how to report file success.
SessionID: 32706
Stored procedure tracing using the xml datatype
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: Development
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: 32707
SSIS and SSRS Better Together
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-1
Speaker: Russel Loski
Title: SSIS and SSRS Better Together
Abstract:
SessionID: 33216
Report Lockdown: Implementing SSRS Security
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-2
Speaker: Steve Hughes
Title: Report Lockdown: Implementing SSRS Security
Abstract:
When working with Reporting Services, you need to consider all aspects of security from access to the report server to filtering the report data. This session will delve into the various techniques used to secure reports throughout the architecture and the nuances of integrating with SharePoint security as well.
SessionID: 33574
Introduction To Transactional Replication
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-2
Speaker: Ben Thul
Title: Introduction To Transactional Replication
Abstract:
Transactional replication: if you're like most who I've met that are tasked with supporting it, it can appear somewhat mystical. There are many (many, many) configurable options for each step in the process, which can make the whole topic daunting. In this session, we'll be setting up a simple topology from scratch and talk about what you should be mindful of and what you should save for further study.
SessionID: 33575
Managing and Administering SQL Azure
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-1
Speaker: Tim Plas
Title: Managing and Administering SQL Azure
Abstract:
This discussion addresses operational questions about using "SQL in the cloud" -- Questions like: Just what is SQL Azure? Where does it make sense to use it (or not)? HOW do I use it? How do I get stuff in and out of it? How much does it really cost? How do I manage it? The session covers SQL Azure "how-to" and "why" questions from the viewpoint of operational DBA's and system architects (vs. developers).
SessionID: 33576
High-Availability and DR Options for SQL Server
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-1
Speaker: Tim Plas
Title: High-Availability and DR Options for SQL Server
Abstract:
A comparison of SQL HA DR options, by a practitioner who has implemented managed pretty much every SQL HA and DR approach ( various combinations thereof). Tim is an operational SQL DBA, charged with keeping SQL servers up running optimized, for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware requirements, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.
SessionID: 33941
Getting Started with MDX
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-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: 33943
Documenting Your Integrated Microsoft BI Solution
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: BI-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: 34521
Powershell Eye for the Monitoring Guy.
Event Date: 29-10-2010 - Session time: 00:00:00 - Track: DBA-2
Speaker: Zach Mattson
Title: Powershell Eye for the Monitoring Guy.
Abstract:
Server monitoring can be expensive and is generally licensed for only critical production servers. In this session, learn how to utilize Powershell along with some SMO to not only be proactive, but productive in monitoring the servers in your environment. Attendees will come away from the session with an understanding of how to read the SQL and Server event logs, check backups, find which servers have pending reboots and more. In order to get the most out of this session, it is suggested that those attending have a basic knowledge of Powershell or another administrative scripting language.