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

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

Microsoft this week released SQL Server 2012 Service Pack 2. The SP2 release goes by the "RTM" (release to manufacturing) nomenclature, according to Microsoft's announcement. That's an old-fashioned ...

The final SQL Server 2012 service pack is now available for download. The latest official release for the half-decade-old version of Microsoft's database management system includes a rollup of all ...

Microsoft's new SQL Server 2012 licensing can come with some costly pitfalls, according to a licensing expert. The details were reviewed by Paul DeGroot, a founder of Pica Communications and a senior ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...