SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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, we need to review our knowledge/skill portfolio and how we… Read more

4 comments, 1,385 reads

Posted in DBA Philosophy on 20 August 2011

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 code (i.e. char(0×13) + char(0×10) ).

However, with PowerShell and… Read more

0 comments, 1,365 reads

Posted in DBA Philosophy on 14 August 2011

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 we will adopt, and this road map may also include… Read more

0 comments, 1,938 reads

Posted in DBA Philosophy on 13 August 2011

Delete backup files older than 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 using various ways. I am not a big fan of… Read more

3 comments, 4,466 reads

Posted in DBA Philosophy on 6 August 2011