Skip to main content

Murach's SQL Server 2008 for Developers

by Bryan Syverson and Joel Murach
22 chapters, 778 pages, 336 illustrations
ISBN: 978-1-890774-51-6

When we published the first edition of this book, we heard from plenty of developers who were just starting out using Microsoft SQL Server and found this to be a great book for training.
But we also heard from a lot of experienced developers who read it and were amazed to discover how much they didn't know about SQL. That's why we've dubbed this book "the SQL book that most developers don't even know they need."
So whether you're new to SQL...or whether you've been squeaking by with the SQL you know, never realizing how much you're missing out on...this is the book for you.

For example, you'll learn:

  • How to create complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less
  • What the different data types are and how to handle the common problems you run into with various types of data
  • How to work with XML data
  • How to take advantage of powerful backend database features like views, scripts, stored procedures, and triggers
  • How to deal with database control features like cursors, transactions, and locking
  • The basics of database design and implementation using the Management Studio or SQL DDL statements (you can write more efficient queries when you know something about how databases are set up…and you can start to see what your DBA has to think about, if that's a career path that interests you)
  • How to use the CLR integration feature to create database objects using C# or Visual Basic code 


What's NEW in this 2008 edition

This new edition now covers the 2008 features that make a developer's job easier:
  • The FILESTREAM storage feature allows you to work more efficiently with binary large objects (BLOBs) such as image, sound, and video files.
  • The MERGE statement allows you to use a single statement to make multiple updates and insertions.
  • The date, time, datetime2, and datetimeoffset data types give you more flexibility and precision for working with dates and times.
  • The user-defined table type allows you to pass a table as a parameter to a stored procedure or a function - a feat that previously required custom coding and often resulted in code that was difficult to maintain.
  • In terms of database design, the SPARSE attribute can help you work with NULL values more efficiently, and filtered indexes can allow you to retrieve data more quickly.
Beyond that, this book covers many other 2008 features that you'll find useful in specific situations. And, of course, the code presented in this book has been thoroughly updated and tested against SQL Server 2008.

Ready to master all of this?

Then let SQL Server 2008 for Developers quickly boost you to a new level of competence and professionalism.

download link :http://www.4shared.com/document/pM0n1nCw/Murach_SQL_Server_2008_for_Dev.html
Labels:

Comments

Post a Comment

Popular posts from this blog

Download Facebook or Youtube Videos Without Any Tools

                Have you ever liked a video shared by your friend on facebook and wanted to download it…Well this this tutorial is not only for facebook or youtube instead it can be used for any video streaming website like metacafe,dailymotion,veoh or yahoo videos.There are websites on the internet that will convert your video link into a download link but it has the following drawback
Post a Comment
Read more

How To Remove “Error Deleting File or Folder”

It is a very common and annoying message that the file or folder you are trying to deleted cannot be deleted or thependrive cannot be removed as it is used by the system.In this tutorial I will show how to remove your pendrive or delete the files and folders if you get such an error.This error has various flavours and it can be of any of the following types:
Post a Comment
Read more

What is the term Multiplexing in data transmission ?

  Multiplexing is the technique of combining multiple signals into a single signal for transmission over a communication channel. In data transmission, multiplexing allows multiple users to share a single communication channel, maximizing its use and increasing efficiency. There are several types of multiplexing used in data transmission, including: Frequency Division Multiplexing (FDM): This technique divides the available frequency range into multiple non-overlapping sub-channels, each of which can be used by a separate signal. Each signal is modulated onto a separate carrier frequency and combined into a single composite signal for transmission. FDM is commonly used in analog systems, such as radio and television broadcasting. Time Division Multiplexing (TDM): This technique divides the available time into multiple time slots, with each slot dedicated to a separate signal. Each signal is transmitted in its designated time slot, and the signals are interleaved in time to create a com
Post a Comment
Read more