Delete Logs Older Than 6 Months

Posted on By David Kittell 
DELETE FROM LogTable WHERE log_datetime < dateAdd(m, -6, getDate())
Originally Posted on February 25, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

Web Crawler – C#

Posted on

<?xml version="1.0"?> <configuration> <configSections> <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > <section name="WebCrawler.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" /> </sectionGroup> </configSections> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> </startup> <userSettings> <WebCrawler.Properties.Settings> <setting name="LogPath" serializeAs="String"> <value>C:tempWebCrawlerErrorLog.txt</value> </setting> <setting name="XMLPath" serializeAs="String"> <value>C:tempWebCrawlerWebCrawlerLog.xml</value> </setting> <setting name="URLPath" serializeAs="String"> <value /> </setting> <setting name="TrimTitle" serializeAs="String">…

Read More

Unix Change Static IP

Posted on

It is best to do this on the machine itself and not remotely as you will lose connection. sudo cp /etc/network/interfaces /etc/network/interfaces.`date +"%m-%d-%Y_%I-%M-%S"` sudo sed -i ‘s|address 192.168.1.16|address 10.1.1.16|’ /etc/network/interfaces sudo sed -i ‘s|netmask 255.255.255.0|netmask 255.255.0.0|’ /etc/network/interfaces sudo sed -i ‘s|gateway 192.168.1.1|gateway 10.1.1.1|’ /etc/network/interfaces sudo service resolvconf restart sudo /etc/init.d/networking…

Read More