Professional Microsoft SQL Server 2008 Programming

Description

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.

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Similar books

• 

  Beginning Microsoft SQL Server 2008 Programming

  By Robert Vieira

  With this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.

• 

  Programming Microsoft SQL Server 2008

  By Andrew Brust, Leonard G. Lobel, Stephen Forte

  This is a must-read for Microsoft .NET and SQL Server developers who work with data access—at the database, business logic, or presentation levels.

• 

  Microsoft SQL Server 2008 Step by Step

  By Mike Hotek

  Teach yourself SQL Server 2008—one step at a time.

• 

  Professional SQL Server 2005 Administration

  By Brian Knight, Ketan Patel, Wayne Snyder

  Visual Studio 2003 used to do this very well, but the deployment feature was removed in Visual Studio 2005 until the Team System version. At the time of the publication of this book, Visual Studio Team System for Database Professionals ...

• 

  Professional Microsoft SQL Server 2008 Reporting Services

  By Paul Turley, Ken Withee, Bryan C. Smith

  This hands-on guide will show you how to harness the full power of Reporting Services to create reporting and business intelligence solutions that meet your company's needs.

• 

  Professional Microsoft SQL Server 2008 Integration Services

  By Brian Knight, Erik Veerman, Grant Dickinson

  The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS) Renowned author Brian Knight and his expert coauthors ...

• 

  Microsoft SQL Server 2008 Administration with Windows PowerShell

  By Ananthakumar Muthusamy, Yan Pan

  The definitive guide to automating SQL Server admnistration with Powershell scripts If you're a SQL Server database administrator, this book will make your life easier.

• 

  Pro SQL Server 2008 Service Broker

  By Klaus Aschenbrenner

  Pro SQL Server 2008 Service Broker helps you to take full advantage of this key Microsoft technology, beginning from the fundamentals, moving through installation and application development, and ultimately showing you how to develop highly ...

• 

  Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution

  By Brian Knight, Erik Veerman, Jessica M. Moss

  Shows you how to design SSIS solutions for data cleansing, ETLand file management Demonstrates how to integrate data from a variety of datasources, Shows how to monitor SSIS performance, Demonstrates how to avoid common pitfalls involved ...

• 

  Beginning SQL Server 2008 for Developers: From Novice to Professional

  By Robin Dewson

  The book takes developers from the point of installing SQL Server 2008, through the process of storing, retrieving, and securing data, to the point of being able to serve up business reports using SQL Server 2008 Reporting Services.