Nr: 130
SQLSaturday #130 - Jacksonville 2012
SessionID: 10134
Page Row Compression How, When, Why in SQL 2012
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 2. DBA (Auditorium 2)
Speaker: Bradley Ball
Title: Page Row Compression How, When, Why in SQL 2012
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. In SQL 2012 we add Spatial Data Types. 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: 10479
BI in the Cloud
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 3. Personal Dev Azure
Speaker: David Liebman
Title: BI in the Cloud
Abstract:
SessionID: 10505
Develop Faster with SQL Server 2012
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 1. BI (Auditorium 1)
Speaker: Brian Knight
Title: Develop Faster with SQL Server 2012
Abstract:
SessionID: 11155
Building your First Cube with SSAS
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 1. BI (Auditorium 1)
Speaker: Chris Albrektson
Title: Building your First Cube with SSAS
Abstract:
So now that your data warehouse is complete now what? In this session Tom will show you how to create your first fully functional Cube in 1 hr. In this session we will cover all of the basics including some best practices to get you up to speed when working with analysis services. This session was designed for someone with little to no experience with SSAS.
SessionID: 11608
SQL Server Internals: It's What's for Dinner!
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 2. DBA (Auditorium 2)
Speaker: Christina Leo
Title: SQL Server Internals: It's What's for Dinner!
Abstract:
Ever wondered what happens under the hood when you query your SQL Server database? Well, it’s somewhat like asking for a special meal for dinner. During this session, I will use a cooking analogy to describe the life cycle of a query and the journey it takes through SQL Server’s working parts. By comparing the concepts of SQL Internals to a familiar idea, you will have a clear understanding of the underlying processes involved in returning data from a SELECT query. Once we’ve established a frame of reference for a simple read operation, we’ll look at an UPDATE statement and consider the additional factors associated with a write operation. By session's end you should have a clear overview of what happens when a query hits your server.
SessionID: 11651
I am a DBA! Why do I care about Scrum?
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 3. Personal Dev Azure
Speaker: Christopher Daily
Title: I am a DBA! Why do I care about Scrum?
Abstract:
This session will provide an overview of Scrum and answer the reason why a DBA should care about Scrum.
SessionID: 11965
Integrating DQS, MDS and Your Data Warehouse
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 4. BI Data Warehouse
Speaker: Christopher Price
Title: Integrating DQS, MDS and Your Data Warehouse
Abstract:
With SQL Server 2012 it has never been easier to empower your data stewards and give them greater control over the data management process. Dive in as we integrate Master Data Services and Data Quality Services into a data warehouse. We will explore how Master Data Services and the new plugins available in 2012 can facilitate the management of your organization’s master data. A look at Data Quality Services will highlight how it can be leveraged to provide value to the data management process through its cleansing and matching capabilities. Finally, we evaluate the options available to integrate back into the data warehouse.
SessionID: 12694
SRS Report Builder for Business Intelligence
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 6. BI
Speaker: David Eichner
Title: SRS 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: 13272
Deep Dive into Indexes (Part 1)
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 5. DBA
Speaker: Dmitri Korotkevitch
Title: Deep Dive into Indexes (Part 1)
Abstract:
SessionID: 13273
Deep Dive into Indexes (Part 2)
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 5. DBA
Speaker: Dmitri Korotkevitch
Title: Deep Dive into Indexes (Part 2)
Abstract:
SessionID: 13499
MDX 101: An Introduction to MDX
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 4. BI Data Warehouse
Speaker: Dustin Ryan
Title: MDX 101: An Introduction to MDX
Abstract:
SessionID: 14027
An Introductory Look at Execution Plans
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 5. DBA
Speaker: Eric Wisdahl
Title: An Introductory Look at Execution Plans
Abstract:
SessionID: 15784
PowerShell for Beginners
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 6. BI
Speaker: Jason Hofferle
Title: PowerShell for Beginners
Abstract:
SessionID: 15895
Advanced Charting Techniques in SSRS
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 6. BI
Speaker: Jason Thomas
Title: Advanced Charting Techniques in SSRS
Abstract:
SSRS 2008 R2 has been a game changer for SQL Server in terms of visualization techniques. With a wide range of available options for charting, BI professionals struggle to get familiar with even the basic functionalities of most charts.
This session will talk about the basic functionalities of all the charts as well as some advanced tips and tricks around them. Come to this session and take your charting skills to the next level.
SessionID: 16987
It’s In There Somewhere!
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 5. DBA
Speaker: James McAuliffe
Title: It’s In There Somewhere!
Abstract:
Focus: 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. This session explores a new feature of SQL 2012 called Statistical Semantic Search. It's 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 look into will include automatic tag extraction, related content discovery, and hierarchical navigation across similar content.
SessionID: 17187
Handling Advanced Data Warehouse Scenarios in SSIS
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 4. BI Data Warehouse
Speaker: John Welch
Title: Handling Advanced Data Warehouse Scenarios in SSIS
Abstract:
So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance.
SessionID: 17348
Surviving Your Sql Developer Interview
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 3. Personal Dev Azure
Speaker: Jonathon Moorman
Title: Surviving Your Sql Developer Interview
Abstract:
This session will describe what to expect when interviewing for a sql server developer position. The session will include tips to strengthen your interviewing techniques and pit falls to avoid. The session will explain why "I don't know." is a perfectly acceptable answer and when it's okay to brag.
SessionID: 17374
SSIS Programming Using .NET
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 6. BI
Speaker: Jorge Novo
Title: SSIS Programming Using .NET
Abstract:
Learn the secrets of how to build SSIS Packages using the .NET Library.
Build your packages using Metadata tables without the need of Integration Services.
Create standard templates, add or modified existing Components on the fly.
Create Custom SSIS Components for your organization.
SessionID: 17385
SQL University: Back That Thang Up!
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 2. DBA (Auditorium 2)
Speaker: Jorge Segarra
Title: SQL University: Back That Thang Up!
Abstract:
In this session we cover backups and restores from beginning to end. Want to know how to do point-in-time restores? Don't understand what the different recovery models mean? How do you handle backups for different size databases? All of these questions and more will be answered in this session.
SessionID: 18633
Choosing a Microsoft Reporting Technology
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 1. BI (Auditorium 1)
Speaker: Devin Knight
Title: Choosing a Microsoft Reporting Technology
Abstract:
SessionID: 18884
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 4. BI Data Warehouse
Speaker: Kyle Walker
Abstract:
SessionID: 19386
The New SSIS in SQL 2012
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 1. BI (Auditorium 1)
Speaker: Mike Davis
Title: The New SSIS in SQL 2012
Abstract:
SessionID: 20028
The Fangorn Forest - ColumnStore Indexes
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 2. DBA (Auditorium 2)
Speaker: Gareth Swanepoel
Title: The Fangorn Forest - ColumnStore Indexes
Abstract:
SessionID: 20436
Jax IT - Trends, Demand Landing the Job
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 3. Personal Dev Azure
Speaker: Mike Maglin
Title: Jax IT - Trends, Demand Landing the Job
Abstract:
SessionID: 20470
Hello, My Name Is DAX
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 4. BI Data Warehouse
Speaker: Michael Antonovich
Title: Hello, My Name Is DAX
Abstract:
For anyone doing serious work with PowerPivot, you know that you must sometimes create additional columns calculated from the data in your existing data sources. If your data source is SQL Server, you could do this in SQL directly by jusst connecting to a custom view. However, for most other data sources (and for those users without develo9pment access to SQL Server) the best alternative is building expressions in PowerPivot to define new columns. This session will explore DAX functions and expressions and how they differ from Excel expressions.
SessionID: 20985
SQL Server 2012 Data Mining Add-ins for Office
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 6. BI
Speaker: Mike Milligan
Title: SQL Server 2012 Data Mining Add-ins for Office
Abstract:
Take advantage of SQL Server predictive analytics in Office Excel 2010 and Office Visio 2010.!
•Table Analysis Tools for Excel: Provides easy-to-use tasks that leverage SQL Server 2012 data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance.
•Data Mining Client for Excel: You can create, test, explore, and manage data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance.
•Data Mining Templates for Visio: Enables you to render and share your mining models as annotatable Visio 2010 drawings.
SessionID: 21583
Indexing your Data Warehouse
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 4. BI Data Warehouse
Speaker: Troy Gallant
Title: Indexing your Data Warehouse
Abstract:
SessionID: 22342
Taking the Scary out of Monster Reports
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 6. BI
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: 23326
Lego Sets: Relational Building Blocks
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 5. DBA
Speaker: Rob Volk
Title: Lego Sets: Relational Building Blocks
Abstract:
Do your eyes glaze over at the mention of tuples, domains, or even basic SQL terms? Have you moved to SQL Server from MS Access, or Excel, or other non-relational database products? This session will help explain the basics of set theory and relational theory using actual Lego blocks. We will illustrate terms and concepts such as joins, unions, and set-based operations, and how you can translate them into actual SQL. If you're an absolute beginner to SQL, or feel overwhelmed by the baggage of computer data models, or would just like to play with Legos, you'll both enjoy and learn something during this session.
SessionID: 24404
Into to SSIS
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 3. Personal Dev Azure
Speaker: Shawn Harrison
Title: Into to SSIS
Abstract:
SessionID: 24907
SQL Server 2012 AlwaysOn for HA and DR
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 2. DBA (Auditorium 2)
Speaker: Chad Churchwell
Title: SQL Server 2012 AlwaysOn for HA and DR
Abstract:
This presentation will focus on the concepts behind AlwaysOn, benefits it provides, and a demo of setting up AlwaysOn Availability groups
SessionID: 25121
Monitoring Databases in a Virtual Environment
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 2. DBA (Auditorium 2)
Speaker: Thomas LaRock
Title: Monitoring Databases in a Virtual Environment
Abstract:
SessionID: 26022
Job Common Sense 101 - Don't be that Guy!!
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 3. Personal Dev Azure
Speaker: Tom Brenneman
Title: Job Common Sense 101 - Don't be that Guy!!
Abstract:
In this session, Tom will go over how to avoid common mistakes when seeking a job. Users will take away how to help better prepare and present themselves in seeking new opportunities.
SessionID: 26321
SQL Server 2012 TSQL Enhancements and Additions
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 5. DBA
Speaker: Kevin Boles
Title: SQL Server 2012 TSQL Enhancements and Additions
Abstract:
The breadth and depth of improvements in TSQL coming out with SQL Server 2012 represent the most significant changes in, well, probably ever! This fast and furious overview will touch on a large range of these goodies, with plenty of sample code for you to take home and review at your leisure!
SessionID: 9130
Fast Track to BISM Tabular and PowerView
Event Date: 28-04-2012 - Session time: 00:00:00 - Track: 1. BI (Auditorium 1)
Speaker: Adam Jorgensen
Title: Fast Track to BISM Tabular and PowerView
Abstract:
Come learn how to get your executives and end users excited about analytics you can deliver quickly. The new Tabular features of Analysis Services are quicker and easier to develop and combine with PowerView (Crescent) to make for amazing (AND PORTABLE) visualizations that your end users will be excited about. As usual this will be all demo and you will get hands on exposure and experience with this new technology.