Archives: August 2011
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, we need to review our knowledge/skill portfolio and how we… Read more
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 code (i.e. char(0×13) + char(0×10) ).
However, with PowerShell and… Read more
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 we will adopt, and this road map may also include… Read more
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 using various ways. I am not a big fan of… Read more