Nr: 110
SQLSaturday #110 - Tampa 2012
SessionID: 10786
Reporting Services Deep Dive
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Brian 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: 14060
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Eddie Wuerch
Abstract:
SessionID: 16299
Rewriting bad T-SQL Code
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Jeffrey Garbus
Title: Rewriting bad T-SQL Code
Abstract:
SessionID: 16991
It's In There Somewhere!
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: James McAuliffe
Title: It's In There Somewhere!
Abstract:
FileTable and Statistical Semantic Search In SQL 2012
It’s like having the biggest junk drawer EVER. That’s often what our “Document Repositories” become. You know you have that golden nugget of information that you’re searching for, and it’s in there somewhere, but you can’t find it. Using the new features of Statistical Semantic Search in SQL 2012 is like having a closet organizer on staff at all times. While full-text search lets you query the words in a document, semantic search lets you query the meaning of the document. New scenarios we will explore will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content.
SessionID: 17390
STOP! Consolidate and Listen!
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Jorge Segarra
Title: STOP! Consolidate and Listen!
Abstract:
SessionID: 17452
Introduction to Project Management
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Richie Rump
Title: Introduction to Project Management
Abstract:
SessionID: 17996
The Dirty Business of Auditing
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Brian Kelley
Title: The Dirty Business of Auditing
Abstract:
SessionID: 18055
Building Your Own SQL Server Virtual Playground
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Kendal Van Dyke
Title: Building Your Own SQL Server Virtual Playground
Abstract:
As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up clustering? Or maybe you want to try out the latest SQL 2012 release candidate...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.
SessionID: 18997
Super Fast Data Warehouse Dimension Loading
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Luis Figueroa
Title: Super Fast Data Warehouse Dimension Loading
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 cover different SQL Server 2008 scenarios and the new Change Data Capture functionality in SSIS 2012.
SessionID: 20379
Running SQL Server 2012 on Server Core: Why How
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Michael Wells
Title: Running SQL Server 2012 on Server Core: Why How
Abstract:
Do you cringe every time "Patch Tuesday" rolls around? Does the idea of applying 70-80% fewer Windows patches on your SQL Servers appeal to you? Join us and learn about this and other benefits that can be achieved by running SQL Server 2012 (Denali) on the Core edition of Windows Server. While Core edition has been used primarily for infrastructure servers like Domain Controllers and DNS servers, SQL Server 2012 now brings support for running the database engine. This session will talk about when you may want to consider running SQL on Server Core and will guide you through the task of installing and configuring your server when you no longer have most of the Windows configuration tools that you may be used to.
SessionID: 21717
Index Internals
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Sebastian Meine
Title: Index Internals
Abstract:
SessionID: 23167
Slowly Changing Dimensions
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Robert Hatton
Title: Slowly Changing Dimensions
Abstract:
Nearly every Data Warehouse, Data Mart, or OLAP Cube is challenged by changes over time. How do you report on a store that was in a different territory last year? What do you do when a product changes categories?
This session will show you how to design SQL Tables that model time and accurately model changes over time.
SessionID: 23609
SkyDrive and Phone 7 App Photos!
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Russell Fustino
Title: SkyDrive and Phone 7 App Photos!
Abstract:
When you are working on a project that involves photos, where are you going to store your photos? How will you review your photos? A free solution would be nice, huh? ? Lots of storage would be nice as well! How about using photos in a Phone 7 app?Answer… SkyDrive. It’s great! It is a solution to for easy free way to share, print, download and review photos from just an individual, or from a team of multiple editors. To check, it out ahead of time, go to http://skydrive.live.com and the developer portal at: http://msdn.microsoft.com/en-us/windowslive. We will take a look at the SkyDrive Connect API’s and the SkyDrive Phone 7 app as well!
SessionID: 28698
SQL Server Security for Developers
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Andy Warren
Title: SQL Server Security for Developers
Abstract:
SQL Server has a robust and granular system for granting and denying access to users, but all too often we see applications running as DBO or even sysadmin. Why? Part of is that same granular system can be overwhelming and part is that many developers don't see the point in applying such granular security. In this introductory level presentation we'll start at the beginning with creating and managing logins, take a quick look at system roles, and then get into the nitty gritty of users and roles and permissions at the database level. Along the way we'll talk about why its so important to set security at the database and not just rely on the application enforced security.
SessionID: 28950
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Allen White
Abstract:
SessionID: 29070
BI in the Cloud
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: David Liebman
Title: BI in the Cloud
Abstract:
SessionID: 29370
Intro to SSRS
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Chris Albrektson
Title: Intro to SSRS
Abstract:
Are you still ramping up on SSRS? In this session Chris will show you how to create your first SSRS report. In this session we will cover all of the basics including some best practices to get you up to speed when creating reports. This session was designed for someone with little to no experience with SSRS.
SessionID: 29547
What's Buried in the Plan Cache?
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Christina Leo
Title: What's Buried in the Plan Cache?
Abstract:
Creating a query plan can be a time consuming and expensive process. To avoid repeating these potentially costly steps, SQL Server stores its query plans, in the plan cache where they can be reused as needed.
In this session, we’ll look at how the plan cache is organized, what plans are saved, when plans are reused and when they are recreated, methods for observing the contents of the plan cache, and finally, methods for manipulating plan reuse and recreation.
SessionID: 29614
Introduction to Master Data Services 2012
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Christopher Price
Title: Introduction to Master Data Services 2012
Abstract:
SessionID: 29785
SQL Report Builder for Business Intelligence
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: David Eichner
Title: SQL Report Builder for Business Intelligence
Abstract:
Learn how easy it is to utilize the free download from Microsoft that allows users to create maps, charts, dashboard objects and reports against any kind of data easily without having to use Visual Studio.
SessionID: 29914
Service Broker - Why, When and Where?
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Dmitri Korotkevitch
Title: Service Broker - Why, When and Where?
Abstract:
Messages, Queues, Contracts, Services, Routes, Endpoints, Transport and Dialog security…What could be easier to understand? While complexity of implementation is one of the factors that make us afraid of using service broker there is another one - we often don't recognize the use cases where service broker would benefit a system.
This session focuses on the latter case. While it provides very high level overview of Service Broker Architecture, the goal of this presentation is to discuss WHEN to use Service Broker. This session outlines several service broker-friendly patterns and shows a few examples based on real life Service Broker implementations in both centralized and distributed systems.
SessionID: 30299
Introduction to Execution Plan
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Nathan Heaivilin
Title: Introduction to Execution Plan
Abstract:
SessionID: 30479
Don't Panic, DBAs! Databases on VMware made easy.
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
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: 30496
Introduction to PowerShell Remoting
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Jason Hofferle
Title: Introduction to PowerShell Remoting
Abstract:
The release of PowerShell version 2 introduced a new technology for managing Windows computers remotely. Everyone from desktop support to enterprise administrators can benefit from the capabilities available with PowerShell Remoting. Learn how it works, what it can do and why you want it enabled in your environment.
SessionID: 30596
What is BI Semantic Model and why should you care?
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Jose Chinchilla
Title: What is BI Semantic Model and why should you care?
Abstract:
Microsoft has shifted gears towards the new Business Intelligence Semantic Model (BISM) in SQL Server 2012. But what does it mean to Analysis Services cube developers? Join Jose to understand what BISM is and the Analysis Services roadmap. Jose will demo how to develop and deploy BISM models to the new Vertipaq engine and how to interface with them.
SessionID: 30690
Mobile Business Intelligence
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Jen Underwood
Title: Mobile Business Intelligence
Abstract:
SessionID: 30818
Little in the middle but got much [Write]Back
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Josh Fennessy
Title: Little in the middle but got much [Write]Back
Abstract:
Often missing from many BI projects is the ability for users to quickly and effectively submit data BACK to the reporting system. Luckily, when these reporting systems are built from a SSAS cube foundation, we have a potential answer.
Writeback is often an underused feature in SSAS cubes. In this session, attendees will learn how to create their own writeback partitions, and create end user interfaces to submit data to them in Excel. Also a deep-dive into the architecture of the writeback implementation in SSAS will be covered, as well as some limitations to the technology that are important to know before designing a solution.
SessionID: 30841
AlwaysOn - Finally, A usable 'mirror'!
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Jim Murphy
Title: AlwaysOn - Finally, A usable 'mirror'!
Abstract:
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We'll also test automatic fail-over using a real web app to see how well this feature works.
SessionID: 31440
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Devin Knight
Abstract:
SessionID: 31646
PowerShell query for the T-SQL Developer
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Maximo Trinidad
Title: PowerShell query for the T-SQL Developer
Abstract:
SessionID: 31692
SQL 2012 DMV's Extended Events
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Gareth Swanepoel
Title: SQL 2012 DMV's Extended Events
Abstract:
As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts Rodents of unusual size. In this session, come and learn how to map your way through these threats using new and improved DMV's and Extended Events.
SessionID: 31728
SharePoint BI: The Basic Environment
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Michael Hinckley
Title: SharePoint BI: The Basic Environment
Abstract:
SessionID: 31789
SQL - External Data Source for SharePoint Office
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Michael Antonovich
Title: SQL - External Data Source for SharePoint Office
Abstract:
In this session, we will examine how to create connections to an external data source (SQL Server) using SharePoint Designer. Once the External Data Content Type exists, we can display and manipulate the data within SharePoint using an External List. But you will see in this session that you can also surface the data to Outlook and use the data in a disconnected mode. You will also see how to use external data sources within a Word document template with the assistance of QuickParts. The final demonstration (time permitting) shows how you can use the external data in an InfoPath form.
SessionID: 32543
Loading a Data Warehouse with SSIS
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Robert Biddle
Title: Loading a Data Warehouse with SSIS
Abstract:
SessionID: 32579
Tame Your Unruly Data...With Constraints!
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Rob Volk
Title: Tame Your Unruly Data...With Constraints!
Abstract:
Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
SessionID: 32580
Revenge: The SQL!
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Rob Volk
Title: Revenge: The SQL!
Abstract:
Have you been wronged, cheated, lied to, lied about, or deceived by a coworker? Feel like your DBA position offers no opportunity for revenge? WRONG! This session is a light-hearted exploration of some delightfully mischievous SQL design patterns that will annoy, aggravate, and antagonize anyone who has to work with them. (But they deserved it!) Learn how to: create tables with no names; columns with duplicate names; and write perfectly valid yet utterly nonsensical SQL. You may never get to use these techniques…but you'll ache for the chance!
SessionID: 33274
Design considerations for Enterprise datawarehouse
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Dr. Suresh Rajappa
Title: Design considerations for Enterprise datawarehouse
Abstract:
This dession discusses the common design pitfalls when implementing EDW and how to avoid them. This session includes the realworld example too.
SessionID: 33556
Fundamentals of Join Operations
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Kevin Boles
Title: Fundamentals of Join Operations
Abstract:
SessionID: 33558
Transaction Log Deep Dive
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Kevin Boles
Title: Transaction Log Deep Dive
Abstract:
Time for another deep dive from TheSQLGuru, this time on the transaction log. Architecture and internals, monitoring, tuning/optimizing will all be covered. A great learning experience on another pillar of the SQL Server relational engine.
SessionID: 33882
Table Vars Temp Tables - What you NEED to Know!
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: Wayne Sheffield
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 34307
Design and Implement BI Like Edison!
Event Date: 10-03-2012 - Session time: 00:00:00 - Track:
Speaker: William E Pearson III
Title: Design and Implement BI Like Edison!
Abstract:
As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.