Beginning SQL Server 2008 for Developers: From Novice to Professional
# By: Robin Dewson
# ISBN10: 1-59059-958-6
# ISBN13: 978-1-59059-958-7
# 496 pp.
# Published Jul 2008
SQL Server 2008 is a first–rate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corporate data warehouses to ad hoc departmental databases. You’ll find enhanced support for XML, new support for spatial data, transparent data encryption, a policy–based management system, and more.
Author and developer Robin Dewson will show you the way from beginner to SQL Server 2008 professional. Learn to install SQL Server 2008 and navigate around Management Studio before getting right to the heart of mastering fundamental SQL Server 2008 tasks: creating tables, storing data, securing data, and retrieving it again. Dewson ensures you’ll be fully prepared to use all the basics and create a solid foundation for your own projects.
Don’t forget about backups! Your database will house important data, so backing up is essential to protect yourself from inevitable hardware failure. Dewson walks you through SQL Server 2008’s easy–to–use backup and recovery feature set, giving you the grounding that you need in order to set up a reliable plan for recovery in your own environment.
Learn to use Transact–SQL, a full–blown procedural language that is built right into the database system. Transact–SQL is the key to unlocking everything that SQL Server 2008 has to offer. Using Transact–SQL, you can write centrally encapsulated business logic through the use of stored procedures, automatically trigger processing through the use of triggers, and manipulate data within the server without having to move data back and forth across the network.
Finally, you’ll learn a bit about SQL Server 2008 Reporting Services, a powerful tool that allows enterprise reporting. Reporting Services enables you to develop and serve reports across your organization and even to business partners outside your company. Reporting Services also gives end users the ability to create their own reports, helping them transform business data into valuable, usable information to guide their day–to–day decisions.
What you’ll learn
* Install and manage SQL Server on your system.
* Create and secure tables.
* Store and query data; use indexes to improve query performance.
* “Sleep when the wind blows,” because you have a solid backup and recovery process.
* Run procedural code inside your database in the form of Transact–SQL procedures and triggers.
* Serve up business reports to in–house users and outside business partners via SQL Server 2008 Reporting Services.
Pro SQL Server 2008 XML
# By: Michael Coles
# ISBN10: 1-59059-983-7
# ISBN13: 978-1-59059-983-9
# 496 pp.
# Published May 2008
Knowledge and ability to apply XML are de rigueur in today’s world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server’s built–in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career.
* Shows how to store, query, and manipulate XML documents in SQL Server
* Provides step–by–step examples showing best practices and advanced features
* Accurately discusses how SQL Server’s XML feature set stacks up against the ISO XML standards
What you’ll learn
* Store XML documents using SQL Server’s built–in XML data type.
* Query those stored documents using SQL/XML and XQuery.
* Manipulate and transform XML using XSLT and XPath.
* Understand how SQL Server’s XML support compares to the ISO XML standards.
* Create SOAP endpoints for use in web services applications.
* Create primary and secondary XML indexes to improve performance of XML queries.
SQL Server 2008 Transact SQL Recipes
Paperback: 872 pages
Data: July 23, 2008
Format: PDF
Description: SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
Current: Newly updated for SQL Server 2008.
Comprehensive: Covers 30 different Transact–SQL problem domains.
What youll learn
Create databases, tables, and indexes.
Query and manipulate data.
Store and manage XML inside the database.
Move business logic into the database.
Encrypt data and capture changes for compliance purposes.
Implement Full–Text Search.
Interface with Service Broker.
And more!
Accelerated SQL Server 2008
# By: Rob Walters , Michael Coles , Fabio Claudio Ferracchiati , Robert Rae , Donald Farmer
# ISBN10: 1-59059-969-1
# ISBN13: 978-1-59059-969-3
# 816 pp.
# Published May 2008
The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.
* Lightning–quick introduction to SQL Server 2008
* Written by top experts in the field
* Provides a solid grounding in key features and technologies
What you’ll learn
* Manage SQL Server installations through the brand–new Declarative Management Framework.
* Protect yourself from downtime with high–availability features such as failover clustering.
* Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008.
* Find what you need using full–text search.
* Store, retrieve, and manage XML in the database.
* Derive competitive advantage from business intelligence tools such as Analysis Services and Reporting Services.
ADO.NET 3.5 Cookbook, Second Edition
By Bill Hamilton
March 2008
Pages: 980
Series: Cookbooks
ISBN 10: 0-596-10140-6 | ISBN 13: 9780596101404
This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform.
Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# code. ADO.NET 3.5 Cookbook also offers clear explanations of how and why each code solution works, and warns you of potential pitfalls so you can learn to adapt the book's problem-solving techniques to different situations.
This collection of timesaving recipes covers vital topics including:
* Connecting to data
* Retrieving and managing data
* Transforming and analyzing data
* Modifying data
* Binding data to .NET user interfaces
* Optimizing .NET data access
* Enumerating and maintaining database objects
* Maintaining database integrity
Ideal for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools such as LINQ. ADO.NET 3.5 Cookbook offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.
# By: Robin Dewson
# ISBN10: 1-59059-958-6
# ISBN13: 978-1-59059-958-7
# 496 pp.
# Published Jul 2008
SQL Server 2008 is a first–rate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corporate data warehouses to ad hoc departmental databases. You’ll find enhanced support for XML, new support for spatial data, transparent data encryption, a policy–based management system, and more.
Author and developer Robin Dewson will show you the way from beginner to SQL Server 2008 professional. Learn to install SQL Server 2008 and navigate around Management Studio before getting right to the heart of mastering fundamental SQL Server 2008 tasks: creating tables, storing data, securing data, and retrieving it again. Dewson ensures you’ll be fully prepared to use all the basics and create a solid foundation for your own projects.
Don’t forget about backups! Your database will house important data, so backing up is essential to protect yourself from inevitable hardware failure. Dewson walks you through SQL Server 2008’s easy–to–use backup and recovery feature set, giving you the grounding that you need in order to set up a reliable plan for recovery in your own environment.
Learn to use Transact–SQL, a full–blown procedural language that is built right into the database system. Transact–SQL is the key to unlocking everything that SQL Server 2008 has to offer. Using Transact–SQL, you can write centrally encapsulated business logic through the use of stored procedures, automatically trigger processing through the use of triggers, and manipulate data within the server without having to move data back and forth across the network.
Finally, you’ll learn a bit about SQL Server 2008 Reporting Services, a powerful tool that allows enterprise reporting. Reporting Services enables you to develop and serve reports across your organization and even to business partners outside your company. Reporting Services also gives end users the ability to create their own reports, helping them transform business data into valuable, usable information to guide their day–to–day decisions.
What you’ll learn
* Install and manage SQL Server on your system.
* Create and secure tables.
* Store and query data; use indexes to improve query performance.
* “Sleep when the wind blows,” because you have a solid backup and recovery process.
* Run procedural code inside your database in the form of Transact–SQL procedures and triggers.
* Serve up business reports to in–house users and outside business partners via SQL Server 2008 Reporting Services.
کد:
]http://rapidshare.com/files/148663532/Beginning.SQL.Server.2008.for.Developers.From.Novice.to.Professional.Jul.2008.rarPro SQL Server 2008 XML
# By: Michael Coles
# ISBN10: 1-59059-983-7
# ISBN13: 978-1-59059-983-9
# 496 pp.
# Published May 2008
Knowledge and ability to apply XML are de rigueur in today’s world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server’s built–in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career.
* Shows how to store, query, and manipulate XML documents in SQL Server
* Provides step–by–step examples showing best practices and advanced features
* Accurately discusses how SQL Server’s XML feature set stacks up against the ISO XML standards
What you’ll learn
* Store XML documents using SQL Server’s built–in XML data type.
* Query those stored documents using SQL/XML and XQuery.
* Manipulate and transform XML using XSLT and XPath.
* Understand how SQL Server’s XML support compares to the ISO XML standards.
* Create SOAP endpoints for use in web services applications.
* Create primary and secondary XML indexes to improve performance of XML queries.
کد:
http://rapidshare.com/files/148664132/Pro.SQL.Server.2008.XML.rarSQL Server 2008 Transact SQL Recipes
Paperback: 872 pages
Data: July 23, 2008
Format: PDF
Description: SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
Current: Newly updated for SQL Server 2008.
Comprehensive: Covers 30 different Transact–SQL problem domains.
What youll learn
Create databases, tables, and indexes.
Query and manipulate data.
Store and manage XML inside the database.
Move business logic into the database.
Encrypt data and capture changes for compliance purposes.
Implement Full–Text Search.
Interface with Service Broker.
And more!
کد:
http://rapidshare.com/files/148664585/SQL.Server.2008.Transact.SQL.Recipes.Jul.2008.rarAccelerated SQL Server 2008
# By: Rob Walters , Michael Coles , Fabio Claudio Ferracchiati , Robert Rae , Donald Farmer
# ISBN10: 1-59059-969-1
# ISBN13: 978-1-59059-969-3
# 816 pp.
# Published May 2008
The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.
* Lightning–quick introduction to SQL Server 2008
* Written by top experts in the field
* Provides a solid grounding in key features and technologies
What you’ll learn
* Manage SQL Server installations through the brand–new Declarative Management Framework.
* Protect yourself from downtime with high–availability features such as failover clustering.
* Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008.
* Find what you need using full–text search.
* Store, retrieve, and manage XML in the database.
* Derive competitive advantage from business intelligence tools such as Analysis Services and Reporting Services.
کد:
http://rapidshare.com/files/148661550/Accelerated.SQL.Server.2008.May.2008.rarADO.NET 3.5 Cookbook, Second Edition
By Bill Hamilton
March 2008
Pages: 980
Series: Cookbooks
ISBN 10: 0-596-10140-6 | ISBN 13: 9780596101404
This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform.
Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# code. ADO.NET 3.5 Cookbook also offers clear explanations of how and why each code solution works, and warns you of potential pitfalls so you can learn to adapt the book's problem-solving techniques to different situations.
This collection of timesaving recipes covers vital topics including:
* Connecting to data
* Retrieving and managing data
* Transforming and analyzing data
* Modifying data
* Binding data to .NET user interfaces
* Optimizing .NET data access
* Enumerating and maintaining database objects
* Maintaining database integrity
Ideal for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools such as LINQ. ADO.NET 3.5 Cookbook offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.
کد:
http://rapidshare.com/files/148667036/zADO.NET.3.5.Cookbook.2nd.Edition.Mar.2008.rar
