Get up to speed on the extensive changes to the newest release of Microsoft SQL Server
The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.

Apply powerful window functions in T-SQL�and increase the performance and speed of your queries
Optimize your queries�and obtain simple and elegant solutions to a variety of problems�using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you�ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you�re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.

To deploy Lync Server 2010 requires Windows Server � and Microsoft SQL Server �, and they must be properly licensed.
The figure below is a list of compatible versions of Windows Server and SQL Server: