SQL Server 2008 Transact-SQL Recipes

Microsoft SQL Server 2008 Management and Administration 

by Ross Mistry, Hilary Cotter

If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's f...

Price:  $9.87  |  Publisher:  SAMS Publishing  |  Release:  2008

Pro Full-Text Search in SQL Server 2008 

by Hilary Cotter, Michael Coles

Businesses today want actionable insights into their data - they want their data to reveal itself to them in a natural and user-friendly form. What could be more natural than human language? Natural-language search is at the center of a storm of ever - increasing web-driven demand for human-computer communication and information access. S...

Price:  $26.72  |  Publisher:  Apress  |  Release:  2008

Microsoft SQL Server 2008 R2 Administration Cookbook 

by Satya Shyam K Jayanty

Provides Advanced Administration techniques for SQL Server 2008 R2 as a book. Covers the essential Manageability, Programmability, and Security features. Emphasizes important High Availability features and implementation. Explains how to maintain and manage the SQL Server data platform effectively....

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2011

Beginning Microsoft SQL Server 2008 Administration 

by Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. The material covers system installation a...

Price:  $5.17  |  Publisher:  Wrox  |  Release:  2009

Professional SQL Server 2008 Internals and Troubleshooting 

by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort

When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together - and simplifies - practical internal information concerning SQL Server along with troubles...

Price:  $5.49  |  Publisher:  Wrox  |  Release:  2010

Exam Ref 70-761 Querying Data with Transact-SQL 

by Itzik Ben-Gan

Prepare for Microsoft Exam 70-761 - and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA le...

Price:  $34.25  |  Publisher:  Microsoft Press  |  Release:  2017

A Developer's Guide to Data Modeling for SQL Server 

by Eric Johnson, Joshua Jones

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL...

Price:  $6.15  |  Publisher:  Addison-Wesley  |  Release:  2008

Expert SQL Server Transactions and Locking 

by Dmitri Korotkevitch

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you devel...

Price:  $24.23  |  Publisher:  Apress  |  Release:  2018