Progess / Project 702 / Project Challenges

T-SQL Command Line Arguments

I am currently working on automating the climate chip analysis process. It is a mix-and-match of Python code for the calculations and callable command line scripts to manage the database. To be truly effective, I have had taken advantage of T-SQL’s ability to accept command line arguments (called “scripting variables”(1) by Microsoft). In general you … Continue reading

Experiments / Project 702 / Project Challenges

SQL Server bcp Utility to bulk insert data from file

Currently, the climate chip package has two major bottlenecks: the calculation of WBGT and the database write. Both of these processes take 4 – 5 min per year of data. At the moment the database write is a simple iteration with individual insert operations. While this is working, there is plenty of room for improvement. … Continue reading