Crib 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
About the Authors
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 firstname.lastname@example.org.
Prasanna contributed Chapters 9 and 10
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 (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
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 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