Database Books
-
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach
Published 12 years ago includes sample chapter
by Joseph Sack, Apress
SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
-
Linux Recipes for Oracle DBAs
Published 12 years ago includes sample chapter
by Darl Kuhn, Bernard Lopuz, Charles Kim, Apress
Linux Recipes for Oracle DBAs is an example–based book on managing Oracle Database in a Linux environment. Covering commonly used distributions such as Red Hat Enterprise Linux and Oracle Enterprise Linux, the book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of Linux documentation. The book is task–oriented: Look up the task to perform. See the solution. Read up on the details. Get the job done.
-
Pro SQL Server 2008 XML
Published 12 years ago includes sample chapter
by Michael Coles, Apress
Knowledge and ability to apply XML are de rigueur in today’s world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server’s built–in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT.
-
Beginning SQL Server 2008 for Developers: From Novice to Professional
Published 12 years ago includes sample chapter
by Robin Dewson, Apress
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.
-
SQL Server 2008 Query Performance Tuning Distilled
Published 11 years ago includes sample chapter
by Sajal Dam, Grant Fritchey, Apress
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter’s domain.