Dba domains of the job

legende

de tientallen : 010 , 020, 030, etc = domains
de niet-tientallen : 011 , 012 , 021 , 033 , 0 47, etc = subdomains
zie afkortingen IT
indien geen prefix ; normaal gesproken = domein naam

domeinen

index	domain	prefix	desc
00	general
05	sql-tooling		3th party suites
07	dbatools
10	info
11	lists	ls_
12	inventory	inv_
15	audits
20	maintenace	maint_
21	backup
22	reindex
23	checkdb
27	jobs
30	monitoring	mon_	solutions
40	performance	perf_	pro-actief
41	detecting	dtct_	= lists, but looking/filtering for anamolies (check is verwarrend in SQL
45	troubleshooting	ts_	ad-hoc
50	building	build_
55	partitioning	part_
59	server_config	svr-cfg_	config, options , tweaks
60	migrations	migr_
70	data_in-out	dIO_
71	dIO_sqlscripts
72	dIO_SS_tools
73	DTS
74	SSIS
80	080.sql-technologies
81	logshipping	logsh_
82	HADR
85	fulltext	ft_
86	TDE

[UPDATE] niet 100% ok , alle niet-tientallen moeten subfolders worden

create dir from this table

1. paste col’s index & domain into Kate editor
2. block mode
3. select & delete leading trailing “|”
4. search & replace middle ” | ” with “,” ( replace space with nothing if needed)
5. copy result into xed editor
6. replace ” \n” with “,”
7. replace space with nothing
8. cut result in 3 parts , or so (something manageble)
9. paste each resulting line into the brackets of mkdir -p {}
   10 these commands ar good to go in a terminal
   example :
   shell mkdir -p {000.general,005.sql-tooling,007.dbatools,010.info,011.lists,012.inventory,015.audits,020.maintenace,021.backup,022.reindex} mkdir -p {023.checkdb,027.jobs,030.monitoring,040.performance,041.detecting,045.troubleshooting,050.building,055.partitioning,059.server_config} mkdir -p {060.migrations,070.data_in-out,071.dIO_sqlscripts,072.dIO_SS_tools,073.DTS,074.SSIS,080.,081.logshipping,082.HADR,085.fulltext,086.TDE}