database Tag

After attending an in-depth technical training in Dallas, Texas, I thought it could be beneficial to give some examples of how Snowflake is unique in a series of blog posts moving forward. This week, I’m talking about JSON (although Snowflake’s functionality displayed in the article...

We’re pleased to announce that InterWorks is officially a Snowflake Solution Partner. After getting to know the Snowflake team as well as the ins and outs of their product, we see the immediate value Snowflake can bring to clients in search of a modern data...

As “big data” becomes increasingly ubiquitous and important to a variety of organizations, many of the existing database systems and platforms have become too cumbersome to set up and maintain: On-site systems can be complex and difficult to scale; and other “big data” solutions require...

Tim Costello - InterWorks' own analytics consultant and SQL guru - switches sides of the mic and is interviewed about his move from medical responder to agile promoter. Tim and Ben talk about SQL Saturdays, agile data warehousing, getting into a meetup, making yourself better. Subscribe...

In most real world data sets, we want to compare “year over year” values. How were we doing last year? How does that compare to this year? Monitoring these comparisons can provide valuable insights to your business; however, the calculation is cumbersome and slow to generate in...

Keeping track of the growing number and types of database products is a full-time chore. This week I spent a few days in Vail, Colorado at the Pacific Crest Global Technology Forum. This is the 17th year that Pacific Crest Securities has sponsored the event—bringing...

A few years ago, I decided to try to count all of the database products that were available. After spending several hours on a Friday evening trying to count all of them, I gave up at around 2 a.m., having counted 200. I classified them...

A couple years ago, Josh Varner was a consultant working on our BI team at InterWorks. The last time I saw Josh (when he was still on our team) was at the Vertica Conference in Boston. I was leaving early for a gig in New...

In my first InterWorks blog post, I’ve decided to write about something that I commonly used in other BI platforms. The idea of passing parameters in Microsoft and IBM products is vastly used in reporting. A user can define their parameter before running the report....

To be more proactive in prevention of account expirations, create an automated report identifying those nearing expiration. Using the scripts outlined below, a report can be set up to run on startup. This provides awareness with ease. The following were excecuted using the SYS account. Create...

(This is a multi-part series about the proper care & feeding of a Vertica cluster. There’s simply too much content for one post, so I’ll be splitting this up into a three-part series. Check back in a few days for the next installment.) Vertica is a...

Scenario Our sales team collects information and forecasts possible sales using a data-table called ‘Opportunities’.  If a sales opportunity converts to an actual sales lead, the customer and his information is moved to the ‘Leads’ table.  Opportunities that do not convert remain on the original table.  Additionally,...

Loading data into Teradata can be done quickly and fairly easily using the Teradata FastLoad utility, but the utility isn’t exactly friendly to new users. This article provides a quick introduction into the FastLoad utility, which is included in the free Teradata Tools & Utilities...

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK