This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more Features updated and new material, including new examples using Microsoft's AdventureWorks sample database

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation and configuration/architecting, implementing and monitoring security controls, configuring and managing network communications, automating administration tasks, disaster prevention and recovery, performance monitoring, optimizing and ensuring high availability, as well as major SQL Server 2008 components including Integration Services, Reporting Services, Analysis Services, and Service Broker.

Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios Includes programming examples focused on specific, scenario-based solutions Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques

Presents an introduction to the features and functions of LightSwitch and offers instructions on ways to create applications without writing code.

The definitive programming guide to ASP.NET, by popular author and Microsoft MVP Imar Spaanjaars Updated for ASP.NET 4, this introductory book retains its helpful examples and step-by-step format from the previous version and keeps the style of offering code examples written in both C# and Visual Basic. Beloved author and Microsoft ASP.NET MVP walks you through ASP.NET, Microsoft's technology for building dynamically generated Web pages from database content. You'll discover many improvements that ASP.NET 4 offers over the previous version, such as the ASP.NET MVC framework, Ajax improvements, jQuery support, and more. You'll gradually build a Web site example that takes you through the processes of building basic ASP.NET Web pages, adding features with pre-built server controls, designing consistent pages, displaying data, and more. Popular author and Microsoft ASP.NET MVP Imar Spaanjaars updates you on the latest updates to ASP.NET 4, Microsoft's technology for building dynamic Web pages from database content Shows you how the 4 version differs from ASP.NET 3.5 and reviews its new features, including the ASP.NET MVC framework, various Ajax improvements, jQuery support, and more Spaanjaars's distinct writing style puts you at ease with learning ASP.NET 4.

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. You'll explore the key additions and changes to this newest version, including conditional action constructs, enhanced controls for results paging, application integration with SharePoint and Excel, and development of BI applications. Covers new features such as SQL Azure for cloud computing, client-connectivity enhancements, security and compliance, data replication, and data warehouse performance improvements Addresses essential topics including managing keys, writing scripts, and working with store procedures Shares helpful techniques for creating and changing tables, programming with XML, and using SQL Server Reporting and Integration Services Beginning Microsoft SQL Server 2012 Programming demystifies even the most difficult challenges you may face with the new version of Microsoft SQL Server.

Master Microsoft's Business Intelligence Tools Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to take full advantage of Microsoft's collaborative business intelligence (BI) tools. A variety of powerful, flexible technologies are covered, including SQL Server Analysis Services (SSAS), Excel, Excel Services, PowerPivot, SQL Server Integration Services (SSIS), Server Reporting Services (SSRS), SharePoint Server 2010, PerformancePoint Services, and Master Data Services. This practical guide focuses on deveoloping end-to-end BI solutions that foster informed decision making. Create a multidimensional store for aggregating business data with SSAS Maximize the analysis capabilities of Excel and Excel Services Combine data from different sources and connect data for analysis with PowerPivot Move data into the system using SSIS, InfoPath, Streamsight, and SharePoint 2010 External Lists Build and publish reports with SSRS Integrate data from disparate applications, using SharePoint 2010 BI features Create scorecards and dashboards with PerformancePoint Services Summarize large volumes of data in charts and graphs Use the SSRS map feature for complex visualizations of spatial data Uncover patterns and relationships in data using the SSAS data mining engine Handle master data management with Master Data Services Publish the components of your BI solution and perform administrative tasks

Take your Microsoft Visual Studio 2008 programming skills to the top tier "A must-read for experienced developers who want to dive deeply into Visual Studio 2008. The authors provide practical guidance combined with real-world applicability. The best of Visual Studio 2008 uncovered-buy this book!" --Michelle Clarke, Program Manager, Microsoft Ireland Maximize every powerful programming feature available in Visual Studio 2008 with expert instruction from two Microsoft MVPs. Through clear explanations and real-world code samples, Microsoft Visual Studio 2008 Programming reveals how to develop innovative, high-performance applications with C# and VB.NET. Learn how to deploy ADO.NET and WCF services, incorporate XML and Ajax scripts, build hack-resistant code, and much more. The latest security tools, visualizers, and debuggers are also covered in detail. Work with WinForms, JavaScript, and Windows Services Use extension methods, partial classes, and XML literals Handle database transactions with XSLT, ADO.NET, and LINQ Build mobile-ready and offline applications using Sync Services Manage Active Directory and Internet Information Services from code Defend against SQL injection and cross-site scripting attacks Learn from secure code guru Michael Howard how to take advantage of the security defenses in Visual C++ Construct setup packages using ClickOnce and Windows Installer Cut development time using Visual Studio Team System and WPF

This book is for anyone who wants to learn how to build rich and interactive Microsoft ASP.NET web sites. With the knowledge you gain from this book, you create a great foundation to build any type of web site, ranging from simple hobby-related web sites to sites you may be creating for commercial purposes. Using this book’s step-by-step format you’ll learn to: Obtain, install, and customize Visual Web Developer (VWD) 2008 create a new web site and how to add new pages to it. use the numerous tools in VWD to create HTML and ASP.NET pages use the VWD tools and CSS, the language that is used to format web pages What ASP.NET server controls are, what they are used for, and how to use them program web pages Visual Basic or C# create consistent-looking pages through the use of master pages, skins, and themes build the navigation structure of your site create and use User Controls and enhance them to repeat content like menus and banners accept, validate, and process user input and send e-mail from your ASP.NET web application create good looking, flicker free web page interaction with ASP.NET Ajax the basics of SQL, the language used access and alter data in a database use the database tools found in Visual Web Developer use the ASP.NET data controls to create an interface for your users to interact with your application’s data use LINQ to SQL to access SQL Server databases without writing a lot of manual code change the visual appearance of your data through the use of control styles interact with the data-bound controls and speed up your application use the security ASP.NET features to create user accounts, distinguish between anonymous and logged on users, and manage the users in your system create personalized web pages with content targeted at individual users find and fix problems with VWD debugging tools deploy and run your final web site