Tag Archives: SSMS

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 , | Leave a comment

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 , , , | Leave a comment

SSMS is Free

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

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

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

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 ,

See Two Queries at Once in SSMS

I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few notes on structuring a post. One of the things that I’ve struggled with a bit in SSMS is sometimes comparing … Continue reading

Posted in Blog | Tagged , ,

Custom SSMS

In my career, I’ve gotten used to working with SSMS on a variety of machines. It seems that as I toiled in various environments, I’d often connect to different SQL Server hosts, or use various consoles that only had the … Continue reading

Posted in Editorial | Tagged | 8 Comments

Quick Tips–SSMS Select a vertical block

I saw this years ago in a presentation from Aaron Bertrand. At the time I thought it was super cool and I’d use it all the time, but I haven’t found many uses. However since I needed to do this … Continue reading

Posted in Blog | Tagged , , ,

Quick Tips–SQL Prompt Qualifying Columns

I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love the tool and had a copy before Red Gate bought the technology from the original developer. Recently I’ve run into … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments