The Data Warrior

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

31 Dec 2016

Happy New Year!

Happy New Year from The Data Warrior

Posted in Uncategorized and tagged , | Leave a comment
24 Dec 2016

Merry Christmas!

Merry Christmas from The Data Warrio

Posted in Uncategorized and tagged , | Leave a comment
22 Dec 2016
3 Comments

Early Christmas: The New #SQLDev Data Modeler is Here!

Thanks to the gang at Oracle for an early Christmas present – the newest version of Oracle SQL Developer Data Modeler (SDDM) is ready for download and use.

The best FREE data modeling tool on the planet just got better!

To be clear this is Early Adopter (EA) version 2 of SDDM 4.2. You can get it here right now!

#SQLDev Data Modeler New Features

Of course there are some bug fixes from EA1, but also some new features for you to enjoy:

Import from Oracle Database

  •   performance and filtering enhancements
  •   ability to define Oracle Client for thick connections
  •   view and materialized view driving query and columns now parsed and validated

Versioning

  •   improvements in performance
  •   new models are shown as a single node in pending changes window

Reporting

  • PDF reports allow diagrams to be embedded with links from diagram to details part into report
  • HTML report for tables now include diagrams

 

SQL Developer Data Modeler EA2 adds diagrams to HTML reports

#SQLDev Data Modeler HTML report with diagrams embedded

So go download and unwrap that present!

Cheers!

Kent

The Data Warrior

P.S. If you need training on Oracle Data Modeler, be sure to check out my online video training course along with my tips and tricks ebook. (HINT: Buy them now, and you may be able to deduct the cost from your 2016 taxes as an educational expense.)

Posted in Oracle, SQL Developer Data Modeler and tagged , , , , , , , , , , , , ,
01 Dec 2016
1 Comment

Cloud Data Warehousing for Dummies

As we all know, cloud is the big thing these days. Getting bigger everyday it seems.

It may get even bigger than Big Data!

If you, like me, are a data warehousing or BI professional, you have probably been wondering how this all fits in the cloud world. You may have even heard of data warehousing  “in the cloud”.

But what does that really mean? What is a cloud data warehouse?

Well thanks to Snowflake Computing, it just got a little easier to answer this question.

They sponsored the development of a new book called Cloud Data Warehousing for Dummies. Yup, an actual Dummies guide for this. And yes, yours truely, got to have a hand in editing and writing the book.

And the best part – it is FREE!

clouddw_dummies

Researching and helping to write the book was very educational for me. I learned a lot in the process about what constitutes a cloud data warehouse, the difference between a platform in the cloud and a real service in the cloud, and what characteristics folks should look for when choosing one.

I also learned to say “on-premises” instead of “on-premise.” 🙂

Content

The chapters of the book cover:

  • An introduction to cloud data warehousing
  • Why the modern data warehouse emerged
  • The criteria for selecting a modern data warehouse
  • On-premises vs cloud data warehousing
  • Comparing cloud data warehousing solutions
  • A six-step guide to choosing a cloud data warehouse

It also includes several real-world customer case studies.

Even though Snowflake sponsored the book, it is vendor agnostic. It really is a book designed to get you introduced to the concepts and to get you thinking about what you might want in a cloud-based data warehousing system.

It is ideal for anyone who is considering making that transition to the cloud.

So head on over to this site and download your FREE copy today!

To infinity and beyond!

Kent

The Data Warrior (with his head in the clouds)

P.S. Forward this to a friend so they can download a copy too!

 

 

Posted in Big Data, Data Warehouse, SnowflakeDB and tagged , , , , , , , , , ,
16 Nov 2016

Using the Snowflake Information Schema

It is my 1 year anniversary of becoming the tech evangelist for Snowflake Computing!anniversary

Hard to believe that a year ago I gave up independent consulting and joined this amazing team in San Mateo. While there has been a lot of travel recently with my speaking schedule, I have gotten to learn a ton about big data, the cloud, and modern issues in the world of BI and analytics. Things I would have missed out on had I keep doing what I had been doing.

And the more I speak at events, talk to prospects, customers, analysts, and data architects, like me, the more convinced I am that Snowflake has NAILED it! What we have built here is truely unique in the industry and is led by a truely genius team of database engineers. You should come work here too! Tell them the Data Warrior sent you!

So, happy anniversary to me and here is yet another post I did about one of our great features.

Snowflake Information Schema

Snowflake has a data dictionary that we expose to users. We call it the Information Schema. This post will give you some examples of how to use it. Enjoy!

Read the post here: Using the Snowflake Information Schema

Cheers everyone!

Kent

The Data Warrior

P.S. In case you missed it, you can now sign up online for a FREE trial of Snowflake – the data warehouse built for the cloud!

Posted in Big Data, Data Warehouse, SnowflakeDB and tagged , , , , , | Leave a comment

Post Navigation

← Older Entries
Newer Entries →