Nr: 121
SQLSaturday #121 - Philadelphia 2012
SessionID: 10000
Manage SQL Server 2012 with PowerShell and Core
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA I
Speaker: Allen White
Title: Manage SQL Server 2012 with PowerShell and Core
Abstract:
SessionID: 10001
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA I
Speaker: Allen White
Abstract:
SessionID: 10763
Conversational leadership
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Brian Moran
Title: Conversational leadership
Abstract:
Leadership coaching is the practice of using relational influence, the people kind, not the database kind J, to develop and empower leaders. You might be in a position of leadership today. You might be in a position of leadership tomorrow. Either way; we all have opportunities to lead in different ways as we go about our lives and careers. Learn some simple techniques that can help you lead through conversation.
SessionID: 11136
SharePoint Integration with SQL Server
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Bill Wolff
Title: SharePoint Integration with SQL Server
Abstract:
SharePoint is a collaboration, document management, and solution delivery platform built on .NET, SQL Server, and Active Directory. This talk explains how SharePoint uses SQL Server to store content, configuration, and logging data. For databases that are not native to SharePoint, Business Connectivity Services provides a seamless forms over data experience. SharePoint is used extensively for Business Intelligence where it becomes the user interface for Reporting Services, PowerPivot, and Performance Point. We will also look at how SQL Server 2012 affects the SharePoint ecosystem.
SessionID: 11600
What's Buried in the Plan Cache?
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Development
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 unnecessarily, 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: 11601
Working with Server Side Traces
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA\Dev
Speaker: Christina Leo
Title: Working with Server Side Traces
Abstract:
You may have heard that it’s a good idea to use a server-side trace to capture SQL profiler data, but do you know how to create one? And, do you know how to process the data you’ve captured? If not, then this session is for you.
First, we’ll examine the anatomy of a server-side trace script and look at the different ways it can be customized. Then, we’ll talk about methods for stopping and starting the trace, how to know what traces are already running, and ways to schedule a trace to start under certain server conditions. Last, we’ll look at different tools available to you for analyzing the data you’ve gathered, including the SQL Server Profiler client application, “home-grown” T-SQL queries, ClearTrace, and the ReadTrace.
SessionID: 13178
Thwarting Database Defects
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Development
Speaker: Dennis Lloyd Jr
Title: Thwarting Database Defects
Abstract:
It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them. This presentation introduces tSQLt, a framework for automated database unit testing. You’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain.
SessionID: 13238
Introduction to the .NET SSIS API (C#)
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Development
Speaker: Dominic Falso
Title: Introduction to the .NET SSIS API (C#)
Abstract:
Using the .NET API, we'll design and run existing packages, and create a new one. We'll discuss the different objects a package contains, see how to query a package's contents, and how to edit field-level component transformations.
SessionID: 13946
DBCC Commands: The Quick and the Dangerous
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA I
Speaker: Erin Stellato
Title: DBCC Commands: The Quick and the Dangerous
Abstract:
SessionID: 13947
You’re My Density: Making Sense of Statistics
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA\Dev
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: 15015
PowerPivot BISM in SQL Server 2012
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI 2012
Speaker: Hope Foley
Title: PowerPivot BISM in SQL Server 2012
Abstract:
The BI world is all coming together as one to have hold and cherish in the BI Semantic Model. We will discuss that and what it means and dive into PowerPivot 2012. Will go over some oldie but goodies from v1 as well as heavily highlight some of the most anticipated new features. We will create together a real world scenario to help solve my own BI problems. Learn to crank out some uber snazzy reports that will knock your boss's KPIs off!
SessionID: 15892
Advanced Charting Techniques in SSRS
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI/Dev
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 tips and tricks around them. Come to this session and take your charting skills to the next level.
SessionID: 16182
It Costs How Much? SQL Server Licensing
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Joseph D'Antoni
Title: It Costs How Much? SQL Server Licensing
Abstract:
Did you know that as of June 30th the model for licensing SQL Server is changing? Learn about what these changes mean to you and your IT organization. We will discuss the impact to hardware architecture, virtualization environments, and DR. Understand the strategies you are your organization can take to minimize the financial impact of these licenses changes.
SessionID: 16183
You Wouldn't Let HR Manage Your DBs...
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Joseph D'Antoni
Title: You Wouldn't Let HR Manage Your DBs...
Abstract:
So don't let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel.
SessionID: 16659
Exploring your Data with Power View
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI 2012
Speaker: Jessica Moss
Title: Exploring your Data with Power View
Abstract:
SessionID: 17693
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA I
Speaker: John Sterrett
Abstract:
SessionID: 17972
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA II
Speaker: Kathy Gibbs
Abstract:
SessionID: 17973
Best Practices for Monitoring Databases on VMware
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA II
Speaker: Kathy Gibbs
Title: Best Practices for Monitoring Databases on VMware
Abstract:
SessionID: 18032
Mobilize your PowerPivot Solutions
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Kevin Bucher
Title: Mobilize your PowerPivot Solutions
Abstract:
Overview and demonstration of steps required to expose PowerPivot/SharePoint to mobile devices.
SessionID: 18033
Power View 101
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Kevin Bucher
Title: Power View 101
Abstract:
Built on top of the BI Semantic Model, Power View gives the users of all levels a powerful yet simple to use experience. Power View provides interactive, browser-based data exploration and visualization - this presentation will walk through the basics of Power View, use cases, and a demonstration.
SessionID: 18332
Integrating MDX code with OLAP applications
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Kevin Goff
Title: Integrating MDX code with OLAP applications
Abstract:
SessionID: 18333
T-SQL for Application Developers - Attendees chose
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Development
Speaker: Kevin Goff
Title: T-SQL for Application Developers - Attendees chose
Abstract:
That's right, attendees choose! I'll show 20 possible topics on the screen, and the attendees vote on which topics I'll cover. Everything from isolation levels to ranking...everything from GUIDs to table-valued functions....everything from querying temporal data to instances where subqueries are necessary....everything from update triggers to reading execution plans. The good news is that you'll walk away with 20 code samples, even though we'll only cover a portion of them in the presentation. This has always been a very popular session.
SessionID: 20222
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Mark Hudson
Abstract:
Whether predicting customers, All Stars or concert set lists, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.
SessionID: 20224
Put Your Data on the Map
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Mark Hudson
Title: Put Your Data on the Map
Abstract:
Columbus demonstrated the world was not flat. Our Address table suggests events occurred at a particular location. SQL Server 2008 supports geospatial data. SQL Server 2008 R2 provides the United States map gallery. Come see how Reporting Services leverages those knowns to present our data in a geographical way.
SessionID: 20554
Top Ten Rules for Managing a Production Environmen
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA II
Speaker: Mike Hillwig
Title: Top Ten Rules for Managing a Production Environmen
Abstract:
Mike Hillwig has ten rules for managing a SQL Server environment regardless of the size. His rules cover things from server configurations to planning for a disaster and a few things that should never be done.
SessionID: 20852
Managing SQL Server in Large Warehouse Environment
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Mark Kromer
Title: Managing SQL Server in Large Warehouse Environment
Abstract:
For SQL Server DBAs experienced in managing OLTP environments, managing a large DW SQL Server environment can present a whole new set of challenges. In this session, we will discuss ways to overcome and prepare for those challenges and the different ways that a DBA must interact with
SQL Server and the associated BI tools to ensure a successful data warehouse environment.
SessionID: 21228
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Development
Speaker: Muthu Ramanathan
Abstract:
In this session, we will talk about some live performance scenarios including CPU starvation, High Memory consuming Queires, SQL Server Caches, I/O Intensive Queries by walking through some live examples. This will be all examples, few slide interactive session that talks about SQL Server performance tuning, using some of the native tools thats comes out of the box. We will finish by getting into SQL Server 2012 Extended Events introduction and how better troubleshooting gets in SQL 2012 and .NET 4.5.
SessionID: 21270
Using Database Projects to Manage Schema Changes
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Mark Wojciechowicz
Title: Using Database Projects to Manage Schema Changes
Abstract:
SessionID: 21271
Data Quality Services in SQL Server 2012
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI 2012
Speaker: Mark Wojciechowicz
Title: Data Quality Services in SQL Server 2012
Abstract:
SessionID: 21613
Analysis Services Half and Half-Half Cube/Half MDX
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Vince Napoli
Title: Analysis Services Half and Half-Half Cube/Half MDX
Abstract:
SessionID: 21714
Index Internals
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA\Dev
Speaker: Sebastian Meine
Title: Index Internals
Abstract:
SessionID: 21787
Shortcuts to Building SSIS in .Net
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Paul Rizza
Title: Shortcuts to Building SSIS in .Net
Abstract:
Shortcuts to Building SSIS in .Net
SessionID: 22191
Accelerate SQL Server 10x
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA I
Speaker: Pat Latorra
Title: Accelerate SQL Server 10x
Abstract:
SessionID: 23029
Creating a PPS Dashboard Using a BI Semantic Model
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI 2012
Speaker: Charles Rivel
Title: Creating a PPS Dashboard Using a BI Semantic Model
Abstract:
SessionID: 23050
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA II
Speaker: Ron Johnson
Abstract:
SessionID: 25158
SSIS Tips Tricks
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI/Dev
Speaker: Josef Richberg
Title: SSIS Tips Tricks
Abstract:
SessionID: 27787
Increasing High Availability and Decreasing Comple
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA II
Speaker: Bill Emmert
Title: Increasing High Availability and Decreasing Comple
Abstract:
SessionID: 28277
Avoiding "Monkey At The Monitor" By Delegating
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA I
Speaker: Joshua Feierman
Title: Avoiding "Monkey At The Monitor" By Delegating
Abstract:
As a DBA there is a lot of simple, step-by-step work that has to be completed on a daily basis. And while it's obviously a necessary part of our job, it's not fun and it takes away from time we could spend doing more important, less urgent work. One attractive option is delegating work to others, thus allowing the DBA to focus on more attractive / important tasks. But how do we do so without compromising security or best practices? Using the tips and tricks presented in this session, you'll be able to spread your workload to junior personnel while still maintaining a sound security / audit model.
SessionID: 29826
Building Your First Tabular Model
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI 2012
Speaker: Dan Clark
Title: Building Your First Tabular Model
Abstract:
SessionID: 31181
Model-Driven Database Design
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA\Dev
Speaker: Karen Lopez
Title: Model-Driven Database Design
Abstract:
Model-Driven Database Development: Myths, Magic and Methods. In this presentation, Karen discusses data model-driven database development from the point of view of the Data Architect, the DBA, and the Developer. She will cover topics such as "Who does what?", "Why are we doing this?", "Do I have to Use a GUI?" and "Just who do you think you are?". Demos, too. Finally, 10 tips for making model-driven database development successful in your organization's culture and environment.
SessionID: 31182
Career Management for Data Professionals
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Prof Dev
Speaker: Karen Lopez
Title: Career Management for Data Professionals
Abstract:
Career Success in Data Management during Turbulent Timesa; A workshop on issues and ideas that today's data professionals can do to build their careers and networking skills with other data management professionals. Workshop topics will include:• Demonstrating your expertise• Building a portfolio of your success stories• Getting others to sell your skills and business value• Building extending your data management skill set• 10 Steps to highlighting you and your workBring your thoughts, ideas, and experiences.
SessionID: 31945
Microsoft Cloud BI
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI
Speaker: Mark Kromer
Title: Microsoft Cloud BI
Abstract:
With the growing number of mobile users, requirements for browser-based BI and the lower TCO of cloud-based solutions, Cloud BI is becoming a dominate topic in the business intelligence world. In this session, I will demonstrate how to create a complete working Microsoft BI application that is cloud-based using SQL Server, SQL Azure, PowerPivot and Silverlight.
SessionID: 32193
Much Ado About Indexes - Tuning, Tips Tricks
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA II
Speaker: Robert Pearl
Title: Much Ado About Indexes - Tuning, Tips Tricks
Abstract:
SessionID: 33880
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA\Dev
Speaker: Wayne Sheffield
Abstract:
SessionID: 34536
MongoDB for the Relational DBA
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA II
Speaker: Justin Dearing
Title: MongoDB for the Relational DBA
Abstract:
NoSQL is the buzzword of the moment, and MongoDB is the leader of the pack. Its probably running in your enterprise in production, and eventually its going to break. As a DBA its your job to fix it when it breaks, and back it up before it does.After all, there's not RELATIONAL in DBA.
On the technical side, this talk will focus on what a DBA needs to know about running MongoDB on windows. This includes setting it up as a service, importing and querying data, and of course backing up and restoring the database.
On the non-technical side, this talk will focus on when you would want to use MongoDB, and when you would not want to.
SessionID: 8990
SQL Server 2012 AlwaysOn Readable Secondaries
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA I
Speaker: Adam Belebczuk
Title: SQL Server 2012 AlwaysOn Readable Secondaries
Abstract:
SessionID: 8991
Introduction to SQL Server Service Broker
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: DBA\Dev
Speaker: Adam Belebczuk
Title: Introduction to SQL Server Service Broker
Abstract:
In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.
SessionID: 9103
SQL Server 2012's Net-New BI Capabilities
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: BI 2012
Speaker: A.J. Mee
Title: SQL Server 2012's Net-New BI Capabilities
Abstract:
Much like other recent installments of SQL Server, SQL 2012 provides a wealth of new capabilities in the arena of Business Intelligence. Come join A.J. Mee, a veteran Microsoft BI specialist, to review the key advances that SQL Server 2012 brings to enterprise BI scenarios, including:
· Power View
· BI Semantic Model (BISM)
· Data Quality Services
· Master Data Management
· Columnstore Index
SessionID: 9227
DBA-User Interface, build a bridge.
Event Date: 09-06-2012 - Session time: 00:00:00 - Track: Development
Speaker: Alex Grinberg
Title: DBA-User Interface, build a bridge.
Abstract:
This is 100% code session, where presenter will demonstrate system development live cycle. Starting from a database stored procedure and go to the user interface to display a result. Down the road I’ll demonstrate different techniques, how to create a stored procedure calling class from SQL Server using system tables. How to pass to the stored procedure different parameter types, such as XML or ADO.NET DataTable.