Wednesday, December 16, 2009 (6:00 PM)
Microsoft Puerto Rico - Borikén Room - Microsoft Building, Metro Office Park Street 1 Lot 18 Suite 5000 Guaynabo PR
(To see a reference map click here)
SQL Server 2008 Management Data Warehouse (MDW) – Elizabeth Córdova (Nagnoi, Inc.)
As a way to improve our visibility of what is happening with our server and databases in order to get the best response times and high availability, a great improvement of SQL Server 2008 is the ability to collect performance statistics in an automated way. The management data warehouse (MDW) is a relational database that contains the data that is collected from a server that is a data collection target. This data is used to generate the reports for the System Data collection sets, and can also be used to create custom reports.
Speaker Profile: Elizabeth Córdova is a Business Intelligence Consultant at Nagnoi, Inc. Elizabeth has 9 year of industry experience and more than 4 years working on Data Warehouse projects and Business Intelligence, including deep experience on Extraction, Transformation and Loading (ETL) components using SSIS, OLAP, Data Mining and Enterprise Reporting.
SQL Server Performance Best Practices on Installation & Configuration – Jorge Sanchez (Rock Solid Technologies)
Level: 300-400 (Advance)
This seminar will focus on the checklist every DBA should have around performance best practices for server (hardware & software) preparation, SQL Server installation, and final configuration.
Speaker Profile: Jorge Sánchez brings 22 years of experience in the IT industry, currently working for Rock Solid Technologies as Senior BI Developer. Previously, Mr. Sánchez worked 8 years in Microsoft as SQL Server Regional Specialist for Caribbean and Central America with direct focus in Puerto Rico, Costa Rica, Dominican Republic, and Trinidad. Before that, 14 years as Senior Consultant, Developer, and SQL Server Certified Instructor for Microsoft Technologies within the Microsoft Partners Ecosystem. Mr. Sánchez is currently certified in SQL Server versions: 2008, 2005, and 2000, 7.0, and 6.5.