SQL Server 2008 is a first-rate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corporate data warehouses to ad hoc departmental databases. You'll find enhanced support for XML, new support for spatial data, transparent data encryption, a policy-based management system, and more. Author and developer Robin Dewson will show you the way from beginner to SQL Server 2008 professional. Learn to install SQL Server 2008 and navigate around Management Studio before getting right to the heart of mastering fundamental SQL Server 2008 tasks: creating tables, storing data, securing data, and retrieving it again. Dewson ensures you'll be fully prepared to use all the basics and create a solid foundation for your own projects. Don't forget about backups Your database will house important data, so backing up is essential to protect yourself from inevitable hardware failure. Dewson walks you through SQL Server 2008's easy-to-use backup and recovery feature set, giving you the grounding that you need in order to set up a reliable plan for recovery in your own environment. Learn to use Transact-SQL, a full-blown procedural language that is built right into the database system. Transact-SQL is the key to unlocking everything that SQL Server 2008 has to offer. Using Transact-SQL, you can write centrally encapsulated business logic through the use of stored procedures, automatically trigger processing through the use of triggers, and manipulate data within the server without having tomove data back and forth across the network. Finally, you'll learn a bit about SQL Server 2008 Reporting Services, a powerful tool that allows enterprise reporting. Reporting Services enables you to develop and serve reports across your organization and even to business partners outside your company. Reporting Services also gives end users the ability to create their own reports, helping them transform business data into valuable, usable information to guide their day-to-day decisions. What you'll learn Install and manage SQL Server on your system. Create and secure tables. Store and query data; use indexes to improve query performance. Sleep when the wind blows, because you have a solid backup and recovery process. Run procedural code inside your database in the form of Transact-SQL procedures and triggers. Serve up business reports to in-house users and outside business partners via SQL Server 2008 Reporting Services. Who is this book for? Developers new to SQL Server 2008. If you are just beginning to develop software using SQL Server 2008, or if you are planning to do so in the near future, this book will set you on the road to success. 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 nextcareer 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 Applied Mathematics for Database Professionals

Service Broker is a key Microsoft product in support of message-based processing between applications. Pro SQL Server 2008 Service Broker helps you to take full advantage of this key Microsoft technology, beginning from the fundamentals, moving through installation and application development, and ultimately showing you how to develop highly available and scalable applications based upon the Service-Oriented Architecture that is fast gaining ground as the way forward in application development. Comprehensive approach to developing with Service Broker Strong focus on best practices and real-world scenarios Covers the key aspects of distributed application design What you'll learn Understand the fundamentals of message-based processing. Install Service Broker and manage the environment. Design databases for service-oriented applications. Develop distributed applications. Build in scalability and high availablity. Apply best practices to avoid future trouble. Who is this book for? Pro SQL Server 2008 Service Broker is written for new and existing users of Service Broker who wish to develop service-oriented and distributed transactions that scale well, that are resilient against failure, and that are as future-proofed as possible from the application of current best practices in Service Broker development. 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 willalways 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 T-SQL 2005 Programmer's Guide SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity.

The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter.

In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. What you'll learn Theory of relational database management systems Oracle Database internals Licensing, architecture, and sizing Software installation and database creation Using indexes to improve performance User management and data loading How to monitor all aspects of your database How to solve and fix problems Database backups and database recovery Database maintenance Database tuning SQL tuning Who this book is for

If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.

Many would argue that the single, most important job of a SQL Server database administrator is to be able to recover your database in the event of loss or damage. Pro SQL Server Disaster Recovery helps you meet that goal by showing you how to think about and plan for potential problems. You'll learn to anticipate and reduce the likelihood of a disaster, and to mitigate the effects of a disaster when one does occur. Perhaps most importantly, you'll learn how to prepare so that you can return a system to its normal state quickly, ensuring system availability and the continued success and operation of your business.

Many SQL Server features and technologies are, or can be put to good use in disaster recovery planning. In this book, you'll learn about powerful tools and features -- such as Database Snapshots and Mirroring -- for data backup and disaster recovery that are present in SQL Server 2005, and that are enhanced in SQL Server 2008. Also covered are common issues to expect when using these features. This book explores your options by examining the technical details of disaster recovery features and then applying that knowledge to practical scenarios.

There's a human side to disaster recovery planning as well. Like few other activities, disaster recovery planning requires that you work closely with a wide variety of people from all across your organization. People skills are as critical to disaster recovery planning as technical skills, and perhaps more so. This book does not leave you in the dark, but provides sound advice on how to keep disaster recovery planning projects on track, how to avoid dangerous scope creep, and how to work effectively with the variety ofpersonality types that you will encounter.

Disaster recovery planning is really about sleep. When you get the call at 3: 00 am that your database is lost, don't wake up with that icy feeling in your veins. Instead wake up with confidence that you have a plan in place, a plan that you've practiced, that management has bought into, a plan that you can execute even while half-asleep to get your database, your company, and your job back on track. What you'll learn

This book shows you how to implement an effective disaster recovery strategy for SQL Server 2005 databases. It covers: Real-world examples of data loss and what might have been done to prevent it A systematic, problem-based approach to designing a disaster recovery plan Pitfalls one might encounter, and how to deal with them Team dynamics, and the soft-side of disaster planning New technology in SQL Server 2005 and 2008 that takes disaster recovery beyond the simple backup/recovery plan When and why to use disaster recovery features, as opposed to just describing how they work
Who is this book for?

SQL Server database administrators

This book constitutes the refereed proceedings of the 5th International Workshop on Databases in Networked Information Systems, DNIS 2007, held in Aizu-Wakamatsu, Japan in October 2007. Focusing on data semantics and infrastructure for information management and interchange, the papers are organized in topical sections on geospatial decision-making, Web data management systems, infrastructure of networked information systems, and Web query and web mining systems.

Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, webenabled reports across your business at a reasonable cost. Learn bestpractices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsoft's enterpriselevel reporting platform.Provides bestpractices for using Reporting Services Written by practicing professionals with paying clients Your key to delivering business intelligence across the enterprise What you'll learn Write efficient queries on which to base a report Build and lay out a report using Report Designer Enable end users to create ad hoc reports on demand Combine Reporting Services with Analysis Services, SharePoint Portal Server, and other technologies to deliver business intelligence across the enterprise Secure and audit your reports as part of your regulatory compliance efforts Customize your reports using C# assemblies and embedded Visual Basic .NET code Who this book is for

Data analysts, developers, database administrators, and others who develop and deploy reports using Microsoft SQL Server Reporting Services.

While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high-performance, maintainable database applications. This book starts by reintroducing the database as a integral part of the software development ecosystem. You'll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can't architect and test database routines just as you would architect and test application code. And nothing should stop you from implementing the types of exception handling and security rules that are considered so important in other tiers, even if they are usually ignored in the database. You'll learn how to apply development methodologies like these to produce high-quality encryption and SQLCLR solutions. Furthermore, you'll discover how to exploit a variety of tools that SQL Server offers in order to properly use dynamic SQL and to improve concurrency in your applications. Finally, you'll become well versed in implementing spatial and temporal database designs, as well as approaching graph and hierarchy problems.

In this book, youll learn how to: Install, configure, and troubleshoot a testing environment with PHP/MySQL and Apache or IIS Learn the fundamentals of PHP and good database design Use Dreamweaver 8 server behaviors to create robust dynamic applications that validate user input for greater security and reliability Incorporate live XML feeds into your web pages with PHP and Dreamweaver 8s new XSL Transformation server behavior Download and apply a suite of custom-built PHP functions designed exclusively for this book Want to add the power of a database to your websites? Build online forms that send feedback straight to your inbox? Incorporate live news feeds and XML data into your web pages? This book shows you how to do all that and more. Dreamweaver 8 takes a lot of the hard work out of integrating a database into your websites, but it cant do everything. So instead of just giving you a series of instructions to click this and click that, this book helps you understand whats going on in the background. As a result, youre more likely to remember and to get it right. Most books on PHP concentrate on code and throw all design considerations out the window. This one is different. It makes use of Dreamweaver 8s vastly improved CSS rendering, and shows you how to build a site thats smart in both senses of the word. It looks good and is intelligent too. Youll learn how to change the entire look of the site, using PHP to serve up different stylesheets each month. Youll also build a contact form protected against email injection attacks. All of Dreamweavers PHP server behaviors are put through their paces, and youll even make some custom server behaviors that will come in useful on any site youcreate. Two chapters take you through the setup process with step-by-step instructions for both Windows and Mac OS X, helping you make the right choices: Apache or IIS? Remote or local testing? There are even instructions on how to set up virtual hosts on your own computer. And in the unlikely event that things go wrong, theres plenty of troubleshooting advice too. In this book we look specifically at using Dreamweaver's built-in server behaviors to build dynamic web sites using PHP and MySQL, the worlds most popular open source server-side language and database server combination, which are both reliable, powerful, and open source (and therefore free to use!) This latest version of Dreamweaver includes more powerful support for PHP and MySQL than ever before, and we'll show you how to make this work for you. No previous experience of PHP or MySQL is necessary to use this book. Examples built throughout the book include a content management system, and an online image gallery. All examples are designed to meet modern usability requirements and be web standards compliant. Summary of Contents: Introduction Chapter 1: So, You Want to Build Dynamic Sites? Chapter 2: Dreamweaver and PHPA Productive Partnership Chapter 3: Getting the Work Environment Ready Chapter 4: Getting Ready for the Case Study Chapter 5: Integrating PHP into Your Site Chapter 6: Getting Feedback from an Online Form Chapter 7: Putting the Power of a Database Chapter 8: Building a Random Quotation Generator Chapter 9: Working with Multiple Tables Chapter 10: Using Sessions to Track Chapter 11: Displaying a Blog and Photo Gallery Chapter 12: Using XSLT to Display Live News Feeds and XML Appendix A: Using Languages OtherThan English in MySQL Appendix B: Essential MySQL Maintenance Index

Purchase this book and you'll get the free, fully searchable eBooka $20 value! (Details are printed inside the book.)

It does a good job of covering the fundamentals and simple reporting needs. For the SSRS newcomer, it is a great place to start. -- Will Wagers, C# Online.NET

SQL Server Reporting Services (SSRS) 2005 is the latest version of the reporting technology from Microsoft. This book examines all of the technology that SSRS provides to design, author, render and deploy professional business reports to the Web or to the company intranet (in a variety of formats, from HTML to XML, PDF, or TIFF), with detailed examples at every step.

It covers all of the new functionality present in the 2005 version, including the new management and BI development studios as well as the new report viewer controls and end-user reporting tools. It also contains significantly expanded chapters on Business Intelligence along with a wealth of tips and workarounds for effective development with SSRS.

The authors are both highly experienced with SQL Server and with business reporting in the medical industry, which is subject to rigorous HIPAA regulations and strict security. It is not their intention to evangelize the product or present "idealized" examples based on the simple built-in schemas. Instead, they take a hard, critical look at the technology and provide exactly what the reader needs to know to deliver effective reports. Their code examples are based on real, complex schemas and the need to deliver versatile, dynamic reports, as well as on strict security and performance requirements.

In summary, this book will provide you with step-by-step guides, best practices, and realcode examples covering all of the common Reporting Services tasks, including: A detailed overview of the reporting architecture and tools The new Report Definition Language Standard, which is XML-based and allows you to define reports in VS.NET Building effective queries for high-performance reporting Building custom .NET applications with SSRS Rendering reports to HTML, XML, PDF and Excel Deploying secure reports, using Windows authentication through Active directory Business Intelligence reporting using SQL Server Analysis Services

Creating clear and comprehensive reporting functionality is one of the most important, and most misunderstood, tasks that developers do in professional life. The reports they generate are used by both their clients and their own managers to assess the performance of their applications and to gauge how well the application meets business objectives. This book shows how to use Visual Studio 2005 and complementary technologies, such as Crystal Reports, to quickly and simply create fast, flexible reporting for applications of any size. In this book our experienced author team shows how to create the best results as efficiently as possible.

The use of parallel processing technology in the next generation of Database Management Systems (DBMSs) makes it possible to meet new and challenging requirements. Database technology in rapidly expanding new application areas brings unique challenges such as increased functionality and efficient handling of very large heterogeneous databases.
Abdelguerfi and Wong present the latest techniques in parallel relational databases illustrating high-performance achievements in parallel database systems. The text is structured according to the overall architecture of a parallel database system presenting various techniques that may be adopted to the design of parallel database software and hardware execution environments. These techniques can directly or indirectly lead to high-performance parallel database implementation.
The book's main focus follows the authors' engineering model: A survey of parallel query optimization techniques for requests involving multi-way joins; A new technique for a join operation that can be adopted in the local optimization stage; A framework for recovery in parallel database systems using the ACTA formalism; The architectural details of NCR's new Petabyte multimedia database system; A description of the Super Database Computer (SDC-II); A case study for a shared-nothing parallel database server that analyzes and compares the effectiveness of five data placement techniques.

SQL Server 2005 Express is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (non-enterprise) 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. It is also a powerful development platform for database applications on nonprofit websites, e-commerce sites, and in small offices and departments.

Author -->Rick Dobson--> provides all of the installation, configuration, administration, and development techniques that you need to build applications quickly. He focuses on techniques that are easy to learn and transparent in their real-world translations. Topics include the SSMS-based query tool and T-SQL programming, and Visual Basic Express and Visual Web Developer, both with SSE, to build Windows Forms applications and to develop ASP.NET web applications.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. 250+ Ready-to-Use, Powerful DMX QueriesTransform data mining model information into actionable business intelligence using the Data Mining Extensions (DMX) language. Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 contains more than 250 downloadable DMX queries you can use to extract and visualize data. The application, syntax, and results of each query are described in detail. The book emphasizes DMX for use in SSMS against SSAS, but the queries also apply to SSRS, SSIS, DMX in SQL, WinForms, WebForms, and many other applications. Techniques for generating DMX syntax from graphical tools are also demonstrated in this valuable resource. View cases within data mining structures and models using DMX Case queries Examine the content of a data mining model with DMX Content queries Perform DMX Prediction queries based on the Decision Trees algorithm and the Time Series algorithm Run Prediction and Cluster queries based on the Clustering algorithm Execute Prediction queries with Association and Sequence Clustering algorithms Use DMX DDL queries to create, alter, drop, back up, and restore data mining objects Display various parameters for each algorithm with Schema queries Examine the values of discrete, discretized, and continuous structure columns using Column queries Use graphical interfaces to generate Prediction, Content, Cluster, and DDL queries Deliver DMX query results to end users Download the source code from www.mhprofessional.com/computingdownload

SSH, or Secure Shell, is the de facto standard among users and administrators who wish to establish secure communication between disparate networks. This book is authored by a Fortune 100 system administrator, who will provide you with a highly practical reference for configuring and deploying OpenSSH in your own environment.

Some of the topics covered in this book include: OpenSSH installation and configuration, key management, secure logging, client/server architectures, and digital certificates. The author also provides you with complete deployment scenarios that arise daily in enterprise environments, both large and small. Table of Contents Legacy Protocols: Why Replace Telnet, FTP, rsh, rcp, and rlogin with SSH? A Quick SSH Implementation The File Structure of OpenSSH The OpenSSH Server The OpenSSH Client Authentication Advanced Topics TCP Forwarding Managing Your OpenSSH Environment Scripting with OpenSSH SSH Tectia Server

SQL Server 2000 is the leading relational database for the Windows platform. It's a full-featured, enterprise-class database server, but its ease of use and maintenance makes it suitable whether youre a junior, part-time, or advanceddatabase administratoror developer. SQL Server expert and author Joseph Sack covers all SQL Server 2000 features, so you'll be able to rely on this book when you're in the field and need quick, effective solutions.

Included are hundreds of practical recipes that describe and demonstrate the utility of a feature or functionwith the minimum necessary background theory. This quick and effective reference highlights the specifics of every SQL Server command or process. Further, this special signature edition contains a searchable PDF of the book, making it ideal to use as both a desktop reference, and a client-site field guide.

Purchase this book and you'll get the free, fully searchable eBooka $25 value! (Details are printed inside the book.)

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 book features practical steps to help you overcome issues youre likely to encounter. You'll learn to use SQL for querying, inserting, updating, and deleting data. You'll also learn how to back up and restore databases for basic administration in SQL Server. Further, you'll cover how to build a complete database, from the fundamentals of relational database design to table and index creation.

Additionally, you'll start to program in T-SQL, SQL Servers implementation (and extension) of the SQL programming language, and you'll come away with effective programming techniques using stored procedures and triggers.

The MySQL database server continues to enjoy an aggressive development schedule, with new features and enhancements released on a regular basis. Most notably, the changes to version 4 and the forthcoming version 5 are among the most significant in the history of the project, and serve to further extend the already considerable capabilities this popular open source database server offers its millions of users worldwide. MySQL 5 is expected to be released in late spring/early summer 2005.

Pro MySQL provides intermediate and advanced MySQL users with a comprehensive guide to the array of features available in these new versions. Clustering, replication, transactions, and subqueries are just a few of the topics youa (TM)ll find in this book.

* First book on the market that covers building high-performance Java applications on the Oracle database-using the latest versions of both the Oracle database (10g) and the JDBC API (3.0). * Promotes and explains an "anti black box" approach to Oracle development complete with benchmark code) that will allow developers to write highly efficient, high performance Oracle JDBC applications. * A new book from the prestigious OakTable Press, which Apress will be strongly promoting and supporting throughout 2004.

Information systems in healthcare and public utility services depend on comp- ing infrastructures. Many research e?orts are being made in related areas, such as wireless computing (e. g. , Auto-ID Laboratories, and projects at MIT), W- based computing, and information accesses by Web users. Government agencies in many countries plan to launch facilities in education, healthcare and infor- tion support as a part of e-government initiatives. In this context, information interchange management has become an active research ?eld. A number of new opportunities have evolved in design and modeling based on new computing needs of users. Database systems play a central role in supporting networked information systems for access and storage management aspects. The4thInternationalWorkshoponDatabasesinNetworkedInformationS- tems (DNIS 2005) was held on March 28-30, 2005 at the University of Aizu in Japan. The workshop program included research contributions, and invited c- tributions. A view of research activity in Information Interchange Management and related research issues was provided by the session on this topic. The invited contribution was contributed by Dr. Umeshwar Dayal. The workshop session on Web Data Management Systems had invited papers by Prof. Elisa Bertino, Prof. Masahito Hirakawa, and Prof. William I. Grosky. The two sessions on Networked Information Systems included invited contributions by Prof. Sushil Jajodia, Dr. Cyrus Shahabi, Prof. Divyakant Agrawal and Dr. Harumi Kuno. I would like to thank the members of the Program Committee for their support and all authors who considered DNIS 2005 in making research contributions.

*Exploits new features of Visual Studio .NET 2003 and the Oracle database 10g. (But concepts and code still apply to the earlier releases, 8i and 9i, that currently comprise most business systems). *Explains Oracle programming using both C# and VB.NET languages; provides a one-stop reference for VS.NET developers working with Oracle. *Excellent resource for J2EE programmers in environments considering moving to a .NET environment (and retaining the Oracle database).

During recent years, huge efforts have been made to establish digital libraries, in a variety of media, offered from a variety of sources, and intended for a variety of professional and private user communities. As digital data collections proliferate, problems of resource selection and data fusion become major issues. Traditional search engines, even the best ones, are unable to provide access to the hidden web of information that is only available via digital library search interfaces.

Originating from the SIGIR 2003 Workshop on Distributed Information Retrieval, held in Toronto, Canada in August 2003, this book presents extended and revised workshop papers as well as several invited papers on the topic to round off coverage of the core issues. The papers are devoted to recent research on the design and implementation of methods and tools for resource discovery, resource description, resource selection, data fusion, and user interaction.

The understanding of data semantics in Web-based information systems is the object of intensive research e?orts. The large volume of data on the Internet originatesaneedforaccessingthesemanticcontentofthatinformation. Furth- more, it requires the personalizing of its search and integration to various types of users. Two approacheshave been proposed in the research literature: integ- tion of Web technologies with database technologies and use of meta-languages such as XML. These solutions o?er highly structured or semi-structured data that allow users to perform queries at a higher semantic level. These also faci- tate thedynamic personalizationof Web-basedapplications. Therefore, it is now important to address the question of how one can e?ciently query and search large collections of XML documents. And it is also necessary to ?nd new so- tions, both to support dynamic architectures for Web-based applications and to model users' search and result presentation criteria. The third international workshop on Databases in Networked Information S- tems (DNIS 2003) was held on September 22-24, 2003 at the University of Aizu in Japan on the occasion of its 10th anniversary. The workshop program included research contributions, and invited contributions. The session on Web IntelligenceincludedinvitedpapersbyProfessorJimingLiuandProfessorCyrus Shahabi. The session on Information Interchange and Management Systems - cluded invited papers by Professor Tosiyasu L. Kunii, Professor Elisa Bertino, and ProfessorMarc Sifer. The session on Information Interchange Among Cyber CommunitieshadinvitedpapersbyProfessorToyoakiNishida, ProfessorMasaru Kitsuregawa, and Dr. Umeshwar Dayal. Finally the session onKnowledge - - notation and Visualization included theinvited contributionby ProfessorDaniel Keim.

"SQL Server CE Database Development with the .NET Compact Framework" is the only book of its kind for developers wishing to examine in detail all aspects of SQL Server CE 2.0 and the .NET Compact Framework, the most significantly updated area of Visual Studio 2003.

Featuring in-depth information on SQL Server CE 2.0 and the .NET Compact Framework, this book illustrates how both Visual Basic .NET and C# can be used to build powerful database applications for the Pocket PC. While other .NET Compact Framework books try to broadly cover general programming issues, this book focuses strictly on database application development.

SQL Server Administration with Perl significantly empowers SQL Server database administrators and developers with Perl scripting techniques and takes SQL Server administration to the next level. This book is about solving SQL Server administrative problems with Perl. SQL Server Administration with Perl consists of a series of scenarios covering a wide range of SQL Server administrative topics. These are real-world scenarios that you hear DBAs discussing on the SQL Server forums and newsgroups-scenarios that DBAs run into in their day-to-day development or production environments. Readers will walk away from this book with two things: a DBA toolkit with well over 150 Perl scripts and problem-solving techniques they can apply to create even more tools for attacking other SQL Server administrative problems. Most of the sample problems are described and addressed in the context of SQL Server 7 or SQL Server 2000, but they are generally version independent. The next major release of SQL Server (Yukon) may change some of the details, but it will not invalidate the nature of the presented approaches or solutions. with any version of SQL Server.

The 9th International Conference on Database Systems for Advanced Appli- tions (DASFAA 2004) was held during March 17-19, 2004 on the beautiful Jeju island of Korea. The DASFAA conference provides an international forum for technical discussions among researchers, developers, and users of database - stems from academia, business, and industry. The main focus of DASFAA is on research in database theory, development of advanced DBMS technologies, and their advanced applications. A premier database conference in the Asia/Paci?c region, DASFAA has been held every two years, and in many countries in the - gion. To promote the area further and to answer the needs of many participants, the steering committee decided to hold the conference annually. DASFAA 2004 was the ?rst such annual conference. The conference was organized by the Special Interest Group on Databases (SIGDB) of the Korea Information Science Society and the Advanced Infor- tion Technology Research Center (AITrc) at KAIST - an engineering research center of excellence (ERC) supported by the Korea Science and Engineering Foundation (KOSEF). We had a number of sponsors who made generous cont- butionstomaketheconferencesuccessful. TheyareOracleKorea, SamsungSDS, Korea Telecom Data, Inc., the United States Air Force O?ce of Scienti?c Re- arch, theAsianO?ceofAerospaceResearch&Development, theArmyResearch O?ce-Far East, and the Korea Advanced Institute of Science and Technology (KAIST).