Data Driver

Blog archive

SQL Server 'Juneau' Developer Tools Needs Testers

You can be among the first to get your hands on the cool new 'Juneau' database development tools if you're willing to test them and provide feedback to Microsoft.

The company is now courting TSQL developers to join the SQL Server Developer Tools Advisory Program. Those chosen to participate will get early access to the package, which features a beefed-up code editor integrated with Visual Studio, a new table designer and a single project type for multiple platforms, among many other improvements.

Earlier, I wrote about the company's similar program for "Denali," code-name for the next version of SQL Server, which will feature the Juneau tools.

The new Juneau-focused advisory program was announced in a blog by Microsoft's Tiffena Kou last week.

Kou said the improved TSQL editor, which will feature IntelliSense, code navigation and language support similar to that of C# and Visual Basic, is just one of the new features of Juneau that has been publicly announced, with more improvements to be revealed.

One new feature was revealed at the Tech-Ed conference in Atlanta last week in a keynote address and demonstrated further in a session hosted by Bill Gibson and Mark Wilson-Thomas. "It's a new local database runtime, which is a new feature in SQL Server Denali," explained Gibson, a principal PM architect at Microsoft, in a session titled "Database Development with SQL Server Developer Tools codename 'Juneau.'"

He described it as "a local database that you can run on your desktop, and it's a single-user, single-instance, on-demand activated version of SQL Server. An incredibly cool, lightweight, test-and-debug feature, if you will." The new feature was revealed when the duo did an F5 project build in Visual Studio and chose the database runtime as the deployment target. Gibson said the new runtime can be used for applications, but the main use for database developers will be for testing and debugging.

One cool aspect of the SQL Server Developer Tools (SSDT) demo was how Gibson and Wilson-Thomas worked while connected to a database via a new SQL Server node in the Server Explorer window on the left-hand side of the Visual Studio IDE. Right-clicking on a table in the node tree opened a new query window in which queries could be instantly executed, just like SQL Server Management Studio. But they also could take advantage of features such as a buffered declarative approach, model-based coding with error detection, a code-backed designer and the "modern TSQL coding experience" with IntelliSense, code coloring and so on.

Later, they switched to offline development, using the familiar Solution Explorer on the right-hand side of the Visual Studio IDE. They explained how this let them use "all the project goodness" while working on a source code-backed model rather than a database-backed model as they had done earlier with the Server Explorer on the left-hand side. This enabled source code control, application lifecycle management and other project-based features. They went on to cover new functionality such as drift detection, snapshots and publishing to SQL Azure.

If you're "interested in evaluating all the cool ideas we are toying with," as Microsoft's Kou phrased it, you can "self-nominate" with a Windows Live ID. You'll need to sign a non-disclosure agreement and give details about your company and database projects. "The Advisory program lasts for 6 months," Kou said. "Program participants will have access to SSDT product prototypes in videos and pictures every month, and participate in surveys to give us feedback on the new ideas we are showing."

Go here to sign up.

What do you think of Juneau/SSDT? Please comment here or drop me a line.

Posted by David Ramel on 05/26/2011


comments powered by Disqus

Featured

  • Windows Community Toolkit v8.2 Adds Native AOT Support

    Microsoft shipped Windows Community Toolkit v8.2, an incremental update to the open-source collection of helper functions and other resources designed to simplify the development of Windows applications. The main new feature is support for native ahead-of-time (AOT) compilation.

  • New 'Visual Studio Hub' 1-Stop-Shop for GitHub Copilot Resources, More

    Unsurprisingly, GitHub Copilot resources are front-and-center in Microsoft's new Visual Studio Hub, a one-stop-shop for all things concerning your favorite IDE.

  • Mastering Blazor Authentication and Authorization

    At the Visual Studio Live! @ Microsoft HQ developer conference set for August, Rockford Lhotka will explain the ins and outs of authentication across Blazor Server, WebAssembly, and .NET MAUI Hybrid apps, and show how to use identity and claims to customize application behavior through fine-grained authorization.

  • Linear Support Vector Regression from Scratch Using C# with Evolutionary Training

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the linear support vector regression (linear SVR) technique, where the goal is to predict a single numeric value. A linear SVR model uses an unusual error/loss function and cannot be trained using standard simple techniques, and so evolutionary optimization training is used.

  • Low-Code Report Says AI Will Enhance, Not Replace DIY Dev Tools

    Along with replacing software developers and possibly killing humanity, advanced AI is seen by many as a death knell for the do-it-yourself, low-code/no-code tooling industry, but a new report belies that notion.

Subscribe on YouTube