Tag Archives: tools

Connection String Confusion in SSMS

Posted on September 25, 2024 by way0utwest

Recently I was trying to use a connection string to connect in SSMS. There are some tools that have a connection string available as an output, including some Redgate tools. ADS lets me paste in a connection string. Can I … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

How Often Do You Update SSMS?

Posted on February 2, 2024 by way0utwest

I got a message recently that SSM S19.3 is out. I am wary of major versions, especially with a few add-in tools, but I have tended to try and update SSMS regularly when it patches, which is about once a … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

Comparing Two Scripts with kdiff3

Posted on November 27, 2023 by way0utwest

I had a customer recently ask if SQL Compare could show them the differences in two scripts they’ve written. They weren’t using version control (tsk, tsk, shame), but saw SQL Compare and the “Scripts folder” option. This isn’t used for … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Quick Filtering in SSMS–#SQLNewBlogger

Posted on September 27, 2023 by way0utwest

I saw someone limit the databases they see in SSMS, which isn’t something I often do, but I thought this was great. A Long List This is the list of databases on a demo instance I have. While it’s a … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments