Using T-SQL to Answer Date-Related Calculations

There are many interesting questions related to date calculations. For example, I have seen the following questions Give a date, find the first Tuesday day of the previous week/month/quarter,...

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...

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...

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...

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...

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...

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...

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...

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...

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...