Since the initial release of SQL Server 2016 in May 2016, there has been monthly updates to SSMS which includes enhancements, new features and bug fixes. This has been a big step in ensuring that the SSMS IDE is up to date and provides a superlative user experience. But how do you know that a new version of SSMS has been released?
SSMS does not provide any tools/utility to search for a value/data inside a particular database.This kind of surprises me a bit, since it is a needed functionality and would be a very popular feature to be built into the SSMS IDE. So the question is, how do you search for a particular value/data in your SQL Database?
Working as a .NET Developer in the Southern City of Birmingham, I feel the last 6 weeks has been pretty awesome for the Birmingham Technology community. There were 3 excellent full day tech events – starting with Sloss Tech held by TechBirmingham, dotNetConf and then devdataDay held by Steel City SQL Group and BHM .NET Meetup.
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.