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