SQL Server 2000: A Beginner's Guide (Book/CD-ROM)

SQL Server 2000: A Beginner's Guide (Book/CD-ROM)
Author: Dusan Petkovic
Publisher: McGraw-Hill Osborne Media
Total Pages: 692
Release: 2000
Genre: Computers
ISBN: 9780072125870

Build and manage SQL Server 2000 databases easily. Work with Transact-SQL and data definition language, and handle simple and complex queries. You'll also learn to use SQL extensions and stored procedures, views, triggers, and transactions.

Professional Microsoft SQL Server 2008 Programming

Professional Microsoft SQL Server 2008 Programming
Author: Robert Vieira
Publisher: John Wiley & Sons
Total Pages: 938
Release: 2010-09-29
Genre: Computers
ISBN: 0470632097

This book is written for SQL Server 2008. However, it does maintain roots going back a few versions and looks out for backward compatibility issues with SQL Server 2005 and SQL Server 2000. These versions are old enough that there is little to no time spent on them except in passing. The book is oriented around developing on SQL server. Most of the concepts are agnostic to what client language you use although the examples that leverage a client language general do so in C#. For those who are migrating from early versions of SQL Server, some “gotchas” that exist any time a product has versions are discussed to the extent that they seem to be a genuinely relevant issue. This book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused. While there is a quick reference-oriented appendix, there is very little coverage given to beginner level topics. It is assumed that you already have experience with data manipulation language (DML) statements and know the basics of the mainstream SQL Server objects (views, stored procedures, user defined functions, etc.). If you would like to brush up on your knowledge before diving into this book, the author recommends reading Beginning SQL Server 2008 Programming first. There is very little overlap between the Beginning and Professional books and they are designed to work as a pair.

The Guru's Guide to SQL Server Architecture and Internals

The Guru's Guide to SQL Server Architecture and Internals
Author: Ken Henderson
Publisher: Addison-Wesley Professional
Total Pages: 1076
Release: 2004
Genre: Computers
ISBN: 9780201700473

bull; Contains the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning bull; Will be a key reference for anyone working with SQL Server, no matter what their skill level bull; The latest book in the bestselling series of Guru's Guides from Ken Henderson

SQL Server Forensic Analysis

SQL Server Forensic Analysis
Author: Kevvie Fowler
Publisher: Addison-Wesley Professional
Total Pages: 0
Release: 2009
Genre: Computer crimes
ISBN: 9780321544360

The tools and techniques investigators need to conduct crucial forensic investigations in SQL Server. The database is the part of a forensic investigation that companies are the most concerned about. This book provides data and tools needed to avoid under or over reporting. Teaches many about aspects about SQL server that are not widely known. A complete tutorial to conducting SQL Server investigations and using that knowledge to confirm, assess, and investigate a digital intrusion. Companies today are in a terrible bind: They must report all possible data security breaches, but they don't always know if, in a given breech, data has been compromised. As a result, most companies are releasing information to the public about every system breech or attempted system breech they know about. This reporting, in turn, whips up public hysteria and makes many companies look bad. Kevvie Fowler's 'SQL Server Forensic Analysis' is an attempt to calm everyone down and focuses on a key, under-documented component of today's forensics investigations. The book will help investigators determine if a breech was attempted, if information on the database server was compromised in any way, and if any rootkits have been installed that can compromise sensitive data in the future. Readers will learn how to prioritize, acquire, and analyze database evidence using forensically sound practices and free industry tools. The final chapter will include a case study that demonstrates all the techniques from the book applied in a walk-through of a real-world investigation.

The Guru's Guide to Transact-SQL

The Guru's Guide to Transact-SQL
Author: Ken Henderson
Publisher: Addison-Wesley Professional
Total Pages: 594
Release: 2000
Genre: Computers
ISBN: 9780201615760

A book/CD-ROM guide to mastering Microsoft Transact-SQL and developing the best possible code. Some 600 code examples not only illustrate important concepts and best practices, but also provide working Transact-SQL code that can be incorporated into real-world DBMS applications. Begins by explaining language fundamentals such as database and table creation, then moves on to advanced topics such as OLE automation. The CD-ROM contains a set of code examples from the book plus a SQL programming environment. Henderson is a nationally recognized consultant and leading DBMS practitioner. Annotation copyrighted by Book News, Inc., Portland, OR

Oracle XML Handbook

Oracle XML Handbook
Author: Mark Scardina Ben Chang, K. Karun Stefan Kiritzov Ian Macky Niranjan Ramakrishnan
Publisher: Mcgraw-hill
Total Pages: 0
Release: 2000-06-16
Genre: Computers
ISBN: 9780072124897

This one-of-a-kind reference explains the XML standard, how to create XML documents, and how XML will transform legacy systems integration involving e-commerce initiatives. As more corporations migrate to an eBusiness model using Oracle8i--THE database for Internet computing--it's crucial for all Web developers to learn to use XML in the Oracle environment. This book shows you how.

Healthcare Databases

Healthcare Databases
Author: Alan Gillies
Publisher: Radcliffe Publishing
Total Pages: 160
Release: 2002
Genre: Computers
ISBN: 9781857759723

Databases are an increasingly important part of the everyday life of all healthcare professionals. This straightforward practical guide to creating and using databases is closely tailored to the needs of healthcare practitioners. It covers design and implementation including simple data modelling, normalisation, tables, forms, queries and reports and shows how a database can be integrated with a word processor to produce letters for mailing. The easy to use step-by-step format guides the reader through the text in a user-friendly style by showing what actually appears on the computer and by making extensive use of screen shots, toolbar icons, mouse and keyboard actions. This clear and concise approachable book is designed for all general practitioners, practice managers and nurses, clinical governance and audit staff, doctors, nurses and other hospital staff, and staff involved in research and development - who need have no prior knowledge of databases.

Expert SQL Server 2005 Integration Services

Expert SQL Server 2005 Integration Services
Author: Brian Knight
Publisher: John Wiley & Sons
Total Pages: 430
Release: 2007-08-27
Genre: Computers
ISBN: 0470179589

As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features with the end goal of putting it all together to get a solution.