Microsoft's SQL Server toolbox is a morass of acronyms, from SMO to SSMS to SOS, and differentiating one from the other can be a challenge. I recently caught up with Vicky Harp, lead program manager ...

Let these tools generate your data access layer, saving you time and headaches. There's something here for the simplest or most complex projects. If your software development projects are anything ...

Joseph Sirosh, Microsoft's new Data Group head, today announced a new CTP of SQL Server 2016, along with a preview of Azure Data Lake Store and Analytics services and a preview of Azure SQL Database ...

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

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

I am looking for suggestions on an alternative product for comparing SQL schema and data with Microsoft SQL server (2012). Up to this point in time our company has used Red Gate SQL Compare and SQL ...