Nr: 118
SQLSaturday #118 - Madison 2012
SessionID: 10424
2012 TSQL Sweets
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 321
Speaker: Bill Fellows
Title: 2012 TSQL Sweets
Abstract:
The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you'll have a taste for all the sweets they've packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.
SessionID: 12020
Upgrade Roadmap: Let’s delve into SQL Server 2012
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142B
Speaker: Craig Purnell
Title: Upgrade Roadmap: Let’s delve into SQL Server 2012
Abstract:
We will review the upgrade process to SQL Server 2012. An upgrade is 75% project planning and 25% execution. Everyone knows that, right? Actually, no. A checklist of considerations a company would likely encounter coming from SQL Server 2005/2008 or R2. The pros and cons of in place upgrade vs. the build out new approach. There will be many real world lessons learned sprinkled in as the presenter has led many upgrades and migrations of SQL Server. Key takeaways include: when to upgrade in place compared to build new, usage of and how to gauge the usefulness of Upgrade Advisor, deprecated features and how to test for them
SessionID: 12813
Demystifying PowerPivot from the SharePoint Admin
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 350
Speaker: David Peterson
Title: Demystifying PowerPivot from the SharePoint Admin
Abstract:
Demystifying PowerPivot from the SharePoint Admin Perspective. PowerPivot can be a maddening undertaking to the SharePoint Admin. We'll walk through the basic architecture of PowerPivot within SharePoint. Then we'll setup an actual working PowerPivot and store it in SharePoint. We'll also walk through setting up the PowerPivot Refresh. Along the way David will share anecdotes, tips hints, SharePoint war stories, and the occasional movie quote.
SessionID: 12919
Setting up an ETL Framework with SSIS 2012
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 350
Speaker: Dave DuVarney
Title: Setting up an ETL Framework with SSIS 2012
Abstract:
In this session we will look at common elements of an ETL framework including logging, auditing and configuration. We'll dive into the new features within SSIS 2012 and how they facilitate a solid ETL framework.
SessionID: 13392
Devs are from Mars, Report Servers are from Venus
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 350
Speaker: Doug Lane
Title: Devs are from Mars, Report Servers are from Venus
Abstract:
Do you remember what it was like to fall in love? Wasn't it wonderful?
Lately it hasn't been the same. There's no spark anymore. You've been stuck doing the same old charts and tables. Maybe Reporting Services won't tell you what's wrong, and you're even thinking about seeing other reporting products.
In this session, Doug will re-ignite your passion for RS by reminding you how reports perform best, what RS has been trying to tell you (but you haven't been listening), and show you some new -- and easy -- tricks you may not have known RS can do. You'll leave knowing more about troubleshooting using the execution log, understanding how to design reports for high performance, how to deal with blank pages, and more.
SessionID: 13717
Practically Normal
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 350
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: 13902
SSMS for Non-DBA Developers
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142B
Speaker: Eric Selje
Title: SSMS for Non-DBA Developers
Abstract:
You're a database application developer who's using SQL Server now, but you're no DBA. Sure you use SQL Server Management Studio (SSMS), and maybe you're even pretty good at designing tables and executing queries. But there's a whole lot more functionality in this seemingly simple program than you may realize. In this session we'll share features in SSMS that you may have overlooked but will make your life as a developer a lot easier.
SessionID: 13942
You’re My Density: Making Sense of Statistics
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 321
Speaker: Erin Stellato
Title: You’re My Density: Making Sense of Statistics
Abstract:
The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.
SessionID: 13943
DBCC Commands: The Quick and the Dangerous
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 321
Speaker: Erin Stellato
Title: DBCC Commands: The Quick and the Dangerous
Abstract:
SessionID: 14046
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 322
Speaker: Eddie Wuerch
Abstract:
SessionID: 14179
Deep Dive in PowerPivot 2012
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 336
Speaker: Farouq Abukhamireh
Title: Deep Dive in PowerPivot 2012
Abstract:
A demo-rich presentation of PowerPivot 2012
SessionID: 15483
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142A
Speaker: Ira Warren
Abstract:
SessionID: 15891
Fast Track to Spatial Reporting
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142A
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: 19642
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 336
Speaker: Mark Vaillancourt
Abstract:
SessionID: 21513
SSIS 2012 New Features
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 336
Speaker: Norman Kelm
Title: SSIS 2012 New Features
Abstract:
SessionID: 24318
Optimizing SQL Server I/O with Solid State Drives
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 336
Speaker: Luke Jian
Title: Optimizing SQL Server I/O with Solid State Drives
Abstract:
Optimal configuration and maintenance of the I/O subsystem is critical and can ultimately be responsible for higher response times of your applications. The HDDs are by design about 1 million times slower than the memory or CPU. In this session we analyze the different options that exist for durable storage, what are their pros and cons . Solid state drives are a viable option and we are going under the covers to see how you can best use them as an alternative to a large and expensive SAN in your infrastructure
SessionID: 24725
(Way Too Much) Fun with Reporting Services
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 321
Speaker: Stacia Varga
Title: (Way Too Much) Fun with Reporting Services
Abstract:
SessionID: 24726
Data Visualization in Reporting Services
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 322
Speaker: Stacia Varga
Title: Data Visualization in Reporting Services
Abstract:
Reporting Services 2008 R2 includes several new data visualization features - sparklines, data bars, indicators, and maps. In this latest release, you now have a wide range of options for helping viewers to better understand data through visualization. In this session, you learn what's new, how best to use these new features, and how to avoid common design problems by properly applying principles of visual design.
SessionID: 24968
SSIS: Figuring Out Configuring
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 336
Speaker: MIKE DONNELLY
Title: SSIS: Figuring Out Configuring
Abstract:
As with most things in the IT world there is more than one way to skin the SSIS configuration cat.* I'll focus on SQL Server 2008 methods (being called Package Deployment method in SQL 2012) and show how to use 1)XML config files or 2)an environment variable or registry entry that points to a config database. I'll also give a brief overview of the new project deployment method in SQL 2012.
*[No cats were skinned in the making of this presentation.]
SessionID: 25784
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142A
Speaker: Steve Hughes
Abstract:
SessionID: 25786
A Window into Your Data:Using SQL Window Functions
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142A
Speaker: Steve Hughes
Title: A Window into Your Data:Using SQL Window Functions
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: 27067
10 Ways To Abuse T-SQL
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142B
Speaker: Tracy McKibben
Title: 10 Ways To Abuse T-SQL
Abstract:
Learn 10 common T-SQL mistakes and how to avoid them. Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we'll cover.
SessionID: 28292
A Powershell Driven Life
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142A
Speaker: Zach Mattson
Title: A Powershell Driven Life
Abstract:
No SSIS or Powerpoint will be harmed during this presentation.
SessionID: 29120
The Skinny on Data Compression
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142A
Speaker: Bob Pusateri
Title: The Skinny on Data Compression
Abstract:
SessionID: 30653
SQL 2012 -- All About HA and DR
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 322
Speaker: Joseph D'Antoni
Title: SQL 2012 -- All About HA and DR
Abstract:
Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start. In this presentation you'll learn all about the new DR features in SQL Server 2012 and see them in practice.
SessionID: 30784
Filegroups: Putting the Puzzle Together
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 321
Speaker: Jes Schultz
Title: Filegroups: Putting the Puzzle Together
Abstract:
SessionID: 30813
Administering the BI Stack
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142B
Speaker: Josh Fennessy
Title: Administering the BI Stack
Abstract:
More often than not, a SQL DBA will also be requested (or required) to administer other applications in the SQL universe. These applications are often the BI stack, SSIS, SSRS, and SSAS. In this session, you will learn not only what each of these applications does, but also some behind the scenes views into how they work. At the end of this session, you will have a better feeling of what to look for when something goes wrong, and have the knowledge to be proactive with your Business Intelligence implementations.
This session will focus on the SSIS, SSRS, and SSAS engines in this session. Not a session for developers, we will be focusing on the ADMINISTRATION of these applications/services only.
SessionID: 31125
Holy Crap! Someone Put the Database in the Cloud
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 321
Speaker: Jason Strate
Title: Holy Crap! Someone Put the Database in the Cloud
Abstract:
The world of databases is constantly changing. It used to be that we kept all of our servers and data locked up in big, expensive server rooms in the back of the building. Now days, you hear about data existing in this cloud-thing. So what happens when you come in on Monday morning and the latest database was deployed in the cloud. In this session, we’ll look at what it means to be a DBA with SQL Azure and how the more things change the more they stay the same.
SessionID: 32031
SQL 2012 AlwaysOn Configuration Deep Dive
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 322
Speaker: Michael Steineke
Title: SQL 2012 AlwaysOn Configuration Deep Dive
Abstract:
Brief overview of AlwaysOn features, then dive into what you need to consider when implementing these new features. This session will be interactive, with demos and systems refer to. Bring ideas and questions on how to make this work in the real world. We will discuss the entire infrastructure needed to support DR and HA, and why you need to have a very good understanding of AD to have a successful implementation. We may even break out a white board!
SessionID: 32662
Minimal Processing for Large Cubes
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 350
Speaker: Ross McNeely
Title: Minimal Processing for Large Cubes
Abstract:
Processing large cubes can consume vast amounts of IO, and create lengthy response times. This presentation will demo how to process dimensions and dynamically create, process, and delete measure group partitions to minimize IO. By taking control of cube processing through a SSIS package you are able to process only the bare minimum in order to bring a cube current while keeping response times acceptable. Additional areas to cover will include the support tables to control cubes, and a review of the XMLA for creating, processing, and deleting. This method is also helpful for processing many smaller cubes.
SessionID: 32966
Asynchronous programming with Service Broker
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 336
Speaker: Sanil Mhatre
Title: Asynchronous programming with Service Broker
Abstract:
SessionID: 33045
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142B
Speaker: Kevin Bullen
Abstract:
SessionID: 33233
Scriptable UI with PowerShell
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 142B
Speaker: Steven Murawski
Title: Scriptable UI with PowerShell
Abstract:
Sick and tired of typing at a command prompt or scrolling through buffers of text output? ShowUI (an open source PowerShell Module) is a great tool for quickly and easily creating great looking UI with all the power of PowerShell behind it.
SessionID: 33348
Merge Replication for Offline Data Mobility
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 350
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: 33672
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 322
Speaker: Tim Ford
Abstract:
Walk-up work.
New database requests.
Users running ad-hoc queries with 18 LEFT OUTER JOINS against heaps.
Suprise SQL instances created by vendors without our knowledge crashing around us!
It's enough to drive a lesser DBA crazy-insane. That's why it's important to take as many steps as you can to simplify, automate, tweak, and tune the tasks you can manage so you have time to deal with those situations you can't control. In this session Tim will go over many of performance-enhancing methods he's developed over the last dozen years as a DBA for a major healthcare concern and show you how you can give yourself some breathing room to make the difficult seem easy.
SessionID: 8894
Event Date: 21-04-2012 - Session time: 00:00:00 - Track: Room 322
Speaker: Aaron Lowe
Abstract: