Nr: 141
SQLSaturday #141 - South Florida 2012
SessionID: 10475
BI in the Cloud
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSAS (1049)
Speaker: David Liebman
Title: BI in the Cloud
Abstract:
SessionID: 11973
Introduction to Master Data Services 2012
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SQL Server 2012 (1054)
Speaker: Christopher Price
Title: Introduction to Master Data Services 2012
Abstract:
SessionID: 11976
SSIS Moving Beyond the Script Task Script Compon
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSIS (1048)
Speaker: Christopher Price
Title: SSIS Moving Beyond the Script Task Script Compon
Abstract:
Move beyond the script task and script component and you’ll find one of the often overlooked aspects of Integration Services is the extensibility options that are available. We will dive into a world of .Net code and discover your options for extending your SSIS Packages with custom objects. We will explore both custom task and data flow components as we develop from the ground up a set of reusable SSIS components using managed code.
SessionID: 13276
Deep Dive into Indexes (Part 1)
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: DBA (1047)
Speaker: Dmitri Korotkevitch
Title: Deep Dive into Indexes (Part 1)
Abstract:
This session dives into the internals of SQL Server and covers various topics such as index physical structure, how and when indexes are used, how to design efficient indexing strategy and perform the index tuning of the system.
SessionID: 13277
Deep Dive into Indexes (Part 2)
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: DBA (1047)
Speaker: Dmitri Korotkevitch
Title: Deep Dive into Indexes (Part 2)
Abstract:
This session dives into the internals of SQL Server and covers various topics such as index physical structure, how and when indexes are used, how to design efficient indexing strategy and perform the index tuning of the system.
SessionID: 13612
Using With in SQL
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: DEV (3031)
Speaker: Eduardo Blumenfeld
Title: Using With in SQL
Abstract:
The With statement is a really powerful for SQL queries that allows to improve readability, simplify maintenance and create very complex queries by dividing the task in small chunks.
This session will go from simple examples to more involved recursive ones.
SessionID: 15026
KEYNOTE SESSION: What Happens Next
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: John Schneyer
Title: KEYNOTE SESSION: What Happens Next
Abstract:
KEYNOTE SESSION
SessionID: 15674
Looney Tuner? No, there IS a method to my madness
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: Other (1052)
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: 16573
Mobile Business Intelligence for Everyone, Now!
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Jen Stirrup
Title: Mobile Business Intelligence for Everyone, Now!
Abstract:
Microsoft has made serious commitments to mobile Business Intelligence, announced at SQLPass Summit 2011. What is the roadmap? What's available right now, and how can it be implemented at your organisation?
Come to this session to learn about mobilising Business Intelligence using Sharepoint, Reporting Services, SQL Azure, Excel Services and Power Pivot. Yes, it is possible to have mobile Business Intelligence in your organisation, and come to this session in order to learn how!
SessionID: 16574
SQL Server 2012: Business Intelligence Data Viz
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSAS (1049)
Speaker: Jen Stirrup
Title: SQL Server 2012: Business Intelligence Data Viz
Abstract:
The new Business Intelligence and Data Visualisation functionality are key to the changes in SQL Server 2012. We will take a look at:
- Power View and its impact for Data Visualisation
- PowerPivot improvements and new features
- Reporting Services and its future in Sharepoint
Come to this session in order to 'hit the ground running' with Business Intelligence and Data Visualisation in SQL Server 2012.
SessionID: 16900
DW/BI: 0 to 60 and beyond!
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSAS (1049)
Speaker: Josh Kodi
Title: DW/BI: 0 to 60 and beyond!
Abstract:
SessionID: 16982
Clean Up On Column 3
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSIS (1048)
Speaker: James McAuliffe
Title: Clean Up On Column 3
Abstract:
Using Data Quality Services to Clean Up Your Mess
It’s happened to all of us. Reach for the jar at the grocery store and…. “Clean up on Aisle 3!”. Well, what happens if the jar you are reaching for is full of data? And it’s bad data? And you got it alllll over the place? This session will deal with techniques for finding bad data, organizing and fixing it, and incorporating the new features of Data Quality Services to help you in your efforts.
This document will talk about Data Quality issues, and how using Microsoft’s new Data Quality Services (SSDQS) feature in SQL 2012
SessionID: 17448
New T-SQL features in SQL Server 2012
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SQL Server 2012 (1054)
Speaker: Richie Rump
Title: New T-SQL features in SQL Server 2012
Abstract:
With the introduction of SQL Server 2012 data developers have new ways to interact with their databases. This session will review the powerful new analytic windows functions, new ways to generate numeric sequences and new ways to page the results of our queries. Other features that will be discussed are improvements in error handling and new parsing and concatenating features.
SessionID: 18625
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Devin Knight
Abstract:
SessionID: 18626
Extending Reporting Services with Custom Code
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Devin Knight
Title: Extending Reporting Services with Custom Code
Abstract:
SessionID: 19000
Extremely Fast Dimension Updates with CDC and CT
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSIS (1048)
Speaker: Luis Figueroa
Title: Extremely Fast Dimension Updates with CDC and CT
Abstract:
In this session Luis will demonstrate how to use Change Tracking and Change Data Capture to very quickly update data warehouse dimensions. He will also cover the new Change Data Capture functionality included in SSIS 2012.
SessionID: 19902
Basic Intro to PowerShell for the DBA
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: DEV (3031)
Speaker: Maximo Trinidad
Title: Basic Intro to PowerShell for the DBA
Abstract:
SessionID: 19903
PowerShell Query for the T-SQL Developer
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: DEV (3031)
Speaker: Maximo Trinidad
Title: PowerShell Query for the T-SQL Developer
Abstract:
SessionID: 21713
Mining XML Query Plans
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: DEV (3031)
Speaker: Sebastian Meine
Title: Mining XML Query Plans
Abstract:
SessionID: 22346
Tips Tricks for dynamic SSRS Reports
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSRS (1053)
Speaker: Pam Shaw
Title: Tips Tricks for dynamic SSRS Reports
Abstract:
In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.
SessionID: 22347
Taking the Scary out of Monster Reports
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSRS (1053)
Speaker: Pam Shaw
Title: Taking the Scary out of Monster Reports
Abstract:
So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services 2008 R2 to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.
SessionID: 24415
SQL 2012 BI Capabilities in SharePoint 2010
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SQL Server 2012 (1054)
Speaker: Shervin Shakibi
Title: SQL 2012 BI Capabilities in SharePoint 2010
Abstract:
SessionID: 24905
Designing An Efficient Replication Topology
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: DBA (1047)
Speaker: Chad Churchwell
Title: Designing An Efficient Replication Topology
Abstract:
This session will cover aspects regarding your data and business that should drive design decisions when architecting a replication topology. Discussed will be design decisions for snapshot, transactional, and merge replication. Also discussed will be agent profiles and optimizations for replication. What type of replication to use to solve specific business needs will also be covered.
SessionID: 26093
Are you spatially aware?
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSRS (1053)
Speaker: Telmo Sampaio
Title: Are you spatially aware?
Abstract:
SessionID: 26688
It's TEMPDB Why Should You Care?
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: DBA (1047)
Speaker: Tim Radney
Title: It's TEMPDB Why Should You Care?
Abstract:
TEMPDB is just for temporary data right? It is installed by default and gets recreated each time SQL is restarted so what does it matter right? WRONG TEMPDB is a critical part of your SQL Server instance and needs special attention. In this session Tim Radney will give you insight into what uses TEMPDB, why TEMPDB is important, what are the best practices for configuring TEMPDB, what makes TEMPDB so unique, and how to determine if your TEMPDB has a contention issue. Tim will demo creating contention in TEMPDB and explain how to solve this dreadful issue. If you have systems where TEMPDB hasn't been touched since the install, you need to attend this session.
SessionID: 26689
Know Backups and Know Recovery
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: Auditorium (1124)
Speaker: Tim Radney
Title: Know Backups and Know Recovery
Abstract:
You say you have a backup strategy, but what is your recovery strategy?
In this session Tim will demonstrate several methods for performing much-needed backups and how to recover those backups to include FULL, DIFFERENTIAL, FILE GROUP, and TRANSACTION LOG. He will also demo performing a peace meal restore as well as backing up and restoring the tail end of the log after the data file becomes corrupt.
Tim will discuss industry best practices for backing up and recovering your data. The goal of this session is to educate you on the various backup strategies so you can decide which is best for your organization, demonstrate how to recover your databases, and to create the desire for you to go back and validate your current strategies
SessionID: 26778
Dimensional Design primer: What you need to know
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSAS (1049)
Speaker: Tim Costello
Title: Dimensional Design primer: What you need to know
Abstract:
Everybody wants a data warehouse. What IS a data warehouse? How is it different from a data mart? Star Schema? Snowflakes? The dimensional bus? In this session we'll cover all the key concepts you need to know to better understand what a data warehouse is and how to start building one.
SessionID: 34552
For Love or Money, Your IT Career
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: Other (1052)
Speaker: Alex Funkhouser
Title: For Love or Money, Your IT Career
Abstract:
• Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue?
• Maintaining a steady job with a direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are learning and using the latest, most marketable technologies?
In this seminar session, you will learn multiple I.T. career strategies for maximizing both the Love and the Money of your multidimensional I.T. career.
SessionID: 8861
Time Saving Tips Tricks for SSMS 2012
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SQL Server 2012 (1054)
Speaker: Aaron Nelson
Title: Time Saving Tips Tricks for SSMS 2012
Abstract:
SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff!
SessionID: 8862
PowerShell for Data Professionals
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: Other (1052)
Speaker: Aaron Nelson
Title: PowerShell for Data Professionals
Abstract:
SessionID: 9907
Divide Conquer Reporting - With Replication
Event Date: 16-06-2012 - Session time: 00:00:00 - Track: SSRS (1053)
Speaker: Anthony Sammartino
Title: Divide Conquer Reporting - With Replication
Abstract:
In this session I will go over how to separate your systems for transactional databases, and for reporting. I will cover the basics of replication, the types, which one is right for your situation, agents it creates and their purpose, provide tips, best practices, and dispel any fears you may have heard or validate them about replication.