![]() You can also use this wizard to generate insert scripts for your tables. To generate scripts for your database tables, SQL Server Management Studio provides a handy wizard called as ‘Generate and Publish Script‘. To view the details of the Standard SSMS Reports, please review the MSDN article here – SQL Server Management Studio Standard Reports – The Full List Generate SQL Insert scripts using SSMS To access the reports, Right Click on the Database –> Go to Reports –> Go to Standard Reports –> Pick any of the SSMS Reportsįor instance, the below ‘Disk Usage’ report displays the total amount of space that the AdventureWorks2008 is occupying and the free space available. The best thing about these reports are that it encapsulates all the complexity behind generating them and displays the results in the form of graphical reports – which can be used in any of your presentations. SSMS provides a number of standard database level reports out of the box for performance monitoring and troubleshooting purpose. Leverage built in Performance Reports in SSMS Keyboard Shortcut – ALT + SHIFT + Arrow Keys ![]() Pressing the ALT key is important, since it indicates to the query editor to not select the entire line but to follow the mouse pointer/ arrow keys for any action. To leverage this feature, you need to hold down the ALT key, then left click on your mouse to drag the cursor over the text you want to select and type/paste the text you want to insert into multiple lines. SSMS provides a ‘ Vertical Block Select Mode‘ feature by which you can select multiple lines, type code and it will reflect across all the selected rows. If you repeatedly press CTRL+SHIFT+V, you can actually cycle through all the entries in Clipboard Ring’s memory, and then select the item you want to paste in your code editor.Įdit multiple lines of code at the same time 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. 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. ![]()
0 Comments
Leave a Reply. |