{"id":26194,"date":"2019-02-06T09:00:07","date_gmt":"2019-02-06T17:00:07","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=26194"},"modified":"2019-02-13T08:48:22","modified_gmt":"2019-02-13T16:48:22","slug":"azure-data-studio-setting-up-your-environment","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/02\/06\/azure-data-studio-setting-up-your-environment\/","title":{"rendered":"Azure Data Studio – Setting up your environment"},"content":{"rendered":"

This blog entry comes from Buck Woody, who recently rejoined the SQL Server team from the Machine Learning and AI team.<\/em><\/p>\n

For those of you who haven\u2019t met me or read any of my books or blog entries, it\u2019s great to meet you! I\u2019ve been a data professional for over 35 years, worked at a variety of places like NASA, various consulting firms, and here at Microsoft since 2006. I started on the SQL Server team, and then helped ship Microsoft Azure. After that I spent some time in Microsoft Consulting Services, then over to the Machine Learning team in Microsoft Research, and then the Machine Learning and AI team. I\u2019ve rejoined the SQL Server team to help with the inclusion of Apache\u00a0Spark\u2122<\/b>, Kubernetes, and the Machine Learning and AI features. I\u2019ll still be blogging at my regular location, and from time to time I\u2019ll chime in here on the SQL Server blog. As I learn something new, I\u2019ll share it. This time I\u2019ve learned about a great new tool the team has put together.\u00a0Azure Data Studio <\/a><\/u>\u00a0is a new tool that you can use to work with SQL Server.<\/p>\n

You may be thinking wait<\/em> – don’t we already have a lot of those? Isn’t that the SQL Server Management Studio (SSMS), or “Data Dude” (SQL Server Tools for Visual Studio) or even Visual Studio Code with the add-in for SQL Server?<\/p>\n

Well, yes. And those still work just fine – but Azure Data Studio goes further than those tools. And it does some things differently.<\/p>\n

Multi-Source<\/h2>\n

In Azure Data Studio, you can connect to multiple data systems, not just\u00a0SQL Server<\/a>,<\/u>\u00a0like Apache Hadoop HDFS,\u00a0 Apache Spark\u2122<\/b>, and others. And if you don’t find what you need, you can make more.<\/p>\n

Multi-Platform<\/h2>\n

SQL Server Management Studio is an amazing tool. When I started at Microsoft in 2006, that’s the product I worked on building. I know it VERY well. But it only runs on Windows. Is that a problem? Well, yes, and no. If you live in Windows all day exclusively, then that’s fine. But if you run a Mac or Linux, then you need a tool that runs on those platforms, and Azure Data Studio does just that. In fact, it does it quite well. I’m typing this on a Mac right now (in Azure Data Studio, no less) and it even\u00a0maps the keyboard to a Mac-like paradigm. You can also run an add-on to map the keyboard to SSMS<\/a><\/u>.<\/p>\n

On each platform, when you start Azure Data Studio, it checks itself and all your extensions and gives you the option to update them, regardless of your platform.<\/p>\n

Extensibility<\/h2>\n

Perhaps the biggest argument for a new tool for working with data is that\u00a0Azure Data Studio has a fully functional extension feature<\/a><\/u>. This means that Azure Data Studio works more as a platform where you can add in new functionality, themes, etc. that Microsoft, vendors, and even you can create extensions to do what you need. Do you need a tool that manages SQL Server Agent? We have that.\u00a0Need search tools, check scripts, reports, or Jupyter Notebooks? Check.\u00a0Need something else?\u00a0Write it. We’ll show you how<\/a><\/u>. If there isn’t something for a platform you regularly work with, contact that vendor and send them the link to create extensions,\u00a0and have them publish it to the github<\/a><\/u>.<\/p>\n

I’m a huge fan of Visual Studio Code. I use it for everything, and Visual Studio Code has LOTS of extensions. And here’s a cool tip: You can use almost all of them in Azure Data Studio. At the end of this post, I’ll show you how to install an extension along with a few of my favorites I always use in my day-to-day coding.<\/p>\n

You can also create widgets to show information about your system.\u00a0 Learn how to do that in this guide<\/a><\/u>.<\/p>\n

Environment and Workspaces<\/h2>\n

If you’re sold on trying out Azure Data Studio, get it installed, and get started setting up<\/a>.<\/p>\n

Workspaces<\/h2>\n

You can connect to servers and open a directory easily from inside the tool. \u00a0The top left two icons will handle that for you.\u00a0Azure Data Studio also has the concept of Workspaces<\/em><\/a><\/u>, which is similar to how you might think about a solution or project in SSMS or Visual Studio. The key is that Workspaces aren’t as rigid as a solution or project. You can include a lot of files located in many places in a single file, such as\u00a0MyFavoriteFilesAndFolders.code-workspace<\/em>, that you can simply double-click to open it all at once in Azure Data Studio. Use the\u00a0File | Save Workspace As<\/strong>\u00a0menu item to create a Workspace.\u00a0This feature alone sells me on using this for day-to-day work. Pair that with github integration,<\/a> and it\u2019s where I spend most of my time.<\/p>\n

Task List<\/h2>\n

As your system works, you’ll see information about what it\u2019s doing and has done in the\u00a0Task History<\/strong>\u00a0icon on the left.<\/p>\n

Integrated Terminal(s) and output panels<\/h2>\n

In every operating system, you have a shell (or terminal) of some type that you often need to work with. In Azure Data Studio, you can run those right in the Azure Data Studio environment<\/a> – and you can run several of them. You can have PowerShell and CMD running, or even the Azure Command-line interface (CLI) shell in the terminal where you can run a quick command.<\/p>\n

Setting up your environment<\/h2>\n

I use Azure Data Studio as my primary work environment for everything from SQL Server code, to Python, R, PowerShell, Apache Spark\u2122<\/b>, and more. It’s become my go-to integrated development environment (IDE). Here’s how I set mine up.<\/p>\n

The first thing I care about is how my environment is laid out, and how it looks. When I work, I like a dark environment with brightly colored fonts.\u00a0So, my primary theme is dark-plus-syntax<\/a><\/u>. For presenting, which I now do in Azure Data Studio, even replacing PowerPoint in some cases, I use Quiet Light, a built-in theme. You can change those after you install the ones you like by opening the Color Theme picker with\u00a0File<\/strong>\u00a0>\u00a0Preferences<\/strong>\u00a0>\u00a0Color Theme<\/strong>. You can open this via Code<\/strong>\u00a0>\u00a0Preferences<\/strong>\u00a0>\u00a0Color Theme<\/strong>\u00a0on macOS.<\/p>\n

Next, I add in the extensions I want. To do this, click the Extensions<\/strong> icon on the left, and select the\u00a0Install<\/strong>\u00a0button on the extension you want from the list. This will either re-install or open a web page. If the former happens, wait a moment while the extension loads, and then click the\u00a0Reload<\/strong>\u00a0button to activate it.<\/p>\n

If the extension installation opens a web page, then download the\u00a0.visx<\/strong>\u00a0file you see on that page. Save that to a location on your hard drive, and then open Azure Data Studio, click the\u00a0File<\/strong>\u00a0menu item, then\u00a0Install Extension from VISX Package<\/strong>. Point to the file you downloaded and when it finishes, click the\u00a0Reload<\/strong>\u00a0button next to the extension.<\/p>\n

We already have several extensions in the list for you, but here’s a cool trick – you can actually load most extensions on the Visual Studio Code Marketplace. All you have to do is the following:<\/p>\n

    \n
  1. Open the VS Code Marketplace<\/a><\/li>\n
  2. Search for the extension you want<\/li>\n
  3. Click the icon for that extension to go to its source page<\/li>\n
  4. On the right-hand side of that page, look for the section marked\u00a0Resources<\/strong><\/li>\n
  5. Click on the\u00a0Download Extension\u00a0<\/strong>link<\/li>\n
  6. Save the file on your hard drive<\/li>\n
  7. Open Azure Data Studio<\/li>\n
  8. Click the\u00a0File\u00a0<\/strong>menu item, then\u00a0Install Extension from VISX Package<\/strong><\/li>\n
  9. Point to the file you downloaded<\/li>\n
  10. When the install finishes, click the\u00a0Reload\u00a0<\/strong>button next to the extension<\/li>\n<\/ol>\n

    Here is a list of the ones I use a lot:<\/p>\n