Скачать книги бесплатно

SQL for Microsoft Access, Second Edition provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code.

Product Description
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. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area.
* Emphasizes the practical. Does not bury readers in theory.
* Gives readers practical techniques to immediately apply in their daily work.
* Dedicates a chapter to each of the most common, performance–related problem areas.

What you’ll learn
* Identify and fix poorly performing queries that are hurting your business.
* Read query execution plans and identify bottlenecks in performance.
* Record system performance metrics for trend analysis.
* Learn to design databases and write Transact–SQL code to avoid common problems.
* Understand what an index is, what it does, and how to build one.
* Use industry accepted best practices and understand how to develop your own to arrive at optimal database performance.

Who is this book for
SQL Server Query Performance Tuning Distilled is aimed at anyone writing business–critical Transact–SQL queries, and also at those responsible for the continued good performance of those queries. Developers, database administrators, business intelligence analysts, and any others who develop Transact–SQL queries will find this book an indispensible resource for getting the most out of what SQL Server 2008 has to offer.

About the Author
Grant Fritchey is currently working as a development DBA for FM Global, an industry–leading engineering and insurance company. In his previous time as a DBA and developer, he has worked at three failed dot–coms, a major consulting company, and a global bank. He has developed large–scale applications in languages such as VB, C#, and Java and has lived with SQL Server from the hoary days of 6.0, right through to 2008. His nickname at work is “The Scary DBA.” He even has an official name plate, and he displays it proudly.

The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.

* Lightning–quick introduction to SQL Server 2008
* Written by top experts in the field
* Provides a solid grounding in key features and technologies

What you’ll learn

* Manage SQL Server installations through the brand–new Declarative Management Framework.
* Protect yourself from downtime with high–availability features such as failover clustering.
* Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008.
* Find what you need using full–text search.
* Store, retrieve, and manage XML in the database.
* Derive competitive advantage from business intelligence tools such as Analysis Services and Reporting Services.

SQL Server reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET.

Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool. Plus, you'll learn how to extend practically every feature of Reporting Services by implementing your own security architecture or adding custom data access.

What you will learn from this book
* Details of programming reports and report scripting
* Advanced report design, including drill-down reports, nested lists, drill-through, links and dynamic content
* High-level strategies for business and support systems
* Rendering reports using .NET code, .NET 10 namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options
* How to design reports for mobile services
* Various tools used to define data sources and semantic metadata models
* How to use parameters and expressions to define creative report solutions
* Advanced object-oriented programming techniques, with examples in C# and VB 2005.

Product Description
Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.



Detailed information on…

* Installing, upgrading, and administering SQL Server 2005
* Database maintenance, backup, and recovery
* Creating and managing tables, views, stored procedures, triggers, and user-defined functions
* Database and index design
* SQL Server query optimization, and performance monitoring and tuning
* Transactions, transaction management, and distributed transactions
* SQL Server Management Studio—NEW!
* SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!
* SQL Server Service Broker—NEW!
* SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!
* SQL Server high availability and SQL Server clustering and replication
* Database Mirroring—NEW!
* Database Snapshots—NEW!
* Using XML in SQL Server 2005
* SQL Server tools and utilities

Product Description
Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 to help protect and manage your company s data whether automating tasks, creating indexes and views, performing backups and recovery, replicating transactions, tuning performance, managing server activity, importing and exporting data, or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot whether you re at your desk or in the field!
Key Book Benefits
Provides fast facts and immediate reference for administering SQL Server 2008 Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2008 Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them

Product Description
Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples.

Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to:
-Program views, stored applications, triggers, and functions using T-SQL
-Work with the new data types, LINQ, and the ADO.NET Entity Framework
-Automate common administration and maintenance tasks
-Debug databases, reports, and objects using Microsoft Visual Studio® 2008
-Write transactional code and implement local and distributed transactions
-Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services

Many of the book s examples, exercises, and code samples are available for download from the companion Web site.

The 283 page book is titled Mastering SQL Server Profiler, and as you can guess from the title, the focus is on learning how to use SQL Server Profiler. Not only does it cover the basics, it includes a discussion of every Profiler event and data column that can be collected, and in addition, shows you how to apply it to your day-to-day work as a DBA or developer.

The book covers these topics:

* Getting Started with Profiler
* Working with Traces and Templates
* Profiler GUI Tips and Tricks
* How to Identify Slow Running Queries
* How to Identify and Troubleshoot SQL Server Problems
* Using Profiler to Audit Database Activity
* Using Profiler with the Database Engine Tuning Advisor
* Correlating Profiler with Performance Monitor
* How to Capture Profiler Traces Programmatically
* Profiler Best Practices
* Profiler Events and Data Column Explained

Welcome to Microsoft SQL Server 2008 (AKA ”Yukon”). Many people have been speculating that the changes from version 2000 to 2005 were more dramatic than those changes that have occurred from 2005 to 2008. Yes, SQL Server 2005 was revolutionary in many respects, but SQL Server 2008 is not without some amazing new features and capabilities.
This book is divided into seven main topics: Security and Administration, Performance, Type System Enhancements, Programmability, Storage, Enhancements for High Availability, and Business Intelligence Enhancements. Each chapter will hopefully offer you insight into the new or improved features in each of these main areas. And, although the book covers a lot of ground, it is not an exhaustive tome, and, alas, not everything new or improved is contained in this book. I leave those additional details to Books Online and fellow authors who
will inevitably write more comprehensive titles.

All-in-One is All You Need

Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.

Get full details on all exam topics including how to:

* Install and configure SQL Server 2005
* Manage database design
* Use Transact-SQL and XML
* Work with functions, triggers, and CLR integration
* Optimize, monitor, and secure databases
* Create stored procedures
* Handle disaster recovery
* Work with Service Broker, Web Services, and MARS
* Use SQL Server Reporting Services and Notification Services
* Manage locks, deadlocks, and cursors
* Transfer data using Replication and SQL Server Integration Services