![]() You can use CTRL+SHIFT+V to paste the current item in Clipboard Ring’s memory. ‘Cycle Clipboard Ring’ feature in SSMS allows you to keep track of last 20 items you have cut/copy and reuse them without any need of copying and pasting text multiple times. The problem with pasting your copied contents using CTRL+V is that it only pastes the last copied text. Two shortcut keys which every developer use in their day to day work is CTRL+C and CTRL+V. Reuse your copied items by storing in memory For developers running data manipulation scripts, it’s always nice to have a visual indication of the environment you are logged in – especially a RED color in your SSMS query editor, indicating you to be extra cautious. Once you select a color for an environment, every time you login to that SQL Server instance – it will display the same color in the SSMS status bar. Then click on the ‘Connection Properties’ tab and you can choose a custom color for your environment: When you are connecting to a SQL Server instance, you will need to click on the ‘Options’ button: This presents a visual indication of the environment in which you are running your scripts. Hence when you connect with a particular environment, it uses the same assigned color. The color is displayed in the SSMS status bar, at the bottom. PROD – Red, MOCK – Orange, QA – Yellow, DEV – Blue and Local – Green Personally, I prefer to set the below colors for my environments. SSMS provides us with an ability to set different colors for connection to separate environments. Also, think about a scenario when you have a data manipulation script to be executed in different environments, isn’t it a big advantage to have a visual differentiation between the environments you are executing your scripts against? This often becomes unmanageable and difficult to keep track of. Use custom colors to differentiate between environmentsĭuring our day to day work in SSMS, generally we have to shift between different environments – Local/DEV/QA/MOCK/PROD, resulting in the creation of multiple query tabs – with each query tab connected to different environments. Increase your Coding Speed in SQL Server Management Studio.SQL Server Management Studio 2016 Productivity Enhancements.I would highly recommend you to go through my last 2 articles relating with SSMS Productivity, if you have not gone through it already – In this article, I will be sharing some beneficial Tips and Tricks which will give you an extra edge in your day to day work, and in the process take your productivity to the next level. NETCore AI Analytics API Management Application Insights ASP.NET ASP.I have been using SSMS for a long time now, and over the period of time I have realized that it’s a very powerful IDE – however, there are lots of hidden features which are less known to lots of developers. Search for: Search Twitter Updates Tweets by flying_maverick. SQL Server Management Studio – Changelog (SSMS) This version of SSMS works with all supported versions of SQL Server 2008 – SQL Server 2019 preview and provides the greatest level of support for working with the latest cloud features in Azure SQL Database and Azure SQL Data Warehouse.Īdditionally, SSMS 18.x can be installed side by side with SSMS 17.x, SSMS 16.x, or SQL Server 2014 SSMS and earlier.ĭownload SQL Server Management Studio (SSMS) If you have an older preview version of SSMS 18.0 installed, you must uninstall it before installing SSMS 18.1. If you have SSMS 18.0 (GA) installed, installing SSMS 18.1 upgrades it to 18.1. NOTE: SSMS 18.1 is the latest general availability (GA) version of SSMS. Head over to and go to the Download SSMS 18.1 section. ![]() There are three entries for launching the New Schedule dialog, New Schedule… menu item shown when right-clicking the SSIS package in SSIS Catalog in Azure, Schedule SSIS Package in Azure menu item under Migrate to Azure menu item under Tools menu item and “Schedule SSIS in Azure” shown when right-clicking Jobs folder under SQL Server agent of Azure SQL Database Managed Instance.įor details about what’s new in this release, please see the SSMS release notes.
0 Comments
Leave a Reply. |