Nr: 149
SQLSaturday #149 - Minnesota 2012
SessionID: 10469
Hadoop for the SQL Developer/DBA
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Bill Preachuk
Title: Hadoop for the SQL Developer/DBA
Abstract:
How does Apache Hadoop fit into our neat tidy database world? In this technical session we'll examine Big Data through the lense of an SQL DBA/DW guy who became a Cloudera Certified Hadoop Developer. Find out in detail what HDFS and Map/Reduce actually are. Learn what Hadoop really means to the SQL Server Professional. See demos of real-world data tasks that Hadoop can accomplish.
SessionID: 11451
Top Features of SQL 2012 Nobody Told You About
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-210: MVP-MCM
Speaker: Robert Davis
Title: Top Features of SQL 2012 Nobody Told You About
Abstract:
This isn't the same old AlwaysOn demo that everyone else is doing. This is the stuff that almost nobody is talking about, but they are very important features that will save you time, frustration, and even money. These are the top features of SQL Server 2012 that you may not even be aware of. Come learn about these really cool features and see them in action.
SessionID: 11453
Recovering from Corruption
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Robert Davis
Title: Recovering from Corruption
Abstract:
Corruption cannot always be avoided. You can take steps to ensure early detection, and you can prepare for the eventuality of it occurring, but it's not possible to completely prevent it. Early detection is your best protection against data lost due to corruption.
In this session, we will discuss the protections within SQL Server to help identify corruption and to help recover from it. We will look at the different types of corruption that could hit your database and the best way to deal with each type. Includes live demos recovering from different types of corrupt databases.
SessionID: 12363
Freaky Fast Database Development Tips
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 45
Speaker: David Valentine
Title: Freaky Fast Database Development Tips
Abstract:
Join Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, and add-ins. We guarantee you will see something you haven’t seen before, or your money back. Co-Presenter: Rick Krueger (@DataOgre)
SessionID: 12692
SRS Report Builder for Business Intelligence
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-125
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. See how SQL Report Builder allows creation of executive dashboards that display cash on hand, payables, receivables, sales, and purchase order commitments with drill-downs!
SessionID: 13063
Power View - Bringing your Data to Life!
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Dan English
Title: Power View - Bringing your Data to Life!
Abstract:
SessionID: 13188
An Intro to Columnstore Indexes in SQL Server 2012
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Derek Dai
Title: An Intro to Columnstore Indexes in SQL Server 2012
Abstract:
This session will introduce the new xVelocity Memory-Optimized Columnstore Index feature of SQL 2012. This presentation will describe what a column store index is, how this feature is used to store data by columns instead of by rows and compare the advantages and disadvantages between the two storage methods. Live demos will explore how to create columnstore indexes, when to create them, best practices for using them and typical data warehouse scenarios that can leverage the columnstore index to drastically speed up data warehouse queries, in many cases by a factor of 10 to 100, so you are equipped to start implementing this feature into your database environment.
SessionID: 13715
Practically Normal
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 2-260
Speaker: Ed Leighton-Dick
Title: Practically Normal
Abstract:
Normalizing a database - splitting apart tables into simpler, more focused tables - can yield concrete benefits, including manageability, scalability, and space savings. The concept is a central tenet of a relational database system such as SQL Server, yet far too many database professionals are unfamiliar with it. This session will present a practical primer on normalization: what it is, why it's beneficial, how to do it, and when not to do it.
SessionID: 13906
Dimensional Data Model Prototyping With PowerPivot
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: Eric Ness
Title: Dimensional Data Model Prototyping With PowerPivot
Abstract:
Data modeling is often an abstract exercise involving a lot of talk and diagrams, but little hands-on experimentation. This may still be viable in the world of transactional systems where a lack of source data prevents the modeler from quickly creating a prototype system, however in the world of dimensional modeling where source data is abundant there’s no longer a reason to treat data modeling as an academic exercise. This session will cover how to use PowerPivot for Excel to quickly create prototypes of different dimensional models to try out and discard as necessary. The features of PowerPivot which allow quick import of data from a variety of data sources will also be demonstrated.
SessionID: 13917
Beginners Guide to Execution Plans
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Eric Zierdt
Title: Beginners Guide to Execution Plans
Abstract:
This session will explore SQL Server Execution Plans. Learn how the server is processing a query, see potential pain points, how to know if an index is needed. This session is designed for intro level DBA's, designers, programmers or anyone who hasn't used Execution plans before
SessionID: 14185
Advanced Dimensional Design and Implementation
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: Fazel Haris
Title: Advanced Dimensional Design and Implementation
Abstract:
Practical, real world implementation of advanced dimensional design concepts using SQL Server Analysis Services 2012. Topics, examples and demos will include the appropriate use of Reference Dimensions, Fact Dimensions,and Many-To-Many Dimensions, to effectively architect and implement SSAS solutions that meet complex business requirements.
SessionID: 14809
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: Greg Beaumont
Abstract:
SessionID: 15012
Consulting The Good, The Bad, The Ugly
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Hope Foley
Title: Consulting The Good, The Bad, The Ugly
Abstract:
Ted Krueger will join Hope in presenting this session. Consulting is a mystical career path that is often questioned: should I do it, can I do it and why should I do it? Come join us on a discussion of the pros and cons to consulting with an emphasis on SQL Server and Microsoft Technologies. We'll field questions with real world experiences. Once you leave this open floor session, you'll be able to make better choices in your own professional development and how consulting may or may not effect it.
SessionID: 15479
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Ira Warren
Abstract:
SessionID: 15829
Posh Eye for the BI Guy
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: Jason Horner
Title: Posh Eye for the BI Guy
Abstract:
In this session we will explore the many ways that PowerShell can help
with all aspects of the software development process.
Including Development, Deployment, and Administration. Specific
products in the stack covered will be SQL Server Reporting Services
(SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis
Services (SSAS). We will spend time going over some basic project
structure and configuration management best practices as well. Some
previous minor exposure to PowerShell or .Net programming is assumed.
SessionID: 15898
Fast Track to Spatial Reporting
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Jason Thomas
Title: Fast Track to Spatial Reporting
Abstract:
SSRS 2008 R2 has opened a new realm of reporting possibilities by including the spatial data support. By the end of this session, you should be familiar with the basic spatial concepts, creating map reports in SSRS from different sources, drilling down on map reports, aggregating custom data in the maps and some interesting tips and tricks revolving around them.
SessionID: 16358
Master Data Services
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 2-260
Speaker: Jeff Prom
Title: Master Data Services
Abstract:
Does your company have similar data in multiple locations? Not really sure which set of data is accurate? Want to give subject matter experts the ability to maintain their own data? In this session we will cover SQL Server's solution to Master Data Management. We will talk about MDS from start to finish including installation, creating models/entities, working with data, using the new Excel add-in, security, hierarchies, views, versions, and business rules.
SessionID: 16622
The What, Why, and How of Filegroups
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-210: MVP-MCM
Speaker: Jes Schultz
Title: The What, Why, and How of Filegroups
Abstract:
SessionID: 16623
Make Your Voice Heard!
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 2-260
Speaker: Jes Schultz
Title: Make Your Voice Heard!
Abstract:
SQL Server professionals like to talk - a lot. We blog, we tweet, we answer forum questions, and more to help others. Add your voice! Learn about the different ways you can share your experience and knowledge. Once you start teaching others, you'll realize how much knowledge you have!
SessionID: 16936
Real Time big data with Microsoft StreamInsight
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 2-260
Speaker: Jeff Krebsbach
Title: Real Time big data with Microsoft StreamInsight
Abstract:
SessionID: 17120
Resolving Cardinality Estimate Issues
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-210: MVP-MCM
Speaker: Joe Sack
Title: Resolving Cardinality Estimate Issues
Abstract:
SessionID: 17738
Getting to Know Index Operation Stats
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Jason Strate
Title: Getting to Know Index Operation Stats
Abstract:
SessionID: 17742
The Creepy DBA, How to Stalk Your Users
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Jason Strate
Title: The Creepy DBA, How to Stalk Your Users
Abstract:
Do you know when your users are using the production login accounts from their workstations? Are you aware of changes being made to the development servers that may impact future deployments? Has the new Junior DBA start giving out access like candy? As DBAs, we are responsible for knowing and acting on all of this and much more. Fortunately, SQL Server provides a number of features that you can use to monitor and track user activity. In this session, we’ll look at these features and demonstrate how you can use them to the extent that your users find you creepy!
SessionID: 18383
Break it up! Implement Table Partitioning
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Kirby Richter
Title: Break it up! Implement Table Partitioning
Abstract:
Tables getting big? Not allowed to delete the data? Consider table partitioning a great way to help manage large tables. It is also useful for implementing a data retention and archiving strategy.
SessionID: 18897
Locks, Blocks, and Deadlocks
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Kyle Neier
Title: Locks, Blocks, and Deadlocks
Abstract:
SessionID: 18950
Big Data
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Lara Rubbelke
Title: Big Data
Abstract:
Drill into Microsoft's Big Data solution and learn how to derive the most value from all your data, including previously untapped unstructured data. Microsoft’s Big Data solution offers breakthrough insights by enabling customers to combine the richness of relational data from databases with unstructured data from Hadoop.
SessionID: 19639
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: Mark Vaillancourt
Abstract:
SessionID: 20063
PowerShell 101
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Merrill Aldrich
Title: PowerShell 101
Abstract:
If you haven't dug in to PowerShell at this point, you're missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work.
SessionID: 21772
Real-Time Analytics with SSAS Tabular DirectQuery
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: Paul Doyle
Title: Real-Time Analytics with SSAS Tabular DirectQuery
Abstract:
In this session we will explore how SQL Server Analysis Services Tabular running in DirectQuery mode can be used to power real-time analytics. In DirectQuery mode the data is guaranteed to be up-to-date, no refreshing or processing is necessary, because DirectQuery mode queries data that is stored in a SQL Server database. We will provide concepts and step-by-step examples of setting up a BI Semantic Model, including security, best practices for getting the most out of Power View and the differences between DirectQuery and the In-Memory VertiPaq cache, so you are equipped to start building real-time analytics solutions with SSAS and Power View.
SessionID: 22391
Quest Software Session - TBD
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Paul Timmerman
Title: Quest Software Session - TBD
Abstract:
Quest Software Session - TBD
SessionID: 23021
SSRS: Reporting on Reports
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Rick Krueger
Title: SSRS: Reporting on Reports
Abstract:
Co-Presenter: Dave Valentine (@IngeniousSQL)
SessionID: 23456
GeoGRAPHY and GeoMETRY Spatial Data Types
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 2-260
Speaker: Ross McNeely
Title: GeoGRAPHY and GeoMETRY Spatial Data Types
Abstract:
SessionID: 23984
SQL server 2012 - Contained Database
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 54
Speaker: Sarita Garg
Title: SQL server 2012 - Contained Database
Abstract:
One of the new exciting features of SQL server 2012 is called Contained Database. We will explore what is contained database, what is partially contained database, what are its components, benefits of using it, some of the limitations, contained database authentication and security best practices, and how to migrate a partially contained database.
SessionID: 24310
Anatomy of a Join
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Luke Jian
Title: Anatomy of a Join
Abstract:
SessionID: 24975
Advancements in CDC with SSIS in SQL 2012
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 54
Speaker: MIKE DONNELLY
Title: Advancements in CDC with SSIS in SQL 2012
Abstract:
There are some great new tasks in SSIS 2012 to take advantage of (CDC) Change Data Capture. I'll walk you through adding CDC to your database and tables and then updating incremental changes using the New CDC Control Task, CDC Source and CDC Splitter.
SessionID: 25789
A Window into Your Data: Using SQL Window Function
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 45
Speaker: Steve Hughes
Title: A Window into Your Data: Using SQL Window Function
Abstract:
Window functions are an underused feature in T-SQL. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join us for a demo filled session on SQL window functions.
SessionID: 26086
Merge Replication for Offline Data Mobility
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-210: MVP-MCM
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: 26545
SQL Bonsai - Identifying dead schema
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Ben Thul
Title: SQL Bonsai - Identifying dead schema
Abstract:
In order to keep your database schema healthy, you need to trim unused tables from time to time. In this session, we'll cover how to use the procedure cache and SQL audit to show you where to start pruning!
SessionID: 27992
Documenting Your Integrated Microsoft BI Solution
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-125
Speaker: William E Pearson III
Title: Documenting Your Integrated Microsoft BI Solution
Abstract:
Having implemented BI solutions for years, I have found documentation to be a task too often resisted until late in the project, when it is hastily and incompletely prepared in remaining hours. Because the integrated Microsoft BI solution comprises multiple application layers, it is challenging to generate documentation about the whole solution in a single, unified document. In this presentation I will share approaches I’ve come to use in assembling documentation that “covers all the bases.”
SessionID: 28004
Design and Implement BI Like Edison!
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-210: MVP-MCM
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.
SessionID: 28293
A Powershell Driven Life
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 56
Speaker: Zach Mattson
Title: A Powershell Driven Life
Abstract:
No SSIS or Powerpoint will be harmed during this presentation.
SessionID: 8892
Writing Professional Database Code
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-180
Speaker: Aaron Lowe
Title: Writing Professional Database Code
Abstract:
SessionID: 9163
A Complete BI Solution in About an Hour!
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Keller 3-115
Speaker: Aaron King
Title: A Complete BI Solution in About an Hour!
Abstract:
In this presentation Aaron will cover how to collect data from multiple SQL Servers using SQL Server 2008 Integration Services (SSIS). Then he will use SQL Server Reporting Services (SSRS) to report detail on that data. After that he will use SQL Server Analysis Services (SSAS) to create a KPI. Finally he’ll present that KPI on a dashboard via a web page. The goal of this presentation is to show how seamless the Microsoft Business Intelligence products are. If you’ve only used a few of these products, you’ll appreciate seeing them together all at once. Code will be provided.
SessionID: 9352
Beginning TSQL Tips and Tricks
Event Date: 29-09-2012 - Session time: 00:00:00 - Track: Rapson 43
Speaker: Andy Lohn
Title: Beginning 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.