Blogs

SQL Server 2017 T-SQL Enhancement CONCAT VS CONCAT_WS Function

SQL Server 2017 released with very impressive feature in many parts one of this parts T-SQL enhancement  and we have a lot of new feature in this part today I will explain one of them Contact_WS function , in SQL Server 2012 Microsoft added new feature in T-SQL called CONCAT function that is returning string …

SQL 2016 Dynamic data masking

SQL 2016 Dynamic data masking Dynamic data masking in SQL Server 2016 limits sensitive data exposure by masking it to non-privileged users. Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. Dynamic data masking …

Top 5 Exciting Features Available in SQL 2016

Introduction:   SQL Server 2016 is a big step forward. Microsoft released SQL Server 2016 RTM version (13.00.1601.5) and SP1 version (13.0.4001.0) with more new features summarized in this article : I will introduce here 5 top new features: HEKATON Enhancements Stretch Database Polybase JSON Support Temporal Tables HEKATON Enhancements: HEKATON was introduced in SQL …