Microsoft SQL Server 2005 Administration Tutorials

SQL Server 2005 is a comprehensive database software platform providing enterprise-class data management and integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for a relational database format or XML. By supporting both a relational database format and XML, the SQL Server 2005 database engine provides the flexibility necessary to support the way you work. It also enables you to build and manage highly available, well-performing database software applications that you and your people can use to take your business to the next level.

The SQL Server 2005 data engine lies at the core of this enterprise data management solution. In addition to providing support for relational databases or XML, SQL Server 2005 combines the best in analysis, reporting, integration, and notification. This enables your team to build and deploy cost-effective BI solutions with which they can drive data into every corner of your business through scorecards, dashboards, Web services, and mobile devices.

Close integration with Microsoft Visual Studio, the Microsoft Office System, and a suite of new development tools, including the Business Intelligence Development Studio, sets SQL Server 2005 apart. Whether you are a developer, database administrator, information worker, or decision maker, SQL Server 2005 provides innovative solutions that help you gain more value from your data—whether stored in a relational database or XML data format.

Download Links

http://rapidshare.com/files/24983389/VTC_SQL_2005.part01.rar
http://rapidshare.com/files/24985577/VTC_SQL_2005.part02.rar
http://rapidshare.com/files/24987576/VTC_SQL_2005.part03.rar
http://rapidshare.com/files/24989714/VTC_SQL_2005.part04.rar
http://rapidshare.com/files/24991684/VTC_SQL_2005.part05.rar
http://rapidshare.com/files/24994063/VTC_SQL_2005.part06.rar
http://rapidshare.com/files/24995105/VTC_SQL_2005.part07.rar
http://rapidshare.com/files/24995423/VTC_SQL_2005.part08.rar

Total Training Microsoft SQL Server Development

Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!

PART 1: Introduction to SQL Server 2005

Lesson 1: SQL SERVER OVERVIEW (32 min)
1. Understanding Client Server Architecture
2. Introducing the Tools
3. Selecting an Addition
4. Creating Sample Databases

Lesson 2: USING MANAGEMENT STUDIO (23 min)
1. Arranging the Workspace
2. Registering Servers
3. Explaining Items in the Object Explorer
4. Explaining the Database Properties Dialog
5. Explaining the Columns Properties Dialog
6. Continuing with Object Explorer Items
7. Using the Query Editor

Lesson 3: DESIGNING RELATIONAL DATABASES (35 min)
1. Understanding Normalization
2. Discovering Patterns
3. Avoiding Over Complexity
4. Managing Optional Data
5. Creating Physical Keys
6. Using the Database Diagrammer Tool
7. Final Comments

Part 2: Selecting Data

Lesson 1: WORKING WITH SINGLE TABLE QUERIES (42 min)
1. Understanding Query Flow
2. Filtering Data with the Where Clause
3. Columns, Expressions & Scalar Functions
4. Using Case Expressions
5. Working with Nulls & Coalesce
6. Selecting Environment Functions
7. Working with Dates & Times
8. Parsing Strings
9. Converting Data
10. Sorting Data
11. Topping Off the Query with Predicates

Lesson 2: MERGING DATA WITH JOINS & UNIONS (25 min)
1. Working with Inner Joins
2. Using Left Outer Joins
3. Multiplying Data with Cross Joins
4. Referencing Self-Joins
5. Working with Complex Joins
6. Finding the Set Difference
7. Stacking Data with Unions

Lesson 3: WORKING WITH SUBQUERIES (19 min)
1. Using Subqueries as Expressions
2. Including Subqueries as Lists
3. Adding Subqueries as Derived Tables
4. Working with Correlated Subqueries
5. Solving for X with Relations Division

Lesson 4: AGGREGATING DATA (35 min)
1. Using the New Windowing Functions
2. Using Aggregate Functions
3. Grouping a Data Set
4. Nesting Aggregations
5. Filtering Groups & Adding Grand Totals
6. Generating Cross Tab Tables (Pivot)
7. Calculating Cumulative Sums

Lesson 5: USING FULL-TEXT SEARCH (14 min)
1. Creating a Full-Text Index
2. Searching for Words
3. Using a Fuzzy Search to Search for Phrases

Lesson 6: SELECTING DATA THROUGH VIEWS (11 min)
1. Creating Views
2. Preventing Disappearing Rows
3. Protecting from Schema Changes
4. Nesting Views

Lesson 7: DISTRIBUTED QUERIES (18 min)
1. Linking to External Data Sources
2. Executing Distributed Queries
3. Looking at Where the Work Takes Place
4. Using Pass Through Queries
5. Controlling Distributed Transactions

Lesson 8: MODIFYING DATA (29 min)
1. Inserting Data
2. Updating Data
3. Deleting Data
4. Using the Output Clause
5. Final Comments & Credits

PART 3: Developing Solutions

Lesson 1: T-SQL & STORED PROCEDURES (68 min)
1. Introducing T-SQL
2. Working with Variables
3. Controlling Procedural Flow
4. Examining SQL Server with Code
5. Using Temp Tables
6. Developing Dynamic SQL
7. Introducing Stored Procedures
8. Passing Parameters
9. Returning Parameters
10. Working with a Cursor
11. Handling Errors
12. Explaining the Raise Error
13. Controlling Transactions

Lesson 2: TRIGGERS & AUDIT TRAILS (31 min)
1. Introducing After Triggers
2. Using "Instead of" Trigger
3. Disabling Triggers
4. Using the Update ( ) Function
5. Selecting Transaction Data
6. Nesting & Recursion
7. Enforcing Complex RI
8. Auditing Data Changes

Lesson 3: USER-DEFINED FUNCTIONS (27 min)
1. Creating Scalar Functions
2. Working with Inline Table-Valued Functions
3. Using Multi-Statement Table-Valued UDFs
4. Navigating a Hierarchy
5. Having Fun with Apply
6. Exploring Functions in Nordic

Lesson 4: INDEXING FOR PERFORMANCE (31 min)
1. Introducing Indexes
2. Creating Indexes
3. Examinging Query Execution Plans, Pt. 1
4. Examinging Query Execution Plans, Pt. 2

Lesson 5: TRANSACTIONS, LOCKING & BLOCKING (33 min)
1. Introducing ACID
2. Understanding Transactional Faults
3. Stepping through a Transaction
4. Exploring Locks
5. Working with Locks
6. Viewing Deadlocks
7. Using Snapshot Isolation

Lesson 6: INTRODUCTION TO OPTIMIZATION THEORY (21 min)
1. Deconstructing the Database System
2. Walking through Optimization Theory
3. Optimization Theory Continued
4. Final Comments & Credits

Part1
http://rapidshare.com/files/56345531/TSQL05_P01_C01_L00.wmv
http://rapidshare.com/files/56345603/TSQL05_P01_C01_L01.wmv
http://rapidshare.com/files/56346080/TSQL05_P01_C01_L02.wmv
http://rapidshare.com/files/56346112/TSQL05_P01_C01_L03.wmv
http://rapidshare.com/files/56346160/TSQL05_P01_C01_L04.wmv

http://rapidshare.com/files/56344418/TSQL05_P01_C02_L00.wmv
http://rapidshare.com/files/56344615/TSQL05_P01_C02_L01.wmv
http://rapidshare.com/files/56345282/TSQL05_P01_C02_L02.wmv
http://rapidshare.com/files/56345757/TSQL05_P01_C02_L03.wmv
http://rapidshare.com/files/56345695/TSQL05_P01_C02_L04.wmv
http://rapidshare.com/files/56345307/TSQL05_P01_C02_L05.wmv
http://rapidshare.com/files/56345350/TSQL05_P01_C02_L06.wmv
http://rapidshare.com/files/56345797/TSQL05_P01_C02_L07.wmv

http://rapidshare.com/files/56344297/TSQL05_P01_C03_L00.wmv
http://rapidshare.com/files/56344645/TSQL05_P01_C03_L01.wmv
http://rapidshare.com/files/56346094/TSQL05_P01_C03_L02.wmv
http://rapidshare.com/files/56345708/TSQL05_P01_C03_L03.wmv
http://rapidshare.com/files/56345299/TSQL05_P01_C03_L04.wmv
http://rapidshare.com/files/56345116/TSQL05_P01_C03_L05.wmv
http://rapidshare.com/files/56345871/TSQL05_P01_C03_L06.wmv
http://rapidshare.com/files/56344226/TSQL05_P01_C03_L07.wmv

Part2
http://rapidshare.com/files/56347494/TSQL05_P02_C01_L00.wmv
http://rapidshare.com/files/56350511/TSQL05_P02_C01_L01.wmv
http://rapidshare.com/files/56350997/TSQL05_P02_C01_L02.wmv
http://rapidshare.com/files/56348537/TSQL05_P02_C01_L03.wmv
http://rapidshare.com/files/56350392/TSQL05_P02_C01_L04.wmv
http://rapidshare.com/files/56349477/TSQL05_P02_C01_L05.wmv
http://rapidshare.com/files/56347748/TSQL05_P02_C01_L06.wmv
http://rapidshare.com/files/56350510/TSQL05_P02_C01_L07.wmv
http://rapidshare.com/files/56349263/TSQL05_P02_C01_L08.wmv
http://rapidshare.com/files/56349448/TSQL05_P02_C01_L09.wmv
http://rapidshare.com/files/56348668/TSQL05_P02_C01_L10.wmv
http://rapidshare.com/files/56349540/TSQL05_P02_C01_L11.wmv

http://rapidshare.com/files/56347205/TSQL05_P02_C02_L00.wmv
http://rapidshare.com/files/56351012/TSQL05_P02_C02_L01.wmv
http://rapidshare.com/files/56349147/TSQL05_P02_C02_L02.wmv
http://rapidshare.com/files/56348591/TSQL05_P02_C02_L03.wmv
http://rapidshare.com/files/56350381/TSQL05_P02_C02_L04.wmv
http://rapidshare.com/files/56348847/TSQL05_P02_C02_L05.wmv
http://rapidshare.com/files/56347745/TSQL05_P02_C02_L06.wmv
http://rapidshare.com/files/56350474/TSQL05_P02_C02_L07.wmv

http://rapidshare.com/files/56347117/TSQL05_P02_C03_L00.wmv
http://rapidshare.com/files/56350193/TSQL05_P02_C03_L01.wmv
http://rapidshare.com/files/56348132/TSQL05_P02_C03_L02.wmv
http://rapidshare.com/files/56347704/TSQL05_P02_C03_L03.wmv
http://rapidshare.com/files/56349284/TSQL05_P02_C03_L04.wmv
http://rapidshare.com/files/56350272/TSQL05_P02_C03_L05.wmv

http://rapidshare.com/files/56346792/TSQL05_P02_C04_L00.wmv
http://rapidshare.com/files/56350866/TSQL05_P02_C04_L01.wmv
http://rapidshare.com/files/56349244/TSQL05_P02_C04_L02.wmv
http://rapidshare.com/files/56350855/TSQL05_P02_C04_L03.wmv
http://rapidshare.com/files/56349609/TSQL05_P02_C04_L04.wmv
http://rapidshare.com/files/56350914/TSQL05_P02_C04_L05.wmv
http://rapidshare.com/files/56351212/TSQL05_P02_C04_L06.wmv
http://rapidshare.com/files/56350646/TSQL05_P02_C04_L07.wmv

http://rapidshare.com/files/56347512/TSQL05_P02_C05_L00.wmv
http://rapidshare.com/files/56351020/TSQL05_P02_C05_L01.wmv
http://rapidshare.com/files/56351174/TSQL05_P02_C05_L02.wmv
http://rapidshare.com/files/56348435/TSQL05_P02_C05_L03.wmv

http://rapidshare.com/files/56347686/TSQL05_P02_C06_L00.wmv
http://rapidshare.com/files/56350880/TSQL05_P02_C06_L01.wmv
http://rapidshare.com/files/56349267/TSQL05_P02_C06_L02.wmv
http://rapidshare.com/files/56348695/TSQL05_P02_C06_L03.wmv
http://rapidshare.com/files/56349269/TSQL05_P02_C06_L04.wmv

http://rapidshare.com/files/56348452/TSQL05_P02_C07_L00.wmv
http://rapidshare.com/files/56350807/TSQL05_P02_C07_L01.wmv
http://rapidshare.com/files/56350833/TSQL05_P02_C07_L02.wmv
http://rapidshare.com/files/56349805/TSQL05_P02_C07_L03.wmv
http://rapidshare.com/files/56350286/TSQL05_P02_C07_L04.wmv
http://rapidshare.com/files/56350044/TSQL05_P02_C07_L05.wmv

http://rapidshare.com/files/56348605/TSQL05_P02_C08_L00.wmv
http://rapidshare.com/files/56351312/TSQL05_P02_C08_L01.wmv
http://rapidshare.com/files/56351007/TSQL05_P02_C08_L02.wmv
http://rapidshare.com/files/56350426/TSQL05_P02_C08_L03.wmv
http://rapidshare.com/files/56350132/TSQL05_P02_C08_L04.wmv
http://rapidshare.com/files/56350987/TSQL05_P02_C08_L05.wmv

Part3

http://rapidshare.com/files/56352619/TSQL05_P03_C01_L00.wmv
http://rapidshare.com/files/56354359/TSQL05_P03_C01_L02.wmv
http://rapidshare.com/files/56354110/TSQL05_P03_C01_L03.wmv
http://rapidshare.com/files/56353319/TSQL05_P03_C01_L04.wmv
http://rapidshare.com/files/56354555/TSQL05_P03_C01_L05.wmv
http://rapidshare.com/files/56354232/TSQL05_P03_C01_L06.wmv
http://rapidshare.com/files/56354106/TSQL05_P03_C01_L07.wmv
http://rapidshare.com/files/56354127/TSQL05_P03_C01_L08.wmv
http://rapidshare.com/files/56354582/TSQL05_P03_C01_L09.wmv
http://rapidshare.com/files/56354132/TSQL05_P03_C01_L10.wmv
http://rapidshare.com/files/56354583/TSQL05_P03_C01_L11.wmv
http://rapidshare.com/files/56354124/TSQL05_P03_C01_L12.wmv
http://rapidshare.com/files/56354077/TSQL05_P03_C01_L13.wmv

http://rapidshare.com/files/56353102/TSQL05_P03_C02_L00.wmv
http://rapidshare.com/files/56352910/TSQL05_P03_C02_L01.wmv
http://rapidshare.com/files/56353952/TSQL05_P03_C02_L02.wmv
http://rapidshare.com/files/56352842/TSQL05_P03_C02_L03.wmv
http://rapidshare.com/files/56352233/TSQL05_P03_C02_L04.wmv
http://rapidshare.com/files/56352925/TSQL05_P03_C02_L05.wmv
http://rapidshare.com/files/56354045/TSQL05_P03_C02_L06.wmv
http://rapidshare.com/files/56353245/TSQL05_P03_C02_L07.wmv

http://rapidshare.com/files/56352185/TSQL05_P03_C03_L00.wmv
http://rapidshare.com/files/56353647/TSQL05_P03_C03_L01.wmv
http://rapidshare.com/files/56353444/TSQL05_P03_C03_L02.wmv
http://rapidshare.com/files/56352616/TSQL05_P03_C03_L03.wmv
http://rapidshare.com/files/56354781/TSQL05_P03_C03_L04.wmv
http://rapidshare.com/files/56352812/TSQL05_P03_C03_L05.wmv
http://rapidshare.com/files/56353743/TSQL05_P03_C03_L06.wmv

http://rapidshare.com/files/56352734/TSQL05_P03_C04_L01.wmv
http://rapidshare.com/files/56354622/TSQL05_P03_C04_L02.wmv
http://rapidshare.com/files/56354426/TSQL05_P03_C04_L03.wmv
http://rapidshare.com/files/56354457/TSQL05_P03_C04_L04.wmv

http://rapidshare.com/files/56352838/TSQL05_P03_C05_L01.wmv
http://rapidshare.com/files/56353179/TSQL05_P03_C05_L03.wmv

Learning SQL Server 2008 Reporting Services

Jayaram Krishnaswamy, "Learning SQL Server 2008 Reporting Services"
Packt Publishing | 2009 | ISBN: 1847196187 | 510 pages | PDF | 13,5 MB

A step-by-step guide to getting the most of Microsoft SQL Server Reporting Services 2008
Everything you need to create and deliver data-rich reports with SQL Server 2008 Reporting Services as quickly as possible
Packed with hands-on-examples to learn and improve your skills
Connect and report from databases, spreadsheets, XML Data, and more
No experience of SQL Server Reporting Services required
In Detail

Microsoft SQL Server Reporting Services 2008 is the third generation Microsoft reporting software that is more tightly integrated with SQL Server 2008 than ever before. It provides a complete server-based platform that is designed to support a wide variety of reporting needs, including managed enterprise reporting, special purpose reporting, embedded reporting, and web-based reporting.

Ideal for beginners who need to create reports as quickly as possible, this book will lead you through practical examples to teach you a full range of skills for reporting with SQL Server 2008 Reporting Services. A series of carefully picked exercises help you practice the most important aspects of report creation. By the end of the book, you will have the confidence to take on the most complex of reports, and be producing reports that will make you the envy of your organization.

What you will learn from this book?
Install SQL Server 2008 and configure the SQL Server Reporting Services
Learn the various components and tools that enable end-to-end support for all reporting activities
Use the report viewer control to get started with the essentials of retrieving and displaying data
Create a Report Model using the Visual Studio 2008 Template
Learn to modify reports on a report server and create linked files with report manager
Embed Microsoft Report Viewer Controls in web and Windows applications
Create interactive reports with charts and gauges using Report Builder
Create several kinds of reports with Report Builder 2.0
Create server reports and report models and deploy them
Get the full details of available programming interfaces and their usage
Learn to work with Crystal Reports 2008
Import reports created using MS Access
Learn how to use the Programming API, convert Report file types, use command-line utilities and more..

Download:
Link_1
Or
Link_2

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)

John L. Viescas, Michael J. Hernandez "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (2nd Edition)"

Addison-Wesley Professional | 2007-10-04 | ISBN: 0321444434 | 672 pages | PDF | 2,3 MB

Download:
Link_1

SQL: Practical Guide for Developers

Michael J. Donahoo, Gregory D. Speegle "SQL: Practical Guide for Developers"
Morgan Kaufmann | 2005-08-01 | ISBN: 0122205316 | 272 pages | PDF | 1,4 MB

Would the basics of SQL querying be useful to you, but you dont want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.

+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.
+ The approach is vendor-neutralso very adaptable and flexiblebut the book's Web site includes information about DBMS-specific peculiarities.
+ The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.
+ Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.
+ SQL 2003-compliant.

Download:
Link_1

Microsoft SQL Server Black Book

Patrick Dalton, Microsoft SQL Server Black Book
Coriolis Group Books | ISBN: 1576101495 | 1997 | PDF | 464 pages | 3.33 MB

Teaches, with step-by-step guides, the most important SQL Server tasks. Troubleshoots common database and client-server problems. Improves performance with sophisticated SQL Server tuning techniques. Develops powerful database features that can easily be integrated into your current database system. Uses ready-to-run database examples and SQL code.

Download:
Link_1
Or
Link_2

Introduction to SQL: Mastering the Relational Database Language ,4 Ed

Rick F. van der Lans, "Introduction to SQL: Mastering the Relational Database Language ,4 Ed"
Addison-Wesley Professional; 4 ed | 2006 | ISBN: 0321305965 | 1056 pages | CHM | 4,5 MB

The Classic SQL Tutorial: Fully Updated for Today’s Standards and Today’s Top Databases
For twenty years, van der Lans’ Introduction to SQL has been the definitive SQL tutorial for database professionals everywhere, regardless of experience or platform. Now van der Lans has systematically updated this classic guide to reflect the latest SQL standards and the newest versions of today’s leading RDBMSs: Oracle, Microsoft SQL Server, DB2, and MySQL.
Using case study examples and hands-on exercises, van der Lans illuminates every key SQL concept, technique, and statement. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why SQL works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer or DBA, a student or veteran, this book will take you from “apprentice” to true SQL master.
Writing queries and updating data: all you need to know about SELECT
Working with joins, functions, and subqueries
Creating database objects: tables, indexes, views, and more
Specifying keys and other integrity constraints
Using indexes to improve efficiency
Enforcing security via passwords and privileges
Building stored procedures and triggers
Developing with embedded SQL and ODBC
Working with transactions, including rollbacks, savepoints, isolation levels, and more
Optimizing performance by reformulating SQL statements
Using object-relational features: subtables, references, sets, and user-defined data types
Reference section: SQL statement definitions and SQL function lists..

Download:
Link_1
Or
Link_2

Professional SQL Server 2005 Performance Tuning (Programmer to Programmer)

Steven Wort, Christian Bolton, Justin Langford, Michael Cape, Joshua J. Jin, Douglas Hinson, Haidong Ji, Paul A. Mestemaker, Arindam Sen, "Professional SQL Server 2005 Performance Tuning (Programmer to Programmer)"
Wrox | 2008-01-29 | ISBN: 0470176393 | 551 pages | PDF | 9,7 MB

Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. The book first walks you through how to discover bottlenecks when something is wrong and you’ll then learn how to identify and remove the problems that are causing poor performance. You’ll discover preventive measures you can take to try to avoid a performance problem entirely and you’ll learn how to achieve better performance.

Download:
Link_1

Professional Microsoft SQL Server 2008 Programming

Robert Vieira, "Professional Microsoft SQL Server 2008 Programming"
Wrox | 2009 | ISBN: 0470257024 | 936 pages | PDF | 8,8 MB

Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming. Review the new features of SQL Server that will be of interest to you as an experienced developer and move on to more detailed, practical code examples. Learn how to write complex queries, build different types of data structures, improve application speed and performance, manage advanced scripting and errors, and design advanced databases the latest edition of this valuable programming guide.

Download:
Link_1
Or
Link_2

High Performance Oracle Database Automation: Creating Oracle Applications with SQL and PL/SQL

Jonathan Ingram, High Performance Oracle Database Automation: Creating Oracle Applications with SQL and PL/SQL

Coriolis Group Books | ISBN: 1576101525 | 1997 | PDF | 448 pages | 1.14 MB

Emphasizes application development skills-not Oracle product internals or syntax. Covers strong use of Oracle's PL/SQL extensions. Includes in-depth coverage of the Oracle exception handling mechanism. Offers advice on design and testing rarely found in Oracle books. Provides coding standards and explains why they're important. Contains numerous examples of all the logical structures in PL/SQL.

Download:
Link_1
Or
Link_2

Microsoft SQL Server 2008 A Beginner's Guide

Microsoft SQL Server 2008 A Beginner's Guide/by Dusan Petkovic (Author) DescriptionGet Started on Microsoft SQL Server 2008 in No TimeLearn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered. * Set up, configure, and maintain SQL Server 2008* Build and manage database objects using Transact-SQL statements* Create stored procedures and user-defined functions* Optimize database performance, availability, and reliability* Implement solid security using authentication, encryption, and authorization* Automate tasks using SQL Server Agent* Create reliable data backups and perform flawless system restores* Use all-new SQL Server 2008 Business Intelligence, development, and administration tools* Learn in detail the SQL Server XML technology (SQLXML)
Download:http://w14.easy-share.com/1701851149.html
http://depositfiles.com/files/8481174http://rapidshare.com/files/152436769/How_Comp_Work_8Ed.rar

Apress : Accelerated SQL Server 2008

Apress : Accelerated SQL Server 2008

Download:
Link_1

MCTS: Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431

MCTS: Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431
By Joseph L. Jorden, Dandy Weyn

Publisher: Sybex
Number Of Pages: 634
Publication Date: 2006-07-19
ISBN-10 / ASIN: 0470025654
ISBN-13 / EAN: 9780470025659
Binding: Paperback

Product Description:
With the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. The Microsoft SQL Server 2005
Implementation and Maintenance exam (70-431) is the first stop for everyone entering this new certification track, and serves as both a single exam certification as well as the entry exam for the MCITP-level certifications. This book provides an introduction to the development and administrative aspects of SQL Server 2005 and features practical guidance for all aspects of the exam.
Get a great start in your certification process today with this comprehensive guide which includes:

Hundreds of challenging practice questions plus two bonus exams
Leading-edge exam preparation software, including a test engine
Authoritative coverage of all key exam objectives, including:
Installing and Configuring SQL Server 2005
Implementing High Availability and Disaster Recovery
Supporting Data Consumers
Maintaining Databases
Monitoring and Troubleshooting SQL Server Performance
Creating and Implementing Database Objects

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Download:
Link_1

MCITP Developer: Microsoft SQL Server 2005 Data Access Design and Optimization Study Guide: Exam 70-442

MCITP Developer: Microsoft SQL Server 2005 Data Access Design and Optimization Study Guide: Exam 70-442
By Marilyn Miller-White, Cristian Andrei Lefter

Publisher: Sybex
Number Of Pages: 632
Publication Date: 2007-04-02
ISBN-10 / ASIN: 0470108800
ISBN-13 / EAN: 9780470108802
Binding: Paperback

Product Description:
As your essential guide to Microsoft’s new SQL Server 2005 certification (exam 70-442), this book offers you practical and in-depth coverage. Full coverage of all exam objectives is presented in a systematic approach so you can be confident you’re getting the instruction you need for the exam. Plus, practical hands-on exercises reinforce critical skills and real-world scenarios put what you’ve learned in the context of actual job roles. Finally, challenging review questions in each chapter prepare you for exam day.

Download:
Link_1

MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design 70-441

MCITP Developer: Microsoft SQL Server 2005 Database Solutions Design
By Victor Isakov

Publisher: Sybex
Number Of Pages: 608
Publication Date: 2006-09-25
ISBN-10 / ASIN: 0470040521
ISBN-13 / EAN: 9780470040522
Binding: Paperback

Product Description:
This comprehensive book guides readers through Microsoft's brand- new SQL 2005 certification: Microsoft Certified IT Professional Developer for SQL Server 2005 (Exam 70441)
Topics covered include writing SQL queries, designing and implementing programming objects, database optimization, designing databases at both the conceptual and logical levels, and implementing databases at the physical level
Aimed at candidates for this exam, namely professional database developers who are responsible for designing and implementing database solutions using SQL Server 2005
The CD-ROM features leading-edge exam prep software with test engine plus hundreds of practice questions and electronic flashcards

Download:
Link_1

MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance Exam 70-444 Study Guide

MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
By Victor Isakov, Marilyn Miller-White, J. Steven Jones, Andy Warren

Publisher: Sybex
Number Of Pages: 647
Publication Date: 2007-07-10
ISBN-10 / ASIN: 0470127457
ISBN-13 / EAN: 9780470127452
Binding: Paperback

Product Description:
Covering Microsoft’s brand-new SQL 2005 administrator exam, this study guide walks you through setting up, maintaining, and troubleshooting database solutions. You’ll review key topics such as defining high-availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and designing and executing deployments. Plus, the CD-ROM features leading exam prep software with an assessment test, test engine of case study practice questions, and electronic flashcards.

Download:
Link_1

MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server(TM) 2005

Publisher: Microsoft Press
Number Of Pages: 656
Publication Date: 2007-09-12
ISBN-10 / ASIN: 0735623422
ISBN-13 / EAN: 9780735623422
Binding: Paperback

Download:
Link_1

Head First SQL: Your Brain on SQL — A Learner’s Guide (Head First)

Is your data dragging you down? Are your tables all tangled up? Well we’ve got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep.

Maybe you’ve written some simple SQL queriesHead First SQL will show you the fundamentals of SQL and how to really take advantage of it. We’ll take you on a journey through the language, from basic INSERT statements and SELECT queries to hardcore database manipulation with indices, joins, and transactions. We all know “Data is Power” - but we’ll show you how to have “Power over your Data”. Expect to have fun, expect to learn, and expect to be querying, normalizing, and joining your data like a pro by the time you’re finished reading!, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, to interact with databases. But now you want more, you want to really dig into those databases and work with your data.

Download:
Link_1
or
Link_2

Pro SQL Server 2008 Service Broker

Publisher: Apress
Number Of Pages: 600
Publication Date: 2008-07-24
ISBN-10 / ASIN: 1590599993
ISBN-13 / EAN: 9781590599990
Binding: Hardcover

Product Description:
Service Broker is a key Microsoft product in support of message–based processing between applications. Pro SQL Server 2008 Service Broker helps you to take full advantage of this key Microsoft technology, beginning from the fundamentals, moving through installation and application development, and ultimately showing you how to develop highly available and scalable applications based upon the Service–Oriented Architecture that is fast gaining ground as the way forward in application development.
Comprehensive approach to developing with Service Broker
Strong focus on best practices and real–world scenarios
Covers the key aspects of distributed application design

Download:
Link_1

SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach

Publisher: Apress
Number Of Pages: 872
Publication Date: 2008-07-23
ISBN-10 / ASIN: 1590599802
ISBN-13 / EAN: 9781590599808
Binding: Paperback

Product Description:
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.
Focused on solutions: Look up what you need to do. Learn how to do it. Do it.

Download:
Link_1