Tag Archives: SSMS

Importing Flat Files in SSMS 17.x Works

Posted on September 12, 2018 by

One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis. For some reason I constantly seem to get files that the import wizard keeps having issues. On top of that, … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

The Ideal IDE

Posted on August 7, 2018 by

When I started working with SQL Server, I spent a lot of time in Query Analyzer and isql.exe. Those were my two main tools, using those to query a database instance in a lightweight manner. At some point Microsoft released … Continue reading →

Posted in Editorial | Tagged , | Leave a comment

Finding Tabs in SSMS–#SQLNewBlogger

Posted on May 10, 2018 by

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Someone posted this as a question and I thought it was worth noting. I use SQL Prompt for formatting, … Continue reading →

Posted in Blog | Tagged , ,

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 , ,

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 , ,

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