• Paperback: 384 pages
• Publisher: Morgan Kaufmann (January 21, 2008)
• Language: English
• ISBN-10: 0123741378

Joe Celko has looked deep into the code of novice SQL programmers and found a consistent and troubling pattern. These programmers have not changed their approach from writing code for a procedural language, like C, to a declarative language�which is what SQL is. As a result they are not fully using the power and capability inherent in SQL and that translates into writing more code than they need to write, more complex code than is needed, and ultimately lower productivity.

Thinking in sets reveals the conceptual shift these programmers need to make. Through detailed examples and clear explanations, Joe enables readers to concepualize database problems as rooted in sets and solvable through declarative programming techniques. The book focuses on three main table-based SQL techniques that not only demonstrate this set characteristic of SQL but also dramatically simplify application development. For each table type�auxillary, temporal and virrual�Joe teaches not only the new kind of thinking required to use them effectively but also how to choose the right table technique to apply and why.

* Joe brings you comprehensive treatment of SQL programming techniques that make use of tables rather than procedural code.

* The focus on real world examples and Joe�s creative teaching style enable SQL programmers to conquer a common weak spot, while learning these new tools.

* A unique contribution, many techniques which are novel and unavailable elsewhere.

About the Author
Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on assorted SQL newsgroups, his column in Intelligent Enterprise (which won several Readers Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celkos SQL for Smarties: Advanced SQL Programming, Joe Celkos SQL Puzzles and Answers, Joe Celkos Trees and Hierarchies in SQL for Smarties, and Joe Celkos SQL Style, all published by Morgan Kaufmann.

Download:

http://w13.easy-share.com/1699630949.html

• Paperback: 656 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (November 5, 2007)
• Language: English
• ISBN-10: 0071498508

Write powerful SQL statements and PL/SQL programs

Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you�ll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

• Explore SQL Plus and SQL Developer
• Use SQL SELECT, INSERT, UPDATE, and DELETE statements
• Write PL/SQL programs
• Create tables, sequences, indexes, views, and triggers
• Write advanced queries containing complex analytical functions
• Create database objects and collections to handle abstract data
• Use large objects to handle multimedia files containing music and movies
• Write Java programs to access an Oracle Database using JDBC
• Tune your SQL statements to make them execute faster
• Explore the XML capabilities of the Oracle Database
• Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more

About the Author
Jason Price is a freelance consultant and former product manager at Oracle Corporation. He has contributed to many of Oracle's products and is an Oracle Certified Database Administrator and Application Developer.

Download:

http://w13.easy-share.com/1698832851.html

• Paperback: 320 pages
• Publisher: Academic Press; Spi edition (September 1999)
• Language: English
• ISBN-10: 0121016250

�Read the book from cover to cover� is rewarding and provides one with a feel for the state of the art in relation to data mining from genetics databases� I would highly recommend the book to anyone currently doing research in the biological sciences and molecular or genetic science in particular� - Today�s Life Sciences

Download:

http://w13.easy-share.com/1698861151.html

• Paperback: 576 pages
• Publisher: Prentice Hall PTR; 1 edition (January 8, 2008)
• Language: English
• ISBN-10: 0132302071

The Most Complete, Practical, Solutions-Focused Guide to Running ESX Server 3

VMware ESX Server in the Enterprise is the definitive, real-world guide to planning, deploying, and managing todaya��s leading virtual infrastructure platform in mission-critical environments.

Drawing on his extensive experience consulting on large-scale ESX Server implementations, Edward L. Haletky brings together an unprecedented collection of tips, best practices, and field-tested solutions. More than any other author, he illuminates the real issues, tradeoffs, and pitfalls associated with ESX Servera��and shows how to make the most of it in your unique environment.

Haletky covers the entire lifecycle: planning, installation, system monitoring, tuning, clustering, security, disaster recovery, and much more. Throughout, he supports his recommendations with examples from real-world deployments. He also provides detailed checklists for handling crucial issues such as caching, networking, storage, and hardware selection. Many of his techniques and practices apply to all current virtualization platforms, not just ESX Server.

This book will be an indispensable resource for every network architect, administrator, and IT professional who works with virtual servers. ESX Server newcomers will find the soup-to-nuts introduction they desperately need; experienced users will find an unparalleled source of field-tested answers and solutions.

In this book, youa��ll learn how to:

a�? Identify key differences between ESX v3.x.y and ESX v2.5.x and their implications

a�? Perform a complete installationa��with automated scripting techniques and samples

a�? Efficiently audit, monitor, and secure ESX Server

a�? Discover SAN storage pitfalls and solutionsa��with detailed guidance for specific SANs, switches, and fibre-channel adapters

a�? Understand ESX Server networking: NIC teaming, vSwitches, network lag, and troubleshooting

a�? Configure ESX Server via the Management User Interface, Virtual Center client, and command line interface

a�? Install Windows, Linux, and NetWare VMs: prepare media images, place configuration files, handle sizing and swap files, and more

a�? Use Dynamic Resource Load Balancing to consistently achieve utilization goals

a�? Implement effective backup and disaster recovery procedures

Edward L. Haletky owns AstroArch Consulting, Inc., a consultancy specializing in virtualization, security, and networking. He has been rated by his peers on the VMware Discussion Forums as a a�?virtuosoa�? for his work in answering VMware security and configuration questions. Prior to establishing AstroArch, Haletky was a member of Hewlett-Packarda��s Virtualization, Linux, and High-Performance Technical Computing teams. He holds a degree in Aeronautical and Astronautical Engineering from Purdue University.

About the Author

Edward L. Haletky graduated from Purdue University with a degree in aeronautical and astronautical engineering. Since then, he has worked programming graphics and other lower-level libraries on various UNIX platforms. Edward recently left Hewlett-Packard, where he worked on the Virtualization, Linux, and High- Performance Technical Computing teams. He owns AstroArch Consulting, Inc., providing virtualization, security, and network consulting and development. Edward is very active (rated Virtuoso by his peers) on the VMware discussion forums providing answers to security and configuration questions.

Download:

http://w15.easy-share.com/14129181.html

• Paperback: 408 pages
• Publisher: Apress (September 21, 2007)
• Language: English
• ISBN-10: 1590598601

Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers explains how to use ASP.NET 2.0 and SQL Server 2005 most efficiently together. It covers all crucial performance issues and illustrates optimal techniques with enterprise-quality development.

Performance is always an issue, and optimizing database access is one of the most daunting performance challenges facing web developers. With Brennan Stehling as your guide, you�ll explore the many overlaps of web and database technologies, including configuration, programming, performance tuning, and deployment. Youa��ll learn how to make high-performance database access not just a goal, but a reality.

What youa��ll learn

• Discover what impedes ASP.NET 2.0 access to SQL Server 2005 and how to make web applications and databases work blindingly fast together.
• Learn to make the subtle choices between DataSets, DataReaders, and DataObjects, to simplify code and maximize performance.
• Optimize data-bound controls and create your own.
• See when a custom database provider is advisable and how to build one.
• Understand how to monitor and measure web/database performance.
• Learn to build, deploy, and configure enterprise-level web applications against SQL Server 2005.

Who is this book for?

Anyone involved in .NET web development will find this book invaluable. Whether youa��re struggling just to handle traffic or scaling up to meet demand, youa��ll find all the tools, tips, and techniques you need for high-performance web access to databases. If you want to build enterprise-level web database applications 100% of the time, this book will tell�and show�you how to do it.

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.

Related Titles

Pro ASP.NET 2.0 Website Programming

Beginning ASP.NET 2.0 Databases: From Novice to Professional

Expert ASP.NET 2.0 Advanced Application Design

About the Author
Brennan Stehling is a consultant in Milwaukee who specializes in web, console, and desktop development projects. He�s worked with .NET for several years, particularly since the .NET 2.0 Beta 1 release. He blogs regularly on .NET topics at http://brennan.offwhite.net/blog/. He also develops reusable tools in C# and makes them available to developers at SmallSharpTools.com. In his spare time, Brennan plays Gaelic hurling, an Irish sport that has become popular in Milwaukee over the past 10 years.

Download:

http://w13.easy-share.com/14140321.html

• Hardcover: 617 pages
• Publisher: Apress; 2 edition (September 28, 2007)
• Language: English
• ISBN-10: 1590599535

It is clear that Visual Studio Team System is the future of development from Microsofta��s perspective. Development is no longer a personal pursuit by one developer in a darkened room; it is a collective effort by a team of peers. VSTS supports this broader vision by providing a complete collaboration platform for the entire project team. VSTS takes a services-oriented approach leveraging Windows SharePoint Services and SQL Server Business Intelligence Suite. Additionally, VSTS brings the life cycle to life by making it part of the integrated suite.

For those seeking to use test-driven development, VSTS is the tool for you. If youa��re an architect, there is a new set of domain-specific modeling tools that makes it easy to visualize systems, determine application relationships, and deploy into a logical datacenter. For testers, Microsofta��s new suite of test tools provides a powerful web testing environment with virtually unlimited extensibility. In addition, the new load tools allow you to perform world-class scalability testing.

Even if you are just considering adopting VSTS, Pro Visual Studio Team System with Team Edition for Database Professionals, Second Edition will provide you with a comprehensive overview. Furthermore, you will be able to dive deep into any area with detailed descriptions, samples, and walkthroughs. Roll up your sleeves and get ready for a new way of developing solutions!

What youa��ll learn

This book will guide you through the entire breadth of VSTS. If you are a stakeholder, you have a portal that gives you instant access to project documents, status, and performance indicators. If you are a project manager, you will learn how create, manage, and assess team performance. As VSTS is integrated with MS Office, you can quickly assign tasks and gather work status. With reporting from the data warehouse, you get a real-time view of all project metrics. If you are a developer, you will learn how to write higher-quality code, and ensure that the code works and performs well.

Who is this book for?

This book is for anyone with an interest in Visual Studio 2005 Team System. Whether youa��re an architect, developer, tester, or database professional implementing VSTS or just considering it, this book will provide you with the answers that you need.

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.

Download:

http://w13.easy-share.com/14200481.html

• Paperback: 645 pages
• Publisher: Wiley; Pap/Onl edition (October 1, 2007)
• Language: English
• ISBN-10: 0470099518

Leverage the power of SQL and Excel to perform business analysis

Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data to produce results. Along the way, he shares stories based on his personal experience in the field, intended to enrich your understanding of why some things worka��and others don�t.

Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what you can expect the results to look like. Throughout the book, critical features of Excel are highlighted, interesting uses of Excel graphics are explained, and dataflows and graphical representations of data processing are used to illustrate how SQL works.

Data Analysis Using SQL and Excel shares hints, warnings, and technical asides about Excel, SQL, and data analysis/mining. The book also discusses:

• How entity-relationship diagrams describe the structure of data
• Ways to use SQL to generate SQL queries
• Descriptive statistics, such as averages, p-values, and the chi-square test
• How to incorporate geographic information into data analysis
• Basic ideas of hazard probabilities and survival
• How data structures summarize what a customer looks like at a specific point in time
• Several variants of linear regression

The companion Web site provides the data sets, Excel spreadsheets, and examples featured in the book.Download:

http://w15.easy-share.com/12316201.html

• Paperback: 520 pages
• Publisher: Digital Press (April 13, 2007)
• Language: English
• ISBN-10: 1555583199

Database professionals will find that this new edition aids in mastering the latest version of Microsofts SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency.

Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered.

* Identifies the most common issues DBAs face day to day for easy reference
*Provides DBAs with solutions actually used by the authors in enterprise environments to resolve common and specialized problems to optimization issues.
* Addresses issues that have been introduced by new features which can add more control but reduce performance.

About the Author
Ken England is President and Founder of Database Technologies, a database consulting, product evaluation and training firm. A Microsoft Certified Systems Engineer and a Microsoft Certified Trainer, Ken England is widely regarded as an authority on SQL Server and other leading database products. He is also the author of the SQL Server 6.5 Performance Optimization and Tuning Handbook. Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COMs (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle High performance Tuning and the just released Oracle SQL

Download:

http://w13.easy-share.com/12318061.html

• Paperback: 412 pages
• Publisher: Syngress (August 13, 2007)
• Language: English
• ISBN-10: 1597491969

The perfect book for multi-tasked IT managers responsible for securing the latest version of SQL Server 2005.

SQL Server is the perfect product for the How to Cheat series. It is an ambitious product that, for the average SysAdmin, will present a difficult migration path from earlier versions and a vexing number of new features. How to Cheat promises help in order to get SQL Server secured as quickly and safely as possible.

* Provides the multi-tasked Sys Admin with the essential information needed to perform the daily tasks
* Covers SQL Server 2005, which is a massive product with significant challenges for IT managers
* Emphasizes best-practice security measures

About the Author
Mark Horninger , A+, Net+, Security+, MCSE+I, MCSD, MCAD,MCDBA, MCTS, MCITP, MCPD is President and founder of Haverford Consultants Inc.( http://www.haverford-consultants.com/ ), located in the suburbs of Philadelphia, PA. He develops custom applications and system engineering solutions, specializing primarily in Microsoft operating systems and Microsoft BackOffice products. He is also an adjunct professor at Kaplan University in the Web department. He has over 15 years of computer consulting experience and has passed 50+ Microsoft Certified Exams. During his career Mark has worked on many extensive and diverse projects including database development, application development, training, embedded systems development and Windows NT and 200x project rollout planning and implementations. Mark lives with his wife Debbie and two children in Havertown, PA. He is the author of Configuring and Troubleshooting Windows XP Professional MCSE Windows 2000 Professional Study Guide and Designing SQL Server 2000 Databases for .NET Enterprise Servers.

Download:

http://w14.easy-share.com/11358231.html

• Paperback: 254 pages
• Publisher: O�Reilly Media, Inc.; 1 edition (April 10, 2007)
• Language: English
• ISBN-10: 0596009577

Although MySQL�s source code is open in the sense of being publicly available, it�s essentially closed to you if you don�t understand it. In this book, Sasha Pachev � a former member of the MySQL Development Team � provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You�ll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.

The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:

• Core server classes, structures, and API
• The communication protocol between the client and the server
• Configuration variables, the controls of the server; includes a tutorial on how to add your own
• Thread-based request handling � understanding threads and how they are used in MySQL
• An overview of MySQL storage engines
• The storage engine interface for integrating third-party storage engines
• The table lock manager
• The parser and optimizer for improving MySQL�s performance
• Integrating a transactional storage engine into MySQL
• The internals of replication

Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It�s your guide to discovering and improving a great database.

Download:

http://w15.easy-share.com/11119071.html

• Paperback: 672 pages
• Publisher: Addison-Wesley Professional; 2 edition (October 4, 2007)
• Language: English
• ISBN-10: 0321444434

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a �Mere Mortal� will indeed be empowered to perform the superhuman. Do not walk past this book!

Download:

http://w14.easy-share.com/11353381.html

• Paperback: 368 pages
• Publisher: Sams; 1 edition (August 2, 2007)
• Language: English
• ISBN-10: 0672328674

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute lessons, youa��ll learn everything you need to know to take advantage of Microsoft SQL Servera��s T-SQL language.

This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints, XML, and much more.

Youa��ll learn what you need to know methodically, systematically, and simplya��in highly focused lessons designed to make you immediately and effortlessly productive.

Tips point out shortcuts and solutions

Cautions help you avoid common pitfalls

Notes explain additional concepts, and provide additional information

10 minutes is all you need to learn how toa��

• Use T-SQL in the Microsoft SQL Server environment
• Construct complex T-SQL statements using multiple clauses and operators
• Filter data so you get the information you need quickly
• Retrieve, sort, and format database contents
• Join two or more related tables
• Make SQL Server work for you with globalization and localization
• Create subqueries to pinpoint your data
• Automate your workload with triggers
• Create and alter database tables
• Work with views, stored procedures, and more

Register your book at www.samspublishing.com/register to download examples and source code from this book.

About the Author

Ben Forta is Adobe Systemsa��s Senior Technical Evangelist and has over 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the bestselling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into more than a dozen languages), MySQL Crash Course, ColdFusion Web Application Construction Kit and Advanced ColdFusion Development (both published by Que), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on Flash, Java, WAP, Windows 2000, and other subjects. He has extensive experience in database design and development, has implemented databases for several highly successful commercial software programs, and is a frequent lecturer and columnist on Internet and database technologies. Born in London, England, and educated in London, New York, and Los Angeles, Ben now lives in Oak Park, Michigan with his wife Marcy and their seven children. Ben welcomes your email at ben@forta.com, and invites you to visit his website at http://www.forta.com/.

Download:

http://w15.easy-share.com/7930921.html

• Hardcover: 745 pages
• Publisher: Apress (July 17, 2007)
• Language: English
• ISBN-10: 159059780X

Maintaining SQL Server 2005 high availability in a global information environment is the database administrator�s greatest practical challenge. Availability is as much about people and processes as it is about technology. Pro SQL Server 2005 High Availability covers the technology, people, processes, and real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances.

With years of experience as a database consultant and production DBA, Allan Hirt provides in-depth, detailed advice on what it takes to ensure SQL Server high availability for businesses of any size. This is not an academic text; it�s not based on lab experiments, but on real-world experience. This book is a dramatic update and revision of the author�s previous best-seller on SQL Server 2000. It gives sound guidance to DBAs and system administrators on how to really get the job done.

• This book provides comprehensive, clear, detailed coverage of all major availability issues.
• The author covers both availability and performance, from the perspective of high availability.
• The book addresses the crucial needs of enterprise-class, 24?7 SQL Server 2005 implementations.
• You�ll gain insight that other SQL Server documentation and whitepapers don�t provide.

About the Author
Allan Hirt is a systems engineer for Avanade, specializing in projects on Microsoft enterprise platforms. Prior to that he worked for Microsoft. He was the primary author of SQL Server 2000 High Availability (Microsoft Press, 2003) as well as a writer and contributor to various whitepapers and training materials about SQL Server for Microsoft. He is a frequent instructor on various DBA topics and presents regularly at Tech Ed, SQL PASS, and other conferences.

Download:

http://w15.easy-share.com/11115011.html

• Paperback: 629 pages
• Publisher: Wrox; 1 edition (August 13, 2007)
• Language: English
• ISBN-10: 0471753610

With this comprehensive resource, you�ll uncover the ins-and-outs of installing, configuring, and running the Apache Tomcat server. This book not only provides a line-by-line analysis of configuration options, but also explores the features and capabilities of Tomcat. You�ll then gain the skills to solve the type of problems that arise during all phases of system administration, including shared hosting, security, system testing, and performance testing and tuning.

Focusing exclusively on Tomcat 6, the book takes you through all of the latest architectural and performance changes. You�ll progress from basic Tomcat and web application configuration to more advanced techniques for clustering, JDBC connectivity, logging, and much more. All of this will help you effectively manage and administer your Tomcat deployment.

What you will learn from this book

• How to install the JVM and Tomcat on Windows and Unix/Linux systems
• Steps for packaging and deploying web applications
• Configuring Tomcat�s internal HTTP protocol stack, including the new APR and NIO Connectors
• Deploying Tomcat with the Apache Web server or Microsoft IIS as the front-end Web servers
• Load balancing and clustering a farm of Tomcat servers
• Ways to install Tomcat in virtual hosting situations
• How to load test web applications deployed in Tomcat
• Monitoring Tomcat servers in real-time by tapping into internally maintained statistics
• Techniques for providing scalability and high availability to web applications
• Performance tips and best practices for Tomcat 6

Who this book is for

This book is for J2EE system administrators and Java developers who are responsible for Tomcat configuration, performance tuning, system security, or deployment architecture.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Download:

http://w15.easy-share.com/8182511.html

• Paperback: 396 pages
• Publisher: Apress (April 24, 2007)
• Language: English
• ISBN-10: 1590598342

Just as every business needs to effectively employ Business Intelligence (BI) to stay competitive, every IT professional needs to master BI to stay employed in this fastest-growing segment of Information Technology. Foundations of SQL Server 2005 Business Intelligence is the quickest path to understanding BI, and it is essential reading for all who work with SQL Server 2005. It is written from a practical perspective, perfect for anyone who uses the tools in SQL Server 2005�s extraordinarily rich BI product suite.

This book explains how best to use Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Data Mining. It also describes best practices for implementing end-to-end BI solutions in small, medium, and large business environments. And it provides important information about integrating BI with various client tools, including Excel, Business Scorecards, Proclarity, and SharePoint Portal Server. Developers, end users, and even managers will find this an enlightening guide to the power and promise of SQL Server 2005 BI. Highlights include the following:

• Comprehensive coverage of all aspects of the SQL Server 2005 BI tool suite
• Concise, yet thorough, so you can use all BI tools effectively
• Special focus on features to use�and avoid�to cleanly scale BI solutions
• Full of sound, practical guidance on real-world best practices
• Essential reading for developers and users with any level of BI experience

About the Author
Lynn Langit is the founder and lead architect of WebFluent, which for the past six years has trained users and developers in building BI solutions. A holder of numerous Microsoft certifications, including MCT, MCITP, MCDBA, MCSD.NET, MCSE, and MSF, she also has ten years� experience in business management. This unique background makes her particularly qualified to share her expertise in developing successful real-world BI solutions using SQL Server 2005.

Download:

http://w14.easy-share.com/6416021.html

• Paperback: 592 pages
• Publisher: Addison-Wesley Professional; 1st edition (March 4, 2000)
• Language: English
• ISBN-10: 0201615762

This is a coder�s book. It�s intended to help developers build applications that make use of Transact-SQL. It�s not about database administration or design. It�s not about end-user or GUI application development. It�s not even about server or database performance tuning. It�s about developing the best Transact-SQL code possible, regardless of the application.

When I began writing this book, I had these design goals in mind:

Be very generous with code samples�don�t just tell readers how to do something, show them. Include complete code samples within the chapter texts so that the book can be read through without requiring a computer or CD-ROM. Use modern coding techniques, with specific emphases on ANSI compliance and current version features and enhancements. Construct chapters so that they�re self-contained�so that they rely as little as possible on objects created in other chapters. Provide real-world code samples that have intrinsic value apart from the book. Avoid rehashing what�s already covered extensively in the SQL Server Books Online. Highlight aspects of Transact-SQL that differentiate it from other SQL dialects; don�t just write another ANSI SQL book. Avoid excessive screenshots and other types of filler mechanisms often seen in computer books. Proceed from the simple to the complex within each chapter and throughout the book. Provide an easygoing, relaxed commentary with a de-emphasis on formality. Be the reader�s indulgent, amiable tutor. Attempt to communicate in writing the way that people speak.

You�ll have to judge for yourself whether these goals have been met, but my hope is that, regardless of the degree of success, the effort will at least be evident. About the Sample Databases

This book uses SQL Server�s Northwind and pubs sample databases extensively. You�ll nearly always be able to determine which database a particular example uses from the surrounding commentary or from the code itself. The pubs database is used more often than Northwind, so, when it�s not otherwise specified or when in doubt, use pubs.

Usually, modifications to these databases are made within transactions so that they can be reversed; however, for safety�s sake, you should probably drop and recreate them after each chapter in which they�re modified. The scripts to rebuild them (instnwnd.sql and instpubs.sql) can be found in the \Install subdirectory under the root SQL Server folder. Results Abridged

If I have a pet peeve about computer books, it�s the shameless use of space-filling devices to lengthen them�the dirty little secret of the computer publishing industry. Many technical books these days overflow with gratuitous helpings of screenshots, charts, diagrams, outlines, sidebars, icons, line art, etc. There are people who assign more value to a book that�s heavy, and many authors and publishers have been all too happy to accommodate them. They seem to take the old saying that �a picture is worth a thousand words� literally�in some cases turning out books that are little more than picture books.

I think there�s a point at which comprehensiveness gives way to corpulence, a time when exhaustiveness becomes exhausting. In this book, I�ve tried to strike a balance between being thorough and being space-efficient. To that end, I�ve often truncated or clipped query result sets, especially those too wide to fit on a page and those of excessive length (I always point this out). On occasion I also list them using reduced font sizes. I don�t include screenshots unless doing so benefits the discussion at hand materially (only one chapter contains any screenshots). This is in keeping with my design goal of being complete without being overwrought. Nearly 600 SQL scripts are used in this book, and they are all included in the chapters that reference them. Hopefully none of the abridgements will detract from the book�s overall usefulness or value. On Formality

Another of my pet peeves is formality for the sake of formality. An artist once observed that �it�s harder to draw a good curved line than a straight one.� What he meant was that it�s in some ways more difficult to do something well for which there is no exact or stringent standard than to do something that�s governed by explicit rules and stuffy precedents. All you have to do to draw a straight line is pick up a straightedge. The rules that govern formal writing, particularly that of the academic variety, make writing certain kinds of books easier because they convert much of the subjective nature of writing into something more objective. They�re like training wheels on the would-be author�s bicycle. Writing goes from being a creative process to a mechanical one. Cross all the T�s, dot all the I�s, and you�re halfway there. Obviously, this relieves the author of many of the decisions that shape creative writing. It also turns otherwise good pieces of work into dreary, textbook-like dissertations that are about as interesting as the telephone book White Pages.

So, I reject the notion that formal writing is better writing, that it is a higher standard and is the ideal for which all technical writers should strive. Instead, I come from the Mark Twain school of thought�I �eschew surplusage��and I believe that, so long as common methods of speech do not become overly banal (a subjective distinction, I freely admit), the ultimate goal of the technical writer should be to write the way that readers speak. It is the way people�even technical people�are most accustomed to communicating and the way they are the most able to learn and share ideas. I did not invent this way of thinking; it�s simply the way most of my favorite authors�Mark Twain, Dean Koontz, Joe Celko, Ernest Hemingway, Robert Heinlein, Andrew Miller, Oscar Wilde, P. J. O�Rourke, Patricia O�Connor�write. Though it is far more difficult to structure and write a narrative that flows naturally and reads easily, it�s worth the effort if the ideas the writer seeks to convey are understood as they were intended.

So, throughout this book, you�ll see a number of the rules and pseudo rules of formal writing stretched, skirted, bent, and sometimes outright broken. This is intentional. Sometimes I split infinitives, begin sentences with conjunctions, and end them with prepositions. Sometimes record is used interchangeably with row; sometimes field takes the place of column; and I never, ever treat data as a plural word. I saw some software recently that displayed a message to the effect �the data are being loaded,� and I literally laughed out loud. The distinction between the plural data and its obscure singular form datum is not maintained in spoken language and hasn�t really ever been (except, perhaps, in ancient Rome). It has also been deprecated by numerous writing guides and many authors. You will have to look very hard for an author who treats data as a plural word (I can think of only one off the top of my head, the irascible Ted Codd). The tendency for technical communication to become self-important or ostentatious has always baffled me: why stoop to pretension? Why trade the fluid conveyance of ideas between people for nonsense that confuses some and reads like petty one-upmanship to others? Acknowledgments

I�d like to thank my wife, who not only makes it possible for me to write books but also makes it worthwhile. The book you see before you is as much hers as it is mine. I�d like to thank Neil Coy, who made a real programmer of me many years ago. Under Neil�s tutelage, I learned software craftsmanship from a master. Joe Celko, the dean of the SQL language, has been a good friend and a valuable source of information throughout this project. Kudos to John Sarapata and Thomas Holaday for helping me come up with a title for the book (I�ll keep Sybase for Dummies in mind for future use, John). Thanks to the book�s technical reviewers, particularly Wayne Snyder, Gianluca Hotz, Paul Olivieri, and Ron Talmage. Heartfelt thanks to John Gmuender, Joe Gallagher, Mike Massing, and Danny Thorpe for their equanimity and for keeping me sane through the recent storm. Congratulations and genuine appreciation to the superb team at Addison-Wesley�Michael Slaughter, Marisa Meltzer, J. Carter Shanklin, and others too numerous to list. Special thanks to Nancy Cara-Sager, a friend, technical reviewer, and copyeditor who�s been with me through several books and a couple of publishers now. Her tireless attention to detail has saved me from embarrassing myself more times than I can count.

Download:

http://w16.easy-share.com/1700607500.html

• Paperback: 967 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (July 30, 2007)
• Language: English
• ISBN-10: 0072263059

Maintain a High-Performance Oracle Database 10g Environment

Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle�s new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You�ll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

�Rich does it again with a book that teaches to multiple levels in a bold and inspiring way.� �Ari Kaplan, President, Independent Oracle Users Group

�There is no doubt about Rich�s grasp on Oracle tuning and the way he simplifies intricate details in it.� �Muhammad Shuja Uddin, Vice President and Head of Technical Support, Ora-Tech Systems; President, Pakistan Oracle Users Group

�Rich Niemiec is THE expert on Oracle tuning. This book is a �must have� for every Oracle DBA�s bookshelf�there is something for everyone to learn. It is an excellent reference that proves useful over and over again.� �Kimberly Floss, Manager, Database Services, PepsiCo; Former President, Independent Oracle Users Group

�Any book with Rich Niemiec as the author is a �must buy.� The man knows Oracle inside and out.� �Karen Brownfield, Board of Directors, Oracle Applications Users Group

Download:

http://w16.easy-share.com/1700600088.html

• Hardcover: 1232 pages
• Publisher: CRC; 1 edition (September 30, 2003)
• Language: English
• ISBN-10: 084937006X

Technology has spurred the growth of huge image and video libraries, many growing into the hundreds of terabytes. As a result there is a great demand among organizations for the design of databases that can effectively support the storage, search, retrieval, and transmission of video data. Engineers and researchers in the field demand a comprehensive reference that will help them design and implement the most complex video database projects. Handbook of Video Databases: Design and Applications presents a thorough overview in 45 chapters from more than 100 renowned experts in the field. This book provides the tools to help overcome the problems of storage, cataloging, and retrieval, by exploring content standardization and other content classification and analysis methods. The challenge of these complex problems make this book a must-have for video database practitioners in the fields of image and video processing, computer vision, multimedia systems, data mining, and many other diverse disciplines.

Download:

http://w17.easy-share.com/1700600628.html

• Hardcover: 751 pages
• Publisher: Mcgraw-Hill College; 2 Sub edition (March 1983)
• Language: English
• ISBN-10: 0070701326

Download:

http://w13.easy-share.com/1700599595.html

• Paperback: 1024 pages
• Publisher: Addison Wesley; 8 edition (September 30, 2003)
• Language: English
• ISBN-10: 0321189566

The newest edition of the classic An Introduction to Database Systems incorporates the latest developments in relational databases, including semantic modeling, decision support, and temporal modeling. There�s better information on distributed databases, security, and the mathematics of relational databases too. With the same strong coverage of fundamental theory that made its predecessors stand out, this book ranks as the definitive textbook for those studying database systems.

This is an extraordinarily academic book. In his preface, C.J. Date goes so far as to lament having to use Structured Query Language (SQL) in some of his examples because it�s �so far from being a true embodiment of relational principles.� What�s more, he writes in a very academic style, peppering his heavily footnoted prose with mathematical expressions and words like relevar and tuple. The academic style and highbrow language isn�t a bad thing, since this book deals with complicated, largely abstract phenomena in depth.

Be aware that An Introduction to Database Systems is a far cry from the highly graphical, problem-focused books that target the community of commercial database developers, and as such requires more careful study. This book is about theories, concepts, and ideals rather than problems, solutions, and specific implementations. Per se, it will enable you to become a better database programmer�but only if you supplement it with practical guides and hands-on experience.

Download:

http://w17.easy-share.com/1700589347.html

• Hardcover: 632 pages
• Publisher: Wiley (November 28, 2005)
• Language: English
• ISBN-10: 047177183X

Covers the administration of all operating systems, data and network security, new trends in storage options, and server, network, and storage management Thoroughly explores each topic, with attention to various network and system design options, best practices, potential problems, and leading solutions Discusses how to build resiliency into the network, servers, and storage to prevent service outages despite hardware or software failures Includes plenty of real-world examples that illustrate objectives, problems, and solutions, along with a complete best practices section for every topic Shows administrators how to ensure close to 100 percent service uptime with various high-availability options such as redundancy and clustering; how to deal with server and storage proliferation, and how to manage separate networks for voice, IP, and storage

Download:

http://w13.easy-share.com/1700599275.html

• Paperback: 432 pages
• Publisher: Syngress (August 15, 2007)
• Language: English
• ISBN-10: 1597491985

This is the only practical, hands-on guide available to database administrators to secure their Oracle databases. This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database. The books companion Web site contains dozens of working scripts that DBAs can use to secure and automate their Oracle databases.

* The only practical, hands-on guide for securing your Oracle database published by independent experts.
* Companion Web site contains dozens of scripts to help you automate security tasks.
* Your Oracle database does not exist in a vacuum, so this book shows you how to securely integrate your database into your enterprise.

Download:

http://w16.easy-share.com/1700503134.html

• Paperback: 432 pages
• Publisher: Syngress (August 15, 2007)
• Language: English
• ISBN-10: 1597491985

This is the only practical, hands-on guide available to database administrators to secure their Oracle databases. This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database. The books companion Web site contains dozens of working scripts that DBAs can use to secure and automate their Oracle databases.

* The only practical, hands-on guide for securing your Oracle database published by independent experts.
* Companion Web site contains dozens of scripts to help you automate security tasks.
* Your Oracle database does not exist in a vacuum, so this book shows you how to securely integrate your database into your enterprise.

Download:

http://w16.easy-share.com/1700289432.html

• Paperback: 152 pages
• Publisher: Kogan Page; 2nd ed. edition (April 10, 2007)
• Language: English
• ISBN-10: 0749448342

In this day of increased pressure to achieve results, time management has become a vital skill. With time-saving solutions, checklists, tips and techniques, �Successful Time Management� helps review and assess time management techniques and shows how to adopt new work practices to make effective use of time. It includes great advice on controlling paperwork, getting and staying organized, delegating and working with others, prioritizing to focus on key issues and realizing the best results. The appendices include a brief assessment of various time management systems such as day, year or meeting planners, action sheets and more. This guide will help readers reduce time-wasting interruptions and focus on the priority tasks that lead to success. Includes new material on email usage

Download:

http://w13.easy-share.com/1700079193.html

• Paperback: 240 pages
• Publisher: Apress (April 9, 2008)
• Language: English
• ISBN-10: 1590599438

Clare Churcher�s Beginning SQL Queries is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare lays well in her book.

• Does not bore with syntax!
• Helps you learn the underlying concepts involved in querying a database, and from there the syntax is easy
• Provides exceptionally clear examples and explanations
• Is academically sound while being practical and approachable

What you�ll learn

• Write simple queries to extract data from a single table.
• Understand relational algebra and calculus and why they are important.
• Combine data from many tables into one business result.
• Avoid pitfalls and traps such as Cartesian products and difficulties with null values.
• Summarize large amounts of data for reporting purposes.
• Apply set theory to the problems of manipulating data and generating reports.

Who is this book for?

Beginning SQL Queries is aimed at intelligent laypeople who need to extract information from a database, and at developers and other IT people who are new to SQL. The book is especially useful for business intelligence analysts who must ask more complex questions of their database than their GUI�based reporting software supports. Such people might be business owners wanting to target specific customers, scientists and students needing to extract subsets of their research data, or end users wanting to make the best use of databases for their clubs and societies.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry�level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from �novice to professional.� You�ll start your journey by seeing what you need to know�but without needless theory and filler. You�ll build your skill set by learning how to put together real�world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there�it is your trusted guide through unfamiliar territory!

Related Titles

• Beginning Database Design: From Novice to Professional
• Date on Database: Writings 2000-2006
• Applied Mathematics for Database Professionals

About the Author
Clare Churcher holds a Ph.D. in physics and has designed several databases for a variety of large and small projects. She is currently the head of the applied computing group at Lincoln University where her teaching has included analysis and design, database, and programming. She has supervised over 70 undergraduate projects designing databases for small projects.

Download:

http://w16.easy-share.com/1700289344.html

• Paperback: 670 pages
• Publisher: Apress (August 20, 2007)
• Language: English
• ISBN-10: 1590598512

It�s sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database.

There�s much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organizations most critical data falls squarely upon your shoulders:

• Lose that data and your company could fail.
• Lose that data and you could be out of a job.

Scared? You should be. But theres help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracles backup and recovery tool of choice. RMAN Recipes for Oracle Database 11g helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide

• Demystifies the steps required to protect your business data
• Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations
• Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems
• Respects your time by providing example-based solutions, not endless reading material

When the pressure�s on, you dont have time for long discussions of theory. This book gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.

What you�ll learn

Who is this book for?

Related Titles

About the Author

Darl Kuhn, an Oracle DBA and software developer with 18 years of experience, is a senior DBA with Sun Microsystems. Before joining Sun, his work as a consultant ranged from database administration to custom application development. Darl is a coauthor of Oracle RMAN Pocket Reference and has written several articles for Oracle Magazine. He is an affiliate professor at Regis University where he teaches Oracle courses for the graduate department of computer information technology. For the past 9 years, Darl has served as a volunteer DBA and developer for the Rocky Mountain Oracle Users Group. Darl has an MBA from Colorado State University and currently lives in Littleton, Colorado.
Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle OCP DBA and the Hewlett-Packard UNIX System Administrator certifications. He currently manages Oracle databases at the Boy Scouts of America National Headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid 1980s. He is also well versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.
Arup Nanda has been an Oracle DBA since 1993, which has exposed him to all facets of database administration&emdash;from modeling to disaster recovery. He currently leads the global DBA team at Starwood Hotels, the parent of chains such as Sheraton and Westin, in White Plains, NY. He serves as a contributing editor of SELECT Journal, the publication of Independent Oracle Users Group (IOUG); speaks at many Oracle Technology&emdash;related events such as Oracle World and local user groups such as New York Oracle User Group; and has written many articles for both print publications such as Oracle Magazine and online publications such as Oracle Technology Network. Arup has coauthored two books: Oracle Privacy Security Auditing (Rampant, 2003) and Oracle PL/SQL for DBAs (O�Reilly, 2005). Recognizing his professional accomplishments and contributions to user community, Oracle chose him as the �DBA of the Year� in 2003. He lives in Danbury, Connecticut, with his wife Anindita and son Anish. He can be reached at arup@proligence.com.

Download:

http://w13.easy-share.com/1700289151.html

• Paperback: 688 pages
• Publisher: Wrox; Pap/Onl edition (November 5, 2007)
• Language: English
• ISBN-10: 0470174021

Expert Access 2007 Programming

As the most popular database system in the world, Microsoft Access is used by millions of people and supported by hundreds of thousands of Access developers. The 2007 version marks the largest release of Access in five years. Written by design engineers on the Access test team at Microsoft, this book introduces you to the many new features of Access 2007 and shows you innovative ways of looking at old problems such as automation, debugging, and deployment.

The authors break down the book into four parts�programming Access applications, data manipulation, interacting with the application, and finalizing the application�in order to walk you through the important steps of creating a full-featured application. They also provide you with in-depth examples that require only minor modifications and then can be easily implemented in the real world. You�ll quickly learn how the 2007 version makes it simpler to write quality Access applications with XML, C#, and other .NET languages that are actually fun to write, feature rich, and easy to use.

What you will learn from this book

• The basics of working with managed code, particularly C# and VB.NET
• How to create different types of forms and customize navigation solutions for forms
• The advantages of developing databases for a global marketplace
• Various techniques that can simplify the development process and provide consistency across multiple applications
• How to use Report view to create compelling scenarios for users such as sorting and filtering
• Ways to find, view, categorize, and interact with data

Who this book is for
This book is for experienced Access application developers who use VBA and SQL. Familiarity with Access 2007 is helpful but not required.

Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.

Download:

http://w13.easy-share.com/1700286535.html

Note: These tutorials were built using modo 203; all techniques and tools used are able to be transfered into the 301 environment.

How to Fold is a unique step-by-step manual, containing hundreds of great folding ideas and ready-to-use designs. This book is an essential tool for anyone involved in the fields of graphic and industrial design, advertising and printing. All patterns are stored in eps vector format on the enclosed CD-ROMs. They may be used freely to create new designs, and can be scaled and modified to suit any conceivable purpose.

Creating Digital Humans 1-4

Kurv Studios - LightWave 3D 9 Foundations of Character Animation
Timothy Albee is very well known in the visual effects industry for his studio work as well as his 7 best selling books (books on amazon here).

Kurv Studios - LightWave 3D 9.x Introduction to Hypervoxels
This video is another in Larry's arsenal of LightWave 3D training. This video done entirely in LightWave 3D 9.2 covers how to create awesome visual effetcs with Hypervoxels.

Larry asked us to call this video an Introduction to Hypervoxels but many would consider this 3+ hour training video much more than an introduction. this video goes into blending Hypervoxels into video or a photograph, creating flames, and adding Hypervoxels to surfaces.

Larry explains the in's and outs of Hypervoxels while showing you different ways to adjust your renders.

This video is a total of 4+ hours long and is designed for beginner to intermediate lightwave 3D 9.x users.

[imghttp://img338.imageshack.us/img338/338/220hypervoxelstc6.jpg[/img]


http://www.kurvstudios.com/lightwave/lightwave3d-9-introduction_hypervoxels.php

http://rapidshare.com/files/82452693/Kurv_Studios_-_LightWave_3D_9.x_Introduction_to_Hypervoxels.part4.rar
http://rapidshare.com/files/82452130/Kurv_Studios_-_LightWave_3D_9.x_Introduction_to_Hypervoxels.part3.rar
http://rapidshare.com/files/82448190/Kurv_Studios_-_LightWave_3D_9.x_Introduction_to_Hypervoxels.part2.rar
http://rapidshare.com/files/82433022/Kurv_Studios_-_LightWave_3D_9.x_Introduction_to_Hypervoxels.part1.rar