Marketplace books
-
Data Analysis Using SQL and Excel
by Gordon S. Linoff
Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more.
-
SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)
by Grant Fritchey, Sajal Dam
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.
-
Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers (Proffesional Reference Series)
by Brennan Stehling
Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers explains how to use ASP.NET 2.0 and SQL Server 2005 most efficiently together. It covers all crucial performance issues and illustrates optimal techniques with enterprise-quality development. Performance is always an issue, and optimizing database access is one of the most daunting performance challenges facing web developers.
-
Pro SQL Server 2005 Database Design and Optimization
by Louis Davidson, Kevin Kline, Kurt Windisch
Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.
-
Pro SQL Server Disaster Recovery
by James Luetkehoelter
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.
-
Beginning SQL Server 2005 Express for Developers: From Novice to Professional (Expert's Voice in .Net)
by Robin Dewson
Assuming neither database nor programming background, Beginning SQL Server 2005 Express for Developers introduces all the fundamental database administration and SQL programming features of SQL Server 2005 Express Edition, the free relational database management system from Microsoft that provides a major subset of full SQL Server 2005 functionality.
-
Pro T-SQL 2005 Programmer's Guide (Expert's Voice)
by Michael Coles
Pro T-SQL 2005 Programmer's Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you'll find it described clearly here. Stored procedures, triggers, and user-defined functions are only part of the story.
-
Building a Data Warehouse: With Examples in SQL Server (Expert's Voice)
by Vincent Rainardi
Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The RDBMS used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.
-
Pro SQL Server 2008 XML
by Michael Coles
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.
-
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach
by Joseph Sack
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.
