During my SQL Saturday Birmingham Presentation on SQL Tips and Tricks, one of the productivity feature which got lot of love from most of the attendees was the use of custom colors to differentiate between SQL environments. SSMS provides us with an ability to set different colors for connection to separate environments.
As a developer, when you are working in a project, you tend to have a number of servers which you need to constantly shift between. What can you do to manage or organize these frequently accessed servers in a better way?
SQL Server Management Studio provides a cool feature called ‘Code Snippets’ which can help you to considerably increase your coding speed. Code Snippets are ready made snippets of code, which you can insert into your T-SQL code. As a result, you can type less and generate more code.
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.
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?
Sometimes we might need to populate our SQL tables with reference/ look-up data. There are other scenarios when we need to copy table data from one environment to another. In both these cases, we require to create bulk scripts for Inserting data into our destination table. In this article, I will mention about a quick way to generate the SQL Insert Scripts using SQL Server Database project with just 2 clicks.