Tag Archives: SSMS

Updating SSMS to 17.9.1

I went to download the SSMS v17.9.1 package the other day and saw this: I remember some issues with a C++ redistributable with a SQL Server install (2016?) and decided to just check on this. I really wish that these … Continue reading

Posted in Blog | Tagged , | Leave a comment

Importing Flat Files in SSMS 17.x Works

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

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 ,

Finding Tabs in SSMS–#SQLNewBlogger

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

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

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

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

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

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

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