Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

IT People’s Technical Debt and Reputation Credit

In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do a credit history check against the applicant, and based on the result, they will decide whether to approve the application or decide what loan rates the applicant will be charged.… Read more

11 comments, 1,489 reads

Posted in DBA Philosophy on 1 June 2016

New Year Wish List for SQL Server Features

 

With SQL Server 2016 to be officially released this year, I want to make a wish list for the features I really dream of, and see when / whether this list will come true down the road.

1. Revolutionize SSMS with features like those in MS Office Word /… Read more

10 comments, 1,160 reads

Posted in DBA Philosophy on 10 January 2016

Be Cautious About Invoke-SqlCmd Bug

With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered to, IMHO, an corner-stone cmdlet in SQLPS module, invoke-sqlcmd.

I mentioned this here http://stackoverflow.com/questions/33271446/invoke-sqlcmd-runs-script-twice (and also in MS forum)

But I’ll give a more simplified version here to verify this… Read more

2 comments, 54 reads

Posted in DBA Philosophy on 25 October 2015

Be Cautious About Invoke-SqlCmd Bug

With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered to, IMHO, an corner-stone cmdlet in SQLPS module, invoke-sqlcmd.

I mentioned this here http://stackoverflow.com/questions/33271446/invoke-sqlcmd-runs-script-twice (and also in MS forum)

But I’ll give a more simplified version here to verify this… Read more

2 comments, 681 reads

Posted in DBA Philosophy on 25 October 2015

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, 88 reads

Posted in DBA Philosophy on 25 May 2015

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, 308 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, 360 reads

Posted in DBA Philosophy on 14 January 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, 74 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, 2,089 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, 678 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, 3,007 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, 294 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, 185 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,658 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, 627 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, 198 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, 192 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, 522 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, 771 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, 179 reads

Posted in DBA Philosophy on 12 June 2013

Older posts