News

Security Tightened in SQL Server Data Tools Update

Database schema comparisons, security among incremental updates made to this July 2014 release of SSDT.

The Microsoft SQL Server team has made incremental updates to SQL Server Data Tools (SSDT), updating the Schema Compare utility, improving Microsoft Azure SQL Database security and supporting Parallel Data Warehouse. The July 2014 release is available from the Data Developer Center.

Schema Compare, a utility used for comparing data definitions between connected databases, has been updated so that it now can be used natively within MSBuild, the Visual Studio build platform. Schema Compare output within build can be output via text or XML. A more detailed description of the integration of Schema Compare in MSBuild is in this blog post.

Improvements were also made to the Microsoft Azure SQL Database node, with the addition of Visual Studio 2012 support, as well as a new security feature that allows use of token-based authentication via a Microsoft account or OrgID.

For those using SQL Server Parallel Data Warehouse (PDW) appliances, SSDT also adds support for PDW tooling in Visual Studio Express 2013 for Windows Desktop. PDW appliances have been updated to support Visual Studio versions 2012 and 2013.

About the Author

You Tell 'Em, Readers: If you've read this far, know that Michael Domingo, Visual Studio Magazine Editor in Chief, is here to serve you, dear readers, and wants to get you the information you so richly deserve. What news, content, topics, issues do you want to see covered in Visual Studio Magazine? He's listening at [email protected].

comments powered by Disqus

Featured

  • GitHub Previews Agentic AI in VS Code Copilot

    GitHub announced a raft of improvements to its Copilot AI in the Visual Studio Code editor, including a new "agent mode" in preview that lets developers use the AI technology to write code faster and more accurately.

  • Copilot Engineering in the Cloud with Azure and GitHub

    Who better to lead a full-day deep dive into this tech than two experts from GitHub, which introduced the original "AI pair programmer" and spawned the ubiquitous Copilot moniker?

  • Uno Platform Wants Microsoft to Improve .NET WebAssembly in Two Ways

    Uno Platform, a third-party dev tooling specialist that caters to .NET developers, published a report on the state of WebAssembly, addressing some shortcomings in the .NET implementation it would like to see Microsoft address.

  • Random Neighborhoods Regression Using C#

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the random neighborhoods regression technique, where the goal is to predict a single numeric value. Compared to other ML regression techniques, advantages are that it can handle both large and small datasets, and the results are highly interpretable.

  • As Some Orgs Restrict DeepSeek AI Usage, Microsoft Offers Models and Dev Guidance

    While some organizations are restricting employee usage of the new open source DeepSeek AI from a Chinese company due to data collection concerns, Microsoft has taken a different approach.

Subscribe on YouTube

Upcoming Training Events