About Me

Hello!

My name is Julie Koesmarno. I am a Senior Program Manager at Microsoft, a former SQL Server MVP and hold Microsoft Certified Solution Expert certifications: in Data Platform and in Business Intelligence for SQL Server 2012. Thanks for visiting my blog! Here’s a little bit about me.

Work Experience

I have worked on high profile database system implementations using SQL Server since 2004. These database solutions were custom implementations for Telecommunication, Finance and internet companies with Australia and international presence.

In addition, I have also worked with different types of database, from MySQL, Oracle to Microsoft SQL Server. The latter being my favourite which I have spent a great deal amount of time implementing data management, data staging and data cleansing systems.  I enjoy working with Data, from data analysis, database design to data visualisation.

I have worked as an independent consultant, specialising in the SQL Server and BI space, surrounded by a network of talented and passionate friends and SQL Server/BI professionals, globally. I have moved from one country to another, to pursue my life long passion, travelling and working with data (and I mean, lots of DATA!).

My recent career move that I’m super stoked about is working at Microsoft as a Senior Program Manager in the Data Platform Group. It was a dream for a long time. I’m here now in Redmond, pursuing what I am passionate about – data and actionable insights.

 

Community

A very good friend of mine, Victor Isakov, was the first #SQLFamily member that I met. He opened my mind about SQL Server and introduced me to the life of SQL Server early 2011. We presented together at Sydney SQL User Group in September 2011.

Since then, I have been active in PASS (Professional Association of SQL Server) as a volunteer and a presenter for local as well as international events. For local events, I have presented at Sydney SQL User Group, SQL Saturdays and virtual chapters.  At international level, I have presented at SQL Rally in Dallas 2012, PASS Summit 2011PASS Summit 2012, PASS Summit 2013PASS Summit 2014 and SQL Bits XII.

I have learnt so much and am still learning from SQL Community – #SQLFamily. So this blog is one of my ways of sharing my knowledge and helping out the community.

 

Passion

Silly SQL SelfieTwo of my favourite things are learning and story telling (sharing knowledge). The two go together quite well, along with my passion for travelling.  This site is my new way of learning more about SQL Server, database design, data visualisation and Business Intelligence. Ultimately this is my journey as Ms SQL Girl (in addition to having fun and being silly along the way!)

 

“Take a leap of faith, life has interesting ways of unraveling itself”

Photo taken at Westlake Village, CA

15 comments on “About Me
  1. I live in the U.S. and have taken a few B.I. courses, which I find very interesting. However, I do not work in B.I. so I pay for these out of pocket.

    Is there a cost effective way to learn SQL Server?

  2. Hi, I am an upcoming database architect specializing in database solution end-end design, applicaiton integration solution development and Data Continuity architecture.

    I am also a Windows System Architect (HW and SW) and Application Virtualization and Integration Architect

    I have a new blog that has been under development for a long time but i haven’t had enough time to complete it but i would love for you guys to drop in whenever you’d like to and drop your thoughts into my suggestions box (a.k.a please leave a comment)

    The name of the blog is DB Resolve (Naive i know)
    the link to blog is : http://geekswithblogs.net/thedatabaseguy/Default.aspx

    Please use elastic layout for best view and please dont mind if the place is a lil messy right now .. it is still under development.

    Thanks for the help.

  3. Hi Julie,

    I’m so glad and thankful for your kindhearted in supporting the very first SQLSaturday Philippines! Actually, I’m a good friend of Edwin Sarmiento. I’ve been in PASS Summit 2012 and also seen your presentation. Great job!

    From there, I’m starting to follow all your footsteps!!

    Regards,
    Jen

    • Hi Jen,

      The pleasure is mine. The enthusiasm of the Philippines SQL community is really moving.

      Hopefully I can visit you and present on BI topics. I saw one spot left at 3PM (and there was no BI topic); I wish I could do something about that!

      Hope your session and the rest of SQL Saturday 218 go well.

      Look forward to hearing more stories from you and seeing you at PASS Summit 2013.

      Kind regards,
      Julie

  4. Pingback: New and Improved SQL Search By Red Gate | Mickey's T-SQL Ponderings

  5. Actually i received an email about a Business Intelligence session next week Nov 26. from your email and went to check out your site. It seems to be a very good resource so far and will be utilizing it quite a bit as i try and find my way into the BI side of Sql Server. I really like your story and look forward to following your continued journey. I hope you don’t mind if i tag online.

  6. Hi Julie. I really enjoy your website. I am a former Oracle Consultant in the Database and BI space and have been working with Microsoft products for the last 4 years and are really enjoying the rapid advancements recently.

    One bug bear I have with the Tabular models is the metadata in the model is not exposed when accessing the model as a pivot table in Excel 2013. Am I missing something, is this feature available in Excel 2016. The metadata appears when using Power View and Power BI. Can it be exposed in Excel 2013, and is it exposed in Excel 2016?

    Thanks

    Andrew

    • Hi Andrew,

      Thanks for the feedback.

      Tabular Model should be accessible from both Excel 2013 and Excel 2016. I don’t think I have heard of issues where the Tabular Model metadata is not exposed in Excel (Pivot Table) – in fact the whole “self-service” BI story when Tabular Model was introduced back in SQL 2012 was so that users can use familiar tools such as Excel (Pivot Table) to explore data this way. If you have more details on where it claims that the metadata in the Tabular model is not exposed in Excel, please let me know.

      To get connected to Tabular Model, in Excel, you will need to go to Data > Get External Data > From Other Sources > From Analysis Services. Then provide the server details, credential and choose which tabular database you want to connect to. Follow the rest of the steps. Then you will be prompted how you want to view the data, i.e. as Pivot Table, Power View report, etc. Step-by-step instruction is available in my most recent blog post: Analyzing Tabular Model in Excel 2016.

      Let me know how you go with it.

      Thanks,
      Julie

Leave a Reply

Your email address will not be published. Required fields are marked *

Some simple Math is good for your brain! Thanks, Ms SQL Girl. *