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...
I grew up in Midwest City, Oklahoma. I was a military kid and got involved with computers and video games at a young age. I was grounded at 9 for swapping out my first modem while my dad was TDY. It was worth it and...
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...
If you stay up with the latest and greatest of the data analytics community, by now you have heard of Spark – the Apache project for big data processing, machine learning and streaming data. Tableau has a connection for Spark SQL, a feature of Spark...
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...
You might be familiar with aggregate functions in Microsoft SQL Server. These functions give you a way to aggregate your data, for example: a sum of a numeric value grouped by one or more fields in your result set. A common business requirement might be...
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...
As a developer who interacts with SQL Server often, the queries I write for the data I need are often slow. Take the query below as an example: This seems like a very simple query without much room for optimization. In fact, it does not take...
In this video I describe the concept of Source Code Control and demonstrate how you can use source code control (in this case Redgate’s SQL Source Control) to manage changes in your SQL Server database. Are you using any form of source code control in...
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...
Summary/Purpose The purpose of this article is to explain a few instances of how an “Object Server Not Found Error” may occur and to show how to modify your Veeam database to fix your jobs in the event that: A vSphere server has crashed beyond a recoverable...
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...
I ran across this multiple times over the last two years or so. This issue started with the introduction of the AMD tri-core processors, and continued when Intel released the hexa-core processors. This only applies to SQL 2005 RTM or older, on processors that are...
If you've managed production database servers for any amount of time, you may have run into this error message in your maintenance plan logs. "The index "[IndexName]" on table "[TableName]" cannot be reorganized because page level locking is disabled." This will cause your Index Reorganize step...
In SQL Server 2005 and 2008 it's possible to start an agent job with T-SQL syntax. This is frequently useful. For example, you may have a job that you'd like to have an outside application invoke. Jobs can also be used to execute SSIS packages....
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