August 2012

Featured Presentation

Upsizing File Based Data To SQL Server

Speaker: Adolfo Santiago

Summary: The proliferation of file-based data silos is a persistent problem for many organizations. The ease of use of Microsoft Excel, Access, and other tools allows almost anyone, from interns to executives, to collect and maintain important business data in individual files. This situation, more commonly known as "Excel Hell", can become a real challenge to the business in terms of data security, quality, access, accountability, and risk of loss.

As SQL Server professionals, many of us are not only responsible for the safekeeping of databases but also of the business data that goes, or should go, into them. And so we may be called upon to architect solutions to move the content of those silos into SQL Server, while giving the users as much of the same freedoms to interact with their data as they had before. From centralization and standardization to increased data quality, leverage, and availability, the benefits to the business of such moves are many. This presentation is a general survey of the tools, methods, questions and concerns associated with "upsizing" file-based data in order to obtain those benefits.

About Adolfo: A developer, architect, and overall "data guy" at Walt Disney World's Sales and Travel Operations, Adolfo lives where the SQL Server rubber meets the business road: project design and implementation. One of his responsibilities is working directly with users to migrate to SQL Server business critical data kept in Excel and Access files.

Pre-Meeting Presentation

Who's Responsible? The Vendor or the DBA?

Speaker: Erin Stellato & Mike Walsh (Video replay from 2011 PASS Summit)

Summary: Database administrators - you don't really trust your third party software vendors, do you? Software vendors - you think most of the DBAs out there are hiding things, don't you? Well guess what, you're both right! Join Erin Stellato (representing vendors) and Mike Walsh (representing DBAs) for an interactive session where they will tackle some of the toughest challenges that DBAs and vendors face when working with each other. Attendees will walk out with a better understanding of what both parties can do to contribute to a successful relationship, as well as a set of fair questions to ask to set the right expectations from the start. Attend our session to see if a Vendor and DBA really can get along, and listen in on some real life horror story examples of how not to do it.

Back to Top