SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Management Studio (SSMS) Rss

Search for any content tagged management studio (ssms)

<< Newer    Items 21 to 40 of 76    Older >>
 

Adding Custom Reports to SQL Server Management Studio

In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.  Read more...
By Additional Articles 2014/08/12 | Source: MSSQLTips.com | Category: reports
Rating: (not yet rated)  Rate this |   Briefcase | 10,823 reads

Automate Registering and Maintaining Servers in SQL Server Management Studio (SSMS)

This tip looks at how to use a control file that lists the structure to use within SSMS and a PowerShell script that will automatically maintain the list of registered servers within SSMS.   Read more...
By Additional Articles 2014/07/16 | Source: MSSQLTips.com | Category: automation
Rating: (not yet rated)  Rate this |   Briefcase | 12,334 reads

Less and Less Visual

Phil Factor ponders the preponderance of text in current database tools, and asks what happened to our glorious graphical future?  Read more...
By Phil Factor 2014/06/26 | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 94 reads

Why I Developed SQL Code Guard: A Fairy Tale from a DBA

This is the story of how a free addin for SSMS, SQL Code Guard, was created and joined the Red Gate SSMS Ecosystem project.  Read more...
By Additional Articles 2014/03/10 | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 5,166 reads

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 | 4,059 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,581 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 | 4,490 reads

Setting Different Colors for Connections in SSMS

Learn how to set colors for different connections in SSMS.  Read more...
By Peter Schott 2015/03/13 (first published: 2013/09/17) | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 20,056 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,820 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 | 19,147 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: Redgate | Category: scripts
Rating: (not yet rated)  Rate this |   Briefcase | 3,791 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 2014/11/27 (first published: 2008/05/20) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 9,861 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,849 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 (xe)
Rating: (not yet rated)  Rate this |   Briefcase | 3,096 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 | 526 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 | 6,272 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 | 4,307 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,216 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,126 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 | 6,008 reads
<< Newer    Items 21 to 40 of 76    Older >>