Live from Visual Studio Live!

Blog archive

Working with SQL Server Data Tools

Lenni Lobel, chief technology officer of Sleek Technologies and author of Programming Microsoft SQL Server 2012 (Microsoft Press), offered a walk through of the SQL Server Data Tools (SSDT) built into Visual Studio 2012 and available for free download for users of Visual Studio 2010.

The session, held Wednesday morning at the Visual Studio Live! Chicago conference, showed how database developers can use SSDT to manage both on-premise and cloud-based database development projects. SSDT works with SQL Server 2012 and SQL Azure databases.

SSDT is essentially the successor to Microsoft Visual Studio Team System for Database Professionals, widely known as DbPro and sometimes referred to as DataDude. Released in December 2012, SSDT is a Visual Studio plug-in that presents itself as a new database type in the IDE. SSDT enables for database developers familiar Visual Studio capabilities like code navigation, IntelliSense, platform-specific validation and debugging. It also enables declarative editing in the TSQL Editor, and provides a visual Table Designer for database projects and online database instances.

"Database development is hard. It's a huge thing to get right and it's a huge challenge," Lobel told the audience during his presentation. "With respect to the development process itself, there are definitely pain points that can be relieved with the right tooling and SSDT aims to deliver that tooling."

During the presentation, Lobel showed how developers can use the declarative model of SSDT to design databases offline, and use source control functionality to preserve earlier versions of database schema. He also explored features like schema compare, local database runtime support and the ability to support SQL Azure database projects.

Lobel after the demo expressed both praise for and frustration with the SSDT toolset. He described SSDT as being "light years ahead of anything that came before for developers," and gave it high marks for integrating database creation and management tooling into the development environment. However, there are things Lobel would like to see in SSDT.

"SSDT is focused on schema, but not data. Data generation and data compare are features in DbPro that are not features in SSDT," Lobel told the audience.

"They've added unit testing, but I've heard no word on the other two," Lobel continued, suggesting that developers needing data generation and compare capabilities consider RedGate Software's SQL Toolbelt product.

Posted by Michael Desmond on 05/15/2013


comments powered by Disqus

Featured

  • 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.

  • Vibe Coding with Latest Visual Studio Preview

    Microsoft's latest Visual Studio preview facilitates "vibe coding," where developers mainly use GitHub Copilot AI to do all the programming in accordance with spoken or typed instructions.

  • Steve Sanderson Previews AI App Dev: Small Models, Agents and a Blazor Voice Assistant

    Blazor creator Steve Sanderson presented a keynote at the recent NDC London 2025 conference where he previewed the future of .NET application development with smaller AI models and autonomous agents, along with showcasing a new Blazor voice assistant project demonstrating cutting-edge functionality.

Subscribe on YouTube