bind would not work unless allow-query is “any”

When you listen-on 127.0.0.1 or localhost or ::1, and/or allow-query from localhost only, bind will answer only to queries originating from the same computer that runs bind. (It set this way in “testing” probably because they probably just meant to test that bind works without opening it to outside for security reasons.) It is normal … Read more

AWS CLI Command Line: How to use “–query” to output multiple source lines

[*] aws ec2 describe-instances –instance-id i-77777777 \ –query ‘Reservations[*].Instances[*].[InstanceId,ImageId,Tags[*]]’ \ –output text This command will print Instance Id, AMI ID, Key and Value Tags. You can see more examples here: Controlling Command Output from the AWS Command Line Interface [*]

Why multiple PTR records in DNS is not recommended?

The PTR record for a reverse name (eg 7.2.0.192.in-addr.arpa) is expected to identify the canonical name that is associated with that IP address. Both the gateway pointers at network nodes and the normal host pointers at full address nodes use the PTR RR to point back to the primary domain names of the corresponding hosts. … Read more

How do I remove a specific bad plan from the SQL Server query cache?

I figured out a few things select * from sys.dm_exec_query_stats will show all the cached query plans. Unfortunately, no SQL text is shown there. However, you can join the SQL text to the plans like so: select plan_handle, creation_time, last_execution_time, execution_count, qt.text FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text (qs.[sql_handle]) AS qt From here it’s pretty … Read more