Professional Microsoft SQL Server 2008 Programming and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Start reading Professional Microsoft SQL Server 2008 Programming on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Professional Microsoft SQL Server 2008 Programming [Paperback]

Robert Vieira

List Price: CDN$ 59.99
Price: CDN$ 30.00 & FREE Shipping. Details
You Save: CDN$ 29.99 (50%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 2 to 4 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.

Formats

Amazon Price New from Used from
Kindle Edition CDN $28.50  
Paperback CDN $30.00  

Book Description

April 27 2009 Wrox Programmer to Programmer

This book is written for SQL Server 2008. However, it does maintain roots going back a few versions and looks out for backward compatibility issues with SQL Server 2005 and SQL Server 2000. These versions are old enough that there is little to no time spent on them except in passing.

The book is oriented around developing on SQL server. Most of the concepts are agnostic to what client language you use although the examples that leverage a client language general do so in C#. For those who are migrating from early versions of SQL Server, some “gotchas” that exist any time a product has versions are discussed to the extent that they seem to be a genuinely relevant issue.

This book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused. While there is a quick reference-oriented appendix, there is very little coverage given to beginner level topics. It is assumed that you already have experience with data manipulation language (DML) statements and know the basics of the mainstream SQL Server objects (views, stored procedures, user defined functions, etc.). If you would like to brush up on your knowledge before diving into this book, the author recommends reading Beginning SQL Server 2008 Programming first. There is very little overlap between the Beginning and Professional books and they are designed to work as a pair.


Customers Who Bought This Item Also Bought


Product Details


Product Description

From the Back Cover

By incorporating significant improvements to the core components of the database engine, Microsoft SQL Server 2008 will change the way you build database applications. Written by one of the leading authorities on SQL Server, Professional Microsoft SQL Server 2008 Programming will help you master this increasingly complex feature set so that you can manage data more efficiently.

Robert Vieira discusses the new features of SQL Server 2008 and progresses to more detailed, practical code examples. He then shows you how to write complex queries, build different data structures, and improve application performance. Plus, you'll discover how to manage advanced scripting and databases, as well as how to identify and correct scripting errors.

This book provides you with the information you need to quickly create and deploy data-driven solutions to meet your business needs. It covers everything from the new data types and indexing structures to the manageability features and advanced time zone handling so that you can get the most out of your database.

What you will learn from this book

  • Techniques for taking data design beyond normalization
  • Ways to ensure that your application is running at optimum speed

  • All about stored procedures and user defined functions

  • Advanced methods for handling stored procedures

  • How to utilize Reporting Services and Integration Services

  • Tips for making your database more secure

  • How to take advantage of XML and XQuery support

  • Steps for modifying specific data values to perform speculative analysis

Who this book is for
This book is for experienced SQL Server developers who want to learn how to take advantage of all the new features in the latest release.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

About the Author

Experiencing his first infection with computing fever in 1978, Rob Vieira knew right away that this was something ‘‘really cool.’’ In 1980 he began immersing himself into the computing world more fully — splitting time between building and repairing computer kits, and programming in BASIC as well as Z80 and 6502 assembly. In 1983, he began studies for a degree in Computer Information Systems, but found the professional mainframe environment too rigid for his tastes and dropped out in 1985 to pursue other interests. Later that year, he caught the "PC bug" and began the long road of programming in database languages from dBase to SQL Server. Rob completed a degree in business administration in 1990 and since has typically worked in roles that allow him to combine his unique knowledge of business and computing. Beyond his bachelor’s degree, he has been certified as a Certified Management Accountant (CMA); Microsoft Certified as a Solutions Developer (MCSD), Trainer (MCT), and Database Administrator (MCDBA); and even had a brief stint certified as an EmergencyMedical Technician (EMT).
Rob is currently the Database Team Lead for Stockamp, a Huron Consulting Group practice. He has published six books on SQL Server development

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.7 out of 5 stars  9 reviews
7 of 7 people found the following review helpful
4.0 out of 5 stars A good SQL Programming Reference Book Nov. 23 2009
By Sudheer K. Maharana - Published on Amazon.com
Format:Paperback
Professional Microsoft SQL Server 2008 Programming from Wrox is a well formatted programming reference book for medium to advanced SQL Developers. The chapters are laid out well with useful examples. Especially, I liked the chapters on XML Integration, Advanced Queries, Index structure and Transaction & Locks. I will suggest this book to anyone who is from other RDBMS background to get up and running with programming in SQL Server. However, I was looking for information in Service Broker in detail as this is one of the programming areas which scales SQL Server to different level. Chapters such as Replication, Performance Tuning, Data Warehousing and Reporting were not explained in great detail. However the book solves it's purpose to provide a general guideline on SQL Server 2008 programming.

I will recommend this book for other SQL Server professionals who want to understand the new programming features in SQL Server 2008 and also keep this book as reference in their SQL Server library
1 of 1 people found the following review helpful
5.0 out of 5 stars very good book March 19 2012
By skizha - Published on Amazon.com
Format:Paperback|Verified Purchase
Covers the topics excellently. Robert Vieira is a great author - He makes things easy to understand . i have already read the Beginners version of this book and I purchased this one because I really liked the way he teaches in the previous book.
1 of 1 people found the following review helpful
5.0 out of 5 stars Great Book Feb. 13 2012
By Antonio Fallucca - Published on Amazon.com
Format:Paperback|Verified Purchase
This book is a must it is an professional book that takes you further than most. I read it cover to cover along with the first book and I learned things I wish I had known all along. If you want to learn by doing and want to have the examples work and explained this is the book. Helpful and easy to read plus being well connected is online and kept up to date. I would recomend this book for anyone library collection and reference.
4.0 out of 5 stars Yet again... False Advertising! Missing Chapter 25!!! Feb. 23 2014
By Marcelino Lemus - Published on Amazon.com
Format:Paperback|Verified Purchase
What is going on with you guys? If the table-of-contents says there are 25 chapters, then the physical book better have TWENTY-FIVE chapters!!!!!

Geez!!!!
5.0 out of 5 stars It is one of my favorite reference books July 7 2013
By Michael Barash - Published on Amazon.com
Format:Paperback
This book has helped me to remember or re-learn the basic details for SSMS 2008. I find myself going back to it daily before I even check a programmer's blog for the basics on some topic I don't remember the 'exact' syntax or usage. The book is well written so that you can read it cover to cover. I recommend it if you already familiar with SQL as a user, but now you need to act more like a DBA.
ARRAY(0xb39b1810)

Look for similar items by category


Feedback