More SQL Server development continues - some heavy lifting
by Mountain Computers Inc., Publication Date: Tuesday, May 17, 2022
View Count: 405, Keywords: SQL Server, 2019, Heavy Lifting, Hashtags: #SQLServer #2019 #HeavyLifting
More SQL Server development and testing continues today. Some heavy lifting going on yet thank goodness the project is rather short and sweet. A lot of data transformations, updates, cleaning, and indexing.
The reporting engine on the backside is custom with some OLE-DB connections which I prefer for speed. When it comes to application mapping and binding of data fields and consistency checking and concurrency of record locking, well, let's just say, its both an art and science to do it properly.
more to come...
if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.
© 2023 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.