BAD: Data Warehouses and BI Systems - Uninvited Guests in a DBA's Home

Everyone agrees that data warehouses are conceptually different to OLTP databases when it comes to design and implementation. However, few people appreciate that managing DWs must be approached from a completely different angle, and that many traditional DBA best-practices are simply not applicable or even counter effective.

Unfortunately, quite a few DBAs don’t fully understand the nature of DWs, don’t see a genuine need to treat DWs very differently and are reluctant to stray away from “tried-and-true” methods and techniques.
Moreover, many data warehouses are handed over to DBAs together with even more unorthodox components that are outside of traditional DBAs realms, like SSAS cubes, SSIS packages, SSRS reports, XMLA scripts, tabular models, MDX and DAX queries, etc.

So it is no wonder that DWs and BI systems are often treated as uninvited guests or even squatters in a DBA's "home".

This very practical session will narrow the gap between the DBA and DW/BI “worlds” by explaining and demonstrating some of the most important differences; and highlighting some of the typical challenges faced. Furthermore, it will address the typical “communication problems” between DW architects/BI developers and DBAs; and provide some guidance on how to overcome these issues.

Speaker: Borivoj Maras (SQL Server Solutions)

Borivoj Maras (MCT, MCITP) is a database and BI consultant with over 20 years of experience in the field. During his career he has worked in different capacities in various industries and was actively involved in literally all phases of software development life cycles. On many projects he worked as part of a development team, on several projects as a DBA and very often his role was a kind of a bridge or even a technical mediator between development and DBA teams, so he can provide a true insight into both worlds.

Join or login to comment.

  • Borivoj M.

    Hi

    Thank you for attending, I hope you found it interesting and useful. I agree it was rushed, especially the second part. I promise next time I do a presentation it will be much better paced.

    I’ve uploaded PowerPoint slides, so you can go through them at your own pace. Please find them under More->Files DW and BI in DBAs home April 2014.pptx

    Cheers,
    Borivoj

    April 8, 2014

  • Frederic C.

    No rush :)
    Thanks a lot

    April 8, 2014

  • Borivoj M.

    Hi
    I'll post the slides and my comments tomorrow, or on Wednesday, sorry for the delay.

    April 7, 2014

  • Frederic C.

    I agree with Susan that the end was a bit rushed unfortunately.
    Would it be possible to get the slides as I was interested to know which Profiler options were used to check the impact of the SSIS package???

    April 7, 2014

  • Susan

    I think the time allotted was too short for this talk. It was very interesting but far too rushed, especially at the end.

    April 3, 2014

35 went

Our Sponsors

  • Idera

    Idera - SQL Server tools - monitoring, manage, availability & security.

  • SQL Tools

    SQL Tools distribute and support Idera's SQL Server management tools.

Create a Meetup Group and meet new people

Get started Learn more
Bill

I started the group because there wasn't any other type of group like this. I've met some great folks in the group who have become close friends and have also met some amazing business owners.

Bill, started New York City Gay Craft Beer Lovers

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