The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the tag “technology”

Data Warrior #HappyDance! Guess who joined @Snowflakedb

Monday, April 16th, 2018 is going to be a BIG day.

As part of my personal campaign to #UniteTheDataNation, I am beyond happy to announce that two of my good friends from the Oracle community are joining my team at Snowflake Computing.

sno-cloud-analytics-tour-2018-email-signature

Drumroll please!

It is my honor and pleasure to announce that Laura K Ramsey and Danny Bryant have joined my team!

Laura will serve as the Director of Technical Education, Training, and Content.

Danny is joining as a Senior Solution Architect (and sometime Technical Trainer).

Please join me in congratulating them on launching their careers further into the #cloud.

Be sure to follow Danny on twitter and at his blog DBA on Tap. And check out all of Laura’s tweets too!

And keep your eyes on my handle, and theirs, to see what happens at Snowflake HQ this week.

Let it snow!

snowflakedifferencescreenshot

Kent

The Data Warrior

Advertisements

Snowflake at Stoweflake

20170519_073717

Every year the World Wide Data Vault Consortium (WWDVC) gets better and better! This year’s event was the 4th Annual and was again held at the lovely Stoweflake Mountain Lodge in Stowe, Vermont.

WWDVC_StoweflakeBalloon

And once again this year, my employer, Snowflake Computing, was a proud sponsor of the event. This year I even got to help with a hands on workshop with our ELT partner Talend as we walked folks through building a Data Vault in Snowflake using Talend!

WWDVC Sponsors

100 attendees got their minds filled and horizons broadened by an amazing slate of presentations given by great speakers from all over the world. Not only did we hear some real-life case studies from companies like Micron and Intact Financials (who have VERY large data vaults) but we even got to hear from someone at the US DoD (yes the Department of Defense!).

Then there were these mind-bending talks that challenged the most experienced in the audience:

– Measuring Data as an Asset (by Nols Ebersohn)
– How to get a DV project Approved (by Neil Strange)
– Uncertainty, Risk, & The Value of Information (by Brad Bergh)

And there were of course absolutely awesome keynotes from Tamara Dull (A Big Data Cheat Sheet for the Technically Savvy Data Professional) and from Scott Ambler we heard (very clearly!): Are You Agile or Are You Fragile?

What? You missed WWDVC 2017?

Well I guess you will have to wait for the 5th Annual WWDVC in 2018…

WWDVC Sunset

Can’t wait? You are in luck!

This year Dan hired professional videographers to record the entire event.

Yup, all the workshops, the keynotes, and all the presentations.

I have seen the videos and they came out great.

So, if you would like to join the elite group of 100 data vault aficionados that attended WWDVC17, you now have the chance to see and hear the same great content we all were exposed to. Then you can be the champion for brining Data Vault 2.0 to your organization.

You can purchase access to all the recordings right here.

NB: There are no refunds on this purchase out of consideration for those who spent the time and money to attend the event.

Here’s what you get:

Pre-Conference Sessions

  • Brainstorming with Dan Linstedt (Inventor of the Data Vault and DV 2.0), Michael Olschimke (Co-Author, Building a Scalable Data Warehouse with DV 2.0) and Sanjay Pande (co-founder, LearnDataVault)
  • Talend and Snowflake Hand’s On Session
  • WhereScape Hands On Session
  • Analytix DS Hands On Workshop

Conference Sessions

Day 1

  • Keynote I – A Big Data Cheat Sheet for the Technically Savvy Data Professional (Tamara Dull, Director of Emerging Technologies, SAS)
  • Implementing a Data Vault 2.0 in the DoD (Cynthia Meyersohn, Senior Technical Consultant, Quadrint)
  • Data Vault 2.0 and the Power of Metadata (Steven Mellare, Data and Information Architect and Strategist, Pepper Money)
  • Software Defined Data Warehouse Using Data Vault 2.0 (Tevje Olin, Data Architect and Consultant, Solita)
  • Big Data Vault at Micron (Mike Magalsky, Enterprise Data Architect, Micron and Chris Sundstrom, Principal Data Architect, IM Flash Technologies)
  • Talend in the world of Data Vault (Dale Anderson, Customer Success Architect, Talend)
  • Analytix DS (Sam Benedict, VP Strategic Accounts, Analytix DS)
  • Data Mining in the Data Vault (Michael Olschimke, CEO, ScaleFree)

Day 2

  • Keynote II – Are You Agile or Are You Fragile? (Scott Ambler, Senior Consulting Partner, Scott Ambler + Associates)
  • Agile Methods and Data Warehousing: How to Deliver Faster (Kent Graziano, Senior Technical Evangelist, Snowflake Computing)
  • No DV is an Island: What Lies Beyond (Nols Ebersohn, Principal Architect, Certus Solutions Limited)
  • Beyond a Hadoop DV 2.0 Data Warehouse (Sanjay Pande, Co-Founder, LearnDataVault.com)
  • Business Vault Creation using a Rules Engine (Bruce McCartney, Senior Information Architect, First4 Database Partners)
  • Getting a Data Vault Project Approved (Neil Strange, Founder and MD, Business Thinking)
  • A Data Modeler and Process Modeler Walk into a Data Vault (John Giles, Independent Consultant and author of “The Nimble Elephant”)
  • WhereScape Automation Enabling Data Vault 2.0 (Neil Barton, CTO, WhereScape and Paul Watson Gover, Senior Solution Architect, WhereScape)

Day 3

  • Data Vault Automation – An OnGoing Story at Intact Financial (Francois Trudeau, Application Architect for Enterprise Information Systems, Intact Financial)
  • Moving to the Cloud, Metadata Driven Automation at Yale (Robert Scott, CTO, EON Collective)
  • Uncertainty, Risk and the Value of Information (Brad Bergh, Enterprise Information Consultant)

The only thing you miss out on is the great food and of course the in-person networking. So put WWDVC18 on your calendar (May 2018) but in the meantime get started by purchasing the videos from WWDVC17 now.

wwdvc2017

Hopefully seeing these talk may even inspire you to not only attend next year but maybe even speak yourself!

Enjoy!

Kent

The Data Warrior & Data Vault Master

P.S. Of course if you have any questions or want to learn more about Snowflake, the 1st cloud-native data warehouse as a service, please reach out to me or follow me on twitter @kentgraziano.

Cloud Analytics Conference – London!

Next up on The Data Warrior speaking tour 2017 is the Snowflake Cloud Analytics Conference in London on June 1st!

CloudConference

Snowflake is kicking off this year’s Cloud Analytics City Tour with a blow out event in London, England. This will be a full day workshop style event where you get to hear and learn from industry veterans and thought leaders like myself, and the CEO of Snowflake Computing, Bob Muglia (to name just a few). In addition we will have a Practitioner Panel discussion that includes several of our customers along with other industry thought leaders.

The unique value proposition for this event is that in the afternoon you can choose from two tracks of in depth sessions related to implementing your BI solutions and your data warehouse in the cloud.

I will be presenting my talk Agile Methods and Data Warehousing: How to Deliver Faster. My highly seasoned colleagues from Snowflake (all industry experts) will teach you about loading data in the cloud, deploying BI in the cloud, and how to best use Snowflake to be successful with your cloud analytics program.

And of course there will be food, drinks, and networking.

You can find all the agenda details here along with the registration form. Use discount code DATAWARRIOR for 50% off the registration fee.  Sign up today!

This will be my first time ever in London, so if you are in the area, please come by, say “hi” and learn about the new world of Cloud Analytics.

Until then, cheers!

Kent

The Data Warrior

P.S. I will be in London the day before and after the event, so if you want to have a more detailed or personalized discussion of the benefits of cloud-native data warehousing, please reach out to me at kent.graziano@snowflake.net.

#OOW13 – Oracle OpenWorld 2013: Pictures, Tweets and more

#OOW13 is well underway now with lots of tweets and blog posts already out on the web. Check the stream on twitter under #oow13 for all the news.

I tried to see some of the Americas Cup race on Saturday but unfortunately the weather and wind did  not cooperate so the race was called for the day. 😦

But got a few pictures to share:

Americas Cup Racing: Team USA

Americas Cup Racing: Team USA

And a  nice view:

Golden Gate from the East Bleachers at the Americas Cup

Golden Gate from the East Bleachers at the Americas Cup

The New Oracle Plaza

Imagine our shock when we learned that there would be no Howard Street Tent this year! The nerve.

But in its place is the open-air Oracle Plaza, full of comfortable seats for hanging out, networking, eating lunch, and watching the keynotes on a big screen. Oracle is really counting on the weather to be typical dry fall weather. Hopefully that holds up.

OOW13: The New Oracle Plaza

OOW13: The New Oracle Plaza

User Group Sunday

I did attend a few sessions on Sunday.

The only session this year (from a user) on my favorite tool, Oracle SQL Developer Data Modeler was given by Heli Helskyaho, the CEO of Miracle Finland (@HeliFromFinland).

Heli Helskyaho: Why do I need #SQLDevModler?

Heli Helskyaho: Why do I need #SQLDevModler?

She did an excellent job of introducing folks to SDDM and laid out 9 use cases for using the tool.

9 use cases for #SQLDevModeler

9 use cases for #SQLDevModeler

(Hard to read I know, but zoom in…)

I also attended a session by my buddy Stewart Bryson, who is now the new Chief Innovation Officer for Rittman Mead globaly, Congrats Stewart!

He did an amazing (IMO) talk about how to go beyond agile and achieve Extreme BI. He gave us the beginnings of a complete Oracle-based framework which looks very promising.

He said some heretical things like skip the staging area for your data warehouse! I do think he is on to something and can make it work so we have a real chance at real time BI and still have a solid architectural foundation.

Stewart Bryson's talk about Extreme BI

Stewart Bryson’s talk about Extreme BI

Opening Keynote

Of course the was the opening Keynote by Oracle CEO Larry Ellison. Key words: #bigdata #inmemory and #AmericasCup (of course). Lots of big news.

Check out this info graphic about the event.

Mark Rittman already did a nice review of the talk (among other things). So rather than repeat check out his post.

And for those interested, right now the Americas Cup standings are USA 5 to New Zealand 8. But that will change later today for sure when they race again.

More to come about #oow13 and this years Oaktable World (#OTW13).

Later.

Kent

The Oracle Data Warrior

P.S. Had a great evening last night at the annual Oracle #ACE dinner which was hosted at the Walt Disney Museum in The Presidio.

KScope13 Day Four: Agile, Big Data, and a Very Special Event

Mid-week. Hump day. The day of the BIG event for KScope13.

Lots of anticipation for the annual Special Event… (which I will write about in a minute or so)

Morning Chi Gung as usual, but with 24 people showing up. Biggest group this week. We even have a few locals joining us now. Everyone seems to be enjoying these sessions.

KScope attendees starting the day with Morning Chi Gung on the plaza in front of Harahs casino.

KScope attendees starting the day with Morning Chi Gung on the plaza in front of Harrahs casino.

In fact, the Chi Gung class at KScope may be the original cross over session! Attendees are from across the spectrum from DBAs, to developers, to Hyperion/EPM folks to spouses of attendees.

There is something for everyone in Morning Chi Gung.

Kanban and Scrum

Everyone wants to be “agile” these days. Stew Stryker of Dartmouth University came to KScope to share with us his experience in applying first Kanban then Scrum to the software development life cycle in his IT department.

Stew Stryker, from Dartmouth College, discusses how his team has use Kanban, and now SCRUM, to improve their software development process.

Stew Stryker, from Dartmouth College, discusses how his team has used Kanban, and now SCRUM, to improve their software development process.

One of Stew’s insights was that to effectively implement a change in methodology like this and get adoption it is first necessary for the powers-that-be to recognize the current approach (usually water fall) is failing.

If you do not know you have a problem, there is no motivation to fix it, right?

A key recommendation he had was to get a consultant that knows and has implemented Kanban for database projects to come in and work with you. Don’t try to do it by just reading articles and books or going to training. There are too many nuances and organizational dynamics to account for.

A simple comparison of aspects of a traditional waterfall methodology compared to the Kanban approach.

A simple comparison of aspects of a traditional waterfall methodology compared to the Kanban approach.

Another key to succes was to prevent context switching – that is keep everyone focused on the task at hand for the duration of the interval (or sprint). He did a great little exercise with us that really showed how task switching costs a lot of time. In some case up to 10 times longer.

It was great to hear real world experiences that we could all take back to our offices and implement and discuss. His team has experienced some great success but with lots of lessons learned, which he shared.

They have now switch to SCRUM with even more success.

Hands On Lab #2

I attended my second lab of the conference to learn from Maria Colgan (@SQLMaria) on how to prevent sub-optimal plans on SQL Statements.

Oracle Senior Product Manager Maria Colgan walks us through how to analyze and and tune some queries.

Oracle Senior Product Manager Maria Colgan walks us through how to analyze and tune some queries.

It was a great session using the Oracle Demo Days virtual box image again (from OTN). Maria walked us through several queries with Explain Plans that did not seem quite right and showed us how to diagnose and fix the potential problems.

It was a little tough for those of us who have not used Linux/Unix or command line in a few years but I did learn a lot and should be able to apply that knowledge when we have poor performing queries at my clients. Worse case, I can always start up the vm again and run through the lab.

Inside the Oracle 12c Opimizer

Another killer session from Maria showing us enhancements and new features to the query optimizer in the recently released Oracle 12c.

Overview of how adaptive query optimization works on Oracle 12c

Overview of how adaptive query optimization works on Oracle 12c

How the new Adaptive Execution Plans work in Oracle 12c

How the new Adaptive Execution Plans work in Oracle 12c

The key phrase for 12c “self-healing” and “adaptive”. Remember when there were just 17 rules for the optimizer that we could control with the syntax of the query?

Long ago.

I guess this is better, but there are still rules to know to make the optimizer work well.

And Maria definitely knows them!

Big Data

These days every tech event has to talk about big data. KScope13 is no different.

Alex Shlepakov, from Accenture’s Oracle BI practice, gave a nice talk about integrating Hadoop with OBIEE using ODI.

He did a really nice job explaining all the concepts and moving parts and how Oracle addressed these things.

Alex presented about doing big data analysis using Oracle BI tools.

Alex presented about doing big data analysis using Oracle BI tools.

All the Oracle products that support the analysis of data in a Hadoop environment

All the Oracle products that support the analysis of data in a Hadoop environment

Pretty sure these products cost lots of money too! But if you want to get value out of your big data, you may have to spend big money for the tools to help (unless you have a lot of programers with really big brains).

My main take away from this session is that the tools to support Hadoop and big data analysis are evolving to make it easier for most programmers to get to the data without having to be Map Reduce programmers.

But it will still be pretty hard, so you better have a good business case for digging into it.

Special Event (aka the big party)

As in past years, ODTUG really did it up right. This was truly a special event to remember – we went to Mardi Gras World!

The annual Special Event was held at Mardi Gras World where we got to see some of the big floats from the famous parade.

The annual Special Event was held at Mardi Gras World where we got to see some of the big floats from the famous parade.

What a treat to see some of the big floats used in the famous parade. I even found a full scale replica of the Bat Boat tucked away in the back. (There was a huge Batman statue as well)

The Oracle Data Warrior finds Batman's boat!

The Oracle Data Warrior finds Batman’s boat!

The tour of the Mardi Gras warehouse included plenty of bead throwing from the floats by the board of directors and the various KScope vendors. This was followed by a nice evening of drinks and a buffet dinner with lots of great food (even some gluten free and vegetarian options).   There was plenty of dancing to great cover band called The Mixed Nuts.

We finished the evening with a spectacular fire works display (which seems to becoming a standard at this event).

We had a spectacular fireworks display (shot off a barge) at the annual KScope Big Event

We had a spectacular fireworks display (shot off a barge) at the annual KScope Big Event

Over too soon, it was last call, last dance, then back to the buses and a short ride to the hotel.

And then there were the after parties….

Stay tuned for my notes on our final day in New Orleans.

Ciao!

Kent

Post Navigation

%d bloggers like this: