Install PowerDNS with recursor and MySQL backend

PowerDNS is not designed to provide recursive results. It is intended to act only as an authoritative server for the domains it serves. This implies it will be serving domain data to other hosts. Install pdns and pdns-recursor sudo apt-get install pdns-server pdns-recursor edit recursor settings in /etc/powerdns/recursor.conf local-port=53 forward-zones=mydomain.local=127.0.0.1:54 # change ‘mydomain.local’ to your...

Read More

Large MSDB Database From sysmaintplan_logdetail Table

I recently received a panicked call from a client who had a SQL instance go down because the server’s C drive was full. As the guy looked he found that the msdb database file was 31 GB and was consuming all of the free space on the OS drive causing SQL to shut down. He cleaned up some other old files so that SQL would work again but did...

Read More