Tag Archives: SSMS

SSMS 17.4 Vulnerability Assessment

Posted on March 5, 2018 by

SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4 It seems that the Microsoft tools team is trying to build us better tools that come with the platform. There are … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Decouple the Tools

Posted on March 5, 2018 by

For years, SQL Server included a complete set of add-ons with the main product. We got SSIS, SSRS, and more as part of an integrated installation. This also included things like Books Online and various tools, such as Profiler, bcp, … Continue reading →

Posted in Editorial | Tagged , , | Leave a comment

Classifying Data with SSMS 17.5

Posted on February 20, 2018 by

I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data. With the GDPR coming for many of us, this is a welcome addition. This is a quick look at this … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

SSMS Line Numbers

Posted on January 16, 2018 by

I typically don’t turn on line numbers if SSMS, but while working with someone on a bit of code, they were referencing line numbers in a large script. By default SSMS shows you the line, column, and character at the … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

SSMS Updates in 17.4

Posted on December 8, 2017 by

SSMS 17.4 is out, and if you haven’t upgraded from SQL 204, 2012, 2008, etc., you should do so. You can run your bundled SSMS side by side with the new versions, but it seems that the 17x versions are … Continue reading →

Posted in Blog | Tagged ,

Adding a Format SQL Button to the Redgate Toolbar

Posted on November 14, 2017 by

I’ve gotten used to CTRL+K,Y to format SQL with SQL Prompt, but a customer wanted a button on the toolbar. It’s fairly easy to do, but I thought I should document the process for others. First, if you click the … Continue reading →

Posted in Blog | Tagged , , ,

SSMS is Free

Posted on July 20, 2017 by

Really, Management Studio (SSMS) is free as in beer. Go download it today. I got a note from a reader recently that was complaining about SSMS and the lack of MDI support. This individual mentioned that they would undock windows (something … Continue reading →

Posted in Editorial | Tagged

Opening .SQL Files in SSMS 2016 by Default #SQLNewBlogger

Posted on August 11, 2016 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is an easy one, but you’ll want to try this yourself. As I’ve been trying to move off … Continue reading →

Posted in Blog | Tagged , ,

Getting Table Change Scripts–#SQLNewBlogger

Posted on July 14, 2016 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the really basic things I think everyone should understand is how to get scripts from Management Studio … Continue reading →

Posted in Blog | Tagged , , ,

SSMS Maturity

Posted on July 2, 2015 by

I’ve used a lot of tools with SQL Server over the years. We had a variety of individual tools from Microsoft for SQL Server 4.2, including the isqlw query editor that I used for years. I wrestled with the Enterprise Manager MMC … Continue reading →

Posted in Editorial | Tagged ,