Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Management Studio (SSMS) Rss

Search for any content tagged management studio (ssms)

   Items 1 to 20 of 52    Older >>
 

SQL Enlight for SQL Server Management Studio

The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that was difficult to automate for release and deployment. As it is now both a Command-line utility and an SSMS add-in, the database developer can see immediately the parts of the code that would raise eyebrows with the vigilant production DBA.  Read more...
By Additional Articles 2014/01/14 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,578 reads

Introducing the Red Gate SSMS Ecosystem

The Red Gate SSMS Ecosystem is a framework that makes it easy to develop, share and manage SSMS add-ins. We aim to help add-in developers build everything from homegrown solutions and community-driven projects to commercial solutions provided by partner companies. We hope that DBAs and database developers will benefit from better integrated tools.  Read more...
By Additional Articles 2013/11/26 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,163 reads

SQL Server Index Properties in Management Studio

Understanding indexes and how they work can be complicated enough for a Jr. DBA, but throw in all the different options and properties and an index can soon be overwhelming. Brady Upton takes an introductory look at creating an index in SQL Server using SQL Server Management Studio. He explains what each index property is meant for and the various options presented.  Read more...
By Additional Articles 2013/11/19 | Source: MSSQLTips.com | Category: create index
Rating:  Rate this |   Briefcase | 3,905 reads

Setting Different Colors for Connections in SSMS

Learn how to set colors for different connections in SSMS.  Read more...
By Peter Schott 2013/09/17 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 11,052 reads

How to hide SQL Server user databases in SQL Server Management Studio

I have a SQL Server instance that has hundreds of databases. Navigating the database tree in SSMS is a pain and I was wondering if there was a way to limit the list of databases that I see in SSMS?  Read more...
By Additional Articles 2013/08/28 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating: (not yet rated)  Rate this |   Briefcase | 4,224 reads

Display More Than 8000 Characters (SQL Spackle)

SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).  Read more...
By Jeff Moden 2013/06/28 (first published: 2011/01/27) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,822 reads

Do you regularly run queries and scripts in SSMS?

SQL Server Management Studio is where most SQL scripts and queries are run, and although it does a decent job, it doesn't provide much help storing, sharing and managing the scripts particularly in the context of a team. Red Gate is considering building functionality into SSMS to help its users consume and share queries and scripts. Please help us by completing this short survey to help us define the requirements.   Read more...
By Press Release 2013/04/12 | Source: Red-Gate | Category: scripts
Rating: (not yet rated)  Rate this |   Briefcase | 3,431 reads

Templates and teamwork

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...
By David Poole 2013/01/31 (first published: 2008/05/20) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 8,242 reads

Prevent Truncation of Dynamically Generated Results in SQL Server Management Studio

While working with the Results to Text option in SSMS, you may come across a situation where the output from dynamically generated data is truncated. In this article I will guide you on how to fix this issue and print all the text for the Results to Text option.   Read more...
By Additional Articles 2012/11/14 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating: (not yet rated)  Rate this |   Briefcase | 2,331 reads

Managing SQL Server Extended Events in Management Studio

We’ve all heard about Extended Events and how they can help troubleshoot SQL Server performance, connectivity, and locking problems, but they seem so difficult to implement using T-SQL. Isn’t there a better way to implement SQL Server Extended Events?  Read more...
By Additional Articles 2012/07/25 | Source: MSSQLTips.com | Category: extended events
Rating: (not yet rated)  Rate this |   Briefcase | 2,572 reads

My Little Friend

Today Steve Jones talks about his favorite feature in SSMS 2012 and why everyone should use it.  Read more...
By Steve Jones 2012/04/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 522 reads

SSMS Shared SQL Templates

This article describes how to use the built in repository for SQL Server Management Studio Templates and how to customize and share a common repository with your team.  Read more...
By Carl Demelo 2012/01/09 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 5,671 reads

SSMS Tools Pack 2.0

If you work with SSMS, you’ll know how frustrating it can be when tasks you perform every day aren’t part of the core features. Malden Prajdic certainly did, which is why he developed his free SSMS Tools Pack. Now on its second version, Grant Fritchey explains the functionality of this great free plugin.  Read more...
By Additional Articles 2011/11/02 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,916 reads

Custom SSMS Shortcuts for ETL Developer. Part 3: Source-Target Mapping

Provides a SQL code that generates a source-target transformation query and can be helpful at several stages of data warehouse development lifecycle.  Read more...
By Olga Klimova 2011/09/29 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 3,080 reads

Custom SSMS Shortcuts for ETL Developer. Part 2: Extended Properties

With the following technique, you can quickly read information stored in the extended properties of a SQL Server table.  Read more...
By Olga Klimova 2011/09/27 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 4,050 reads

Custom SSMS Shortcuts for ETL Developer. Part 1: SELECT in a Keystroke

This is the first of three tips on how ETL Developers can be more productive by applying custom SSMS shortcuts to the most often used tasks.  Read more...
By Olga Klimova 2011/09/22 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 5,941 reads

Configure SQL Server Database Mirroring Using SSMS

This tip outlines a test environment and then walks through the process of setting up Database Mirroring. This includes the configurations, backups, restores and verification process.  Read more...
By Additional Articles 2011/09/02 | Source: MSSQLTips.com | Category: database mirroring
Rating: (not yet rated)  Rate this |   Briefcase | 2,822 reads

SSMS: The Query Window Keyboard Shortcuts

Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations within SQL Server Management Studio that unlock the hidden magic that is available for editing and executing queries.   Read more...
By Additional Articles 2011/06/24 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,962 reads

SQL Server Management Studio keyboard shortcuts - Part 1

As responsibilities are growing every day, a DBA or developer needs to improve his/her productivity. One way to do this is to use as many shortcuts as possible instead of using your mouse and the menus. In this tip we take a look at common tasks you may perform when using SSMS and the associated shortcut keys.  Read more...
By Additional Articles 2011/06/15 | Source: MSSQLTips.com | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 5,451 reads

When a SQL file will not open in SSMS

What happens when double clicking a .SQL file doesn't open the file in SSMS? This article provides the solution to fixing that annoying SSMS issue.  Read more...
By Lynn Collins 2011/04/27 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 5,162 reads
   Items 1 to 20 of 52    Older >>