Acheter neuf

Identifiez-vous pour activer la commande 1-Click.
Acheter d'occasion
D'occasion - Très bon Voir les détails
Prix : EUR 3,40

Plus de choix
Vous l'avez déjà ? Vendez votre exemplaire ici
Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible

Dites-le à l'éditeur :
J'aimerais lire ce livre sur Kindle !

Vous n'avez pas encore de Kindle ? Achetez-le ici ou téléchargez une application de lecture gratuite.

Inside Microsoft® SQL Server(TM) 2005: T-SQL Programming [Anglais] [Broché]

Itzik Ben-Gan

Prix : EUR 35,79 Livraison à EUR 0,01 En savoir plus.
  Tous les prix incluent la TVA
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
Il ne reste plus que 2 exemplaire(s) en stock.
Expédié et vendu par Amazon. Emballage cadeau disponible.
Voulez-vous le faire livrer le mardi 28 octobre ? Choisissez la livraison en 1 jour ouvré sur votre bon de commande. En savoir plus.
Il y a une édition plus récente de cet article:
Inside Microsoft® SQL Server® 2008: T-SQL Programming Inside Microsoft® SQL Server® 2008: T-SQL Programming
EUR 41,17
En stock.

Description de l'ouvrage

14 juin 2006

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the programming language—solving complex problems with real-world solutions.

Discover how to:

  • Understand when to apply set-based programming techniques
  • Design and implement date and time-related XML and CLR datatypes
  • Use temporary objects, including temporary tables, table variables, and table expressions
  • Work with T-SQL and CLR user-defined functions, stored procedures, and triggers
  • Support user input-based queries and variable data with dynamic execution
  • Work with transactions and new exception handling constructs
  • Apply a concurrency model to support simultaneous users
  • Use Service Broker for controlled asynchronous processing in database applications

      This book includes code samples on the Web.

Offres spéciales et liens associés

Descriptions du produit

Biographie de l'auteur

Dejan Sarka is MCT and MCDBA certified and a Microsoft¿ MVP for SQL Server¿. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

Détails sur le produit

En savoir plus sur les auteurs

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Dans ce livre (En savoir plus)
Parcourir les pages échantillon
Couverture | Copyright | Table des matières | Extrait | Index | Quatrième de couverture
Rechercher dans ce livre:

Vendre une version numérique de ce livre dans la boutique Kindle.

Si vous êtes un éditeur ou un auteur et que vous disposez des droits numériques sur un livre, vous pouvez vendre la version numérique du livre dans notre boutique Kindle. En savoir plus

Commentaires en ligne

Il n'y a pas encore de commentaires clients sur
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles
Commentaires client les plus utiles sur (beta) 4.3 étoiles sur 5  18 commentaires
37 internautes sur 39 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Serious SQL Programmers need this book 30 juin 2006
Par Colin Brown - Publié sur
Firstly, this is not a book for beginners or those new to T-SQL, this is targetted more towards intermediate/advanced programmers. If you're new then look at T-SQL Querying.

The level of knowledge and detail that Itzik, Dejan and Roger have and portray in this book is awesome. Do you want to know how SQL Server 2005 internally stores date/time values and what the pitfalls are that you might run into when programming against date/time values (one of the most common problems facing SQL programmers), this book has the answer.

With chapters on Stores Procedures, Transactions, temporary tables, views, the service broker and more.

Each chapter has excellent advice and knowledge and filled with sample code (available online). The book is targetted specifically at SQL Server 2005 and the new ways it handles things, new functions and commands.

My only concern and a slight one at that is that with the amount of information the authors are trying to portray in 500 pages, sometimes the reading is heavy.

An invaluable book for SQL Server 2005 programmers.
9 internautes sur 10 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Useful but COULD be much better. Needs major editorial intervention. 26 juillet 2007
Par Malleus Maleficarum - Publié sur
You should think of this book as of the second volume of the two-volume set on the 2005-Server SQL. If you get this one, you'll get the other one too; neither tome is self-sufficient; in fact there's a lot of explicit interdependence. This book, Programming, deals with slightly more esoteric features than the first tome, Querying -- although I can't say you must read the first entire volume before touching this one. Both books can be read at the same time (but see what I say about the target reader below).

So, real quick:

1. Target reader: someone with a good grasp of the 2000 Server wishing to learn the new stuff that came with the 2005 server (there's a lot: the 2005 product is _much_ better than the previous: covering new features is probably the only thing that's unequivocally good about this book). This is NOT your first, nor second, nor third book on SQL in general or MS SQL Server in particular. You must have a good grasp of the basics to be able to overcome this book. I say 'overcome' advisedly; more on it below.

2. Content: Data-type subtleties (datetime, xml, CLR user-defined types -- a lot of CLR in this volume); temporary tables, cursors, dynamic SQL, views, user-defined funcs, stored procs, triggers, a bit on transactions, exception handling, a bit on service broker.

3. Very clean technically: no technical errors (and while we're here: I found no typos either).

4. Depth vs breadth: the book is more extensive than deep, although on average it's (inevitably) more in-depth than the first volume. Some reviewers here say it's very deep or difficult -- and difficult is true, although not because of PhD anything. This, unfortunately, brings me to the next point:

5. Writing: ABHORRENT. (Both volumes, Querying, and Programming, in about the same degree). That's why it seems difficult, PhD and so on -- except this difficulty isn't due to, say, conceptual complexity of the subject matter. It's the authors' extreme inability to use the English language to explain things that makes reading this book such a chore. There is also conceptual muddle (unsurprisingly: people write as they think).

Now, experience taught me to forgive literary incapacity to a _technical_ author (to a degree; and I do take notice and, if possible, avoid him in the future). In cases like that I put the blame squarely on the publisher, especially if otherwise I know the publisher to be solid. I have a pile of books from Microsoft Press and I consider them a good publisher, so what's the matter?

Although (strangely) a bit better than the first volume, this book (Programming) is also strewn with unimaginable, fantastic garbage of every possible kind, from grating usage errors to a pervasive lack of unity, coherence, and logical connectedness on the page/paragraph level, to a frequent lack of the overall unity. When I bought this book and read it a bit I was so p-off I almost sent it back (I got as far as getting an RMA from Amazon). I did keep it though. Both of them, actually.

Do I recommend this book? It has been useful to me (especially the UDF section: there's a lot of new stuff, all very handy), so -- with great reservation, and only to the right reader -- yes, kinda. And please check out what else is available (there's tons of books on the 2005 server these days). The Programming book is part of the three-volume update and extension of the server-2000 version by Delaney. Delaney's server-2000 book was extremely useful and quite decently written. I wish they let her write the new version, even though it's now three books instead of one, and I suppose it's difficult for one person to do it all.
11 internautes sur 13 ont trouvé ce commentaire utile 
2.0 étoiles sur 5 Too clever by half 6 août 2007
Par Dr. Robotnik - Publié sur
Please see review by C. Mialaret. S/he is spot on.

One gets the impression that the author may have been more focused on impressing you with his eruditeness, rather than writing a practical book with useful examples and clear explanations.

Affecianados of Kalen Delaney's 'Inside SQL Server 2000' will be disappointed.
10 internautes sur 12 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 This is an excellent book 23 août 2006
This is an excellent book that should be in the library of every serious database developer. It is by far the most detailed book that I have ever read on T-SQL programming. There are many cookbooks or sql recipes books but IMHO this book is many steps ahead of the rest of the books. It is well written, with realistic examples and extremely precise. The one thing that I really loved in this book was that for every problem it provides many alternative solutions and explains the advantages of one solution over the other. Again congratulations to the authors for their great job.
6 internautes sur 7 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Excellent book 3 janvier 2007
Par Amazon Customer - Publié sur
Format:Broché|Achat vérifié
I've been a SQL Server DBA for each version since 6.5, so with the release of 2005, it was time to make sure that I was up with the new stuff. It's difficult to find a book that has enough technical meat to it without just being a dump of BOL. This book is a winner for me. I really enjoy the pace and depth of the material. For those needing to just refresh their basic knowledge and those that need a good overview of the new features in 2005 (t-SQL related), this is the book for you. It's companion book, t-SQL Querying, make two great additions to anyone's library!
Ces commentaires ont-ils été utiles ?   Dites-le-nous

Discussions entre clients

Le forum concernant ce produit
Discussion Réponses Message le plus récent
Pas de discussions pour l'instant

Posez des questions, partagez votre opinion, gagnez en compréhension
Démarrer une nouvelle discussion
Première publication:
Aller s'identifier

Rechercher parmi les discussions des clients
Rechercher dans toutes les discussions Amazon

Rechercher des articles similaires par rubrique


Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?