File age measurements show the distribution of file ages (days since the first commit) and the recency of file updates (days since the latest commit).
Summary
- Number of files: 71
- Daily file updates (only one update per file and date counted): 10539
- First update: 2017-06-25
- Latest update: 2022-01-14
- Days between first and latest update: 1665 (237 weeks, estimated 1185 working days)
- Active days (at least one file change): 62
- Data:
File Change History Overall
File Age Distribution Overall
Days since first update
- There are 71 files with 777 lines of code in files.
- 71 files that are 366+ days old (777 lines of code)
- 0 files that are 181-365 days old (0 lines of code)
- 0 files that are 91-180 days old (0 lines of code)
- 0 files that are 31-90 days old (0 lines of code)
- 0 files that are 1-30 days old (0 lines of code)
Legend:
366+
181-365
91-180
31-90
1-30
Latest Change Distribution Overall
Days since last update
- There are 71 files with 777 lines of code in files.
- 71 files have been last changed 366+ days ago (777 lines of code)
- 0 files have been last changed 181-365 days ago (0 lines of code)
- 0 files have been last changed 91-180 days ago (0 lines of code)
- 0 files have been last changed 31-90 days ago (0 lines of code)
- 0 files have been last changed 1-30 days ago (0 lines of code)
Legend:
366+
181-365
91-180
31-90
1-30
File Change History per File Extension
sql, sh, cmd, md, ps1, ipynb, yaml, txt, java, MD, yml, js, json, gitignore, tpl, xml
File Age Distribution per Extension
Days since first update
366+
181-365
91-180
31-90
1-30
Latest Change Distribution per Extension
Days since last update
366+
181-365
91-180
31-90
1-30
File Change History per Logical Decomposition
primary
primary (file age distribution)
Days since first update
366+
181-365
91-180
31-90
1-30
primary (latest change distribution)
Days since last update
366+
181-365
91-180
31-90
1-30
Oldest Files (Top 20)
| File | # lines | # units | last modified (days ago) | created (days ago) | # changes |
|---|---|---|---|---|---|
 _config.yml in root |
1 | - | 1448 | 1450 | 2 |
 customerappinssel.js in sqllinuxbook/ch4 |
84 | 6 | 1174 | 1174 | 1 |
execinsertcustomer.js in sqllinuxbook/ch4 |
30 | 1 | 1174 | 1174 | 1 |
customerappconnect.js in sqllinuxbook/ch4 |
21 | - | 1174 | 1174 | 1 |
createwwi.cmd in sqllinuxbook/ch3 |
9 | - | 1174 | 1174 | 1 |
extendwwidw.cmd in sql2019book/ch2_intelligent_performance/iqp |
1 | - | 838 | 1015 | 2 |
 RegexSample.java in sql2019book/ch5_modern_development_platform/java |
66 | 4 | 838 | 838 | 1 |
mydeployment.yaml in sql2019book/ch8_sql_on_k8s/mychart/templates |
66 | - | 838 | 838 | 1 |
deployment.yaml in sql2019book/ch8_sql_on_k8s/mychart/templates |
51 | - | 838 | 838 | 1 |
sql2019deployment.yaml in sql2019book/ch8_sql_on_k8s/deploy |
39 | - | 811 | 838 | 2 |
ingress.yaml in sql2019book/ch8_sql_on_k8s/mychart/templates |
38 | - | 838 | 838 | 1 |
sql2017deployment.yaml in sql2019book/ch8_sql_on_k8s/update |
37 | - | 838 | 838 | 1 |
_helpers.tpl in sql2019book/ch8_sql_on_k8s/mychart/templates |
30 | - | 838 | 838 | 1 |
service.yaml in sql2019book/ch8_sql_on_k8s/mychart/templates |
19 | - | 838 | 838 | 1 |
values.yaml in sql2019book/ch8_sql_on_k8s/mychart |
19 | - | 838 | 838 | 1 |
sqlloadbalancer.yaml in sql2019book/ch8_sql_on_k8s/deploy |
12 | - | 838 | 838 | 1 |
storage.yaml in sql2019book/ch8_sql_on_k8s/deploy |
12 | - | 811 | 838 | 2 |
buildclass.cmd in sql2019book/ch5_modern_development_platform/java |
7 | - | 838 | 838 | 1 |
 cleanup.ps1 in sql2019book/ch7_inside_sql_containers/update/dockerpowershell |
7 | - | 838 | 838 | 1 |
reset.ps1 in sql2019book/ch7_inside_sql_containers/update/dockerpowershell |
5 | - | 838 | 838 | 1 |
Files Not Recently Changed (Top 20)
| File | # lines | # units | last modified (days ago) | created (days ago) | # changes |
|---|---|---|---|---|---|
_config.yml in root |
1 | - | 1448 | 1450 | 2 |
createwwi.cmd in sqllinuxbook/ch3 |
9 | - | 1174 | 1174 | 1 |
customerappconnect.js in sqllinuxbook/ch4 |
21 | - | 1174 | 1174 | 1 |
execinsertcustomer.js in sqllinuxbook/ch4 |
30 | 1 | 1174 | 1174 | 1 |
customerappinssel.js in sqllinuxbook/ch4 |
84 | 6 | 1174 | 1174 | 1 |
step6_dockerconnectotsql.ps1 in sql2019book/ch7_inside_sql_containers/update/dockerpowershell |
1 | - | 838 | 838 | 1 |
step4_dockerconnectotsql.ps1 in sql2019book/ch7_inside_sql_containers/update/dockerpowershell |
1 | - | 838 | 838 | 1 |
step2_dockerconnectotsql.ps1 in sql2019book/ch7_inside_sql_containers/update/dockerpowershell |
1 | - | 838 | 838 | 1 |
step1_dockerrun.ps1 in sql2019book/ch7_inside_sql_containers/update/dockerpowershell |
1 | - | 838 | 838 | 1 |
dockerrunnonroot.ps1 in sql2019book/ch7_inside_sql_containers/nonroot |
1 | - | 838 | 838 | 1 |
step8_dockerquerywwi..ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step7_dockerstart.ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step6_dockerstop.ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step5_dockerexec.ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step4_dockerrestorebackup.ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step3_dockercopybackup.ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step2_dockerconnectotsql.ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step1_dockerrun.ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step13_dockerquerywwi..ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
step10a_dockerrunvolume.ps1 in sql2019book/ch7_inside_sql_containers/deploy/dockerpowershell |
1 | - | 838 | 838 | 1 |
Most Recently Created Files (Top 20)
| File | # lines | # units | last modified (days ago) | created (days ago) | # changes |
|---|---|---|---|---|---|
 README.MD in azuresqlbook |
22 | - | 455 | 455 | 1 |
query_order_rating.cmd in azuresqlbook/ch7_performance/tuning_recommendations |
5 | - | 455 | 455 | 1 |
failoverbase_bc.ps1 in azuresqlbook/ch8_availability/gp_vs_bc |
4 | - | 455 | 455 | 1 |
failoverbase_gp.ps1 in azuresqlbook/ch8_availability/gp_vs_bc |
4 | - | 455 | 455 | 1 |
sqlworkload.cmd in azuresqlbook/ch7_performance/monitor_and_scale |
1 | - | 455 | 455 | 1 |
order_rating_insert.cmd in azuresqlbook/ch7_performance/tuning_applications |
1 | - | 455 | 455 | 1 |
order_rating_insert_single.cmd in azuresqlbook/ch7_performance/tuning_applications |
1 | - | 455 | 455 | 1 |
querybase_bc.cmd in azuresqlbook/ch8_availability/gp_vs_bc |
1 | - | 455 | 455 | 1 |
querybase_gp.cmd in azuresqlbook/ch8_availability/gp_vs_bc |
1 | - | 455 | 455 | 1 |
README.MD in sql2019book/ch7_inside_sql_containers |
9 | - | 798 | 810 | 2 |
README.MD in sql2019book/ch2_intelligent_performance |
7 | - | 810 | 810 | 1 |
README.MD in sql2019book/ch4_mission_critical_availability |
5 | - | 810 | 810 | 1 |
README.MD in sql2019book/ch5_modern_development_platform |
5 | - | 810 | 810 | 1 |
README.MD in sql2019book/ch3_new_security_capabilities |
3 | - | 810 | 810 | 1 |
README.MD in sql2019book/ch9_data_virtualization |
3 | - | 810 | 810 | 1 |
README.MD in sql2019book |
97 | - | 668 | 811 | 7 |
RegexSample.java in sql2019book/ch5_modern_development_platform/java |
66 | 4 | 838 | 838 | 1 |
mydeployment.yaml in sql2019book/ch8_sql_on_k8s/mychart/templates |
66 | - | 838 | 838 | 1 |
deployment.yaml in sql2019book/ch8_sql_on_k8s/mychart/templates |
51 | - | 838 | 838 | 1 |
sql2019deployment.yaml in sql2019book/ch8_sql_on_k8s/deploy |
39 | - | 811 | 838 | 2 |
Most Recently Changed Files (Top 20)
| File | # lines | # units | last modified (days ago) | created (days ago) | # changes |
|---|---|---|---|---|---|
README.MD in azuresqlbook |
22 | - | 455 | 455 | 1 |
query_order_rating.cmd in azuresqlbook/ch7_performance/tuning_recommendations |
5 | - | 455 | 455 | 1 |
failoverbase_bc.ps1 in azuresqlbook/ch8_availability/gp_vs_bc |
4 | - | 455 | 455 | 1 |
failoverbase_gp.ps1 in azuresqlbook/ch8_availability/gp_vs_bc |
4 | - | 455 | 455 | 1 |
sqlworkload.cmd in azuresqlbook/ch7_performance/monitor_and_scale |
1 | - | 455 | 455 | 1 |
order_rating_insert.cmd in azuresqlbook/ch7_performance/tuning_applications |
1 | - | 455 | 455 | 1 |
order_rating_insert_single.cmd in azuresqlbook/ch7_performance/tuning_applications |
1 | - | 455 | 455 | 1 |
querybase_bc.cmd in azuresqlbook/ch8_availability/gp_vs_bc |
1 | - | 455 | 455 | 1 |
querybase_gp.cmd in azuresqlbook/ch8_availability/gp_vs_bc |
1 | - | 455 | 455 | 1 |
README.MD in sql2019book |
97 | - | 668 | 811 | 7 |
README.MD in sql2019book/ch7_inside_sql_containers |
9 | - | 798 | 810 | 2 |
README.MD in sql2019book/ch2_intelligent_performance |
7 | - | 810 | 810 | 1 |
README.MD in sql2019book/ch4_mission_critical_availability |
5 | - | 810 | 810 | 1 |
README.MD in sql2019book/ch5_modern_development_platform |
5 | - | 810 | 810 | 1 |
README.MD in sql2019book/ch3_new_security_capabilities |
3 | - | 810 | 810 | 1 |
README.MD in sql2019book/ch9_data_virtualization |
3 | - | 810 | 810 | 1 |
sql2019deployment.yaml in sql2019book/ch8_sql_on_k8s/deploy |
39 | - | 811 | 838 | 2 |
storage.yaml in sql2019book/ch8_sql_on_k8s/deploy |
12 | - | 811 | 838 | 2 |
RegexSample.java in sql2019book/ch5_modern_development_platform/java |
66 | 4 | 838 | 838 | 1 |
mydeployment.yaml in sql2019book/ch8_sql_on_k8s/mychart/templates |
66 | - | 838 | 838 | 1 |