Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA) tools for Access applications, integrate Access with SharePoint and other business systems, and much more.
by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort, Wrox
A hands-on resource for SQL Server 2008 troubleshooting methods and toolsSQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.
Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples.
· This is The 'Real' Microsoft Exam Prep Kit, and provides the reader with independent and unbiased exam tips and warnings everything they need to know to ensure certification success. · Authored by Mark Horninger, a nationally recognized leader in SQL Server with over 50 Microsoft certifications to his credit; Mark knows what it takes to successfully navigate Microsoft exams.
Sams Teach Yourself ASP.NET 3.5 in 24 HoursScott MitchellStarter KitDVD includes Microsoft Visual Web Developer 2008 Express EditionIn just 24 sessions of one hour or less, you will be up and running with ASP.NET 3.5. Using a straightforward, step-by-step approach, each lesson builds upon a real-world foundation forged in both technology and business matters, allowing you to learn the essentials of building dynamic, data-driven web applications from the ground up.
by Bryan C. Smith, C. Ryan Clay, Hitachi Consulting, Microsoft Press
Teach yourself SQL Server 2008 Multidimensional Expressions (MDX) language one step at a time. You ll begin with an introduction to the fundamentals of MDX language and the business intelligence landscape. Next, you ll develop queries for various business scenarios, starting with basic concepts and then progressing to more advanced features and demonstrating their practical applications. Finally, you ll explore the most critical and commonly used features of the language.
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter’s domain.
This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations.
Information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Covers Microsoft Transact-SQL. Softcover. CD-ROM included. DLC: SQL (Computer program language)
by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy, Wrox
This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.What you will learn from this book *Ways to quickly move and transform data *How to configure every aspect of SSIS