Birmingham is surely growing fast as a technology hub and the overwhelming response to the dotNetConf event was a testimony to that. On 4th August, 2016 – the Birmingham .NET Meetup group organized a full day local extension event to the virtual dotNetConf conference, which Microsoft holds annually, to promote and educate developers about the .NET framework.
In this video session, we will learn about the rich set of capabilities of SQL Server 2016 and the new & improved features relating to Performance, Productivity and Security.
Coded UI Automated Tests run fine locally but randomly fails when run on the server. The functionality which you are trying to verify works fine, but the tests does not consistently pass on the test agents. In this article, we will look at a simple way by which we can analyze/debug these randomly failing tests and get more understanding on how to resolve it.
Currently one of the most irritating things in SQL, is to explicitly check if an object exists before dropping it.The DROP IF EXISTS is a simple T-SQL Enhancement in SQL Server 2016, but I am sure it would be one of the most frequently used syntax in a T-SQL developer’s day to day life.
From a security standpoint, sensitive data in the database needs to be protected against unauthorized access. Personal information of an individual like phone number, email, credit card details, bank account number, social security number needs to be stored safely in a database table.
In this article, we will look at a new security feature in SQL Server 2016 called as ‘Dynamic Data Masking’, which will now provide a database driven technique to mask sensitive data.
Historical data are a key source for trend analysis and are considered critical to business success. Traditional databases don’t provide insights into how data has changed over a period of time.As a developer, imagine if SQL Server provides this information out of the box, and there is no need to write any custom code to achieve this functionality. Wouldn’t it be awesome?
Lot of web services and Web APIs are using JSON these days, primarily as their data interchange format. The inability of the current versions of SQL Server to parse, store and process JSON data has been a hindrance. This makes the integration of JSON into SQL Server as one of the most awaited feature of SQL Server 2016.