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,448 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,060 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,731 reads
With the following technique, you can quickly read information stored in the extended properties of a SQL Server table.
2011-09-27
4,639 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,486 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Telp/Wa 62 8218200203 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...
Telp/Wa 62 817825533 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...
Telp/Wa 62 8218200233 Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar Muda,...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers