SQL Server 2012/2014 delivers compelling new capabilities that make an upgrade worthwhile. Many IT professionals agree that the AlwaysOn Availability Group (AG) feature offers the most value with its ...

FRAMINGHAM, MASS. — 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 ...

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data work ...

SQL Server isn't on the kind of update schedule that characterizes Visual Studio these days, when it's unusual for two months to go by without some sort of release. But one version is getting a new ...

Bharat Kumar Dokka spearheaded a comprehensive enterprise-wide SQL Server migration initiative across a major client's Administration Infrastructure project, successfully modernizing multiple ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...