Channel

sql Tag

Tableau does a great job of connecting to a variety of databases, but it sometimes needs help on the database end to get the results we need to make hot visualizations. One such example showed itself when connecting to Google BigQuery. The issue? Count distincts. BigQuery doesn't handle count distincts like one...

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...

Tim Costello shares his Speaker Idol talk from SQL PASS Summit 2014. Speaker Idol is a speaking contest among 12 of the sharpest SQL minds in the industry. Whoever gives the best presentation wins. The prize is a speaking spot at next year's summit. "If you...

Today, I noticed an interesting series of blog posts float up in the SQL community. Mike Walsh started things off with his post: "4 Attitudes I wish I had earlier as a DBA" This was followed closely with posts by Kathi Kellenberger and Brent Ozar. I like the theme, so...

The improvements of the Visual Data Window in Tableau 8.2 gave a breath of fresh air to the Tableau community. So far, the new design has been intuitive and user friendly. However, when I went searching for the Custom SQL option when connecting to an...

What do you do when a request can’t be solved by traditional reporting tools, and adding new tables or views to your database can take weeks?  Situation  A new manager joins the group. While you’re presenting your workbook, she wants to see things a little differently. Instead...

A common question I've received from new Vertica users is, "How do I enter newlines into a string literal, or use other backslash sequences like 't'?" This is especially common from users transitioning from systems like MySQL that do not use SQL standard-conforming string literals,...

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...

Let me tell you a secret about working with SQL Server.  Anyone can do it.  I’m not going to imply that it’s easy.  You can’t do it in 24 hours and it’s certainly not for dummies … but it can be done.  The cool thing...

With the advent of C# 3.0, Microsoft introduced the Language Integrated Query (LINQ) feature to provide .NET developers the ability to query and transform data using any .NET language.  This data can come from XML documents, relational database tables, or other objects.  LINQ is quite...

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

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072