Category Archives: SQL Saturday #120

SQL Saturday returns to Orange County

I’m speaking at SQL Saturday #120 this weekend in Orange County, CA and it’s the 3rd straight year for me at this event.  It’s also the first SQL Saturday I presented at two years ago, so I have a soft spot in my heart for this one.  Andrew Karcher, Marlon Ribunal, Thomas Mueller and the rest of the volunteers do a great job putting this one together, and this year they have an all-star lineup of speakers.  They have 8 tracks scheduled with 6 sessions per track so there’s going to be a lot of content delivered in a short time frame, with a number of SQL Server 2012 sessions so you can learn more about the new release.  There’s also a Women in Technology panel at lunch that I highly recommend, especially to the men.   A small fringe benefit of attending is that the conference is held in a junior college with classrooms around a courtyard, registration is outside, and going from session to session means a breath of fresh air in the coastal weather of Huntington Beach.  I’m presenting two sessions, the first at 11am on Tabular Models, a hot new SQL Server 2012 topic.  The second is right after lunch at 1:30 on real-time data warehousing.  Here’s the title and abstract of my sessions.  I look forward to seeing you there.

Preparing Data for Analysis as Tabular Models

The new Tabular Model in SQL Server 2012 is being touted as a powerful analytic engine that is faster and easier to implement than traditional cubes using Analysis Service. In this session Carlos Bossy will demonstrate how to develop analytic models using your existing data sources and will discuss best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, Carlos will show you how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience.

Real-time Data Warehouse and Reporting

This session will present a Database and ETL Architecture that allows you to smoothly move data from your application databases across the enterprise in real-time to your data warehouse. Carlos Bossy will show you how to use SQL Server features such as Replication, Change Data Capture, SSIS and other techniques to extract, transform and load data fast and dependably and view a real demonstration of the system in action. Finally, Carlos will show how to use Reporting Services to present data with a minimum amount of latency.