Programming in Practice
Technical articles for those interested in programming.
Do You Want to Work at a Startup? The first question you need to ask yourself is do you want to work at a startup. It tends to be quite different from a regular company and you need to think about if you will like it. So let’s talk about what’s different. You will fail. […] …read more
Editor’s note: This is part of our blog series on getting to know AutoTag better. Here’s another useful feature you may have overlooked. AutoTag makes calculating sums in Microsoft® Word, using data from your data source, quick and easy with the Equation Editor’s SUM Function. Let’s say you have a report with a table showing […] …read more
Editor’s note: This is our first article in a new blog series on getting to know AutoTag better. We’ll be introducing you to cool features you may have overlooked. Did you know that AutoTag can automatically calculate due dates? For instance, you can configure the software to calculate and display the due date on an invoice […] …read more
How much do you really want to know? That’s the real question when you’re deciding on a GROUP BY vs a window function in SQL. A GROUP by clause (explained here) is fantastic for a quick summary of your information. Totals, averages, and so on. Window functions, on the other hand, will give you all […] …read more
Oh, the joys of goosing the performance while reducing the memory hit! One of our customers needs to create million-row spreadsheets. Their use case makes a lot of sense. The people who get the spreadsheets use pivot tables and filtering to get just the parts they need, and this way anyone can pull any of […] …read more