Pro T SQL 2008 or Adobe AIR 15

Pro T-SQL 2008

Author: Michael Coles

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact–SQL functionality in SQL Server 2008 in his book Pro T–SQL 2008 Programmer’s Guide. Fully functioning examples and downloadable source code bring Coles’ technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success.

Pro T–SQL 2008 Programmer’s Guide is every developer’s key to making full use of SQL Server 2008’s powerful, built–in Transact–SQL language. Transact–SQL is the language developers and DBAs use to interact with SQL Server. It’s used for everything from querying data, to writing stored procedures, to managing the database. New features in SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market–leading XML feature set, and support for encryption—all of which are covered in this book

What you’ll learn

Write stored procedures, functions, and triggers using Transact–SQL

Apply best–practices when centralizing procedural logic inside your SQL Server database.

Seamlessly work with XML data using XQuery, XPath, and the XML type.

Use SQLCLR to write .NET code that runs inside SQL Server.

Implement full–text search within your database.

Load data more efficiently using the new MERGE statement.

Learn about the newgeography type for storing spatial data.

Who is this book for?

Pro T–SQL 2008 Programmer’s Guide is written for SQL Server and Transact–SQL developers who want to implement best–practices and take full advantage of all that SQL Server has to offer. .NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.

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–won solutions to problems you will face in your professional programming career.

Read also Corporate Advocacy or Customer Service

Adobe Air 1.5: Solutions and Examples for Rich Internet Application Developers

Author: David Tucker

Thoroughly vetted by Adobe's AIR development team, Adobe AIR Cookbook addresses fundamentals, best practices, and topics that web developers and application designers inquire about most. The hands-on recipes in this cookbook help you solve a variety of tasks and scenarios you may encounter using Adobe AIR to build Rich Internet Applications for the desktop. It's an ideal way to learn the nuances of Adobe AIR, with practical solutions you can use right away, and detailed explanations of why and how they work. These recipes will help you: Build an AIR application with Flex, Flash, or HTML and Ajax Create a database and connect it to your application Put together native menus for PCs and Macs Work with the Service Monitor Framework Utilize the Adobe AIR Update Framework Create branded desktop experiences with custom chrome and custom application icons Distribute your AIR application with the Seamless Install Badge

And more. Adobe AIR Cookbook includes dozens of recipes from rising stars in the AIR development community-David Tucker, Rich Tretola, Marco Casario, and Koen De Weggheleire-along with the best solutions posted by visitors to the Adobe AIR Cookbook community website hosted by Adobe and O'Reilly (adobe.com/go/air_cookbook). If you're ready to expand your skill set with Adobe AIR, this is the book you've been waiting for.