SQL server 2008 administration instant reference

Sample

Paul A. Strassmann

Strassmann reveals the hidden costs versus value of information technology, including how to realize the alignment of IT and business plans, how spending interacts with revenue, overhead costs, and personnel related to IT, and the idea of workload without payoff. One strategy is outsourcing and the perspective that the best companies do not outsource massive amounts of data manipulation, but rather study good reasons for outsourcing and manage it effectively without decaying their information assets.

Sample

Nabil R. Adam and Aryya Gangopadhyay

Database Issues in Geographic Information Systems approaches several important topics in GIS from a database perspective. Database management has a central role to play in most computer-based information systems, and is expected to have an equally important role to play in managing information in GIS as well. Existing database technology, however, focuses on the alphanumeric data that are required in business applications. GIS, like many other application areas, requires the ability to handle spatial as well as alphanumeric data. This requires new innovations in data management, which is the central theme of this monograph. Database Issues in Geographic Information Systems is suitable as a secondary text for a graduate level course on Geographic Information Systems, Database Systems or Cartography, and as a reference for researchers and practitioners in industry.

Sample

W.H. Inmon

The data warehouse solves the problem of getting information out of legacy systems quickly and efficiently. If designed and built right, data warehouses can provide significant freedom of access to data, thereby delivering enormous benefits to any organization. In this unique handbook, W. H. Inmon, "the father of the data warehouse," provides detailed discussion and analysis of all major issues related to the design and construction of the data warehouse, including granularity of data, partitioning data, metadata, lack of creditability of decision support systems (DSS) data, the system of record, migration and more. This Second Edition of Building the Data Warehouse is revised and expanded to include new techniques and applications of data warehouse technology and update existing topics to reflect the latest thinking. It includes a useful review checklist to help evaluate the effectiveness of the design.

Sample

Russell J.T. Dyer

"With an easy, step-by-step approach, this guide shows beginners how to install, use, and maintain the world's most popular open source database: MySQL. You'll learn through real-world examples and many practical tips, including information on how to improve database performance. Database systems such as MySQL help data handling for organizations large and small handle data, providing robust and efficient access in ways not offered by spreadsheets and other types of data stores. This book is also useful for web developers and programmers interested in adding MySQL to their skill sets. Topics include: Installation and basic administration ; Introduction to databases and SQL ; Functions, subqueries, and other query enhancements ; Improving database performance ; Accessing MySQL from popular languages" --