this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft’s database has a boatload of new features and delivers solid performance improvements.

Microsoft introduced a preview of the latest edition of its flagship RDBMS, SQL Server 2019, highlighting new Big Data capabilities. The company said v2019 creates a unified data platform by packaging ...