Nr: 205
SQLSaturday #205 - Puerto Rico 2013
SessionID: 11852
An Introduction to Extended Events
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Jack Corbett
Title: An Introduction to Extended Events
Abstract:
XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents. We will look at why you should start working with Extended Events, when you should start, and how to start. What you will learn:
- How to investigate XEvents objects using the DMV's
- How to create an XEvents Session
- How to transition an existing Trace to an XEvents Session.
What you should know coming in:
- Basic use of SSMS
- Familiarity with Trace/Profiler
SessionID: 12926
Dealing With Errors in SSIS 2012
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: David Dye
Title: Dealing With Errors in SSIS 2012
Abstract:
This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
SessionID: 12927
Whats New in T-SQL With SQL Server 2012
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: David Dye
Title: Whats New in T-SQL With SQL Server 2012
Abstract:
This session covers the new features and functions introduced to T-SQL in SQL Server 2012. Our time will be spent reviewing enhancements to T-SQL specifically for SQL Server 2012 with attention to demonstrations and code samples. This is a basic session, but ttendees should have a general knowledge of T-SQL.
SessionID: 14100
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Eddie Wuerch
Abstract:
SessionID: 14101
Partitioning for Perf and Mgmt of Large Tables
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Eddie Wuerch
Title: Partitioning for Perf and Mgmt of Large Tables
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
SessionID: 14853
Power View Reporting Enhancements in SQL Server
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Guillermo Caicedo Santiago
Title: Power View Reporting Enhancements in SQL Server
Abstract:
SessionID: 14854
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Guillermo Caicedo Santiago
Abstract:
SessionID: 16309
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jeffrey Garbus
Abstract:
Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
SessionID: 16312
How to be a GREAT DBA
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jeffrey Garbus
Title: How to be a GREAT DBA
Abstract:
This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.
Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.
SessionID: 16959
Upgrade your TSQL to the NEXT level
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jose L. Rivera
Title: Upgrade your TSQL to the NEXT level
Abstract:
TSQL window functions, originally introduced in SQL Server 2005, have proven to be quite useful to solve complex ranking and aggregation scenarios. The new additions in SQL Server 2012 make them irresistible. In this session, we will discuss how to use them and highlight the new order, offset and distributions functionalities in real-world examples.
SessionID: 16961
Stay ahead with Change Data Capture
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Jose L. Rivera
Title: Stay ahead with Change Data Capture
Abstract:
SessionID: 17627
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jorge Sanchez
Abstract:
SessionID: 17628
SQL Server High Availability Disaster Recovery
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Jorge Sanchez
Title: SQL Server High Availability Disaster Recovery
Abstract:
(Spanish) This presentation explains how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server high availability and disaster recovery solutions.
SessionID: 17656
MS Access with SQL Server Strategies and Tips
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Juan Soto
Title: MS Access with SQL Server Strategies and Tips
Abstract:
SQL Server DBA's face a lot of challenges now days, from maintaining servers to putting out fires. One of them is how to properly deal with Access databases in the workplace. Quite frequently they contain mission critical data and grown to be important to your business. Upsizing them to SQL Server is just the first step, you need to change Access's forms, reports, queries and code to avoid issues with your server. In this session we will discuss strategies; from importing data to optimizing the relationship between Access and SQL. Users will leave having a much better understanding of how to incorporate Access in the workplace and safeguard their data.
SessionID: 22443
SQL Server Deployment Options
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Ramon Ponte
Title: SQL Server Deployment Options
Abstract:
Indistinctively of which deployment model makes sense for you, it is extremely important to have a consistent user experience when managing, monitoring and developing for these databases. Learn about how you start today to take advantage of SQL Server deployment options.
SessionID: 28078
Getting Started with MDX: The (Very) Basics
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: William E Pearson III
Title: Getting Started with MDX: The (Very) Basics
Abstract:
In this session, led by Microsoft BI Architect, SQL Server MVP, and Analysis Services Maestro Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
SessionID: 28080
Serene Velocity: Reporting Services and SSAS Data
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: William E Pearson III
Title: Serene Velocity: Reporting Services and SSAS Data
Abstract:
SSRS 2008 and above provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many features, such as server aggregation, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.
SessionID: 9181
Predictive Analytics using SQL Analysis Services 2012
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Alan Koo
Title: Predictive Analytics using SQL Analysis Services 2012
Abstract:
SessionID: 9182
Tasting the Analysis Services 2012 Flavors
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Alan Koo
Title: Tasting the Analysis Services 2012 Flavors
Abstract:
The Unified Dimensional Modeling (UDM) concept was introduced in Analysis Services 2005 as the semantic layer to enable the OLAP cube development from multiple sources using an abstract layer. Analysis Services 2012 introduces the Business Intelligence Semantic Model (BISM) concept as an evolution to UDM, offering two new 'flavors': the Multidimensional Mode and the Tabular Mode. The BISM represents the heart of Microsoft Business Intelligence strategy for now and the upcoming years. This session will explain and clarify the basic concepts of Analysis Services 2012 and PowerPivot. We will also discuss different scenarios that will allow BI architects / developers take better decisions when building up the foundation for their companies’ Enterprise Analytics strategy.
SessionID: 9461
DW Design Tips Slowly Changing Dimensions
Event Date: 20-04-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Andreina Rizo
Title: DW Design Tips Slowly Changing Dimensions
Abstract:
In the session we are going to take on a challenging subject that all designers face: how to deal with changing dimensions. Unlike most OLTP systems, a major objective of a data warehouse is to track history. So, accounting for change is one of the analyst’s most important responsibilities. Ralph Kimball introduced the concept of slowly changing dimension (SCD) attributes in 1996. Dimensional modelers, in conjunction with the business’s data governance representatives, must specify the data warehouse’s response to operational attribute value changes. In this session we will also explain “type numbers” assigned to several techniques that have been described in the past.