sqlsathistory

Nr: 99

Back to Main list

SQLSaturday #99 - Minnesota 2011

Start Time (24h)	Speaker	Track	Title
00:00:00	Dan Lewendowski, Aaron Bangasser	BI-2	Securing an SSAS, SSRS, and SharePoint BI Solution
00:00:00	Ajay Nangia	DBA-1	Converged SQL Server Solutions from HP Microsoft
00:00:00	Andy Lohn	DEV-1	TSQL Tips and Tricks
00:00:00	Bill Preachuk	DBA-2	Database Restores - Lessons from the Real World
00:00:00	Brian Larson	Prof Develop	Geographic Visualizations Using Maps in SSRS
00:00:00	Brian Larson	BI-1	Introduction to Data Mining in SQL Server
00:00:00	Dan English	BI-1	Inside PerformancePoint
00:00:00	Eric Zierdt	DBA-1	A Beginners Guide to Execution Plans
00:00:00	Greg Beaumont	BI-2	Uniting Free Government Data using PowerPivot
00:00:00	Hans Johnson	DEV-2	SSRS Multi-language Dynamic DB Connections
00:00:00	Janis Griffin	DBA-1	Don't Panic, DBAs! Databases on VMware made easy.
00:00:00	Janis Griffin	DEV-2	SQL Server Service Broker – An Overview
00:00:00	Jason Horner	DBA-2	PowerShell for the Reluctant DBA
00:00:00	Jin Cho	BI-1	SQL Denali - What's new for PowerPivot and SSAS!
00:00:00	Jeff Krebsbach	DEV-1	Custom assemblies for Reporting Services
00:00:00	Jason Strate	DEV-2	SQL Denali - An Open Window To T-SQL Enhancements
00:00:00	Jason Strate	Prof Develop	Do SQL Server Certifications Really Matter?
00:00:00	Kirby Richter	DBA-2	Intro to Locking and Blocking
00:00:00	Marc Beacom	DEV-2	Introduction to Integration Services
00:00:00	Marc Beacom	BI-2	Introduction to Data Warehousing
00:00:00	Mike Benkovich	DEV-2	Diving into the Cloud with SQL Azure
00:00:00	Natalie Wood	BI-1	Introduction to Project Crescent
00:00:00	Paul Doyle	BI-2	Analysis Services vs. PowerPivot Denali
00:00:00	Peter Kral	DEV-1	Building a SQL Listener Job Using Powershell
00:00:00	Robert Biddle	DEV-1	Loading a Data Warehouse with SSIS
00:00:00	Ross McNeely	BI-1	Minimal Processing for Large Cubes
00:00:00	Rowland Gosling	DBA-1	Storage Design and SQL Server Performance
00:00:00	Steve Hughes	DEV-1	Beyond Rounded Corners - SSIS Changes in Denali
00:00:00	Gus Siefker	DBA-1	Performance, Scalability and Efficiency
00:00:00	Ted Krueger	DBA-2	Merge Replication for Offline Data Mobility
00:00:00	Tim Plas	DBA-1	High-Availability and DR Options for SQL Server
00:00:00	Trent Mera	BI-1	Baselining for SQL Server
00:00:00	William E Pearson III	BI-2	Becoming DAX: An Introduction ...
00:00:00	William E Pearson III	Prof Develop	Entity Strategies: Structuring Your Consultancy
00:00:00	Zach Mattson	DBA-2	Powershell and Perfmon - A performance story

SessionID: 28433

Securing an SSAS, SSRS, and SharePoint BI Solution

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-2

Speaker: Dan Lewendowski, Aaron Bangasser

Title: Securing an SSAS, SSRS, and SharePoint BI Solution

Abstract:

Security is a vital part of any business intelligence solution. Unfortunately, creating a solution that presents users only with the information they should see can be a challenge. In this session we’ll look at how the various security pieces come together to make the solution work. We’ll cover configuring Kerberos for securing SSRS, SSAS, and SharePoint; Scripting permissions in SSAS using MDX, Active Directory groups, and SSIS; and finally, configuring SharePoint, PerformancePoint services, and Power Pivot services to access user’s data by passing Windows credentials and/or the use of data sources with execution accounts.

SessionID: 28502

Converged SQL Server Solutions from HP Microsoft

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-1

Speaker: Ajay Nangia

Title: Converged SQL Server Solutions from HP Microsoft

Abstract:

.

SessionID: 28634

TSQL Tips and Tricks

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-1

Speaker: Andy Lohn

Title: TSQL Tips and Tricks

Abstract:

This session will demonstrate tips and tricks that will help you complete tasks fast and efficient using TSQL. This session is targeted at TSQL beginners to SQL Server experts looking to add to their TSQL bag of tricks. The focus of this session will be on leveraging builtin functions, scripts to create scripts, troubleshooting procedures and other uses.

SessionID: 29062

Database Restores - Lessons from the Real World

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-2

Speaker: Bill Preachuk

Title: Database Restores - Lessons from the Real World

Abstract:

Having consistent, regular, verified backups are only a starting point. When failures happen - and they will happen - can you recover your database? In this presentation we will dive into the mechanics of database restores and discuss how choices made previously in database/server/backup design can have profound effects on how ( what) you can recover. We will also discuss spectacular ways to fail miserably... all in the hopes of preventing those same failures in the future.

SessionID: 29093

Geographic Visualizations Using Maps in SSRS

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Prof Develop

Speaker: Brian Larson

Title: Geographic Visualizations Using Maps in SSRS

Abstract:

This session will explore the many and varied uses of the map report item in Reporting Services. From providing geographic analytics to diagramming locations on a warehouse floorplan, the map report item – when combined with SQL Server spatial data types - can be used in a variety of ways to create spatial representations of your data. We may even look at a game or two created using the map report item.

SessionID: 29094

Introduction to Data Mining in SQL Server

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-1

Speaker: Brian Larson

Title: Introduction to Data Mining in SQL Server

Abstract:

Data mining provides a powerful tool for predictive analysis. These capabilities are available free as part of your SQL Server license. Unlock this powerful analytical tool to assist with decision making, cross-selling, and data analysis, and other areas within your organization.

SessionID: 29886

Inside PerformancePoint

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-1

Speaker: Dan English

Title: Inside PerformancePoint

Abstract:

This session will provide an overview of what PerformancePoint is, where it came from, and how do you get it. We will also discuss what’s changed in the 2010 release (including with the latest SP1 update). Along with this we will go over the Dashboard Designer tool showing you how to install it and explain what it is used for. Then hold on to your seats, I will build out and deploy a fully functional and interactive dashboard. Along the way I will provide insight from the trenches including tips and tricks along with experience from client deployments.

SessionID: 30064

A Beginners Guide to Execution Plans

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-1

Speaker: Eric Zierdt

Title: A Beginners Guide to Execution Plans

Abstract:

This session is geared for people who write SQL and have little to no experience with Execution Plans; we will go over how to read an execution plan, how to improve server performance based on the results and common things to watch out for.

SessionID: 30280

Uniting Free Government Data using PowerPivot

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-2

Speaker: Greg Beaumont

Title: Uniting Free Government Data using PowerPivot

Abstract:

In recent years, governments throughout the world have made large volumes of data available for public use. Vast data with detailed insights into verticals such as healthcare, census, weather, natural resources, land use, financial markets, and economics are available to be extracted, transformed, joined and unleashed. In this session PowerPivot will be used to tie data together for analysis. Examples include uniting commodity prices with weather patterns, integrating free healthcare data with economic data, and integrating US economic data with that of other countries.

SessionID: 30294

SSRS Multi-language Dynamic DB Connections

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-2

Speaker: Hans Johnson

Title: SSRS Multi-language Dynamic DB Connections

Abstract:

Speaker Hans Johnson will entertain and educate attendees with a lesson on how to set up a dynamic database connection for an external application to call the web report server and render a .pdf for read only viewing. Hans will also show how to set up the same report with multi-language capabilities based on the end users browser language setting.

Prizes will be given away based on a few different criteria that Hans will make fun, thought provoking and participant centered.

SessionID: 30450

Don't Panic, DBAs! Databases on VMware made easy.

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-1

Speaker: Janis Griffin

Title: Don't Panic, DBAs! Databases on VMware made easy.

Abstract:

More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. 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 a VMWare environment.

SessionID: 30451

SQL Server Service Broker – An Overview

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-2

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: 30506

PowerShell for the Reluctant DBA

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-2

Speaker: Jason Horner

Title: PowerShell for the Reluctant DBA

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 professionals 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: 30853

SQL Denali - What's new for PowerPivot and SSAS!

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-1

Speaker: Jin Cho

Title: SQL Denali - What's new for PowerPivot and SSAS!

Abstract:

The presentation will consist of slides to lay out the approach/strategy for Microsoft's single BI semantic model (BISM). Also, demonstration of the new capabilities in SQL Server Denali CTP3 for PowerPivot and BISM.

SessionID: 30856

Custom assemblies for Reporting Services

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-1

Speaker: Jeff Krebsbach

Title: Custom assemblies for Reporting Services

Abstract:

With SSRS we can quickly generate reports that can be exported to multiple formats. What happens when you want to extend your report with custom code? Perhaps you need a custom authentication layer, custom access to data requiring .Net code, or you want to extend some of the controls that come out of the box with SSRS.

In this session we will see an example of extending SSRS to use a .Net library for a data provider allowing us to use a custom .Net business layer for our report. We will also show an example extension to the SSRS graph control allowing us to make design graphs for SSRS. Custom code is a great alternative for those considering using toolkits like Nevron or Dundas toolkits to extend their SSRS graphing capabilities

SessionID: 31110

SQL Denali - An Open Window To T-SQL Enhancements

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-2

Speaker: Jason Strate

Title: SQL Denali - An Open Window To T-SQL Enhancements

Abstract:

The upcoming release of SQL Server is full of new features to help everyone from DBAs to developers. In this session, we'll examine some of the new features that are being added to the T-SQL language. From error handling to windowing functions, we'll look at the new flexibility and power available within the T-SQL language.

SessionID: 31111

Do SQL Server Certifications Really Matter?

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Prof Develop

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: 31375

Intro to Locking and Blocking

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-2

Speaker: Kirby Richter

Title: Intro to Locking and Blocking

Abstract:

Understand the basics of SQL Server locking including lock modes, lock granularity and lock escalation. Also what is blocking, why should you be concerned and what you can do about it.

SessionID: 31554

Introduction to Integration Services

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-2

Speaker: Marc Beacom

Title: Introduction to Integration Services

Abstract:

Just getting started with SQL Server Integration Services (SSIS)? Not sure where to start? Or have you been using SSIS for a little while now and are still trying to figure out the basics. The biggest barrier to learning something new is figuring out the first few steps. We will discuss what SSIS is and a few lessons learned.

SessionID: 31555

Introduction to Data Warehousing

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-2

Speaker: Marc Beacom

Title: Introduction to Data Warehousing

Abstract:

Just starting or thinking of starting a data warehousing project but not sure where to begin. Or still not sure if your organization needs a data warehouse. This discussion is geared towards answering the what and why (or why not) of data warehousing.

SessionID: 31784

Diving into the Cloud with SQL Azure

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-2

Speaker: Mike Benkovich

Title: Diving into the Cloud with SQL Azure

Abstract:

Working with data is core to what we do as developers. With the release of the Microsoft SQL Azure Database cloud offering, developers have a new set of options and features that make it possible to take full advantage of the scalability and availability of this platform. In this webcast, we take a look at what SQL Azure means for developers and show how to create and manage a database in the cloud. We also explore the tools and the practices for using the tools.

SessionID: 32046

Introduction to Project Crescent

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-1

Speaker: Natalie Wood

Title: Introduction to Project Crescent

Abstract:

Project Crescent is the new self-service BI tool that will ship with SQL Server Denali. This session will cover what you need to know to install, configure and secure your new Project Crescent environment. It will also provide an overview of the features of Project Crescent and demonstrations of it's powerful yet simple reporting capabilites.

SessionID: 32159

Analysis Services vs. PowerPivot Denali

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-2

Speaker: Paul Doyle

Title: Analysis Services vs. PowerPivot Denali

Abstract:

This session is a primer to understanding the differences and advantages between Analysis Services and PowerPivot; which scenarios to use analysis services vs. PowerPivot and how both serve to provide a perfect BI platform addressing short term vs. long term BI needs of organizations. We will focus on the differences between the two storage methods that are available for creating a BI Semantic Model, OLAP and Tabular, including a deep-dive into comparing Analysis Services vs. PowerPivot on topics such as security, hierarchies, KPIs and scalability. Understand when you should use PowerPivot in comparison with SQL Services Analysis Services (OLAP) so you are equipped to create robust Self Service BI applications in your organization.

SessionID: 32234

Building a SQL Listener Job Using Powershell

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-1

Speaker: Peter Kral

Title: Building a SQL Listener Job Using Powershell

Abstract:

In this session, you will be introduced to some simple PowerShell techniques, and see how to combine them to create an event-driven listener job running in SQL Server Agent service. Designed to be accessible to database administrators and database developers, you will see how easy it is to create useful scripts in PowerShell.

SessionID: 32542

Loading a Data Warehouse with SSIS

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-1

Speaker: Robert Biddle

Title: Loading a Data Warehouse with SSIS

Abstract:

You've just been assigned a data warehouse project. Maybe you've figured out what tables you want to work with, but outside of that you don't really know how to get started. In this session you'll learn how to load a data warehouse using SSIS, as well as techniques that you can use for any platform.

SessionID: 32657

Minimal Processing for Large Cubes

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-1

Speaker: Ross McNeely

Title: Minimal Processing for Large Cubes

Abstract:

Processing large cubes can consume vast amounts of IO, and create lengthy response times. This presentation will demo how to process dimensions and dynamically create, process, and delete measure group partitions to minimize IO. By taking control of cube processing through a SSIS package you are able to process only the bare minimum in order to bring a cube current while keeping response times acceptable. Additional areas to cover will include the support tables to control cubes, and a review of the XMLA for creating, processing, and deleting.

SessionID: 32666

Storage Design and SQL Server Performance

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-1

Speaker: Rowland Gosling

Title: Storage Design and SQL Server Performance

Abstract:

This discussion will be about storage design and how it affects SQL Server's performance. Topic will include Solid State Drives (SSDs), SAN and Direct Attached Storage (DAS) and how the perform using RAID 5,RAID 6 and RAID 10. We will also cover File Groups, Files and entry level Table Partitioning.

SessionID: 33222

Beyond Rounded Corners - SSIS Changes in Denali

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DEV-1

Speaker: Steve Hughes

Title: Beyond Rounded Corners - SSIS Changes in Denali

Abstract:

Unlike SSIS 2008, there are a number of developer improvements in SSIS Denali, beyond the rounded corners and new icons. This session will explore the changes and how they improve the developer experience.

SessionID: 33319

Performance, Scalability and Efficiency

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-1

Speaker: Gus Siefker

Title: Performance, Scalability and Efficiency

Abstract:

Improving Response Times, Reduce Workload, Enhance Reliability, and Save Money with IOMemory Solutions• Improve performance and scalability• Provide High Availability• Empower data warehouses• Improve ROI

SessionID: 33333

Merge Replication for Offline Data Mobility

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-2

Speaker: Ted Krueger

Title: Merge Replication for Offline Data Mobility

Abstract:

How many times have you been sitting in a meeting and you hear, “We want all our users to have access to the data, 24/7. That includes when they are offline and on a client location”. At this point you may start letting out a large sigh because you are thinking, “How could the user get to the data if there is no connection?” This isn’t as hard as you may think and this session will show how to use SQL Servers Merge Replication in order to accomplish the task. Merge replication offers a scalable option for data mobility. This session will go over how Merge Replication can be used to replicate data to users that spend many hours offline.

SessionID: 33579

High-Availability and DR Options for SQL Server

Back to calendar

Event Date: 11-11-2011 - 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 all the SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps 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, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.

SessionID: 33782

Baselining for SQL Server

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-1

Speaker: Trent Mera

Title: Baselining for SQL Server

Abstract:

Why creating SQL Server performance baselines is important. Methods and approaches for baselining. How you can make use of baselines. Tools and applications that can help.

SessionID: 33976

Becoming DAX: An Introduction ...

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: BI-2

Speaker: William E Pearson III

Title: Becoming DAX: An Introduction ...

Abstract:

The Data Analysis Expressions (DAX) language is a library of operators and constants that we can combine to craft formulas and expressions in PowerPivot Client. In this introductory session Microsoft BI Architect and SQL Server MVP Bill Pearson will concentrate upon crafting simple DAX expressions whose purposes, for the most part, are to return a set of data. He’ll overview a simple data source structure, outline the components of simple DAX syntax, and get you started understanding basic expressions.

SessionID: 33980

Entity Strategies: Structuring Your Consultancy

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: Prof Develop

Speaker: William E Pearson III

Title: Entity Strategies: Structuring Your Consultancy

Abstract:

Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.

SessionID: 34523

Powershell and Perfmon - A performance story

Back to calendar

Event Date: 11-11-2011 - Session time: 00:00:00 - Track: DBA-2

Speaker: Zach Mattson

Title: Powershell and Perfmon - A performance story

Abstract:

It turns out there might be something better than the combination of beer and peanuts (at work anyway); using Powershell to gather Performance Monitor (perfmon) metrics! In this session we will tackle gathering all the perfmon counters, storing them and alerting when they reach a defined level. This will be a demo intensive session that will also use SQL and XML components of Powershell. Attendees will leave this session with ideas and examples that they can implement in their jobs immediately. A basic working knowledge of Powershell syntax and commandlets will be assumed.

This site is open source. Improve this page.