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

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

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

It's official: Microsoft has released SQL Server 2008, the culmination of a series of new tools and server product launches by the company this year, including Visual Studio and Windows Server.

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.

It's not 2008 anymore. Joey details the ins and outs of upgrading these aging Microsoft servers, including licensing changes, support options and potential pitfalls. It was a simpler time. A decade ...