Microsoft has recently added two new string functions STRING_AGG and CONCAT_WS to its cloud offering RDBMS solution i.e Azure SQL. These two functions are not new in the market and were already available in other databases like Postgres, Oracle, MySQL Continue Reading..
Checking a column existence in a table is very simple in SQL Server, but you should be careful while doing it on Azure environment. We simply ignore the performance consideration while writing SELECTs against systems tables/views/dmvs etc. Recently a stored proc started Continue Reading..