Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: DatabaseCollation
| Server          | ServerCollation      | Database                    | DatabaseCollation    | IsEqual   |
|:----------------|:---------------------|:----------------------------|:---------------------|:----------|
| SQL2008Ser12R2  | Latin1_General_CI_AS | dbatools-testrestore-master | Latin1_General_CI_AS | True      |
| SQL2008Ser12R2  | Latin1_General_CI_AS | master                      | Latin1_General_CI_AS | True      |
| SQL2008Ser12R2  | Latin1_General_CI_AS | model                       | Latin1_General_CI_AS | True      |
| SQL2008Ser12R2  | Latin1_General_CI_AS | msdb                        | Latin1_General_CI_AS | True      |
| SQL2008Ser12R2  | Latin1_General_CI_AS | tempdb                      | Latin1_General_CI_AS | True      |
| SQL2012Ser08AG1 | Latin1_General_CI_AS | AGDB                        | Latin1_General_CI_AS | True      |
| SQL2012Ser08AG1 | Latin1_General_CI_AS | AndJusticeforAll            | Latin1_General_CI_AS | True      |
| SQL2012Ser08AG1 | Latin1_General_CI_AS | Blackened                   | Latin1_General_CI_AS | True      |
| SQL2012Ser08AG1 | Latin1_General_CI_AS | DBA-Admin                   | Latin1_General_CI_AS | True      |
| SQL2012Ser08AG1 | Latin1_General_CI_AS | DyersEve                    | Latin1_General_CI_AS | True      |


Table: DatabaseCompatibilityLevel
| Server         | ServerLevel   | Database         | DatabaseCompatibility   | IsEqual   |
|:---------------|:--------------|:-----------------|:------------------------|:----------|
| SQL2005Ser2003 | Version90     | AdventureWorks   | Version90               | True      |
| SQL2005Ser2003 | Version90     | AdventureWorksDW | Version90               | True      |
| SQL2005Ser2003 | Version90     | Aerosmith        | Version90               | True      |
| SQL2005Ser2003 | Version90     | BlackSabbath     | Version90               | True      |
| SQL2005Ser2003 | Version90     | DBA-Admin        | Version90               | True      |
| SQL2005Ser2003 | Version90     | IronMaiden       | Version90               | True      |
| SQL2005Ser2003 | Version90     | master           | Version90               | True      |
| SQL2005Ser2003 | Version90     | model            | Version90               | True      |
| SQL2005Ser2003 | Version90     | msdb             | Version90               | True      |
| SQL2005Ser2003 | Version90     | Nirvana          | Version90               | True      |


Table: DatabaseOwner
| Server         | Database         | DBState   | CurrentOwner   | TargetOwner   | OwnerMatch   |
|:---------------|:-----------------|:----------|:---------------|:--------------|:-------------|
| SQL2005Ser2003 | AdventureWorks   | Normal    | THEBEARD\Rob   | sa            | False        |
| SQL2005Ser2003 | AdventureWorksDW | Normal    | THEBEARD\Rob   | sa            | False        |
| SQL2005Ser2003 | Aerosmith        | Normal    | THEBEARD\Rob   | sa            | False        |
| SQL2005Ser2003 | BlackSabbath     | Normal    | THEBEARD\Rob   | sa            | False        |
| SQL2005Ser2003 | DBA-Admin        | Normal    | THEBEARD\Rob   | sa            | False        |
| SQL2005Ser2003 | IronMaiden       | Normal    | THEBEARD\Rob   | sa            | False        |
| SQL2005Ser2003 | master           | Normal    | sa             | sa            | True         |
| SQL2005Ser2003 | model            | Normal    | sa             | sa            | True         |
| SQL2005Ser2003 | msdb             | Normal    | sa             | sa            | True         |
| SQL2005Ser2003 | Nirvana          | Normal    | THEBEARD\Rob   | sa            | False        |


Table: DiskAlignment
| Server   | Name   |   PartitonSizeInMB | PartitionType           |   TestingStripeSizeKB |   OffsetModuluCalculationKB |   StartingOffsetKB | IsOffsetBestPractice   | IsBestPractice   |   NumberOfBlocks | BootPartition   |   PartitionBlockSize | IsDynamicDisk   |
|:---------|:-------|-------------------:|:------------------------|----------------------:|----------------------------:|-------------------:|:-----------------------|:-----------------|-----------------:|:----------------|---------------------:|:----------------|
| SQL2005  | C:     |            24568.1 | Installable File System |                  1024 |                        31.5 |               31.5 | False                  | False            |         50315517 | True            |                  512 | False           |
| SQL2005  | C:     |            24568.1 | Installable File System |                   128 |                        31.5 |               31.5 | False                  | False            |         50315517 | True            |                  512 | False           |
| SQL2005  | C:     |            24568.1 | Installable File System |                   256 |                        31.5 |               31.5 | False                  | False            |         50315517 | True            |                  512 | False           |
| SQL2005  | C:     |            24568.1 | Installable File System |                   512 |                        31.5 |               31.5 | False                  | False            |         50315517 | True            |                  512 | False           |
| SQL2005  | C:     |            24568.1 | Installable File System |                    64 |                        31.5 |               31.5 | False                  | False            |         50315517 | True            |                  512 | False           |
| SQL2008  | C:     |            61338   | Installable File System |                  1024 |                         0   |           103424   | False                  | True             |        125620224 | False           |                  512 | False           |
| SQL2008  | C:     |            61338   | Installable File System |                   128 |                         0   |           103424   | False                  | True             |        125620224 | False           |                  512 | False           |
| SQL2008  | C:     |            61338   | Installable File System |                   256 |                         0   |           103424   | False                  | True             |        125620224 | False           |                  512 | False           |
| SQL2008  | C:     |            61338   | Installable File System |                   512 |                         0   |           103424   | False                  | True             |        125620224 | False           |                  512 | False           |
| SQL2008  | C:     |            61338   | Installable File System |                    64 |                         0   |           103424   | False                  | True             |        125620224 | False           |                  512 | False           |


Table: DiskAllocation
| Server   | Name                | Label          |   BlockSize | IsSqlDisk   | IsBestPractice   |
|:---------|:--------------------|:---------------|------------:|:------------|:-----------------|
| SQL2008  | C:\                 |                |        4096 | True        | False            |
| SQL2014  | C:\                 |                |        4096 | False       | False            |
| SQL2014  | C:\mounts\newmount\ | mounted volume |        4096 | False       | False            |
| SQL2014  | L:\                 | Logs           |       65536 | True        | True             |
| SQL2014  | M:\                 | Data           |       65536 | True        | True             |
| SQL2014  | W:\                 | New Volume     |       65536 | False       | True             |
| SQL2014  | X:\                 | New Volume     |       65536 | False       | True             |
| SQL2014  | Y:\                 | New Volume     |       65536 | False       | True             |
| SQL2014  | Z:\                 | New Volume     |       65536 | False       | True             |
| SQL2016  | C:\                 |                |        4096 | True        | False            |


Table: FullRecoveryModel
| Server         | Database              | ConfiguredRecoveryModel   | ActualRecoveryModel   | Notes   | FullRecoveryModel   |
|:---------------|:----------------------|:--------------------------|:----------------------|:--------|:--------------------|
| SQL2005Ser2003 | model                 | FULL                      | FULL                  |         | True                |
| SQL2005Ser2003 | Aerosmith             | FULL                      | FULL                  |         | True                |
| SQL2005Ser2003 | BlackSabbath          | FULL                      | FULL                  |         | True                |
| SQL2005Ser2003 | IronMaiden            | FULL                      | FULL                  |         | True                |
| SQL2005Ser2003 | Nirvana               | FULL                      | FULL                  |         | True                |
| SQL2005Ser2003 | Prince                | FULL                      | FULL                  |         | True                |
| SQL2005Ser2003 | RageAgainstTheMachine | FULL                      | FULL                  |         | True                |
| SQL2005Ser2003 | DBA-Admin             | FULL                      | FULL                  |         | True                |
| SQL2008Ser12R2 | model                 | FULL                      | FULL                  |         | True                |
| SQL2008Ser12R2 | DBA-Admin             | FULL                      | FULL                  |         | True                |


Table: JobsOwner
| Server         | Job                                                      | CurrentOwner   | TargetOwner   | OwnerMatch   |
|:---------------|:---------------------------------------------------------|:---------------|:--------------|:-------------|
| SQL2005Ser2003 | Check things                                             | sa             | sa            | True         |
| SQL2005Ser2003 | CommandLog Cleanup                                       | sa             | sa            | True         |
| SQL2005Ser2003 | DatabaseBackup - SYSTEM_DATABASES - FULL                 | sa             | sa            | True         |
| SQL2005Ser2003 | DatabaseBackup - SYSTEM_DATABASES - FULL - Big_Beard_NAS | sa             | sa            | True         |
| SQL2005Ser2003 | DatabaseBackup - USER_DATABASES - DIFF                   | sa             | sa            | True         |
| SQL2005Ser2003 | DatabaseBackup - USER_DATABASES - FULL                   | sa             | sa            | True         |
| SQL2005Ser2003 | DatabaseBackup - USER_DATABASES - FULL - Big_Beard_NAS   | sa             | sa            | True         |
| SQL2005Ser2003 | DatabaseBackup - USER_DATABASES - LOG                    | sa             | sa            | True         |
| SQL2005Ser2003 | DatabaseIntegrityCheck - SYSTEM_DATABASES                | sa             | sa            | True         |
| SQL2005Ser2003 | DatabaseIntegrityCheck - USER_DATABASES                  | sa             | sa            | True         |


Table: LastBackup
| Server         | Database         | RecoveryModel   | LastFullBackup          | LastDiffBackup        | LastLogBackup        | SinceFull       | SinceDiff       | SinceLog   | DatabaseCreated         |   DaysSinceDbCreated | Status                                  |   DaysSinceLastFullBackup | MissingBackup   | LastFullBackupHandled   |
|:---------------|:-----------------|:----------------|:------------------------|:----------------------|:---------------------|:----------------|:----------------|:-----------|:------------------------|---------------------:|:----------------------------------------|--------------------------:|:----------------|:------------------------|
| SQL2005Ser2003 | AdventureWorks   | Simple          | 2017-05-13 10:01:20.000 | 5/13/2017 12:00:05 AM |                      | 7 days 03:24:09 | 7 days 13:25:24 |            | 2016-12-02 17:52:13.793 |                  168 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:01:20.000 |
| SQL2005Ser2003 | AdventureWorksDW | Simple          | 2017-05-13 10:02:20.000 | 5/13/2017 12:00:06 AM |                      | 7 days 03:23:09 | 7 days 13:25:23 |            | 2016-12-02 18:05:26.463 |                  168 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:02:20.000 |
| SQL2005Ser2003 | Aerosmith        | Full            | 2017-05-13 10:03:24.000 | 5/13/2017 12:00:08 AM | 5/19/2017 4:16:01 PM | 7 days 03:22:05 | 7 days 13:25:21 | 21:09:28   | 2016-12-02 18:05:26.480 |                  168 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:03:24.000 |
| SQL2005Ser2003 | BlackSabbath     | Full            | 2017-05-13 10:03:46.000 | 5/13/2017 12:00:09 AM | 5/19/2017 4:16:01 PM | 7 days 03:21:43 | 7 days 13:25:20 | 21:09:28   | 2016-12-02 18:05:26.496 |                  168 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:03:46.000 |
| SQL2005Ser2003 | DBA-Admin        | Full            | 2017-05-13 10:03:48.000 | 5/13/2017 12:00:10 AM | 5/19/2017 4:16:01 PM | 7 days 03:21:41 | 7 days 13:25:19 | 21:09:28   | 2016-12-02 18:09:03.183 |                  168 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:03:48.000 |
| SQL2005Ser2003 | IronMaiden       | Full            | 2017-05-13 10:03:50.000 | 5/13/2017 12:00:11 AM | 5/19/2017 4:16:01 PM | 7 days 03:21:39 | 7 days 13:25:18 | 21:09:28   | 2016-12-02 18:05:26.510 |                  168 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:03:50.000 |
| SQL2005Ser2003 | master           | Simple          | 2017-05-13 10:00:34.000 |                       |                      | 7 days 03:24:55 |                 |            | 2003-04-08 09:13:36.390 |                 5156 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:00:34.000 |
| SQL2005Ser2003 | model            | Full            | 2017-05-13 10:01:35.000 |                       |                      | 7 days 03:23:54 |                 |            | 2003-04-08 09:13:36.390 |                 5156 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:01:35.000 |
| SQL2005Ser2003 | msdb             | Simple          | 2017-05-13 10:01:41.000 |                       |                      | 7 days 03:23:48 |                 |            | 2005-10-14 01:54:05.240 |                 4236 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:01:41.000 |
| SQL2005Ser2003 | Nirvana          | Full            | 2017-05-13 10:03:52.000 | 5/13/2017 12:00:12 AM | 5/19/2017 4:16:02 PM | 7 days 03:21:37 | 7 days 13:25:17 | 21:09:27   | 2016-12-02 18:05:26.526 |                  168 | No Full or Diff Back Up in the last day |                      1882 | True            | 2017-05-13 10:03:52.000 |


Table: LastGoodCheckDb
| Server   | Database                                                                         | LastGoodCheckDb   | DaysSinceLastGoodCheckDb   |
|:---------|:---------------------------------------------------------------------------------|:------------------|:---------------------------|
| sql2005  | Application_Registry_Service_DB_cde90313b64848408b625cb9b083eaf3                 |                   | True                       |
| sql2005  | Application_Registry_Service_DB_cde90313b64848408b625cb9b083eaf3_20161224_012032 |                   | True                       |
| sql2005  | Bdc_Service_DB_d739e5ac04fe419e9d9b36c459ed25a0                                  |                   | True                       |
| sql2005  | db_2005_CL80                                                                     |                   | True                       |
| sql2005  | Managed Metadata Service_409329a415ed46b99d18fd24e3daee80                        |                   | True                       |
| sql2005  | model                                                                            |                   | True                       |
| sql2005  | msdb                                                                             |                   | True                       |
| sql2005  | PerformancePoint Service Application_e54ae521b7cf42aa973f3b273c595f2e            |                   | True                       |
| sql2005  | Search_Service_Application_CrawlStoreDB_400e7eef5e624ca3a8a42c5fa30d7213         |                   | True                       |
| sql2005  | Search_Service_Application_DB_1d8c840dacad4043b11bbf54637a2470                   |                   | True                       |


Table: MaxDop



Table: MaxMemory
| Server          |   InstanceCount |   TotalMB |   SqlMaxMB |   RecommendedMB | BestPractice   |
|:----------------|----------------:|----------:|-----------:|----------------:|:---------------|
| SQL2005Ser2003  |               1 |      4096 | 2147483647 |            2048 | False          |
| SQL2008Ser12R2  |               1 |      8096 | 2147483647 |            5024 | False          |
| SQL2012Ser08AG1 |               1 |      4096 | 2147483647 |            2048 | False          |
| SQL2012Ser08AG2 |               1 |      4096 | 2147483647 |            2048 | False          |
| SQL2012Ser08AG3 |               1 |      4096 | 2147483647 |            2048 | False          |
| SQL2014Ser12R2  |               1 |      4970 |       4096 |            1898 | False          |
| SQL2016N1       |               1 |      2048 | 2147483647 |            1024 | False          |


Table: NetworkLatency
|   Count |   TotalMs |   AvgMs |   ExecuteOnlyTotalMs |   ExecuteOnlyAvgMs | ComputerName    | InstanceName   | SqlInstance     |
|--------:|----------:|--------:|---------------------:|-------------------:|:----------------|:---------------|:----------------|
|       3 |   108.214 |  36.071 |               35.301 |             17.651 | SQL2005SER2003  | MSSQLSERVER    | SQL2005SER2003  |
|       3 |   261.913 |  87.304 |               28.396 |             14.198 | SQL2008SER12R2  | MSSQLSERVER    | SQL2008SER12R2  |
|       3 |   289.179 |  96.393 |               75.627 |             37.813 | SQL2012SER08AG1 | MSSQLSERVER    | SQL2012SER08AG1 |
|       3 |   369.043 | 123.014 |              140.53  |             70.265 | SQL2012SER08AG2 | MSSQLSERVER    | SQL2012SER08AG2 |
|       3 |    77.815 |  25.938 |               60.667 |             30.333 | SQL2012SER08AG3 | MSSQLSERVER    | SQL2012SER08AG3 |
|       3 |   255.417 |  85.139 |               35.428 |             17.714 | SQL2014SER12R2  | MSSQLSERVER    | SQL2014SER12R2  |
|       3 |    36.552 |  12.184 |               24.946 |             12.473 | SQL2016N1       | MSSQLSERVER    | SQL2016N1       |


Table: OptimizeForAdHoc
| Instance        |   CurrentOptimizeAdHoc |   RecommendedOptimizeAdHoc | Notes                          | UsingRecommended?   |
|:----------------|-----------------------:|---------------------------:|:-------------------------------|:--------------------|
| SQL2008Ser12R2  |                      0 |                          1 | Recommended configuration is 1 | False               |
| SQL2012Ser08AG1 |                      0 |                          1 | Recommended configuration is 1 | False               |
| SQL2012Ser08AG2 |                      0 |                          1 | Recommended configuration is 1 | False               |
| SQL2012Ser08AG3 |                      0 |                          1 | Recommended configuration is 1 | False               |
| SQL2014Ser12R2  |                      0 |                          1 | Recommended configuration is 1 | False               |
| SQL2016N1       |                      0 |                          1 | Recommended configuration is 1 | False               |


Table: ServerName
| ServerInstanceName   | SqlServerName   | IsEqual   | RenameRequired   | Updatable   | Warnings                                                      | Blockers   |
|:---------------------|:----------------|:----------|:-----------------|:------------|:--------------------------------------------------------------|:-----------|
| SQL2005SER2003       | SQL2005SER2003  | True      | False            | True        | N/A                                                           | N/A        |
| SQL2008SER12R2       | SQL2008SER12R2  | True      | False            | True        | N/A                                                           | N/A        |
| SQL2012SER08AG1      | SQL2012SER08AG1 | True      | False            | True        | Reporting Services (MSSQLSERVER) must be stopped and updated. | N/A        |
| SQL2012SER08AG2      | SQL2012SER08AG2 | True      | False            | True        | N/A                                                           | N/A        |
| SQL2012SER08AG3      | SQL2012SER08AG3 | True      | False            | True        | N/A                                                           | N/A        |
| SQL2014SER12R2       | SQL2014SER12R2  | True      | False            | True        | Reporting Services (MSSQLSERVER) must be stopped and updated. | N/A        |
| SQL2016N1            | SQL2016N1       | True      | False            | True        | N/A                                                           | N/A        |


Table: TempDB
| ComputerName   | InstanceName   | SqlInstance    | Rule                   | Recommended   | CurrentSetting   | IsBestpractice   | Notes                                                                                                      |
|:---------------|:---------------|:---------------|:-----------------------|:--------------|:-----------------|:-----------------|:-----------------------------------------------------------------------------------------------------------|
| SQL2005SER2003 | MSSQLSERVER    | SQL2005SER2003 | TF 1118 Enabled        | True          | False            | False            | KB328551 describes how TF 1118 can benefit performance.                                                    |
| SQL2005SER2003 | MSSQLSERVER    | SQL2005SER2003 | File Count             | True          | True             | True             | Microsoft recommends that the number of tempdb data files is equal to the number of logical cores up to 8. |
| SQL2005SER2003 | MSSQLSERVER    | SQL2005SER2003 | File Growth in Percent | False         | True             | False            | Set grow with explicit values, not by percent.                                                             |
| SQL2005SER2003 | MSSQLSERVER    | SQL2005SER2003 | File Location          | False         | True             | False            | Do not place your tempdb files on C:\.                                                                     |
| SQL2005SER2003 | MSSQLSERVER    | SQL2005SER2003 | File MaxSize Set       | False         | False            | True             | Consider setting your tempdb files to unlimited growth.                                                    |
| SQL2008SER12R2 | MSSQLSERVER    | SQL2008SER12R2 | TF 1118 Enabled        | True          | False            | False            | KB328551 describes how TF 1118 can benefit performance.                                                    |
| SQL2008SER12R2 | MSSQLSERVER    | SQL2008SER12R2 | File Count             | True          | True             | True             | Microsoft recommends that the number of tempdb data files is equal to the number of logical cores up to 8. |
| SQL2008SER12R2 | MSSQLSERVER    | SQL2008SER12R2 | File Growth in Percent | False         | True             | False            | Set grow with explicit values, not by percent.                                                             |
| SQL2008SER12R2 | MSSQLSERVER    | SQL2008SER12R2 | File Location          | False         | True             | False            | Do not place your tempdb files on C:\.                                                                     |
| SQL2008SER12R2 | MSSQLSERVER    | SQL2008SER12R2 | File MaxSize Set       | False         | False            | True             | Consider setting your tempdb files to unlimited growth.                                                    |


Table: ValidLogin
| Server          | Domain   | Login                  | Type   | Found   | Enabled   | DisabledInSQLServer   | AccountNotDelegated   | AllowReversiblePasswordEncryption   | CannotChangePassword   | PasswordExpired   | Lockedout   | PasswordNeverExpires   | PasswordNotRequired   | SmartcardLogonRequired   | TrustedForDelegation   | UserAccountControl   |
|:----------------|:---------|:-----------------------|:-------|:--------|:----------|:----------------------|:----------------------|:------------------------------------|:-----------------------|:------------------|:------------|:-----------------------|:----------------------|:-------------------------|:-----------------------|:---------------------|
| SQL2005SER2003  | THEBEARD | Rob                    | User   | False   | True      | False                 | False                 | False                               | False                  | False             | False       | True                   | False                 | False                    | False                  | 66048                |
| SQL2005SER2003  | THEBEARD | SQL_SVC                | User   | True    | True      | False                 | False                 | False                               | False                  | False             | False       | True                   | False                 | False                    | False                  | 66048                |
| SQL2005SER2003  | THEBEARD | SVC_SCOM               | User   | False   | True      | False                 | False                 | False                               | False                  | False             | False       | True                   | False                 | False                    | False                  | 66048                |
| SQL2008SER12R2  | THEBEARD | Rob                    | User   | True    | True      | False                 | False                 | False                               | False                  | False             | False       | True                   | False                 | False                    | False                  | 66048                |
| SQL2008SER12R2  | THEBEARD | SQL_DBAs_The_Cool_Ones | Group  | False   |           | False                 |                       |                                     |                        |                   |             |                        |                       |                          |                        |                      |
| SQL2012SER08AG1 | THEBEARD | Rob                    | User   | True    | True      | False                 | False                 | False                               | False                  | False             | False       | True                   | False                 | False                    | False                  | 66048                |
| SQL2012SER08AG1 | THEBEARD | SQL_SVC                | User   | True    | True      | False                 | False                 | False                               | False                  | False             | False       | True                   | False                 | False                    | False                  | 66048                |
| SQL2012SER08AG1 | THEBEARD | SVC_SCOM               | User   | False   | True      | False                 | False                 | False                               | False                  | False             | False       | True                   | False                 | False                    | False                  | 66048                |
| SQL2012SER08AG1 | THEBEARD | SVC_SQL_AG2            | User   | True    | True      | False                 | False                 | False                               | False                  | False             | False       | False                  | False                 | False                    | False                  | 512                  |
| SQL2012SER08AG1 | THEBEARD | SVC_SQL_AG3            | User   | True    | True      | False                 | False                 | False                               | False                  | False             | False       | True                   | False                 | False                    | False                  | 66048                |


Table: VirtualLogFile
| Server         | Database              |   Count | HighNumberOfVLFs   |
|:---------------|:----------------------|--------:|:-------------------|
| SQL2005Ser2003 | AdventureWorks        |      12 | False              |
| SQL2005Ser2003 | AdventureWorksDW      |       4 | False              |
| SQL2005Ser2003 | Aerosmith             |       4 | False              |
| SQL2005Ser2003 | BlackSabbath          |       4 | False              |
| SQL2005Ser2003 | DBA-Admin             |       4 | False              |
| SQL2005Ser2003 | IronMaiden            |       4 | False              |
| SQL2005Ser2003 | Nirvana               |       4 | False              |
| SQL2005Ser2003 | Prince                |       4 | False              |
| SQL2005Ser2003 | RageAgainstTheMachine |       4 | False              |
| SQL2008Ser12R2 | DBA-Admin             |       5 | False              |

 


tables: name: DatabaseCollation
data: DatabaseCollation.csv
name: DatabaseCompatibilityLevel
data: DatabaseCompatibilityLevel.csv
name: DatabaseOwner
data: DatabaseOwner.csv
name: DiskAlignment
data: DiskAlignment.csv
name: DiskAllocation
data: DiskAllocation.csv
name: FullRecoveryModel
data: FullRecoveryModel.csv
name: JobsOwner
data: JobsOwner.csv
name: LastBackup
data: LastBackup.csv
name: LastGoodCheckDb
data: LastGoodCheckDb.csv
name: MaxDop
data: MaxDop.csv
name: MaxMemory
data: MaxMemory.csv
name: NetworkLatency
data: NetworkLatency.csv
name: OptimizeForAdHoc
data: OptimizeForAdHoc.csv
name: ServerName
data: ServerName.csv
name: TempDB
data: TempDB.csv
name: ValidLogin
data: ValidLogin.csv
name: VirtualLogFile
data: VirtualLogFile.csv
label: DatabaseCollation
Server
MaxMemory
Server
DatabaseCompatibilityLevel
Server
MaxMemory
Server
DatabaseOwner
Server
MaxMemory
Server
FullRecoveryModel
Server
MaxMemory
Server
JobsOwner
Server
MaxMemory
Server
LastBackup
Server
MaxMemory
Server
VirtualLogFile
Server
MaxMemory
Server
LastGoodCheckDb
Server
MaxMemory
Server
ValidLogin
Server
MaxMemory
Server
DiskAlignment
Server
MaxMemory
Server
DiskAllocation
Server
MaxMemory
Server
output: {
    "joins": [
        {
            "from_table": "DatabaseCollation",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "DatabaseCompatibilityLevel",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "DatabaseOwner",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "FullRecoveryModel",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "JobsOwner",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "LastBackup",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "VirtualLogFile",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "LastGoodCheckDb",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "ValidLogin",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "DiskAlignment",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        },
        {
            "from_table": "DiskAllocation",
            "from_column": "Server",
            "to_table": "MaxMemory",
            "to_column": "Server"
        }
    ]
}