Tip # 1
Problem: You have too many connections stored in your
management studio using IP address. Sometime it is hard to remember the IP
address vs server mapping. Or you have scripts to run on various servers in
same management studio instance.
Solution: Use SQL Server
Connection Registration feature as shown in diagram below and you can organize
all your connections in amazing ways. To get this window just go to View ->
Registered Servers.
Tip # 2
Problem: You are trying to get
the things done using SQL Server designer because you don’t remember the query
syntax. E.g. Adding a new column, insert script etc
Solution: SQL Server Studio has
a feature called Template Explorer(Hit CTRl+Alt+T) and you can see readymade
queries available for most of the day to day operation. You can even create
your own templates. See the diagram below
Hope this will help you in someway.
Currently rated 3.3 by 6 people
- Currently 3.333333/5 Stars.
- 1
- 2
- 3
- 4
- 5