Yuval Aloni
Introduction If you've ever dealt with ANY database system you probably encountered the ACID acronym. Let's briefly go over each of the principles it describes: A for Atomicity The concept of treating something (a block of data operations in our context) as a single, indivisible unit of work. C...
Adam Lynch
The goal here is get what you need done as quickly as possible and keep rolling. "Move fast and break things. Unless you are breaking stuff, you are not moving fast enough." - Mark Zuckerberg. 1. Connect to your production databases using the same tool you use for development. There's no need to...
Carl Trachte
This is another simple but common problem in certain business environments: 1) Data are presented via a Microsoft SQL Server Reporting Services report, BUT 2) The user wants the data in Excel, and, further, wants to play with it (pivot, etc.) there. The problem is that the grouping column...
Carl Trachte
A couple months back I had a one-off assignment to dump some data from a vendor provided relational database to a csv file and then from there to Excel (essentially a fairly simple ETL - extract, transform, load exercise). It was a little trickier than I had planned it. Disclaimer: this may not...