SQL Server Management Studio Tip: Get a customized New Query Window

Who is online?  132 guests and 0 members
home  »  blogs  »  Amit Bansal  »  SQL Server Management Studio Tip: Get a customized New Query Window
  Rate This Blog Entry:  register  or  login


AmitBansal Amit Bansal (Member since: 3/12/2011 4:59:54 PM)
Follow Amit at Twitter @A_Bansal : Amit Bansal is the CTO of eDominer Systems & Peopleware India. He is a consultant, trainer, writer, speaker & evangelist on SQL Server & Business Intelligence. A seasoned speaker; he speaks at major summits and conferences of Microsoft worldwide including TechED, MCT Summits, MSDN & TechNet conferences. Over the last 8 years, he has consulted, trained & mentored more than 6000 IT professionals on SQL Server & Business Intelligence and worked with top notch blue chip companies worldwide including Microsoft, Infosys, Wipro, RBS, HCL, HP, Siemens, IBM, Accenture, etc. He has delivered more than 400 workshops on SQL Server & Business Intelligence. Apart from holding many Microsoft credentials, he is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server. He is also one of the first Microsoft Certified Trainer in India. Amit has worked with Microsoft in India and US as a Subject Matter Expert in various capacities participating in OD sessions, technical reviewing, etc. He is also a very active community lead in Asia Pacific. Visit www.amitbansal.net to know more. Subscribe to Amit’s blog and be a member of his technical forum at www.SQLServerGeeks.com - an exclusive SQL Server portal. Visit www.peoplewareindia.com for Corporate Training solutions. FaceBook – http://www.facebook.com/people/Amit-Bansal/525339346 LinkedIn – http://www.linkedin.com/pub/amit-bansal/7/121/755

View Amit Bansal 's profile

Comments (12)

4/22/2011 3:20:30 AM user261933  said:

Cool tip! Simple yet extravagant!

4/22/2011 4:13:51 AM Sachin Nandanwar said:

Good one amit..Wink

4/22/2011 7:49:30 AM Vishal Gajjar said:

handy trick.... thanks Amit.

4/22/2011 8:17:08 AM Amit Bansal said:

Good to see many of you liking these tips.. I shall try to post more such tricks/tips. Thanks agin for reading our content at sqlservergeeks.com

Cheers !

4/22/2011 10:11:32 AM Sarabpreet Anand said:

Gud One Amit. 

I was not aware of this.

4/24/2011 10:29:04 AM Meganathan Kanagaraj said:

Cool one! Thanks and looking forward for more tips like this.

2/8/2013 7:09:08 AM himanshu said:

thanks amit I was copy WHOLE HEADER and automate as per your suggession

4/26/2013 1:43:34 PM chirag said:

hi . nice.

but i want 3 line code and my cursor should at last new line.

how can i do it.

let me know.

thank in advanced

8/6/2013 3:33:21 PM Tom said:

Just wanted to say thank you for this - has been invaluable for almost a year.  I put my most commonly used tables together in a select, all commented out.  Huge shortcut.

3/20/2014 1:58:47 PM adi said:


I am junior sql dba with one year experince, could you please help me?

when we opene ssms it gives a connection string and we press connect it gets connect, could you help me how it gets connected, is there any file it is checking, or any protocol it is using to check, could you please explain me in detail what exactly is happening when we press connect?




3/20/2014 5:37:18 PM Lee said:

Great tip! Is there a way to do this with SQL Server Studio Manager 2012?



3/24/2014 5:40:21 PM Maxwell said:

Lee, in SQL Server 2012, this file is at C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\SqlWorkbenchProjectItems\Sql. Enjoy, thanks.


Leave a comment

Email:  (your email is kept secure)

example: "http://www.SQLServerGeeks.com"

Type the characters:

SQLServerGeeks FaceBook group

SQLServerGeeks Events

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Amit Bansal's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • Hi Friends, In my earlier blog, I just explain about the importance of filtered indexes. Link for that blog is mention below: http://sqlservergeeks.com/blogs/princerastogi/personal/599/filtered-indexe...
  • A few words about the technology of our site. It's easy to take technology for granted, to focus on content and pay no attention to how it is being delivered. Typically we would encourage this focus. ...
  • Hello, Constraints can be defined as rules that govern the values that are inserted into a column. These rules help in enforcing data integrity. For example if a NOT NULL constraint is defined over a ...