Outside the context of ETL staging, if your application must resort to pattern matching on varchar columns when joining tables or filtering rowsets, then your data model is to some...

Also, keep in mind that MIN and MAX are scalar operations, so they will always return a value, like a value of NULL for an empty table. However, SELECT TOP...

Another issue is date/times contained in VARCHAR columns. 

The ISO standard for formatting date strings is YYYYMMDD, and the following check constaint will not only require that the string...

If you're debating whether something like phone number or zip code should be contained as a varchar versus an integer, then I'd rather err on the side of varchar. For...

I don't have a problem with Microsoft's technical implementation of CLR functions in SQL Server. It's just that when folks want execute C# or VB.NET from SQL Server queries, it...

Imagine that you're at the shopping mall, and a sales associate follows you out of the store, keeping notes about every other store you visit, and even following you home,...

I only use table variables for stored procedures that I know will query only a relatively small number of rows. For example, a procedure that gets called by a high...

We shouldn't allow criminals, terrorists, hostile nations, or political dictators to set our agenda.

So, do microservices really eliminate the need for RDMS, or could many of them simply be an abstraction for a RDMS?
It is essential that the microservice be backed...

It would be interesting to see some statistics about how many terrorist attacks or criminal operations have been discovered and/or successfully prosecuted by surveillance of internet communications. Does the net...