Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Keep up to date - daily newsletter:
Sign up
Articles with tag
Management Studio (SSMS)
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,800 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,295 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,137 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,036 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,559 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,455 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
|
19,989 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,797 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,140 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,785 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,860 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,829 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,081 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,268 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,279 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,215 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,007 reads
<< Newer
Items 21 to 40 of 76
Older >>
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.