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 you’ll 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!

Who is this book for?

Developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.

About the Author

Joseph Sack works for Microsoft as a SQL Server Dedicated Support Engineer in the Premier Field Engineering team. For 10+ years, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, retail and the real estate industry. He is the author of SQL Server 2005 T–SQL Recipes and SQL Server 2000 Fast Answers for DBAs and Developers. He is the co–author of Pro SQL Server 2005 and Beginning SQL Server 2000 DBA: From Novice to Professional.

Whether you need an approachable on-ramp to .NET or you want to enhance your skills, C# 3.0 Unleashed is a comprehensive, in-depth guide to the solutions you seek. You’ll learn to do more with the new tools that are available, including Visual Studio 2008 and the .NET Framework Class Libraries. Throughout this book, you’ll get a practical look at what can be the most useful tools for any given task. You’ll also learn common traps to avoid and learn insightful tips that will save you time and help you be more productive.

 

C# 3.0 Unleashed contains complete coverage of the C# programming language. The author covers all the essential syntax, but keeps the focus on practical application. The chapters are arranged to take you step-by-step from the core of the C# language to elements of the .NET Framework, and further into advanced concepts on distributed n-tier Internet applications. Additionally, C# 3.0 Unleashed shows you how to debug, monitor, and scale enterprise applications, enabling you to use the C# programming language to ship the right code at the right time.

 

What’s included in this book:

• A complete reference for C# syntax, object oriented programming, and component programming with C#
• Comprehensive data coverage through ADO.NET and LINQ
• An introduction to UI technologies, including Windows Forms, WPF, ASP.NET Ajax, and Silverlight
• Coverage of traditional ASMX and WCF Web Services
• Coverage of multiple .NET technologies, including networking, instrumentation, interop, and multi-threading
• In-depth discussion of platform concepts including CLR, Garbage Collection, Type System, Assemblies, and Code Access Security
• Guidance on design and architecture for a big-picture view and essential help in piecing together all you’ve learned

 About the Author

Joe Mayo has more than 21 years of software engineering experience and has worked with C# and .NET since July 2000. He regularly contributes to the community through his website, C# Station, which has been running since July 2000. He enjoys giving presentations on .NET, and you can occasionally find him online in a forum or newsgroup, doing what he loves to do–talking about .NET. For his community service over the years, he has been a recipient of multiple Microsoft Most Valuable Professional (MVP) awards. These days, Joe makes a living through the company he founded, Mayo Software Consulting, Inc., delivering value to customers through custom .NET software development services.

Dojo offers Web developers and designers a powerful JavaScript toolkit for rapidly developing robust Ajax applications. Now, for the first time, there’s a complete, example-rich developer’s guide to Dojo and its growing library of prepackaged widgets. Reviewed and endorsed by the Dojo Foundation, the creators of Dojo, this book brings together all the hands-on guidance and tested code samples you need to succeed.

 

Expert Web developer James E. Harmon begins by demonstrating how to “Ajax-ify” existing applications and pages with Dojo, adding Ajax features such as client- and server-side validation as quickly and nondisruptively as possible. Next, he presents in-depth coverage of Dojo’s user interface, form, layout, and specialized Widgets, showing how they work and how to use them most effectively. Among the Widgets, he covers in detail: Date Pickers, Rich Text Editors, Combo Boxes, Expandable Outlines, and many others.

 

In conclusion, Harmon introduces the Dojo toolkit’s powerful capabilities for simplifying Ajax development. He thoroughly explains Dojo’s helper functions, shortcuts, and special methods, illuminating each feature with examples of the JavaScript problems it can solve. This section’s far-ranging coverage includes strings, JSON support, event handling, Ajax remoting, Dojo and the DOM, testing, debugging, and much more. All source code examples are provided on a companion Web site, including source code for a complete tutorial case study application.

 

About the Author

James E. Harmon is the President and Senior Instructor at Object Training Group in Chicago. He is an experienced developer who spent a majority of his career building large scale online applications at Accenture and for several other Web-centric consulting firms. He now specializes in training Java Developers to be more productive by using the latest technologies and frameworks.

 

The book’s web site is http://www.ObjectTrainingGroup.com/dojobook.

 

This monograph deals with the description and design of digital images. Regarding digital images as special input/output relations in our previous book with LNCIS series, the description problem of digital images is transformed into the realization problem of digital images. From the data in digital images, mathematical models will be constructed. Then new systems which describe faithfully any digital images provide new results and their extensions which design digital images. As concerned with mathematical models for digital images, this monograph introduces 2-Commutative Linear Representation Systems for two-dimensional images and 3-Commutative Linear Representation Systems for three-dimensional images. This monograph is intended for researchers and graduate students who specialized in image processing and system theory.

This book constitutes the refereed proceeding of the 13th European Software Process Improvement Conference, EuroSPI 2006, held in Joensuu, Finland in October 2006.

The 18 revised full papers presented were carefully reviewed and selected from 62 submissions. The papers are organized in topical sections on SPI (Software Process Improvement) processes, SPI and risk management, measurement, process modelling, human factors, and implementation of SPI.

As modern organizations migrate from older information architectures to new Web-based systems, the discipline of software engineering is changing both in terms of technologies and methodologies. There is a need to examine this new frontier from both a theoretical and pragmatic perspective, and offer not only a survey of new technologies and methodologies but discussions of the applicability and pros/cons of each.

Software Engineering for Modern Web Applications: Methodologies and Technologies presents current, effective software engineering methods for the design and development of modern Web-based applications, offering scholars, researchers, and practitioners innovative research on the theoretical frameworks, structures, management, and implications software engineering for modern Web applications.

About the Author

Dan Brandon obtained a BS from Case Western Reserve University, an MS, and PhD in Engineering University of Connecticut; his PhD specialization was in computer methods. Before returning to the university environment, Dr. Brandon accumulated over thirty years of commercial experience in both the IT technical and management arenas. He is currently a Professor of Information Technology Management (ITM) and chairperson of that department at Christian Brothers University (CBU) in Memphis, TN. He has been published in a number of books, journals, and conference proceedings. He is a member of the Society of Information Management (SIM), the Information Resource Management Association (IRMA), and the Project Management Institute (PMI). He continues to do consulting with a number of companies both locally and internationally. Currently he is involved in the design and development of comprehensive open source software systems for project management and other business applications.

Software has bugs. Period.

That's true, unfortunately. Even the good old "hello, world" program, known to virtually every C and C++ programmer in the world, can be considered to be buggy. Developing software means having to deal with defects; old ones, new ones, ones you created yourself, and those that others brought to life. Software developers debug programs for a living.

Hence, good debugging skills are a must-have. That said, it is regrettable that debugging is hardly taught in engineering schools. That's how the idea for this book was born.

The Developer's Guide to Debugging is a book for both professional software developers seeking to broaden their skills and students that want to learn the tricks of the trade from the ground up. With small examples and exercises it is well suited to accompany a CS course or lecture. At the same time it can be used as a reference guide to address problems as the need arises.

This book goes beyond the level of simple source code debugging scenarios. In addition, it covers the most frequent real-world problems from the areas of program linking, memory access, parallel processing and performance analysis. The picture is completed by chapters covering static checkers and techniques to write code that leans well towards debugging.

While the focus lies on C and C++, the workhorses of the software industry, one can apply many techniques described in The Developer's Guide to Debugging to programs written in other languages.

Methods of Historical Analysis in Electronic Media provides a foundation for historical research in electronic media by addressing the literature and the methods—traditional and the eclectic methods of scholarship as applied to electronic media. It is about history—broadcast electronic media history and history that has been broadcast, and also about the historiography, research written, and the research yet to be written. Divided into five parts, this book: • addresses the challenges in the application of the historical methods to broadcast history; • suggests the various methods appropriate for electronic-media research based on the nature of the object under study; • suggests new approaches to popular historical topics; • provides a broad topical look at history in broadcasting; and • provides a broad overview of what has been accomplished, a historian's challenges, and a look to the future. Intended for students and researchers in broadcast history, Methods of Historical Analysis in Electronic Media provides an understanding of the qualitative methodological tools necessary for the study of electronic media history, and illustrates how to find primary sources for electronic media research.

With electronic commerce growing so rapidly, businesses need to examine critical elements that could influence users' perceptions of business-to-business and business-to-consumer electronic commerce. This book presents a study of key components and concepts of e-commerce, evaluates the critical success factors for global e-commerce, the economics of e-commerce, and the practical issues involved with e-commerce in various applications. Also included are discussions of the impact of e-commerce on small businesses and entrepreneurships in the United States, consequences of information technology for customer loyalty, internal e-mail messaging systems within organizations, and e-commerce comparisons of the United States and the United Kingdom.

Many experts believe that by the beginning of the next century, the majority of business transactions and communications will be conducted through the use of web-enabled technologies, particularly electronic commerce. As a result, many organizations around the world are looking into the emerging applications of electronic commerce technologies and ways to utilize them in support of their business strategies and postures. With this field growing so rapidly, the object of all businesses is to examine the critical elements that could impact a user’s perception of business-to-business and business-to-consumer electronic commerce. Strategies for eCommerce Success presents a study of key components and concepts of eCommerce, evaluating the critical success factors for global eCommerce, the economics of eCommerce and the practical issues involved with eCommerce in various applications.

About the Author

Bijan Fazlollahi is an associate professor in the Institute of International Business, J. Mack Robinson College of Business at Georgia State University. He currently serves on the editorial board of the Journal of Database Administration and has published articles in journals such as Interfaces, Information and Management, and Information Systems Research. He was a Fulbright Scholar to the former U.S.S.R, 1992-1993, and is an honorary professor at Azerbaijan State Oil University. He lives in Atlanta, Georgia.

If anyone asks us “Do you think motion capture will replace key-frame animation?” we will say “No.”

Motion capture (mocap) is a very fast and accurate way to bring human motion into a 3D computer animation, but it is not always the best way. Mocap technology exhibits its remarkable strengths for some projects while other methods, such as key-framing, work much better for some other projects. We all need to make sure that whichever the method we decide to use, that’s the most effective method for the project.

In this book, we try to give you a basic overview of motion capture based off of the most popular method which is currently (circa 2007) optical motion capture that tracks retro-reflective markers. We don’t even try to say that our way is the only way or always the best way, just that it works for us. You will find many different ways to tackle problems as you go along and find different ways to think about mocap data. Every person we know in the mocap industry has a different idea about how to do things and very good reasons for doing them that way. It’s a big pond and there’s room for lots of different ideas and methods. If you use motion capture you’ll create some of your own methods.

Our goal is to help those who are involved in 3D computer animation and games have a better understanding of motion capture as a whole so that they can decide if they need it for a project, and if they do, how it can be used. One of the things we try to do in this book is to have a mix of showing you how to do things and telling you the theory behind it. Neither one of us was interested in writing a “manual” nor a definite guide that tells you exactly what you need to do with specific mocap hardware and software. We wanted to make the information as broad as possible and applicable to as many situations as possible. So there will be times you need to rely on the user manuals from your hardware and software providers.

We are currently using optical motion capture systems at our workplaces and our pipelines involve Maya and MotionBuilder, where MotionBuilder is currently the only widely available motion editing tool with adequate functionality. Many examples in this book are products of the pipelines. However, let us emphasize this again: this is not the only way. Other applications can work in your pipeline. Photography did not replace painting as some predicted. It has found its own place in visual arts.

We believe that motion capture is finding its own place in motion picture and interactive arts. We hope this book will help you get started with mocap and give you a roadmap to how it all works. We also hope to see results of your creative endeavors.