On 14th January, 2017 I attended SQL Saturday Nashville held at Middle Tennessee State University (MTSU), Murfreesboro. I have been to multiple SQL Saturdays before, but this was my first SQL Saturday as a Speaker.
In this article we will evaluate the Performance Impact of searching data in SQL Tables. We will understand how the Query Optimizer processes such queries and things we need to be aware of, from a performance standpoint, by using any toolset.
In this article, we will go through one of the features in SSMS 2016 – ‘Quick Launch’. Quick Launch greatly helps in making the developers productive in the IDE by helping them to search features and options inside SSMS.
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?
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.
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.
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.