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.
2014-01-14
4,134 reads
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.
2013-11-26
3,631 reads
Learn how to set colors for different connections in SSMS.
2015-03-13 (first published: 2013-09-17)
33,437 reads
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?
2013-08-28
4,875 reads
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.
2012-11-14
2,887 reads
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.
2012-01-09
9,046 reads
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.
2011-11-02
4,349 reads
Provides a SQL code that generates a source-target transformation query and can be helpful at several stages of data warehouse development lifecycle.
2011-09-29
3,721 reads
With the following technique, you can quickly read information stored in the extended properties of a SQL Server table.
2011-09-27
4,621 reads
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.
2011-09-22
6,473 reads
I am excited to host T-SQL Tuesday for the first time. I want to...
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
Comments posted to this topic are about the item Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers