addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Data Warehouse Physical Design Best Practices

Please also RSVP on http://atlantabi.sqlpass.org/ if you plan to eat.

Overview:

You have your star schema beautifully defined. Now what? How can you assure that you physical database design is prepared to receive the amount of data that you are expecting? How can you best utilized your servers, SAN, memory, partitions, SSIS, SSAS, etc.? Let’s talk about a real case scenario where all of that were applied in order to improve daily process and meet businesses SLAs.

Speaker:

Carlos Rodrigues is a Business Intelligence Architect with Recall Corporation and he has expertise in planning, developing, and implementing state of the art information solutions facilitating corporate management and growth. He has been successfully leveraging SQL Server BI tools at Recall since 2004 going through the several SQL Server versions. Lately, we've been leveraging SQL Server 2012 Bi tools such as Power View, PowerPivot, etc.

Join or login to comment.

  • Gene O.

    Thank you Carlos, cool presentation.
    I appreciate the fact you suggested the split: one file_group per one table/ per disk - now I am totally pumped .. will do.

    Thanks again for your presentation and your time!

    March 25, 2013

  • Gene O.

    Awesome, look forward to it ..SSIS, SSAS

    March 24, 2013

  • Lance E.

    Hate to miss it

    March 21, 2013

16 went

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy