Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Beginning SQL Server 2000 Programming

By Esteban Garcia,

In this book, the author targets the beginner SQL Server Programmer by taking a very simple approach to it. He starts by going through the process of setting up SQL Server 2000 and then continues by gradually introducing various new concepts that help the reader understand and master the subject.

The book includes a 120-Day Enterprise Evaluation Edition of SQL Server 2000, which is very useful for someone who is trying to decide between different database products, or someone who is not ready to buy the software until feeling comfortable with it. It touches on every aspect of database programming, but without getting into so much detail that it would confuse someone trying to understand the basics.

These are some of the topics that ‘Beginning SQL Server 2000 Programming’ covers:

  • SQL Server Installation and Management
  • SQL Server Tools
  • Creating Databases and Components
  • Data manipulation

The chapters are filled with examples, and the user is encouraged to follow along as the author demonstrates how to use the different tools to manage the sample database. I feel like the author did a great job of balancing between what programmers and administrators want to know. A great deal of time was spent on maintenance issues such as setting up the server, performing backups and recovery, and managing SQL Server through Enterprise Manager. At the same time, the reader will learn how to insert and retrieve data, create stored procedures, build views, and use triggers. Towards the end of the book, the author touches on the topic of XML, but very briefly. This chapter gives the reader enough knowledge in the subject to create simple solutions.

There is an appendix that goes over the steps of upgrading from Microsoft Access to SQL Server. I would like to have seen more on this topic because I believe that a big percentage of the readers of this book will be making the jump from Access.

Overall, I found this book to be very accurate and thorough. If you have worked with previous versions of SQL Server, this book is not for you, I would recommend looking into a more advanced book since you will not need to learn the basics. If you are in the process of trying to determine if SQL Server would be the right tool for your application or you are trying to jump into the field of database development then I would definitely recommend this book as one of your primary sources of information.

Total article views: 3934 | Views in the last 30 days: 0
 
Related Articles
FORUM

Database Reader Permission

Query for Database Reader Permission to a Login

FORUM

Log Reader Agent Blocking

Log Reader Agent Blocking

BLOG

ALTER AUTHORIZATION sql to change owner of a database

ALTER AUTHORIZATION changes the ownership of  entities .  Server level entity ownership can be chang...

ARTICLE

A SQL Server Log Reader

There's a hole in the SQL Server platform. No log reader comes with the product and Steve Jones thin...

FORUM

Error after restoring a Replicated Database and starting the Log Reader Again...

Error after restoring a Replicated Database and starting the Log Reader Again...

Tags
book reviews    
reviews    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones