News

A core tenant of the RESTful API development doctrine is that a Uniform Resource Locator, as the name implies, should uniquely identify a resource on the server. Sadly, that simple concept is often ...
Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...
I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 minutes ...
Excel is more than just a spreadsheet tool; it is a comprehensive platform for data analysis and business intelligence. By using its advanced tools—Power Query, Power Pivot, and DAX—you can elevate ...
A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects. Every so often, I find myself wishing that I had a utility ...
Have you ever found yourself tangled in a web of Excel formulas, trying to clean up messy datasets or make sense of inconsistent entries? If so, you’re not alone. Many of us have spent countless hours ...