Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Database Administration via CrowdSourcing

According to Wikipedia:

 Crowdsourcing is the process of obtaining needed services, ideas, or content by soliciting contributions from a large group of people, and especially from an online community, rather than from traditional employees or suppliers.

Every DBA must have googled something to address his/her technical issue, and… Read more

0 comments, 135 reads

Posted in DBA Philosophy on 25 May 2015

Award from MSSQLTIPS.com

Today, I am excited and humbled to learn that I am awarded “Rookie of the Year – 2014” by MSSQLTips.com.

I have to say it is probably my best decision in 2014 to write for MSSQLTips.com as I am not only paid decently for writing about what I… Read more

0 comments, 195 reads

Posted in DBA Philosophy on 14 January 2015

Bug in SQL Server 2014 SQLPS For Registered Servers/Groups

I recently had an opportunity to write an article for mssqltips.com on managing registered servers under “local server groups”, and Greg Robidoux was kind enough to do a review for me and he got back to me saying my script not working under SQL Server 2014 SSMS, though it works… Read more

0 comments, 1,372 reads

Posted in DBA Philosophy on 7 June 2014

Decode SQL Server Job Schedules

As once a data architect, I cannot help but admiring and appreciating the data model behind the sql server job schedules. The core design is actually just one table, msdb.dbo.sysschedules, but the design beauty/elegance of the table is that it can support many different types of schedule with a rich… Read more

0 comments, 351 reads

Posted in DBA Philosophy on 7 April 2014

Fun in DateTime Calculations

Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.

Usually there are two types of approaches, one is to convert datetime value to string value and then through string calculations like substring, concatenation and convertion to get the result, another… Read more

4 comments, 2,420 reads

Posted in DBA Philosophy on 2 March 2014

Fun in DateTime Calculations

Recently I was working on a task that needs to handle various datetime calculations, and it is really fun.

Usually there are two types of approaches, one is to convert datetime value to string value and then through string calculations like substring, concatenation and convertion to get the result, another… Read more

4 comments, 137 reads

Posted in DBA Philosophy on 2 March 2014

Reliably Drop A Database With CLR Stored Procedure

 

After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up with a solution that in theory is robust. The only way I can think of is to use a CLR stored procedure which will do the following three… Read more

0 comments, 44 reads

Posted in DBA Philosophy on 20 January 2014

Reliably Drop A Database With CLR Stored Procedure

 

After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up with a solution that in theory is robust. The only way I can think of is to use a CLR stored procedure which will do the following three… Read more

0 comments, 1,235 reads

Posted in DBA Philosophy on 20 January 2014

Reliably Drop A Database In T-SQL Script

 

I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I think I have a solution, which at least I cannot prove it not working so far.

   1: USE master; 

   2: GO

   3:  

   4: IF EXISTS(

Read more

2 comments, 397 reads

Posted in DBA Philosophy on 7 January 2014

Reliably Drop A Database In T-SQL Script

 

I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I think I have a solution, which at least I cannot prove it not working so far.

   1: USE master; 

   2: GO

   3:  

   4: IF EXISTS(

Read more

2 comments, 42 reads

Posted in DBA Philosophy on 7 January 2014

Thoughts About MS Advanced Certification

 

Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on this cancellation and my expectation for future.

I have read lots of blogs discussing this cancellation. Most are against the cancellation. Indeed, I agree this is not a decent… Read more

0 comments, 47 reads

Posted in DBA Philosophy on 16 September 2013

Thoughts About MS Advanced Certification

 

Now MS has decided to cancel all its advanced certifications. I am here to share some of my thoughts on this cancellation and my expectation for future.

I have read lots of blogs discussing this cancellation. Most are against the cancellation. Indeed, I agree this is not a decent… Read more

0 comments, 381 reads

Posted in DBA Philosophy on 16 September 2013

Agile Database Administration

 

I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile <something>” really is, but I do know that the key of “agile <something>” is a breakup of the traditional way of doing <something> and this agile way is coming…

Read more

0 comments, 485 reads

Posted in DBA Philosophy on 12 June 2013

Agile Database Administration

 

I first heard the word “agile <something>” about 10 years ago, I do not have profound experience to what “agile <something>” really is, but I do know that the key of “agile <something>” is a breakup of the traditional way of doing <something> and this agile way is coming…

Read more

0 comments, 50 reads

Posted in DBA Philosophy on 12 June 2013

Database Administration KPIs – 2/2

In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to evaluate DBA work performance from business perspective. However, I believer there should be some qualitative KPIs that can be best used by “insiders” to evaluate the DBA work from… Read more

0 comments, 97 reads

Posted in DBA Philosophy on 4 May 2013

Database Administration KPIs – 2/2

In my last post, I discussed about the quantitative KPIs which, to me, are useful for “outsiders”, i.e. non-DBAs, to evaluate DBA work performance from business perspective. However, I believer there should be some qualitative KPIs that can be best used by “insiders” to evaluate the DBA work from… Read more

0 comments, 2,382 reads

Posted in DBA Philosophy on 4 May 2013

Database Administration KPIs – 1/2

 

As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way, what criteria would I hope to be used by others (my manager / clients / peers etc) to evaluate my work?

In DBA world, we love “no news is… Read more

7 comments, 1,632 reads

Posted in DBA Philosophy on 25 April 2013

Database Administration KPIs – 1/2

 

As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way, what criteria would I hope to be used by others (my manager / clients / peers etc) to evaluate my work?

In DBA world, we love “no news is… Read more

7 comments, 59 reads

Posted in DBA Philosophy on 25 April 2013

Procedural Justice In Database Administration

 

According to Wiki, Procedural Justice (PJ) means:

Procedural justice is the idea of fairness in the processes that resolves disputes and allocates resources.

To me, this concept of PJ should be introduced to database administration domain as well, I’ll use the following example to illustrate the necessity.

As… Read more

0 comments, 39 reads

Posted in DBA Philosophy on 7 April 2013

Procedural Justice In Database Administration

 

According to Wiki, Procedural Justice (PJ) means:

Procedural justice is the idea of fairness in the processes that resolves disputes and allocates resources.

To me, this concept of PJ should be introduced to database administration domain as well, I’ll use the following example to illustrate the necessity.

As… Read more

0 comments, 543 reads

Posted in DBA Philosophy on 7 April 2013

Older posts