Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint, PerformancePoint, and other key Microsoft technologies.

The book begins by addressing the many misconceptions that surround the use of key performance indicators (KPIs) and giving a brief overview of the business intelligence (BI) and reporting tools that can be combined on the Microsoft platform to help you generate the results that you need.

The focus of the book is to help you implement a successful business intelligence project of your own. The text discusses many of the required project planning components, provides overviews and examples associated with Microsoft's BI tools, and gives detailed examples of successful dashboard implementations. What you'll learn The key functional and technical components of a successful report/dashboard implementation What Microsoft tools are provided both within and without SQL Server 2008 to help you achieve an integrated solution How to determine whether your performance indicators are correct for your business and how to roll them out to your organization in an effective way Who this book is for

This book is for entrepreneurs, technologists, and developers who want to bring clear-cut, reliable reporting into their organization. No prior experience of building analytics and reporting dashboards is required, but basic familiarity with SQL Server 2008 is assumed. Table of Contents An Overview of Analytics Seven Keys to Successful Reporting Projects Key Performance Indicators Microsoft Platform Components for Dashboards Core Components of SQL Server 2008 SQL Server Analysis Services Performance Management Implementation and Maintenance of the Integrated System Case Studies

Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing databasebacked applications. It's easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers aren't left out, however. Those who choose to do socan go deep and leverage the full power and flexibility of Oracle's database engine.

Getting started with APEX is easy; learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the hood of APEX and expose the full power behind its easytouse GUI. They show you what you need to know to produce powerful, professionally polished applicationssuch as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more.

The authors are wellqualified to write on APEX. John Scott runs ShellPrompt, a hosting service that handles many large-scale APEX applications, some of which he is paid to develop. John is a hardcore APEX developer. His co-author, Scott Spendolini, is one of the original creators of APEX. Both John and Scott now base their full-time careers on developing APEX applications. Pro Oracle Application Express is your opportunity to learn APEX from the very best.

Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008.Clearly describes relational database concepts Explains the SQL Server database engine and supporting tools Shows various database maintenance scenarios What you'll learn To understand core concepts of relational databases How to install SQL Server in your environment How to use the tools that come with SQL Server to perform daily administrative tasks How to design and implement a database maintenance plan in SQL Server Configuring database security and protect your sensitive data from intruders How to meet regulatory and government compliance requirements like Sarbanes-Oxley and the Payment Card Industry (PCI) regulations Who this book is for

This book is primarily for those who are aspiring to become SQL Server 2008 database administrators. Reading this book gives you a great foundation of knowledge upon which to build a future career in database administration. You might be new to SQL Server 2008, or you might have experience with competing products such as Oracle. Either way, this book gets you up to speed quickly in managing SQL Server 2008, helping you transfer your existing knowledge into the SQL Server 2008 environment. Table of Contents The Database Administration Profession Planning and Installing SQL Server 2008 What's in the Toolbox? Creating Tables and Other Objects Transact-SQL SQL Server Internals Storage Management Strategies Database Backup Strategies Database Restore Strategies Common Database Maintenance Tasks Automation Through SQLCMD and PowerShell Database Maintenance Plans Performance Tuning and Optimization SQL Server Security Auditing, Encryption, and Compliance SQL Server in the Enterprise Where to Go Next?

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

Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.Introduces new administration features of SQL Server 2008 Shows how to manage a SQL Server 2008 database at professional level Provides guidance on performance optimization What you'll learn Take advantage of the new administrative features in SQL Server 2008 Make intelligent decisions when choosing an installation or upgrade path Define and implement database policies to create a consistent, predictable environment throughout the organization Automate repetitive Tasks for increased productivity Create baseline monitors using Performance Monitor, Profiler, and System Dynamic Management views Identify and resolve long-running, I/O, and CPU-intensive queries Who this book is for

This book is for junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2008. Table of Contents New Feature Overview Pre-Installation Considerations Choosing a High Availability Solution Installing Microsoft SQL Server 2008 Upgrading to Microsoft SQL Server 2008 Post Installation Multi-Server Administration Managing Security within the Database Engine Administering Database Objects Indexing for Performance Managing Backups Restore and Recovery Strategies Automating Routine Maintenance Monitoring Your Server Auditing SQL Server Managing Query Performance Secrets to Excelling as a Professional DBA What's Next?

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.

Beginning SQL Server 2008 Express for Developers: From Novice to Professional takes a developer, and even a database administrator, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource commonly used by students, developers of small systems, and those transferring skills from other databases. This book focuses on the features within the Express Edition and therefore will not confuse readers with coverage of features found only in the Development Edition. By the end of the book, readers will be ready to move on to Accelerated SQL Server 2008 as well as other books within the Apress SQL Server lineup such as Pro SQL Server 2008 Reporting Services.Covers using the free Express Edition of SQL Server Describes creating a database from scratch and builds on this Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you and your business What you'll learn Learn what features exist within SQL Server 2008 Express Edition and how to install and upgrade the product and set up security. Design and create a database. Build database objects, such as tables and stored procedures, graphically as well as programmatically. Work with datainserting, updating, deleting, and retrievingusing simple and complex queries, programs, and data views. Generate reports from data. Implement a solid database maintenance strategy that includes backing up and restoring your data when necessary. Take advantage of advanced TransactSQL techniques to get the most out of your data. Ensure good performance by building the right indexes, defining the right relationships between tables, and joining tables in the most optimal manner. Who this book is for

Anyone interested in working with SQL Server as a database, and particularly those who wish for a no-cost database platform that plays well in the .NET environment. Ideal for those starting out in IT or who have to prior database experience.

Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications.

Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth.All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data. Every section is illustrated with code examples that you can use directly in SQL Server. All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express. What you'll learn Understand the fundamental concepts involved in working with spatial data, including spatial references and coordinate systems.Apply these concepts in the collection and storage of spatial data in SQL Server 2008, using the new geometry and geography field types.Create different types of spatial data objectspoints, lines, and polygonsand use these to describe realworld objects.Learn how to analyze spatial data using a range of supported methods, and be aware of a number of different practical applications for these methods.Be shown how to integrate SQL Server with other tools, such as Microsoft Virtual Earth, to display a visual representation of spatial data.Know how to ensure the performance of spatially enabled databases by creating appropriate spatial indexes. Who this book is for

SQL Server developers who wish to use spatial data in Microsoft SQL Server 2008.

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

Oracle Database experts Darl Kuhn, Sam Alapati, and Arup Nanda show you how to

Reliablyback up and recover your database using Oracles Recovery Manager. Utilize New Oracle Database 11g features such as the Data Recovery Advisor. Let Oracle Database manage your backup files via the Flash Recovery Area. Automate backup and recovery tasks by writing scripts. Troubleshoot RMAN problems and optimize RMAN performance. Interface with a Media Management Layer to manage your backup tape library. Recover from the loss of a control file, loss of an online redo log, and other (hopefully!) unusual situations.

Who is this book for?

Oracle database administrators responsible for database backup and recovery operations.

Learn effective and scalable database design techniques in a SQL Server environment.Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Solid foundation in best practices and relational theory Maximize SQL Server features to enhance security, performance, scalability Thorough treatment from conceptual design to an effective, physical implementation What you'll learn Develop conceptual models of client data using interviews and client documentation Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect the integrity of data as part of meeting regulatory requirements Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more Create effective indexing to speed query performance Who this book is for

Pro SQL Server 2008 Relational Database Design and Implementation is designed for programmers of all types who want to use SQL Server 2008 to store data. Rookie database programmers will find a complete course on the fundamentals of database design that includes conceptual designs and physical implementation. Seasoned veterans will find many tips and tricks for implementing database systems that will be well worth the time invested in reading this book.

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.

Pro Access 2007 will help readers overcome any upgrade issues, covering the new features of Microsoft Access 2007, including working with SharePoint Office Server and customizing Ribbons (the new UI in office 2007). It includes solid examples that thoroughly explain new features. This book is aimed at professional developers and power users new to Access 2007. Author Martin Reid is also a working Access developer who is respected by his peers and knows what working developers face, especially at the time of a new release.

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.

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

Oracle is the number one database engine in use today. The fact that it is the choice of military organizations and agencies around the world is part of the company s legacy and is evident in the product. Oracle has more security-related functions, products, and tools than almost any other database engine. Unfortunately, the fact that these capabilities exist does not mean that they are used correctly or even used at all. In fact, most users are familiar with less than twenty percent of the security mechanisms within Oracle.

Written by Ron Ben Natan, one of the most respected and knowledgeable database security experts in the world, HOWTO Secure and Audit Oracle 10g and 11g shows readers how to navigate the options, select the right tools and avoid common pitfalls. The text is structured as HOWTOs addressing each security function in the context of Oracle 11g and Oracle 10g. Among a long list of HOWTOs, readers will learn to:

• Choose configuration settings that make it harder to gain unauthorized access
• Understand when and how to encrypt data-at-rest and data-in-transit and how to implement strong authentication
• Use and manage audit trails and advanced techniques for auditing
• Assess risks that may exist and determine how to address them
• Make use of advanced tools and options such as Advanced Security Options, Virtual Private Database, Audit Vault, and Database Vault

The text also provides an overview of cryptography, covering encryption and digital signatures and shows readers how Oracle Wallet Manager and orapki can be used to generate and manage certificates and other secrets. While the book s seventeen chapters follow a logical order of implementation, each HOWTO can be referenced independently to meet a user s immediate needs. Providing authoritative and succinct instructions highlighted by examples, this ultimate guide to security best practices for Oracle bridges the gap between those who install and configure security features and those who secure and audit them.

From operating systems to the cloud, Oracle's products and services are everywhere, and it has the market share to prove it. Given the share diversity of the Oracle product line, and the level of complexity of integration, management can be quite a daunting task. The CIO's Guide to Oracle Products and Solutions is the go-to guide for all things Oracle. It provides management-level guidance on how to successfully navigate and manage the full range of Oracle products. The book presents management best practices and user/developer lessons learned in the use of Oracle products and services. Supplying both conceptual and technical views, the text focuses on what CIOs need to do to orient, or reorient, their organization toward the use of Oracle products and services. It describes how to develop a strategic framework for the use of these products and services rather than the specific product or service itself. This strategic framework will help you to prepare, educate, keep up with change, mitigate risk, and implement with the confidence needed to succeed. Providing an overview of the suite of Oracle technologies and solutions, the book covers the heart of the Oracle products set, including Oracle analytics, enterprise performance management, Oracle cloud, data management, application development, social business, and fusion. It examines compliance and security issues and includes metrics to help you evaluate potential solutions. The book also provides readers with access to a set of helpful resources on the book's page at www.crcpress.com, including cloud procurement best practices, cloud migration tips, a sample project procurement plan template, and various glossaries.

This brilliant new book gives readers the lowdown on the most important new features in the latest release of Oracle's flagship database product. Authors Sam Alapati and Charles Kim are experienced database administrators who go beyond regurgitating Oracle's new feature documentation to report on "what's new that really matters." Readers whose careers are bound up in Oracle's database system need to know what's new. Sam and Charles deliver with a rigor and candor that will help readers choose the best of the new features to apply in their own environments.

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

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.

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

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.

* 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.