This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more. Four expert SQL Server administrators, developers, and consultants have packed this book with real-world information, tips, guidelines, and samples drawn from their own extensive experience creating and managing complex database solutions. Writing for intermediate-to-advanced-level SQL Server professionals, they focus on the product’s most complex and powerful capabilities, and its newest tools and features. For example, you’ll find invaluable information on administering SQL Server more efficiently, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning performance. The accompanying CD-ROM contains an extraordinary library of practical tools and information including sample databases and all code examples. Whether you’re responsible for SQL Server 2008 analysis, design, implementation, support, administration, or troubleshooting, no other book offers you this much value. Understand the Microsoft SQL Server 2008 environment, R2’s newest features, and each edition’s capabilities Manage SQL Server 2008 more effectively with SQL Server Management Studio, the SQLCMD command-line query tool, and Powershell Efficiently manage security, users, backup/restore, replication, Database Mail, and database objects—from tables and indexes to stored procedures and triggers Increase availability with clustering, database mirroring, and other features Use new Policy-Based Management to centrally configure and operate SQL Server throughout the organization Use SQL Server Profiler to capture queries and identify bottlenecks Improve performance by optimizing queries, design more effective databases, and manage workloads with the new Resource Governor Develop applications using SQL Server 2008’s enhancements to T-SQL and SQLCLR, .NET integration, LINQ to SQL, XML, and XQuery Make the most of Analysis Services, Integration Services, and Reporting Services—especially Microsoft’s new R2 reporting improvements Improve data security using Column-level and Transparent Data Encryption CD-ROM includes: 15 additional chapters Code samples, scripts, and databases utilized within the book Free version of SQL Shot (performance & tuning software)

Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing everything you need to know in Microsoft SQL Server 2008 Bible. Learn the best practices, tips, and tricks from this comprehensive tutorial and reference, which includes specific examples and sample code, with nearly every task demonstrated in both a graphical and SQL code method. Understand how to develop SQL Server databases and data connections, how to administer the SQL Server and keep databases performing optimally, and how to navigate all the new features of the 2008 release.

SQL Injection Attacks and Defense, First Edition: Winner of the Best Book Bejtlich Read Award "SQL injection is probably the number one problem for any server-side application, and this book unequaled in its coverage." –Richard Bejtlich, Tao Security blog SQL injection represents one of the most dangerous and well-known, yet misunderstood, security vulnerabilities on the Internet, largely because there is no central repository of information available for penetration testers, IT security consultants and practitioners, and web/software developers to turn to for help. SQL Injection Attacks and Defense, Second Edition is the only book devoted exclusively to this long-established but recently growing threat. This is the definitive resource for understanding, finding, exploiting, and defending against this increasingly popular and particularly destructive type of Internet-based attack. SQL Injection Attacks and Defense, Second Edition includes all the currently known information about these attacks and significant insight from its team of SQL injection experts, who tell you about: Understanding SQL Injection – Understand what it is and how it works Find, confirm and automate SQL injection discovery Tips and tricks for finding SQL injection within code Create exploits for using SQL injection Design apps to avoid the dangers these attacks SQL injection on different databases SQL injection on different technologies SQL injection testing techniques Case Studies Securing SQL Server, Second Edition is the only book to provide a complete understanding of SQL injection, from the basics of vulnerability to discovery, exploitation, prevention, and mitigation measures Covers unique, publicly unavailable information, by technical experts in such areas as Oracle, Microsoft SQL Server, and MySQL---including new developments for Microsoft SQL Server 2012 (Denali) Written by an established expert, author, and speaker in the field, with contributions from a team of equally renowned creators of SQL injection tools, applications, and educational materials

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today's most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You'll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts -- all packed into a succinct, comprehensive, and easy-to-use format. This book provides: Background on the Relational Database Model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations Platform-specific functions unique to each implementation Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you've been using SQL since its earliest days, you'll get lots of new tips and techniques in this book.

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 CD-ROM includes 8 bonus chapters covering topics such as Notification Services, Service Broker, and Full-Text Search Code samples, scripts, and sample databases A PDF version of the entire book Introduction Part I Welcome to Microsoft SQL Server 1 SQL Server 2005 Overview 2 What’s New in SQL Server 2005 Part II SQL Server Tools and Utilities 3 SQL Server Management Studio 4 SQL Server Command-Line Utilities 5 SQL Server Profiler Part III SQL Server Administration 6 SQL Server System and Database Administration 7 Installing SQL Server 2005 8 Upgrading to SQL Server 2005 9 Client Installation and Configuration 10 Security and User Administration 11 Database Backup and Restore 12 Database Mail 13 SQL Server Scheduling and Notification 14 SQL Server High Availability. 15 Replication 16 Database Mirroring 17 SQL Server Clustering Part IV Database Administration 18 Creating and Managing Databases 19 Creating and Managing Tables 20 Creating and Managing Indexes 21 Implementing Data Integrity 22 Creating and Managing Views in SQL Server 23 Creating and Managing Stored Procedures 24 Creating and Managing User-Defined Functions 25 Creating and Managing Triggers 26 Transaction Management and the Transaction Log 27 Database Snapshots 28 Database Maintenance Part V SQL Server Performance and Optimization 29 Indexes and Performance 30 Understanding Query Optimization 31 Query Analysis 32 Locking and Performance 33 Database Design and Performance 34 Monitoring SQL Server Performance Part VI SQL Server Application Development 35 What’s New for Transact-SQL in SQL Server 2005 36 SQL Server and the .NET Framework 37 Using XML in SQL Server 2005 38 SQL Server Web Services Part VII SQL Server Business Intelligence Features 39 SQL Server 2005 Analysis Services 40 SQL Server Integration Services 41 SQL Server 2005 Reporting Services Bonus Chapters on the CD 42 Managing Linked and Remote Servers 43 Configuring, Tuning, and Optimizing SQL Server Options 44 Administering Very Large SQL Server Databases 45 SQL Server Disaster Recovery Planning 46 Transact-SQL Programming Guidelines, Tips, and Tricks 47 SQL Server Notification Services 48 SQL Server Service Broker 49 SQL Server Full-Text Search Index

Get comprehensive information to plan, deploy, administer, and support Microsoft SQL Server 2005 in organizations of any size. With the ADMINISTRATOR’S COMPANION, you get mission-critical information in a single volume—straight from the experts.

Microsoft SQL Server 2000 Unleashed, 2E offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server 2000 Unleashed covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL Server CE.

is a handbook of practical solutions for busy database professionals charged with managing an organization's critically important data. Covering today's most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms. SQL Performance Tuning Packed with tips, techniques, and best practices, this hands-on guide covers SQL commands and queries over a wide range of conditions and environments. Every facet of the SQL environment is covered, from concurrency control to optimization—and every issue in between. The book includes an overview of each of the most widely used database management systems (DBMS) and provides tuning tips for common day-to-day situations. Topics covered include: General and specific tuning General sort considerations and options Joins and subqueries Columns and tables Indexes, including B-trees and bitmaps Constraints and stored procedures ODBC and JDBC Data changes and concurrency control (locking) Clients, servers, and middleware Whether you are a programmer, consultant, or user, you will find SQL Performance Tuning an indispensable guide to optimizing SQL performance across today's popular database environments. Throughout , ideas and techniques are tested on a variety of popular SQL environments, including IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, MySQL, Oracle, and Sybase ASE. The book's practical examples are written in ANSI/ISO Standard SQL: 1999. SQL Performance Tuning