Next Meeting: Tue, Mar 12 2013
HASSUG & H-BI Monthly Meeting - March 12, 2012
Event Type: In-Person & Online
Online Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=HASSUG_MAR2013&role=attend
The general schedule for each meeting will be:
11:30-11:40 – Announcements
11:40-12:45 – General presentation (Topic 1)
12:45-1:15 – Lunch\Networking – Raffle #1
1:15-2:20 – BI themed presentation (Topic 2)
2:20-2:30 – Recap Announcements – Raffle #2
UTC : Tue, Mar 12 2013 16:30 - 19:30
Event Time : Tue, Mar 12 2013 11:30 - 14:30 (GMT-06:00) Central Time (US & Canada)
Your Local Time: Tue, Mar 12 2013 16:30 - 19:30
2000 W. Sam Houston Pkwy S. #350
SQL Server Backup and Restore – Back to Basics
Peter Tran, Sr. Technical Lead PROS Revenue Management
Backup and restore is a fundamental skill required of any DBA regardless of level. There are a lot of 3rd party sophisticated tools to help with SQL Server backup and restore, but it is still important skillset to know how to do this the old fashion approach using only tools available with SQL Server. In this presentation, we’re going back to basic. We’ll review the fundamental of backup and restore. The topics we’ll be reviewing are the SQL Server components involved, types of backup, and recovery models. Demonstration will be provided on different backup and restore strategies. If you’re a new DBA, then this presentation is definitely for you. Even if you’re a season pro, it will be a good review of the fundamentals.
Peter works for PROS Revenue Management (NYSE: PRO) as a Sr.Technical Performance Lead specializing in server-side performance tuning on Java, SQL Server, and Oracle. Peter holds both MCTS and MCITP certifications. He's presented topics on SQL Server performance at the annual Houston Tech Fest and Java tuning at the Houston Java User Group (HJUG). When he's not busy studying for his SQL Server Master Certification (MCM), he indulges in his other passion - photography. You can find his rambling at tranpeter.blogspot.com.
Top BI Enhancements for SQL Server 2012
James Serra, BI/Data Warehouse/MDM Architect Serra Consulting Services
What are the new features and functionality in SQL Server 2012 that are specific to business intelligence? SQL Server 2012 has an abundance of new features and enhancements, with business intelligence (BI) being one area given a lot of attention. In this session I will cover the most important of these new features, broken out into the logical areas seen in a full end-to-end development of a BI solution: data integration, data management & warehousing, and end-user reporting.
James Serra is an independent consultant serving as Business Intelligence, Data Warehouse, and Master Data Management Architect, and has more than 25 years of IT experience. He started as a software developer and then served as a DBA for 12 years, working extensively the past seven years with BI using the SQL Server BI stack (SSIS, SSAS, and SSRS). James is a SQL Server MVP and is a noted speaker, blogger, and contributing writer for SQL Server Pro magazine.