SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach

  • 13h 4m
  • Joseph Sack
  • Apress
  • 2006

Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL–related features. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a DBA or developer.

This “no-fluff” desk reference offers direct access to the information you need to get the job done. It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance. It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimum of background theory.

Additionally, this book provides “how-to” answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005. It also features concise T-SQL syntax examples, and you can use the book to prepare for a SQL Server-related job interview or certification test.

About the Author

JOSEPH SACK is an independent consultant based in Minneapolis, Minnesota. Since 1997, he has been developing and supporting SQL Server environments for clients in the financial services, multimedia distribution, IT consulting, manufacturing, and real estate industries. Joseph received his bachelor’s degree in psychology from the University of Minnesota. He is the author of SQL Server 2000 Fast Answers for DBAs and Developers and is a Microsoft Certified Database Administrator (MCDBA).

In this Book

  • Select
  • Insert, Update, Delete
  • Transactions, Locking, Blocking, and Deadlocking
  • Tables
  • Indexes
  • Full-Text Search
  • Views
  • SQL Server Functions
  • Conditional Processing, Control-of-Flow, and Cursors
  • Stored Procedures
  • User-Defined Functions and Types
  • Triggers
  • CLR Integration
  • XML
  • Web Services
  • Error Handling
  • Principals
  • Securables and Permissions
  • Encryption
  • Service Broker
  • Configuring and Viewing SQL Server Options
  • Creating and Configuring Databases
  • Database Integrity and Optimization
  • Maintaining Database Objects and Object Dependencies
  • Database Mirroring
  • Database Snapshots
  • Linked Servers and Distributed Queries
  • Performance Tuning
  • Backup and Recovery
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book MySQL Crash Course: A Hands-on Introduction to Database Development
Book Job Ready SQL
Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition