Monthly Archives: August 2011

Thoughts on DBA Professional Development

As a DBA, we have a lot to work on and also we have a lot to learn about. The asset that makes us as a DBA is our professional knowledge and skills, and as such, from time to time, … Continue reading

Posted in Career, professional development | Tagged | Leave a comment

Counting code lines in SPs with Powershell

One of interesting tasks I once had is to check the # of code lines for all user stored procedures (SPs) in a user database. I once developed a pure yet lengthy t-sql solution by counting the new line ASCII … Continue reading

Posted in Uncategorized | Leave a comment

Database Administration Operation Road Map

In my company, every two years, we have a tradition to collectively ponder at the technology road map for the next two years, this may include what OS / server products / development tools / management tools / hardware architecture … Continue reading

Posted in Uncategorized | 2 Comments

Delete backup files older than <xx> days

For almost all sql backup jobs, we want to have a step to delete old backup files older than a specified time. Usually there are two ways, one is to use Maintenance Plan or we create our own “cleaning” step … Continue reading

Posted in SQL Development | Tagged , , | Leave a comment