Subscribe to this blog
PracticalSQLDba
I have total of 11 years of IT experience with Application development, Database Development and Database Administration. I have worked with different version of SQL server from 7.0 to 2008.Started my carrier as VB ,VC++ and database developer in a banking sector for implementing their core banking solution. Currently working as Database Administrator with wide knowledge in performance tuning, high availability solution, troubleshooting and server monitoring. This blog is my humble attempt to share my knowledge and what I learned from my day to day work.
Archives: February 2012
How to setup a task to delete the old backup files or log files from the server ?
Cleaning up the servers disks on daily basis is very important task for smooth functioning of servers.We have seen many times our report servers went down and database backup failed due to the lack of disk space.
It is a tedious task to log in to the servers and delete the old…
0 comments, 373 reads
Posted in PracticalSQLDba on 27 February 2012
How to remove new line character from string using SQL ?
In a varchar column some of the entries were showing space in the left side and even after using the LTRIM it was not getting removed. When I tried to print the first character using the ASCI function it was showing 13 which is a new line character. it can be…
1 comments, 2,079 reads
Posted in PracticalSQLDba on 26 February 2012