The Data Warrior
Changing the world, one data model at a time. How can I help you?
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
#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.)
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!
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!
Using the Snowflake Information Schema
It is my 1 year anniversary of becoming the tech evangelist for Snowflake Computing!
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!
Agile Amped Video – Live from Southern Fried Agile
A few weeks back I had the pleasure of attending and speaking at the Southern Fried Agile event in Charlotte, North Carolina.
It was quite an event with over 700 people in attendance. This is a primarily local event drawing people mostly from the Charlotte area. To say agile is big in that town is an understatement. There were some very large, name brand, companies present. If you are interested in learning more about taking an agile approach to development, I can highly recommend this event which draws excellent speakers (and vendors) from all over. (And the traditional southern fried lunch was pretty darn good too!)
My talk was on applying agile methods to data warehousing projects. I had a great audience of about 50 who wanted to learn how they might approach their DW projects differently.
In addition to giving my talk I got the opportunity to participate in my 2nd Agile Amped interview. This time my interviewer was Leslie from SolutionsIQ. We talked a lot about the rise of agile in the data warehousing space and how new technology solutions like Snowflake’s Cloud-Native Elastic Data Warehouse are helping organizations achieve a more agile deployment cycle.
Here is the entire interview for your viewing pleasure:
If you want to watch more Agile Amped video podcasts you can find them online here.
Enjoy.
Kent
The Data Warrior
Kent - The Data Warrior-
Alumni
Better Data Modeling
Now in paperback!
Kindle format on Amazon
Click to buy on Amazon
Get the Original Data Vault Book!
Got Modeler? Need Training?
Learn Oracle Data Modeler from The Data Warrior
Data Vault 2.0 Book
The Data Warrior 
You must be logged in to post a comment.