I've been playing around with the new SQL Server Data Tools, and although many have complained about missing features compared to the "Data Dude" Visual Studio projects and other tools that SSDT ...

Using SSDT means we don't just shout orders at the database; instead, we plan what we're going to say. For almost 13 years, Microsoft has tried to make Visual Studio a place where developers can do ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Explore the top data migration tools to efficiently and securely transfer data to new systems or platforms. Find the best tool for your data migration needs. If you need to move, convert or migrate ...

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

“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 comes at a ...

In the last several articles, I’ve been describing the benefits of reading and analyzing the benchmarking case studies vetted and released by the Transaction Processing Council (www.tpc.org). I’ve ...

It can be tough to manage data manually, and doing so can sometimes lead to errors or inefficiencies. Spreadsheets can get overly complex, and data quality can suffer. This has become a large enough ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Remote Server Administration Tools (RSAT) are meant for the system and IT administrators. They allow admins to set and manage roles as well as the features that are installed on a Windows Server ...