The Data Warrior

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

Archive for the tag “Free”

02 Nov 2020

Snowflake Data Cloud Summit 2020

This will be an EPIC event that you will not want to miss.

Join me and the rest of the Snowflake team at Data Cloud Summit 2020! This year we are going virtual with eight business and technology summit tracks, filled with never-before-seen demos, customer presentations, fun interviews, fireside executive chats and, of course, technical deep dive sessions.

This is a totally FREE event that will deliver:

  • 8 tracks
  • 40+ Sessions
  • 25+ partners

All focused on using the Snowflake Data Cloud to #MobilizeYourData!

Mark this date on your calendar – November 17, 8:30 AM – 2:30 PM PT.

And if you miss any part of the event, sessions will be available for replay immediately after.

Register now:  Snowflake Data Cloud Summit 2020

And if you CAN’T Make the North American event, we have additional dedicated events for all my global friends too:

The EMEA event will be on November 18th. Register here: Data Cloud Summit – EMEA

For my friends down under in APAC, the event will be November 19: Data Cloud Summit – APAC

And for all the folks in JAPAN, we have an event just for you on November 25th: Data Cloud Summit – Japan

So no reason to miss this great event.

Check out the agenda today and plan you viewing!

See you online.

Kent G

The Data Warrior and Chief Technical Evangelist, Snowflake

Posted in #cloud, Big Data, Data Warehouse, SnowflakeDB and tagged , , , , , , , , , , | Leave a comment
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 , , , , , , , , , ,
04 Dec 2013
4 Comments

Better Data Modeling: The best FREE data modeling tool just got better!

Yes, it true Virginia, the is a Santa Claus!

And this year Santa brought you a new, improved version of the best FREE data modeling tool in the known universe: Oracle SQL Developer Data Modeler 4.0.

The team at Oracle went all out this year and produced three (yes three) pre-release versions to make sure all the fixes and new features were rock solid before they called it production.

That is a lot of testing and work.

But worth the effort – they fixed piles of bugs and added dozens of new features.

Oracle product manager Jeff Smith (@thatjeffsmith) has already published several articles highlighting his favorite new features. Check out what he has to say here then go download the new version and give it try.

Let me know what you your favorite new feature is.

Merry Christmas!

The Oracle Christmas Elf

(Kent)

P.S. Without proven methods and standards, even the best tool will not insure you build the best model, so why not increase your chances by giving yourself the gift of knowledge by picking up a copy of my data model checklist book (on sale for a few more hours).

 

Posted in Data Modeling, Oracle, SQL Developer Data Modeler and tagged , , , , , , , , , , ,
12 Jun 2013
1 Comment

Free Introduction to Data Warehousing the Data Vault Way

My good friend Dan (@dlinstedt) has put together a sweet set of three videos to introduce everyone to the wonderful world of Data Vault.

When you sign up you will get a set of email messages from Dan discussing the Data Vault Approach to data warehousing. You get access to three videos about the architecture, the methodology, and the modeling technique.

Plus you get free downloads of the first few chapters of the data vault book Super Charge Your Data Warehouse.

So if you have always wanted to learn more about Data Vault, but don’t have the budget for a full on class, this offer will get you headed in the right direction.

Head on over to the Learn Data Vault site now. It is all free.

(NB: this is an affiliate link. If you eventually buy the book or some other training off Dan’s site, I will get a small piece of the action. Not enough to retire mind you, but it might buy lunch.)

The videos are pretty cool. Enjoy.

Kent

Posted in Data Vault, Data Warehouse and tagged , , , , , , , , ,
14 Jan 2013
36 Comments

Tech Tip: Connect to SQL Server Using Oracle SQL Developer (updated)

I spend a lot of time reverse engineering client databases to see what kind of design they are working with or to simply create a data model diagram for them (so they know what they have).

Along the way I often need to actually look at the data as well to do some analysis and profiling.

Often this means looking at data and models in SQL Server as well as Oracle.

What’s an Oracle Data Warrior to do?

Hook up my FREE handy dandy Oracle SQL Developer to the SQL Server database.

How do you do that?

First you need to get the right driver. You can find it here: http://sourceforge.net/projects/jtds/files/jtds/1.2.5/jtds-1.2.5-dist.zip/download

NOTE: For SQL Developer 4.0EA3 and SQL Developer Data Modeler 4.0 (production) you now need jtds-1.3.1. Get it here: http://sourceforge.net/projects/jtds/files/

Then follow these steps:

  1. Download and unzip the file into the main SQL Developer directory (or the directory of your choice).
  2. In SQL Developer go to Tools -> Preferences -> Database -> Third party JDBC Drivers
  3. Click the “add entry” button
  4. Navigate to the jtds-1.2.5.jar file. (or the 1.3.1 file for 4.x installs)
  5. Save and exit preferences.
  6. Close and restart SQL Developer
  7. Open “Add Connection” – there should now be a SQL Server tab.
SQL Developer Preferences

SQL Developer Preferences

With this in place, you can now connect to SQL Server without having to load any other software.

Pretty useful.

Happy Querying!

Kent

P.S. You can connect to other non-Oracle dbs as well. Check out this post by Jeff Smith for even more details.

Additional Notes on SSO errors:

Lots of folks, including me, have had issues getting the native Windows SSO connection to SQL Server to work. Based on answers on the OTN Forum and this post (http://www.oracle-base.com/blog/2013/10/01/sql-developer-4-ea2-connecting-to-sql-server/) I finally got my new 4.x versions to work.

For SQL Developer 4.0EA3, I did as suggested in the article: http://www.oracle-base.com/blog/2013/10/01/sql-developer-4-ea2-connecting-to-sql-server/. I put the ntlmauth.dll where my JDK 1.7 was installed: C:\Program Files\Java\jdk1.7.0_40\jre\bin

For Data Modeler 4.0.13 (production), based on a suggestion from Jeff Smith, I put the dll file here: C:\SQLDeveloper\SQLDeveloper4.0.13\sqldeveloper\sqldeveloper\bin

If I was better at setting windows paths, I am sure there is a better way to do this.

Posted in Oracle and tagged , , , , , , , , , , , , ,

Post Navigation

← Older Entries
%d bloggers like this: