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

Who is online?  451 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 this blog post, let’s have an insight on how Auditing can be done in SSIS packages? The basic auditing in package includes measures like How many rows were inserted, updated or de...
  • Hi SQL Geeks, Here are the blog posts by Piyush Bajaj for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at ht...
  • Hi SQL Geeks, Here are the blog posts by Ahmad Osama for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at htt...
  • Hi Friends, Are you facing any issue on SQL Server 2014 while running the same query which is running fine on previous version of SQL Server? If answer is yes then this may be due to the change in SQL...
  • I have written a SQL Server Change Data Capture GUI interface to facilitate for CDC operations. The project is hosted here https://sqlcdcapp.codeplex.com/ . Feel free to download, review and suggest c...
  • Recently I came across an interesting deadlock scenario I wasn’t aware off. I didn’t have idea that foreign key constraint can also result in deadlocks. The detailed steps to replicate the...
  • 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. ...