Nr: 74
SQLSaturday #74 - Jacksonville 2011
SessionID: 28534
Introduction to Analysis Services
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: BI (Auditorium 1) -1102
Speaker: Adam Jorgensen
Title: Introduction to Analysis Services
Abstract:
Overcome the barriers of traditional training and seminars with this Quick Start to building a cube and power pivot solutions. This all demo session will get you started and answer many questions you have about building cubes and reports the right way, the first time.
SessionID: 28711
Building a Professional Development Plan
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1404
Speaker: Andy Warren
Title: Building a Professional Development Plan
Abstract:
This session is designed to help you build a professional development plan using the same techniques that are used for building business plan. We'll talk about obtaining and managing resources, setting realistic goals, tracking progress, and what to do when you get off plan. At the end of this session you should be ready to spend a few hours building a plan that will help you move your career forward to a goal that you've selected.
SessionID: 29029
.Net for the DBA
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1202 (Auditorium 2)
Speaker: Benjamin Evans
Title: .Net for the DBA
Abstract:
SessionID: 29072
Iron Chef Jacksonville BI Edition
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: BI (Auditorium 1) -1102
Speaker: Brian Knight
Title: Iron Chef Jacksonville BI Edition
Abstract:
In this session, you'll see a battle between two business intelligence heavyweights, attempting to load and report against the perfect data warehouse with today’s secret ingredient. You'll see varying architectures and best practices from each of the contestants and you decide who wins the Iron Chef competition. You’ll learn varying patterns in loading a data warehouse, reporting against it and cubing architectures.
SessionID: 29073
Data Mining 101
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1400
Speaker: Brian Knight
Title: Data Mining 101
Abstract:
This session will demonstrate “How to build data mining solutions to address predictive analytics needs of your organizations” . This is a basic session and intended to target audience with none or limited exposure to Data Mining.
SessionID: 29097
Reporting Services Deep Dive
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1202 (Auditorium 2)
Speaker: Brian K McDonald
Title: Reporting Services Deep Dive
Abstract:
SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like:
-What is Reporting Services and what can it be used for?
-New Features included in 2008 R2
-Architectural Overview
-Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQL Saturday favorite and is always packed full. Don't miss it **
SessionID: 29139
Page and Row Compression How, Why, and When
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1406
Speaker: Bradley Ball
Title: Page and Row Compression How, Why, and When
Abstract:
Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page Row with SQL 2008 RTM, and Page Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.
SessionID: 29327
Introduction To SSIS
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: BI (Auditorium 1) -1102
Speaker: Bradley Schacht
Title: Introduction To SSIS
Abstract:
In this session we will help get you past the learning curve of SSIS. We will cover the basics of the development environment, the control flow and data flow. We will show you how to create an end to end package to demonstrate best practices and illustrate design concepts. This is a great session for anyone who is new to SSIS.
SessionID: 29347
Designing a Data Recovery (and Backup) Solution
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1402
Speaker: Brandie Tarvin
Title: Designing a Data Recovery (and Backup) Solution
Abstract:
SessionID: 29372
Business Intelligence: Around the Horn
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1402
Speaker: Chris Albrektson
Title: Business Intelligence: Around the Horn
Abstract:
In this session hosted by Chris Albrektson we will have several different speakers present a unique “tip or trick” that will help you succeed in your day to day BI tasks. Each mini-session will last about 5-10 minutes. The entire session will cover all aspects of the BI stack (SSRS, SSIS, SSAS) so everyone should attend.
SessionID: 29723
Multisite Clusters for HA and Disaster Recovery
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1402
Speaker: David Bermingham
Title: Multisite Clusters for HA and Disaster Recovery
Abstract:
Windows Server 2008 R2 failover clustering supports the concept of a "multisite cluster", which provides an excellent disaster recovery and high availability solution for SQL Server. This session will describe the concept of a multisite cluster and why it provides the best recovery point objective (RPO) and recovery time objective (RTO) for all of your SQL Server databases and other applications. Configuration details, known issues and a live demonstration will complete this session. After this session the attendee should be armed with the knowledge to propose a robust disaster recovery solution for any environment.
SessionID: 29805
SQL CE 4.0 for Prototyping
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1406
Speaker: David Fekke
Title: SQL CE 4.0 for Prototyping
Abstract:
This session will give an introduction to the new features in SQL Compact Edition 4.0, how it can be used for prototyping with .NET 4, and how it can be used as a standalone database for Mobile devices and websites.
SessionID: 29818
What is this Cache and why is it so big?
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1402
Speaker: Douglas Brendle
Title: What is this Cache and why is it so big?
Abstract:
SessionID: 29858
Implementing auditing in SQL Server
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1404
Speaker: David Dye
Title: Implementing auditing in SQL Server
Abstract:
SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
SessionID: 29907
Accelerating BI Development with BIxPress
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: BI (Auditorium 1) -1102
Speaker: Donny Johns
Title: Accelerating BI Development with BIxPress
Abstract:
In this session, Donny Johns will show you how to accelerate your BI development lifecycle with BI xPress. You’ll see how to implement advanced SSIS frameworks, implement code reusability in SSIS and write MDX calculation code in seconds with this must have time saving application.
SessionID: 29918
Adopt, Discover and Improve
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1404
Speaker: Dmitri Korotkevitch
Title: Adopt, Discover and Improve
Abstract:
This session shows how to analyze the system state using wait statistics, DMO and performance counters. It demonstrates how specific resource bottlenecks relate to design and code issues, shows how to pinpoint the most problematic queries and detect anti-patterns and design issues in the system
The session is targeted to both DBAs and Developers who want to become familiar with the necessary techniques helping to take an ownership and detect issues in the system.
SessionID: 29950
The Fundamentals of DBA-ism
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1202 (Auditorium 2)
Speaker: Don Stevic
Title: The Fundamentals of DBA-ism
Abstract:
When I was a freshly minted DBA and trying to learn the ropes, my manager used to tell me “You should know that, that’s DBA 101”. As much as it frustrated me, he was right. There is a core set of knowledge that DBA. Correct SQL installation and configuration, how’s and whys of backups, how to make your role proactive, and many other things fall under that heading. This session is for the “freshly minted” DBA to help them find and define their own set of best practices.
SessionID: 30146
SSIS - Data Flow Buffer Breakdown
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1400
Speaker: Eric Wisdahl
Title: SSIS - Data Flow Buffer Breakdown
Abstract:
SessionID: 30624
What's new in Denali for SSIS, SSAS and SSRS
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: BI (Auditorium 1) -1102
Speaker: Jose Chinchilla
Title: What's new in Denali for SSIS, SSAS and SSRS
Abstract:
In this session I will go over the most important enhancements to SQL Server, SSIS, SSAS and SSRS in SQL Server 11 codename "Denali". Join me to explore several of the new features and services released in CTP1 and discuss what is yet to come.
SessionID: 30870
SSIS: Lookup Between the Lines
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1400
Speaker: James McAuliffe
Title: SSIS: Lookup Between the Lines
Abstract:
This session covers some interesting ways to work with data iand SQL in ETL, and solve some common problems
- Using Range Predicates in a Lookup Transform (Using Between and IN type lookups can give you VERY sophisticated matching techniques you may not have known were available in SSIS),
- Using stored procs and parameters in a lookup
- Having a named parameter to match on in an OleDB lookup.
SessionID: 30976
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1404
Speaker: John Welch
Abstract:
SessionID: 31011
SSIS Programmatically
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1404
Speaker: Jorge Novo
Title: SSIS Programmatically
Abstract:
Build dynamic packages or build a metadata driving ssis library.
SessionID: 31273
DR Availability,You're Wanted in the Recovery Room
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1406
Speaker: Kendal Van Dyke
Title: DR Availability,You're Wanted in the Recovery Room
Abstract:
There are a lot of options when it comes to disaster recovery and high availability with regards to SQL Server. Most business owners (and many DBA’s) lump disaster recovery (DR) high availability (HA) together and while they do share some pieces, they call for different strategies. Do you pick one or more than one of these options, and based on what? It’s incredibly important that you understand the decision tree that helps you pick the right one(s) for your business, and that you can explain the choices clearly to the stakeholders. It’s not as complicated as it sounds, but it is complicated – and in this hour presentation we’ll give you a high level understanding of the options, the costs, complexities, reasons for using each of them.
SessionID: 31439
Introduction to MDX
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1202 (Auditorium 2)
Speaker: Devin Knight
Title: Introduction to MDX
Abstract:
In this beginner session, Dustin will introduce the audience to Multi Dimensional Expression language. Attendees will learn about MDX query syntax, how to write a basic MDX query, and about more advanced MDX queries involving time and hierarchies.
SessionID: 31481
Taking SSIS to the Next Level
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: BI (Auditorium 1) -1102
Speaker: Kyle Walker
Title: Taking SSIS to the Next Level
Abstract:
SessionID: 31661
Introduction to Business Intelligence
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: BI (Auditorium 1) -1102
Speaker: Mike Davis
Title: Introduction to Business Intelligence
Abstract:
In this session Mike shows how a complete BI solution is built from the transactional system to the finished Cube and reports. He will go over the steps involved in planning a BI solution and how to make your project successful. You will get an understanding of the roles SSIS, SSAS, and SSRS play in building a BI solution.
SessionID: 31815
Introduction to PowerPivot for Excel
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1400
Speaker: Michael Antonovich
Title: Introduction to PowerPivot for Excel
Abstract:
This session focuses on the basics of how to use PowerPivot with Excel to create simple pivot tables (cubes) and pivot charts using both data already in Excel as well as how to connect to SQL tables as your data source. It will also cover how add slicers, how to add calculated columns and how to define hierarchies in your pivot tables.
SessionID: 31967
Sql trivia
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1402
Speaker: Michael Mollenhour
Title: Sql trivia
Abstract:
An exiting interactive trivia of sql questions including all facets of sql
server including but not limited to tsql,ssas,ssrs,ssis and maybe a little
BS. Don't miss the chance to be crowned the sql trivia geek.
SessionID: 32239
T-SQL Enhancements in Denali
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1202 (Auditorium 2)
Speaker: Plamen Ratchev
Title: T-SQL Enhancements in Denali
Abstract:
Take a look in the future of SQL Server and experience the new T-SQL features in SQL Server 11 (code named Denali). This session is a deep dive into the new OFFSET option for paging, error handling improvements with THROW, sequences, enhancements to EXECUTE for results sets, and new features to describe query and procedures result sets and parameters. You will see practical code demos describing the use cases for these T-SQL extensions.
SessionID: 32650
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1400
Speaker: Phillip E Rosen
Abstract:
I will demonstrate how to develop MS Excel BI Dashboards in the following ways:
- Workbook style with Office data connections stored on local PC or networked document drive
- excel services style using Reports Library SP 2007 for storage of the Office data connections workbook that excel services will render
- Convert excel pivot table into excel OLAP formulas
- Discuss SP 2010 BI Center
- Discuss references to cap off session.
SessionID: 32907
Creating Your First Dashboard in SSRS
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1402
Speaker: Shawn Harrison
Title: Creating Your First Dashboard in SSRS
Abstract:
SessionID: 33121
SQL Server 2008 Installation Best Practices
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1406
Speaker: Scott Gleason
Title: SQL Server 2008 Installation Best Practices
Abstract:
SessionID: 33318
How to build your brand
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1202 (Auditorium 2)
Speaker: Tom Brenneman
Title: How to build your brand
Abstract:
Having trouble finding a position or make yourself visible in today's market?
This session will provide tips to help build up your existing brand or land the next job!
SessionID: 33371
Introduction to Transactional Replication
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1404
Speaker: Troy Gallant
Title: Introduction to Transactional Replication
Abstract:
SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution as well as alternatives we may wish to realize.
SessionID: 33442
SQL Injection
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1202 (Auditorium 2)
Speaker: Kevin Boles
Title: SQL Injection
Abstract:
SessionID: 33445
Advanced TSQL Solutions
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1406
Speaker: Kevin Boles
Title: Advanced TSQL Solutions
Abstract:
SessionID: 33605
You inherited a database, now what?
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1406
Speaker: Tim Radney
Title: You inherited a database, now what?
Abstract:
SessionID: 33811
Data Mining Addin in Excel
Event Date: 30-04-2011 - Session time: 00:00:00 - Track: 1400
Speaker: VIKAS HAWALDAR HAWALDAR
Title: Data Mining Addin in Excel
Abstract:
During this presenatation the speaker will demonstrate various functionality of Excel Data Mining Addin.
The presentation will also go over real life scenarios to demonstrate the application of Excel DM addin.
Attendees will be able to see the role of Excel Data Mining Addin during the lyfecycle of a Data Mining and Predictive Analysis project.