Microsoft SQL Server 2008 For Dummies If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company’s data management — read Microsoft SQL Server 2008 For Dummies! SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You’ll be able to: * Develop and maintain a SQL Server system * Design databases with integrity and efficiency * Turn data into information with SQL Server Reporting Services * Organize query results, summarizing data with aggregate functions and formatting output * Import large quantities of data with SSIS * Keep your server running smoothly * Protect data from prying eyes * Develop and implement a disaster recovery plan * Improve performance with database snapshots * Automate SQL Server 2008 administration ISBN-13: 978-0470224656

LINQ For Dummies If you’ve asked yourself “Why can’t I develop database and XML queries in a language I already know?”, then Language INtegrated Query, or LINQ, is for you. LINQ For Dummies introduces you to LINQ and the .NET Framework technologies, so you can use LINQ to query any object, any data set, any kind of XML, and SQL Server—no questions asked. This plain-English guide gives you a thorough overview of LINQ, from understanding the tasks it performs to making LINQ work with both Visual Basic and Visual Studio 2005. It explains the four LINQ providers in the .NET Framework, the easiest ways to go about accessing data, and how to write more efficient applications with less code using LINQ. There’s also clear guidance on combining third-party providers with LINQ to create even more powerful apps. With this single, comprehensive guide, you’ll discover how to: ISBN-13: 978-0470277942 * Use one query language with all Microsoft languages * Examine .NET language extensions and work with extension methods, partial methods, lambda expressions, and query expressions * LINQ to DataSet operators, SQL server operations, XML API, or Active Directory * Deal with databases — download and install the Northwind database, generate Northwind entity classes, and create the Northwind XML mapping file * Create the partial class example, the partial method example, and the database modification example * Use objects with LINQ * Query databases in Visual Basic and C#