SQLServerCentral Article

SQL Server Crib Sheet Compendium


Simple-Talk Series
SQL Server Crib SheetsSQL Server Crib Sheet Compendium by Amirthalingam Prasanna, Grant Fritchey, Phil Factor, Robert Sheldon, Robyn Page

(1st Edition, December 2008)

Download eBook (PDF): Free

" As a developer, DBA or manager, you may not want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is from the 'jungle roof'." -- Tony Davis (Ed.)

View Table of Contents

View Sample Chapter

View Related Books:

Editorial ReviewCrib Sheets aim to give you the broad view. Each one tackles a key area of database development, administration or deployment and provides both a management view and a technical view of that topic. Each starts with the business reasons that will underpin a certain technology requirement and then moves on to the methods available to implement them. A Crib Sheet is not about code solutions – see the Simple-Talk Workbench series for that – but about providing a good understanding of all the core concepts and terminology that surround a given technology or discipline. The aim is to cover each topic in just enough detail to perform a given function, no more.

This book contains a collection of Simple-Talk Crib Sheets published between 2006 and 2008. It focuses on SQL Server topics, but also covers  two .NET issues that are relevant to all SQL Server developers and DBAs:

  • SQL Server Security
  • SQL Server XML
  • SQL Server Reporting Services
  • SQL Server Data Warehousing
  • SQL Server Database Backups
  • SQL Server Performance
  • SQL Server Replication
  • Entity Framework
  • .NET Performance

About the Authors

Amirthalingam Prasanna

Prasanna is a software engineer, technical author and trainer with over seven years' experience in the software development industry. He is a Microsoft MVP in the Visual developer category, a MCT and a MCPD on enterprise application development. You can read his blog at www.prasanna.ws and e-mail him at feedback@prasanna.ws.

Prasanna contributed Chapters 9 and 10

Grant Fritchey

Grant is a database administrator for a major insurance company. He has 18 years' experience in IT, including time spent in support and development. He has been working with SQL Server since version 6.0 back in 1995. He worked with Sybase for a few years. He has developed in VB, VB.Net, C# and Java. He is currently working on methods for incorporating Agile development techniques into database design and development at his company.

Grant contributed Chapter 7

Phil Factor

Phil Factor (real name withheld to protect the guilty), aka Database Mole, has 20 years of experience with database-intensive applications. Despite having once been shouted at by a furious Bill Gates at an exhibition in the early 1980s, he has remained resolutely anonymous throughout his career.

Phil contributed to Chapters 1, 2, 3, 6 and 8

Robert Sheldon

After being dropped 35 feet from a helicopter and spending the next year recovering, Robert Sheldon left the Colorado Rockies and emergency rescue work to pursue safer and less painful interests – thus his entry into the world of technology. He is now a technical consultant and the author of numerous books, articles and training material related to Microsoft Windows, various relational database management systems, and business intelligence design and implementation. He has also written news stories, feature articles, restaurant reviews, legal summaries and the novel Dancing the River Lightly. You can find more information at http://www.rhsheldon.com.

Robert contributed Chapters 4 and 5

Robyn Page

Robyn Page is a consultant with Enformatica and USP Networks. She is also a well-known actress, being most famous for her role as Katie Williams, barmaid in the Television Series Family Affairs.

Robyn contributed to Chapters 1, 2, 3, 6 and 8

Book Details

Paperback: 150 pages

Publisher: Red Gate Books


You rated this post out of 5. Change rating




You rated this post out of 5. Change rating