Jovo Kljajic jkljajic
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Fail2Ban filter for unsuccesfull MSSQL authentication attempts | |
| [INCLUDES] | |
| # Read common prefixes. If any customizations available -- read them from | |
| # common.local | |
| before = common.conf | |
| [Definition] |
jkljajic
/ How to find Duplicate foreign keys
Created
February 7, 2018 07:52
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ;WITH FKData AS | |
| ( | |
| SELECT | |
| fk.parent_object_id, | |
| fkc.parent_column_id, | |
| fk.referenced_object_id, | |
| fkc.referenced_column_id, | |
| FKCount = COUNT(*) | |
| FROM | |
| sys.foreign_keys fk |