When you are working with custom software over your database, you can easily find some data you need to clean up. It can be trash from poorly written code, or users can write rubbish if no controls are established. So next couple of posts will be about searching and updating this kind of trash values. …
Few months ago, I was given a task to send some notifications via circular letter. The best thing is to send it by MS WORD. Unfortunately, after sending this, the attachment could not be read on the recipients side. Me and my colleague could not understand, is it because WORD or attachment or in the …
MSSQL has a service called Database mail and it is used from MSSQL 2005 till today. This service is predecessor of SQL Mail. I will write about Database mail, and how to set it up. First of all, you have to open a port 25 (SMTP), so you can send mail from server to the …
Ok, so let’s start with my first blog. Couple of days ago, I’ve been given a task to migrate some tables from AS400 to SQL. So first of all, you would need a connector (provider) to IBM AS400 structure. So that connector comes with IBM iSeries Access software. After quick and “select All option” installation, …