Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...

I always seem to have trouble with the simplest things. I can figure out more complicated stuff on my own most of the time though. Odd.<br><br>Here's what I have: I have an Access db with a table ...