Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list. dsq will likely work on other platforms that Go is ported to ...

MySQL is an open-source relational database management system (RDBMS). It stores, manages, and retrieves data using Structured Query Language (SQL). Here, the data is stored in rows and columns in ...

I recently had some interesting problems and learned some cool solutions while working in Power Query in Excel =] ! The first problem I had was that I was trying to create a dynamic SQL query based on ...

Most people view Microsoft’s Excel as a simple “spreadsheet program” that’s rapidly being eclipsed by free web-based apps that run on any cheap laptop. Well think again. Modern-day Excel is an ...

The table below shows my favorite go-to R packages for data import, wrangling, visualization and analysis — plus a few miscellaneous tasks tossed in. The package ...

Often when making changes to a stored procedure or SQL object, testing if the changes have downstream impact can be difficult. This tool automatically runs SQL on two servers, stores the results in ...