Volume I
One of the attractive aspects of being a Microsoft SQL Server Database Administrator (DBA) is that unlike most other technical occupations where you must constantly learn new ways of doing things because the previous methods become deprecated as technologies are created, SQL Server evolves in such a way that the new learning is built on top of previous knowledge and techniques that continue to be valid. Most queries that have been around since SQL Server was created still work.
The tips, techniques, solutions and other information provided in this book are based on published and unpublished best practice advice along with experiences from years of managing SQL Server.
There are many excellent books and websites that contain a wealth of information about SQL Server and the technical workings of it. I highly recommend reading as many as you can. The focus of this book is to provide a condensed overview of most of the day-to-day knowledge items needed to manage SQL Server in an easy to find format.
Disclaimer
This information is provided "AS IS" with no warranties and
confers no rights. Use of any included information and script
samples are the sole responsibility of the user.
The author is
not responsible for any losses or damage resulting from using the
information provided in the book. The techniques and scripts have
been used and fit most or many environments and situations, but
there is no guarantee that they are the best fit for all cases. Use
at your own risk.
When it comes to determining what are the best techniques for a particular situation the answer is "It depends". Because of the various variables and circumstances, not all techniques and solutions fit every situation or problem. It is always best to test and monitor changes being made to ensure that the changes provide the desired results.
Volume I - Contents
- Introduction to SQL Server
- SQL Server Management Studio Basics
- T-SQL Code - Part 1
- T-SQL Code - Part 2
- T-SQL Code - Part 3
- User Defined Objects