Author Archives: jxhyao

Bug in SSMS V17.4

  If you are using SSMS V17.4 as I am You may encounter a weird error. This can be repeated as follows: Open a new SSMS window, and connect to any SQL Server instance (I tested on connections to SQL … Continue reading

Posted in SQL Development | Tagged | Leave a comment

Linguistics Crisis In Microsoft Technology

With technology expanding in both complexity and quantity, the task to name each component and functions of a technology product becomes more daunting and thus creates the room for confusion and dubious meaning regarding terms used to explain the technology … Continue reading

Posted in Uncategorized | 3 Comments

How to sign a SQL Server CLR Assembly in Visual Studio 2015

It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR stored procedure / function / trigger etc) in VS 2015. If you google “sign a SQL Server CLR Assembly”, you … Continue reading

Posted in SQL Development | Leave a comment

CLR Stored Procedure Cannot Be Marked as System Object?

It is an open secret that in SQL Server, we can “create a system object” by using an undocumented stored procedure sp_MS_marksystemobject as explained here. The benefit is that when you put a SP in the [master] database and mark … Continue reading

Posted in SQL Development | Tagged | 1 Comment

What Is Your Career Investment Portfolio?

Every year, financial advisors will recommend their clients to take a review of their investment portfolio and make necessary changes according to one’s financial reality, like whether you are going to be married, to have a baby soon, to have … Continue reading

Posted in Career | Tagged | Leave a comment

SQL Server 2016 Bug in R Integration?

  I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using sp_execute_external_script. So here is the re-play of the bug; If I run the following code, I will get an … Continue reading

Posted in Administration | Tagged | 1 Comment

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