I got stuck writing a query for Firebird today. And here I was thinking that SQL was a standard — if only the “S” were for “Standard”… I was busy writing scripts atRead More…
I battled for ages to find the correct syntax to create a trigger in MySQL — the examples I could find were all to complex and I could not get any of themRead More…
I love the fact that the best solutions are almost always the simplest! I spend a lot of time sanitising data. I use Excel a lot of the time to perform mostRead More…
I am creating an Excel Report that queries a MySQL database using an ODBC connection. The data is the returned result of a Stored Procedure which contains some pretty slow, resource intensiveRead More…
I have always stored IP addresses as strings in VARCHAR fields in MySQL. I am currently reading “High Performance MySQL” (O’Reilly) and it mentions the advantages of storing IP addresses as integersRead More…
Got this question as part of a skills evaluation test. It requires a query to calculate summary-like data from tables in an order system type database. There is an orders table thatRead More…