Category Archives: Tips

How to edit a connection in Azure Data Studio

Did you ever want to rename an existing connection in Azure Data Studio? Unfortunately as of today (April 2020), there is no way to modify an existing connection group or data source connection using the GUI. 

Luckily for us, Azure Data Studio (ADS) is a very powerful and flexible tool that allows us to modify many settings without the need for a GUI. All these changes can be made simple updating the settings.json file. Honestly, though, you don’t need to be an expert in JSON to make modifications to this file. I will do my best to explain to you how to take care of these changes easily and quickly.

Continue reading

Multi-server scripts with SSMS using SQLCMD mode

SSMS is the most common tool used by SQL Developers or DBA’s but unfortunately there are some features that are barely known, SQLCMD mode is not the exception and that’s why I decided to follow up in this topic.

You may want to check one of this previous blog post, where you will find instructions how to enable SQLCMD mode and some examples that could help you to become familiar with it.

Continue reading

Determine database version from a bak file

Have you ever imagine you can determine the version of SQL Server from a bak or a MDF file? I have been in situations where I received a bak or MDF and LDF files from a vendor to restore \ create a database for the implementation of a new application, most of the times I receive complete detail of the supported versions of SQL Server by the product but what happens if I don’t get that information?

SQL Server offers a way to get the actual version where the files were created, let’s review the process to using a database restore.

Continue reading