Like Visual Studio Code and your data lives in SQL Server? Microsoft has something for you

SQL Object Explorer, SQLCMD and more IntelliCode arrive for VS Code


Microsoft's determination to foist on the world ever more ways of connecting to SQL Server has continued unabated with a major update of the mssql extension for the ubiquitous Visual Studio Code.

Developers with a yearning for SQL Server are not short of options, with the venerable SQL Management Studio and upstart Azure Data Studio both making a decent fist of connecting to the data shack.

However, since many developers these days prefer the default-to-dark-mode world of Visual Studio Code, Microsoft has emitted a substantial update which brings the SQL Server Management Studio Object Explorer and SQL Server command line support to the platform as well as some AI in the form of IntelliCode.

Naturally, we had to take a look and pointed a copy of Visual Studio 1.39, updated with the new extension, at a local SQL Sever 2019 Preview to see how things worked.

First up, the Object Explorer does indeed work as advertised, inflicting the tree view found in Microsoft's other data botherers onto VS Code for trotting through a hierarchal view of a given SQL Instance.

VS Code with MSSQL

Click to enlarge

For those that need such graphical fripperies (and since this was the most requested feature) it will be welcome, although for those more happy in the command line, SQLCMD mode is equally handy.

The feature turned up Azure Data Studio back in September and allows users to write and edit queries as SQLCMD scripts. Enabling SQLCMD mode makes the extension handy for script jockeys keen to drop in the odd command or two among the T-SQL.

However, while its implementation in SQL Server Management Studio has been considerably refined over the years, and even Azure Data Studio has an obvious "Enable SQLCMD" button in the query window, things in VS Code are a little less intuitive. A status bar switch can turn the thing on and off, and the team points to a toggle in the VS Code command prompt, but we found it all a little clunky.

It is, of course, the first iteration of the SQLCMD implementation, and we suspect the limitations imposed by the VS Code extension model are preventing some of the free-wheeling of the SSMS incarnation, so we'll cut it some slack.

The final major tweak is IntelliCode support, which improves on IntelliSense by popping up suggestions the algorithm has calculated that the user needs at the top of the list. It is a useful feature, but a stretch to say there is much AI involved.

It is, however, a noticeable improvement over IntelliSense, although does not yet appear to scan our horribly written triggers and stored procedures when guessing what we might be trying to do in a query, thank goodness.

Overall, if you're using Visual Studio Code and SQL Server, this is a handy tool and will save a lurch into SSMS or Azure Data Studio. The Object Explorer is nice to have, although the SQLCMD support remains a little jarring for those more used to a friendly button or query option. ®


Other stories you might like

  • DuckDuckGo tries to explain why its browsers won't block some Microsoft web trackers
    Meanwhile, Tails 5.0 users told to stop what they're doing over Firefox flaw

    DuckDuckGo promises privacy to users of its Android, iOS browsers, and macOS browsers – yet it allows certain data to flow from third-party websites to Microsoft-owned services.

    Security researcher Zach Edwards recently conducted an audit of DuckDuckGo's mobile browsers and found that, contrary to expectations, they do not block Meta's Workplace domain, for example, from sending information to Microsoft's Bing and LinkedIn domains.

    Specifically, DuckDuckGo's software didn't stop Microsoft's trackers on the Workplace page from blabbing information about the user to Bing and LinkedIn for tailored advertising purposes. Other trackers, such as Google's, are blocked.

    Continue reading
  • Despite 'key' partnership with AWS, Meta taps up Microsoft Azure for AI work
    Someone got Zuck'd

    Meta’s AI business unit set up shop in Microsoft Azure this week and announced a strategic partnership it says will advance PyTorch development on the public cloud.

    The deal [PDF] will see Mark Zuckerberg’s umbrella company deploy machine-learning workloads on thousands of Nvidia GPUs running in Azure. While a win for Microsoft, the partnership calls in to question just how strong Meta’s commitment to Amazon Web Services (AWS) really is.

    Back in those long-gone days of December, Meta named AWS as its “key long-term strategic cloud provider." As part of that, Meta promised that if it bought any companies that used AWS, it would continue to support their use of Amazon's cloud, rather than force them off into its own private datacenters. The pact also included a vow to expand Meta’s consumption of Amazon’s cloud-based compute, storage, database, and security services.

    Continue reading
  • Atos pushes out HPC cloud services based on Nimbix tech
    Moore's Law got you down? Throw everything at the problem! Quantum, AI, cloud...

    IT services biz Atos has introduced a suite of cloud-based high-performance computing (HPC) services, based around technology gained from its purchase of cloud provider Nimbix last year.

    The Nimbix Supercomputing Suite is described by Atos as a set of flexible and secure HPC solutions available as a service. It includes access to HPC, AI, and quantum computing resources, according to the services company.

    In addition to the existing Nimbix HPC products, the updated portfolio includes a new federated supercomputing-as-a-service platform and a dedicated bare-metal service based on Atos BullSequana supercomputer hardware.

    Continue reading

Biting the hand that feeds IT © 1998–2022