Microsoft's SQL Server toolbox is a complicated ecosystem, and differentiating one tool from another is a challenge. Vicky Harp, lead program manager of the SQL Server tools team, clarifies ...

I've been playing with the new SQL Server Data Tools, and I'm impressed by the way Microsoft has gotten the product out for review and is improving it with user-requested functionality.

When SQL Server 2012 comes out, so, too, will SQL Server Data Tools (SSDT), code name "Juneau," which will provide full-fidelity database design and development experience that can work offline or on ...

SQL Server Data Tools has upgraded from Microsoft.Data.SQLClient 3.0 to 5.0. The new version has support for TDS 8.0, support for specifying Server SPN and Failover Server SPN on the connection.

In this second delve into data cleanliness (read the first, How clean is your data?, here), we’ll test-drive the data profiling tool provided with Microsoft SQL Server. Other profiling tools ...

For Visual Studio 2012, Microsoft SQL Server Data Tools provides Business Intelligence tools. Visual Studio 2012 project templates for Analysis Services, Integration Services, and Reporting Services ...

As part of Microsoft SQL Server, users have access to tools to help them implement business intelligence, the process of turning raw data into actionable information.

“Free” is a term rarely associated with Microsoft offerings, especially at the server end of the spectrum. Exchange Server, SQL Server, SharePoint, Hyper-V — IT admins know functionality ...

Global software house Microsoft is making big data the focus of SQL Server 2019, set for release later this year. A key part is data virtualisation, eliminating complex ETL processes.

SQL Server 2022 customers will see benefits in the areas of data integration, analytics, governance, and high availability thanks to the database’s enhanced connectivity to the Azure cloud, Microsoft ...