:::: MENU ::::

Posts Categorized / SSMS tips and tricks

  • May 12 / 2010
  • 0
dbDigger, SSMS tips and tricks

How to increase font size in SSMS query pane

While working in query pane of your favorite SQL Server Management Studio (SSMS), you may be required to change font size in SSMS query pane. For this click on Options in Tools menu of SSMS.
Options frame would be opened. Click on Fonts and Colors under environment as shown in snap. On right side you have font size drop down along with several other fonts and colors related settings.

Change font size of query pane in SSMS

Adjust the font size and Click Ok. changed font size would be immediately implemented even in already opened query panes.

  • May 04 / 2010
  • 0
DBA best practices, dbDigger, SSMS tips and tricks

Customize SSMS startup environment for object explorer, query pane and activity monitor

After launching SQL Server Management Studio (SSMS) you always modify the environment by opening query pane or by opening/closing the object explorer. In SSMS i am also habitual to use activity monitor. Fortunately SSMS provides you option to modify the start up environment. At start up you can configure SSMS to open

  • empty environment
  • object explorer
  • query pane
  • both object explorer and query pane at same time
  • In SSMS 2008 open object explorer and activity monitor at same time

To configure your SSMS start up environment. Just go to Options in tools menu.

Open Options in SSMS

Now open ‘At start’ drop down list in produced options frame. It is under ‘General’ heading as marked in snap below.

Configure SSMS startup options

Select required environment and click Ok to save the settings. Next time when you would open SSMS you have your required environment there. Activity monitor of SSMS 2008 can be used with SQL Server 2005 instance.

  • Apr 29 / 2010
  • 0
Backup and Restore, dbDigger, SSMS tips and tricks

Managing frequent restore of last backup through SSMS

While connected to test server through SQL Server management studio (SSMS), i have to restore any particular database several times. It is time consuming to browse and select the backup file each time. If you have same problem then consider the restore of last backup by this way.
SQL Server provides option to restore last backup of any database on same server without knowing the name or location of backup file. This method can be used in test environments when excessive restores are being performed for same backup. Follow these steps

  • Click on database on which backup is to be restored, or even you can do this by database which is to be restored. A database can be restored on itself. In my case it is last backup of AdventureWorks that i would restore on itself

Sleect DB for easy restore of last backup

  • A frame would appear select database on which back is to be restored. As i mentioned before it may be any database on your server. Even you can create new one from here. Also select the database whose backup is required to be restored. Automatically list of last backups would appear in frame. Select the backup that is required to be restored. It may be full, differential or last backup.
  • Also have a look at options pane of frame to configure any parameter.

Configure easy restore of last backup

At the end click the Ok button and last backup of selected database would be restored at required database.
This method would prevent you to keep track of last backup. But make sure that backup file is located at place where it was created.

  • Nov 23 / 2009
  • 2
DBA thoughts, dbDigger, SSMS tips and tricks

An option that i miss in SQL Srever Management Studio (SSMS)

I am a fan of SSMS as DBA operations interface. It was first provided with SQL Server 2005 and onwards. It efficiently replaced its predecessors management tools like enterprise manager and query analyzer.
Often i miss ‘copy name’ option for objects like table, view, UDF and procedures. I suggest that there should be an option available through right click, that may copy object name. e.g if you are required to use a lengthy name of a table/sp, then just right click on object and clicking on ‘copy name’ , you would have object name on clip board.
I Think it would be a good option and would make the life a bit easy.

Copy Name option in SSMS

Consult us to explore the Databases. Contact us