SQL Server 2005 is next generation of SQL Server database and represents a massive leap forward for SQL Server developers in terms of programming options, productivity, database management and analysis. This book will take a deep look at the full range of SQL Server enhancements that will give meaningful and relevant examples that show not just how these new features work, but also how to architect their applications in order to exploit the new features most effectively.

This book is all about getting developers working on their own SQL Server 2005 solutions as quickly and painlessly as possible. Some of the core topics covered in the book are: Enhancements to database programmability features and languages, such as ADO.NET, XML, .NET assemblies, and T-SQL; New Servers, services and tools such as Reporting Services, and the Service Broker and DTS; Enhancements to the BI capabilities such as Analysis Services and Notification services.

Join us if you will, and discover the tales of the Storyteller's Chest. There are new friends to meet and wonderful places to discover. Whether it be in the depths of the ocean or a castle in a magical kingdom, our heroes are waiting for you. So pack your bag and get ready. It is time for you to join them on their adventures. And maybe at the end, you'll have a story or two of your own to tell.

Pro SQL Server 2005, Second Edition is a revised and expanded version of this classic and bestselling book, which provides in-depth coverage of all the key new SQL Server features and enhancements. It focuses on what experienced SQL Server DBAs, developers, and Business Intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. Each new feature is carefully presented and precisely illustrated using examples to show you how to use it most effectively. The second edition expands on the original by adding chapters on encryption, full-text search, LINQ, and the ADO.NET 3.0 Entity Data Model, bringing it up to date for .NET 3.5, and making it even more attractive than ever to readers. You'll find incisive, expert guidance on all of the major new functionality of SQL Server 2005 under one cover, including essential topics for all SQL Server professionals, such as Transact-SQL enhancements SQL Server Management Studio CLR integration and programming stored procedures in C# SQL Server Reporting Services enhancements SQL Server Analysis Services enhancements The new XML datatype and XQuery support Security enhancements and Service Broker SQL Server Integration Services for data extraction, transformation, and loading Encryption Full-text search ADO.NET 3.0 Entity Data Model A team of expert authors provides practical, in-depth coverage of the core topics each specializes in--all supported by realistic examples, so you'll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race tomastery of SQL Server 2005 What you'll learn How to use enhanced T-SQL statements and features How to use SQL Server Management Studio to manage databases How to program stored procedures in C# with SQLCLR How to use Reporting Services and Analysis Services enhancements How to use the new XML datatype and XQuery support How to take advantage of enhanced security features How to use Service Broker How to use Integration Services to extract, transform, and load data How to encrypt and decrypt data How to do full-text searches How to simply access data with LINQ How to use the ADO.NET 3.0 Entity Data Model Who is this book for? Pro SQL Server 2005, Second Edition is for every experienced SQL Server 2000 user who wants to quickly learn about the many major new features of SQL Server 2005. It's also for experienced SQL Server 2005 users who need to quickly master new features and exploit them to solve problems in a more efficient and effective way. Each chapter is a self-contained, in-depth introduction to a new feature. The wealth of information contained makes the book an indispensable reference for every database user, programmer, and administrator. About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard-wonsolutions to problems you will face in your professional programming career. Related Titles from Apress Pro T-SQL 2005 Programmer's Guide Pro SQL Server 2005 Reporting Services Foundations of SQL Server 2005 Business Intelligence Expert C# 2005 Business Objects. Second Edition Foundations of LINQ in C#

Updated guidance on how to take advantage of the newest features of SharePoint programmability

More than simply a portal, SharePoint is Microsoft's popular content management solution for building intranets and websites or hosting wikis and blogs. Offering broad coverage on all aspects of development for the SharePoint platform, this comprehensive book shows you exactly what SharePoint does, how to build solutions, and what features are accessible within SharePoint.

Written by a team of SharePoint experts, this new edition offers an extensive selection of field-tested best practices that shows you how to leverage the vast power of this multi-faceted tool to build custom workflow and content management applications. Plus, you'll discover how to take advantage of the new features to roll out new SharePoint sites or upgrade existing sites.Keeps you thoroughly up to date on all the most recent changes to SharePoint 2010 Reveals broad and deep coverage of social media features, content management applications, enterprise search, business connectivity services, user experience development, and custom workflowExamines SharePoint Server 2010 vs. SharePoint Foundation ServerHighlights ways you can take advantage of improvements to offline and mobile client capabilities, improvements to SQL Server table support, Cloud-based offerings with Azure integration, social networking additions, and more

"Professional SharePoint 2010 Development, Second Edition" presents you with authoritative coverage on all aspects of development for the SharePoint platform.