SQL Server e-Books Download

You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL:1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product.

SQL Server 2005 Express is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (nonenterprise) features from SQL Server 2005, and comes complete with development and administration tools. As such, it is an ideal database for developers and administrators to use in prototype/evaluation projects.

SQL Server 2005 is the biggest change to SQL Server in many years, and the first revision at all in five years. Yet almost all of the books written or announced on SQL Server 2005 either are written for developers, or try to cover material for both developers and admins. This will be one of the first, and one of the only, books written specifically for database and systems administrators.

SQL Server 2005 will increase your programming options, productivity, analysis, and database management. If you have some basic knowledge of relational databases and want to start a career as a developer using SQL Server, then this book is your ideal first step. It explains the core jobs and roles for developing a database in both SQL Server 2000 and 2005.

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release

Beginning Transact-SQL with SQL Server 2000 and 2005 Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases.

Microsoft recently announced its .NET Enterprise Server line abd its commitment to .NET as Microsoft's application architecture model. SQL Server 2000 is the first .NET Enterprise Server available and it offers the data storage and management component of the .NET line.

|Next|

SQL Server e-Books Download

Guru's Guide to SQL Server Stored Procedures, XML, and HTML

Books in the Microsoft Windows Server System Series are written and reviewed by the world's leading technical authorities on Microsoft Windows Technologies, including principal members of Microsoft's Windows and Server Development Teams. The goal of the series is to provide reliable information that enables administrators, developers, and IT professionals to architect, build, deploy, and manage solutions using the Microsoft Windows Server System.

This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.

To help you design Microsoft database servers that must achieve the best possible performance, Inside Microsoft SQL Server 2000 has the details you need. For one thing, author Kalen Delaney explains how SQL Server 2000 works at a level that will interest all database administrators.

This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine.

A comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced querying techniques using Transact-SQL (T-SQL), the database programming language built into SQL Server.

SQL Server has always distinguished itself by, among other things, its management tools. One of the earliest design principles for the team was "It just works." We accomplished this by replacing the usual database knobs and levers with intelligent defaults and adaptive behavior.

Improve functionality and develop robust SQL Server applications with confidence using this collection of pre-written solutions. Best-selling programming author Greg Buczek brings you the most authoritative and useful collection of expert techniques and ready-to-use applications available

|Next|Prev|

SQL Server e-Books Download

Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.

Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS)—and begin writing your own data movement applications—one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse.

Teach yourself how to use the new, integrated reporting capabilities in SQL Server—one step at a time! This practical, hands-on guide expertly builds your expertise with the concepts and architecture of SQL Server Reporting Services—including Report Definition Language, Report Designer, Report Server, and the programming model.

This comprehensive administrator's reference delivers the details you need to successfully plan, deploy, administer, and support Microsoft SQL Server 2005. The authors - experts in database technologies - provide easy-to-follow procedures, practical workarounds, and key troubleshooting tactics for everyday, on-the-job results.

Your hands-on guide to learning Microsoft SQL Server Analysis Services, Microsoft’s customizable analysis solution for business data modeling and interpretation. Analysis Services is a powerful tool for business intelligence, so understanding the essentials—how to create a cube, as well as how to deploy, customize, and extend the basic calculations—is critical to harnessing the full benefits of SQL Server.

Your hands-on guide to learning Microsoft SQL Server Reporting Services, Microsoft’s customizable reporting solution for business data analysis. Reporting Services is a powerful tool for business intelligence, so an understanding of the essentials—how to architect a report, as well as how to install and program Reporting Services—is key to harnessing the full benefits of SQL Server.

SQL Server 2005 is Microsofts next-generation data management and analysis solution that delivers increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage. This is a skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005.

The popular, learn-by-doing tutorialupdated for SQL Server 2005. Teach yourself the fundamental techniques for designing, building, testing, and deploying SQL Server databases one step at a time.

|Prev|

Oracle e-Books Downloads

Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions.

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle.

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

This is the only real Oracle9i database administration book in the market! This 1,000 page book enables a beginner or intermediate level Oracle DBA or Oracle developer/manager to master the art of building and managing complex Oracle9i databases.

Walks through the process of transforming a Windows NT or 2000 server into an Oracle 8i or 9i database server. The guide demonstrates how to install and define the Oracle database software, create a basic security schema, formalize the database backup plan, add client PCs, normalize the data, design the GUI forms, and produce reports. The CD-ROM contains code sample and scripts.

Teaches how table design techniques can be used to maximize Oracle performance. Exposes the internal mechanisms of Oracle. Provides pretested performance scripts to get immediate performance information. Offers expert advice on interpreting Oracle performance information. Shows how to quickly implement performance and tuning data collection without buying expensive tools.

|Next|

Oracle e-Books Downloads

Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"-- that is, how to fine-tune the Oracle database for its greatest processing efficiency.

Few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that. The authors cover the full range of Oracle SQL features that apply to query writing. Learn to write UNION queries that take full advantage of SQL's set orientation, and ways to use Oracle's new analytic SQL features to write ranking queries, lag and lead queries, and more.

SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples.You will gain full competence to define, access, and manipulate data in an Oracle database.

Complete coverage of the exam objectives, hands-on exercises, review questions, and more, this is the first and only book to offer such in-depth coverage of this challenging exam

Oracle Oracle Database 10g. Written by people on the Oracle development team that designed and implemented the code and by people with industry experience implementing warehouses using Oracle technology, this thoroughly updated and extended edition provides an insiders view of how the Oracle Database 10g software is best used for your application.

Oracle databases have long handled the publicly invisible task of managing large corporate data stores. With the release of Oracle 9iAS Portal, the company has made it much easier to securely share the contents of data warehouses with appropriate audiences.

From the exclusive publisher of Oracle Press books, here is an architectural and technical reference on how to use Oracle Application Server 10g to Web-enable Oracle databases for application server systems. You’ll find coverage of installation, configuration, and tuning, using Java with Oracle Application Server 10g, and much more.

Oracle Application Server 10g: J2EE Deployment and Administration focuses on the latest version of Oracle's fully J2EE-certified application server (previously called Oracle9iAS). Oracle Corp. is aggressively attacking this market with a new lost-cost version of the server, as well as a program to move BEA customers onto Oracle free of charge.

|Next|Prev|

Oracle e-Books Downloads

Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux servers--all in an easy reading and quick-to-navigate format.

Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools Data warehouses are the core technology that businesses use to capture, store, and analyze vast amounts of business data, and Oracle has emerged as the leading database platform. Its business intelligence tools make it considerably easier to analyze data to support marketing, sales, and other initiatives. Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools.

Attain real solutions for current availability challenges. Based on a “DBA-centric” approach to High Availability, Oracle Database 10g High Availability concentrates on explaining Oracle Database 10g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery, and distributed database solutions.

Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database.

Comprehensive book instructs how to write Structured Query Language statements to access an Oracle database and use Procedural Language/SQL to write programs containing SQL statements. Explains how to use the latest Oracle Database 10g features and more.

Two new Oracle instruction and resource titles from Osborne/McGraw-Hill are indispensable additions to personal and professional reference collections.

Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracle's XML-enabled products. Includes real-world case studies based on the authors' experience managing Oracle's XML Discussion Forum--a community of 20,000 XML component users.

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL.

|Next|Prev|

Oracle e-Books Downloads

The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor.

Automate Oracle—and save your time for more important tasks! This is the Oracle automation reference every working Oracle DBA needs...concise, straightforward, and incredibly easy to use.

If you're a working Oracle DBA, here's the Oracle SQL reference you've been searching for—simple, straightforward, and incredibly easy to use! There's no faster way to discover the exact syntax you need...refresh your memory about that option you haven't used lately...find the name of that view you know exists...start using that new Oracle 9i feature you haven't tried yet. Keep it by your desk, near your server...wherever you need fast, reliable answers right this minute!

Oracle Developer Forms Techniques describes the concepts and techniques needed to build Web-enabled applications with Forms. The book covers advanced topics in great detail, including understanding and overcoming error handling limitations in Forms, such as errors which cannot be tracked through normal FORM_SUCCESS or FORM_FAILURE, ordering by items based on FK look-ups, obtaining Query Count without actually executing a query, and performing an exclusive server-side commit from Forms.

An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals. O'Reilly's Oracle Essentials claims a unique place among these books. Rather than focusing on one area, the book explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it.

Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures.

If you are a typical Oracle professional, you don't have the luxury of time to keep up with new technology and read all the new manuals to understand each new feature of the latest release from Oracle. You need a comprehensive source of information and in-depth tips and techniques for using the new technology.

Oracle DBAs finally have a definitive guide to every aspect of designing, constructing, tuning, and maintaining star schema data warehouses with Oracle 8i and 9i. Bert Scalzo, one of the world's leading Oracle data warehousing experts, offers practical, hard-won lessons and breakthrough techniques for maximizing performance, flexibility, and manageability in any production environment.

|Next|Prev|

Oracle e-Books Downloads

Oracle's PL/SQL language is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools. Among the most useful constructs in the PL/SQL language are the built-in functions and packages.

PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur.

Clustered configuration first hit the scene nearly 20 years ago when Digital Equipment Corporation (DEC) introduced the VaxCluster. Until now, the topic of Real Application Clusters (RAC) implementation had never been fully explored. For the first time, Murali Vallath dissects RAC mysteries in his book Oracle Real Application Clusters to enlighten and educate readers on the internals of RAC operations, cache fusion, fusion recovery processes and the fast reconfiguration of RAC.

Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level.

Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery Manager for database backup and recovery. Because Recovery Manager (RMAN) is a relatively new tool, many DBAs are just becoming familiar with it. They will welcome a timely book that explains clearly and concisely how to use RMAN for common backup and recovery tasks that are infrequent, yet extremely vital. The first portion of the book is primarily task-oriented.

Security in a relational database management system is complex, and too few DBAs, system administrators, managers, and developers understand how Oracle implements system and database security. This book gives you the guidance you need to protect your databases.

SQL*Loader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQL*Loader is to load data from flat files into an Oracle database

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions.

|Prev|

Design and content guidelines

• Make a site with a clear hierarchy and text links. Every page should be reachable from at least one static text link.
• Offer a site map to your users with links that point to the important parts of your site. If the site map is larger than 100 or so links, you may want to break the site map into separate pages.
• Create a useful, information-rich site, and write pages that clearly and accurately describe your content.
• Think about the words users would type to find your pages, and make sure that your site actually includes those words within it.
• Try to use text instead of images to display important names, content, or links. The Google crawler doesn't recognize text contained in images.
• Make sure that your TITLE and ALT tags are descriptive and accurate.
• Check for broken links and correct HTML.
• If you decide to use dynamic pages (i.e., the URL contains a "?" character), be aware that not every search engine spider crawls dynamic pages as well as static pages. It helps to keep the parameters short and the number of them few.
• Keep the links on a given page to a reasonable number (fewer than 100).

Microsoft wins in second Alcatel-Lucent patent suit

A week after Microsoft was ordered to hand over $1.5 billion in an Alcatel-Lucent MP3 patent dispute, a federal judge has ruled that the Windows maker did not violate a patent at the heart of a second trial that was set to begin soon. more.....


Multicore move cuts Oracle database cost

In a move designed to counter Microsoft's growing database influence, Oracle has quietly cut software prices on some lower-end servers using multicore processors, CNET News.com has learned. more...



Woman accuses Yahoo of stealing her image

An Ohio woman is demanding $20 million from Yahoo for allegedly using a photo of her without her permission for a welcome e-mail sent to new users. more...

Achieving Software Quality through Teamwork

Successful software depends not only on technical excellence but on how members of the software team work together. Written in easy to understand language by a leading expert in the field, this ground-breaking volume provides an overview of the team culture required to develop quality software.

Business Rules Applied: Building Better Systems Using the Business Rules Approach

A step-by-step tutorial on how to execute the business rules approach from planning through implementation The business rules approach to application development represents a major evolution in software engineering and promises to be the most practical and desirable way to build systems.

Crackproof Your Software: Protect Your Software Against Crackers

This software protection guide describes the various ways crackers break registration keys, circumvent original CD checks, disable time limitations, and otherwise neutralize software protections.

Essential Business Process Modeling

Ten years ago, groupware bundled with email and calendar applications helped track the flow of work from person to person within an organization

Herding Chickens: Innovative Techniques for Project Management

Project Management skills are in high demand, as businesses
worldwide recognize the key role project managers play in their operations. Membership in PMI, the leading Project Management organization, has increased dramatically in recent years, with current membership now exceeding 130,000.

• Node


• ezMySQL


• List content of directory


• Pablosky MySQL


• RImageManipulator


• MySQL Pagination


• HTTP Locale


• MySQL DB Class with Data Manipulation Class


• TimeTaMeR


• Easy PHP Validation


• Filtreatment


• Image to ASCII text


• KDoubleMetaphone


• Geo Conversion