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
| DECLARE @db_name varchar(50) = N'db_name', | |
| @table_name varchar(250) = N'db_name.dbo.tbl_name' | |
| SELECT IndStat.database_id, | |
| IndStat.object_id, | |
| QUOTENAME(s.name) + '.' + QUOTENAME(o.name) AS [object_name], | |
| IndStat.index_id, | |
| QUOTENAME(i.name) AS index_name, | |
| IndStat.avg_fragmentation_in_percent, | |
| IndStat.partition_number, |
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
| kubectl config unset users.gke_project_zone_name | |
| kubectl config unset contexts.aws_cluster1-kubernetes | |
| kubectl config unset clusters.foobar-baz | |
| kubectl config use-context my-cluster-name |
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
| rabbitmqctl add_user test test | |
| rabbitmqctl set_user_tags test administrator | |
| rabbitmqctl set_permissions -p / test ".*" ".*" ".*" |
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
| -- In master database: | |
| -- Creates login | |
| CREATE LOGIN user1 | |
| WITH PASSWORD = 'secretpassword'; | |
| GO | |
| -- In user's database: | |
| -- Creates user | |
| CREATE USER user1 FROM LOGIN user1; | |
| GO |