Monthly Archives: May 2015

MSSQL Mass Delete

To avoid holding up everything else when deleting massive amounts of data from an SQL Server table, you can use the TOP() function to delete the data in chunks. SELECT 1 WHILE @@ROWCOUNT > 0 BEGIN DELETE TOP(1000) FROM [dbo].[mytable] WHERE timestampUtc < ‘2015-05-29’ END The “SELECT 1” primes the @@ROWCOUNT variable, so the while […]

dovecot: master: Error: systemd listens on port 143, but it’s not configured in Dovecot. Closing.

Upgrading a mail server from Debian Wheezy (7) to Debian Jessie (8), the following errors were observed in the mail.error log: dovecot: master: Error: systemd listens on port 143, but it’s not configured in Dovecot. Closing. dovecot: master: Error: systemd listens on port 993, but it’s not configured in Dovecot. Closing Looking for solutions, I […]