Category Archives: Uncategorized

A DBA’s Developer Experience and After-Thoughts

After 10+ years of a dedicated DBA, for the past 17 months, I have purposely chosen to work as a database developer. I decided to do this mainly for two reasons: 1. I want to have a career travel to … Continue reading

Posted in Uncategorized | 6 Comments

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 … Continue reading

Posted in Uncategorized | 10 Comments

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 … Continue reading

Posted in Uncategorized | Tagged , | 2 Comments

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 … Continue reading

Posted in Uncategorized | Leave a comment

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 … Continue reading

Posted in Uncategorized | 4 Comments

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 … Continue reading

Posted in Uncategorized | Leave a comment

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 … Continue reading

Posted in Uncategorized | Leave a comment