sqlsathistory

Nr: 106

Back to Main list

SQLSaturday #106 - Puerto Rico 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	Maritza Córdova	(03) - AppDev	A Lap Around SQL Server Integration Services 2012
00:00:00	Eduardo Sobrino	(03) - AppDev	Managing Blobs and Geo-Location Data
00:00:00	Gualberto Huerta	(01) - DBA	HP Data Management Solutions.
00:00:00	Guillermo Caicedo	(02) - BI	Power View Reporting Enhancements in SQL Server
00:00:00	Jose L. Rivera	(03) - AppDev	You got XML !!!
00:00:00	Maximo Trinidad	(03) - AppDev	PowerShell Query for the T-SQL Developer.
00:00:00	Maximo Trinidad	(01) - DBA	Basic Intro to PowerShell for the DBA
00:00:00	Pam Shaw	(02) - BI	Tips Tricks for dynamic SSRS Reports
00:00:00	Janis Griffin	(03) - AppDev	Looney Tuner? No, there IS a method to my madness
00:00:00	Joseph D'Antoni	(01) - DBA	SQL 2012 -- All About HA and DR
00:00:00	Joseph D'Antoni	(01) - DBA	SAN Basics for DBAs
00:00:00	Jorge Sanchez	(01) - DBA	SQL Server Performance Troubleshooting for the DBA
00:00:00	Ramon Ponte	(02) - BI	Cleansing Your Data with Data Quality Services.
00:00:00	William E Pearson III	(02) - BI	PowerPivot for Excel: For Those Unacquainted ...
00:00:00	Alan Koo	(02) - BI	Tasting the Flavors of Analysis Services 2012

SessionID: 13769

A Lap Around SQL Server Integration Services 2012

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (03) - AppDev

Speaker: Maritza Córdova

Title: A Lap Around SQL Server Integration Services 2012

Abstract:

This session will cover a featured enterprise-level extract, transform and load (ETL) tools like SSIS platform. Features and architecture of the new toolset of MSSSIS 2012 as we learn how you can be using SSIS for your projects. This session will be presented in Spanish.

SessionID: 13967

Managing Blobs and Geo-Location Data

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (03) - AppDev

Speaker: Eduardo Sobrino

Title: Managing Blobs and Geo-Location Data

Abstract:

Working with "very large objects" ("Binary Large Objects") including images, binary data, xml documents, or geo-location related data sets is a challenge. Once the object is registered then how you manage or query data within. What about performance? This session will present to you various issues related to managing large objects and strategies / code alternatives for its storage, retrieval and querying. Presented in Spanish.

SessionID: 14842

HP Data Management Solutions.

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (01) - DBA

Speaker: Gualberto Huerta

Title: HP Data Management Solutions.

Abstract:

The HP and Microsoft global strategic alliance is one of the longest standing alliances of its kind in the industry; this session presents the solution portfolio for Database management and consolidation using the HP Converged Infrastructure portfolio and Microsoft technologies. Presented in Spanish.

SessionID: 14844

Power View Reporting Enhancements in SQL Server

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (02) - BI

Speaker: Guillermo Caicedo

Title: Power View Reporting Enhancements in SQL Server

Abstract:

Power View provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on PowerPivot workbooks or tabular models deployed to SSAS instances. In this session will dive in to what is needed to create PowerView reports and an overview of the reporting enhancements in SQL Server 2012. Presented in Spanish.

SessionID: 17464

You got XML !!!

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (03) - AppDev

Speaker: Jose L. Rivera

Title: You got XML !!!

Abstract:

The use of XML based content in SQL Server has become very popular over time. In this session, we will show you how to use the XML data type (FOR XML, Schemas, Namespaces), perform basic operations on XML data (XML DML), and discuss the performance consideration (storage, XML indexes) associated to these features.In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All

SessionID: 19900

PowerShell Query for the T-SQL Developer.

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (03) - AppDev

Speaker: Maximo Trinidad

Title: PowerShell Query for the T-SQL Developer.

Abstract:

This session will show the side-by-side similarity in building a PowerShell query vs T-SQL. I will demo some scripting techiniques in buidling a PowerShell query, building Hash table objects, ways to read and display the information. If the person knows how-to write T-SQL script, then it makes it easy to understand How-To write a PowerShell query. Presented in English.

SessionID: 19901

Basic Intro to PowerShell for the DBA

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (01) - DBA

Speaker: Maximo Trinidad

Title: Basic Intro to PowerShell for the DBA

Abstract:

Description:This is an Intro level for the SQL DBA wanting to start and learn how to use PowerShell in their environment. It will be divided in two half hour part be covering PowerShell setup essentials, and testing PowerShell working with both SMO and SQLPS module to build SQL PowerShell scripts. This is not a language intro but it will get you started to learn PowerShell. Covering PowerShell V2/V3 and SQL Server tools.

SessionID: 22344

Tips Tricks for dynamic SSRS Reports

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (02) - BI

Speaker: Pam Shaw

Title: Tips Tricks for dynamic SSRS Reports

Abstract:

In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create. Presented in English.

SessionID: 30478

Looney Tuner? No, there IS a method to my madness

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (03) - AppDev

Speaker: Janis Griffin

Title: Looney Tuner? No, there IS a method to my madness

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.This session will be presented in English.

SessionID: 30651

SQL 2012 -- All About HA and DR

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (01) - DBA

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. Presented in English.

SessionID: 30652

SAN Basics for DBAs

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (01) - DBA

Speaker: Joseph D'Antoni

Title: SAN Basics for DBAs

Abstract:

Curious as to what a LUN is? Or what RAID level you should use for you database files? This session will cover the basics of what a SAN is, how it works, and how to talk to your SAN Admins. We will also discuss various ways to configure SQL Server for optimal I/O. Presented in English.

SessionID: 31072

SQL Server Performance Troubleshooting for the DBA

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (01) - DBA

Speaker: Jorge Sanchez

Title: SQL Server Performance Troubleshooting for the DBA

Abstract:

(Presented in Spanish). This session will present performance troubleshooting tips for the Database Administrator (DBA). First, will explain Windows and SQL Server installation configuration best practices, followed by TSQL scripts to detect bottlenecks (CPU, RAM, I/O, Waits, Blocking, and others), TSQL recommendations on large databases, and finally SQL performance counters.

SessionID: 32368

Cleansing Your Data with Data Quality Services.

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (02) - BI

Speaker: Ramon Ponte

Title: Cleansing Your Data with Data Quality Services.

Abstract:

SQL Server Data Quality Services (DQS) is a Knowledge-Driven Data Quality product aimed at the data stewards and IT professionals who seek to improve the quality of their business data. In this session, Ramon will describe the concept and main principles behind SQL Server 2012 Data Quality Services. The main capabilities of the product, such as knowledge management, cleansing, matching and profiling.In Spanish.

SessionID: 34335

PowerPivot for Excel: For Those Unacquainted ...

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (02) - BI

Speaker: William E Pearson III

Title: PowerPivot for Excel: For Those Unacquainted ...

Abstract:

Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities. (ENGLISH)

SessionID: 9178

Tasting the Flavors of Analysis Services 2012

Back to calendar

Event Date: 26-05-2012 - Session time: 00:00:00 - Track: (02) - BI

Speaker: Alan Koo

Title: Tasting the Flavors of Analysis Services 2012

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. Now, 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 2.0 and discuss different scenarios that will allow BI architects / developers to take better decisions when developing OLAP solutions with SSAS. (Spanish)

This site is open source. Improve this page.