Inside Microsoft SQL Server 2008 T-SQL Programming et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus

Acheter neuf

Identifiez-vous pour activer la commande 1-Click.
Acheter d'occasion
D'occasion - Bon Voir les détails
Prix : EUR 21,64

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

Commencez à lire Inside Microsoft SQL Server 2008 T-SQL Programming sur votre Kindle en moins d'une minute.

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

Inside Microsoft® SQL Server® 2008: T-SQL Programming [Anglais] [Broché]

Itzik Ben-Gan , Dejan Sarka

Prix : EUR 40,80 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 5 exemplaire(s) en stock (d'autres exemplaires sont en cours d'acheminement).
Expédié et vendu par Amazon. Emballage cadeau disponible.
Voulez-vous le faire livrer le lundi 22 septembre ? Choisissez la livraison en 1 jour ouvré sur votre bon de commande. En savoir plus.


Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 18,74  
Broché EUR 40,80  

Description de l'ouvrage

16 septembre 2009

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 this programming language—solving complex problems with real-world solutions.

Discover how to:

  • Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.
  • Handle transactions, concurrency, and error handling.
  • Efficiently use temporary objects, including temporary tables, table variables, and table expressions.
  • Evaluate when to use set-based programming techniques and when to use cursors.
  • Work with dynamic SQL in an efficient and secure manner.
  • Treat date- and time-related data in a robust manner.
  • Develop CLR user-defined types and learn about temporal support in the relational model.
  • Use XML and XQuery and implement a dynamic schema solution.
  • Work with spatial data using the new geometry and geography types and spatial indexes.
  • Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture.
  • Use Service Broker for controlled asynchronous processing in database applications.

All the book’s code samples will be available for download from the companion Web site.

Offres spéciales et liens associés

Les clients ayant acheté cet article ont également acheté

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
Rechercher dans ce livre:

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.2 étoiles sur 5  13 commentaires
14 internautes sur 16 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Outstanding Book Covering T-SQL Programming w/ SQL Server 2008 9 avril 2010
Par Dan McKinnon - Publié sur
Being primarily a database and web developer, I feel more than experienced enough to review 'Inside Microsoft SQL Server 2008: T-SQL Programming' by Itzik Ben-Gan and others and I feel more and easily able to give this ***** and highly recommend this text. All the basics are covered in this 800 page book. It's not a teaching book that will give you all the ins and outs of database design and use, but it will show you what the major points of using SQL Server 2008 are, and how to get the most out of them.

Major topics covered are Views, User-Defined Functions, Stored Procedures, Triggers, Transactions & Concurrency, Error Handling, Temporary Tables/Table Variables, Cursors, Dynamic SQL, Date/Time usage, CLR User-Defined Types, Temporal Support, XML & XQuery usage, Spatial Data, Tracking Access and Changes, and finally Service Broker discussion.

The parts of the book that I enjoyed most were the last 6 chapters, as discussion on CLR usage, Spatial Data, and the like are limited in most other SQL Server books. I especially loved the chapter on Spatial data, a very important subject that has much, much greater support than years in the past.

If you are a SQL Server developer or admin, you owe it to yourself to take a hard look at this great book. It is written fantastic and is a great resource that I found useful from the moment I picked it up.

5 internautes sur 5 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Probably the best focused on T-SQL Programming 18 juin 2011
Par Andre Guerreiro - Publié sur
Format:Broché|Achat vérifié
I can't praise this book enough.
This is one of those books that keeps you interested like a good best-selling novel because it's so well written, almost in a conversational way. The author seems pationate about the technologies being shown and he doesn't try to confuse the readers by using a vocabulary which is difficult to understand like many other technical books.

Each chapter is filled with real world code examples and you can download the sample database used in the book's website. I find the examples to be satisfyingly useful and a lot of them helped me to think of better ways to optimize my code.
This book also served as a wonderful reference when I was studying for my MCITP exam.

To sum it all, this is probably the best book about T-SQL I've read because it's easy to understand and presents many useful techniques and explanations. It's not for the beginner though. To those I recommend the first book in the series: "T-SQL Querying" by the same author.

I recommend this book along with Kalen Delaney's SQL Server 2008 Internals because they complement each other amazingly.
5 internautes sur 6 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Inside Microsoft SQL Server 2008-T-SQL Programming Book Review 27 octobre 2010
Par Cecil T. Champenois Jr. - Publié sur
I have used SQL Server since the 6.5/7.0 days and thought I knew enough to get by. I had various experiences with SQL Server 2000/2005, and then did not immediately use SQL Server 2008 until the Spring of 2010; I took a T-SQL CLASS using SQL Server 2008 at Mt. San Antonio College in Walnut, California. I learned a great deal that I did not previously know from Professor Shui-lien Huang, a very excellent teacher.

You can work with SQL Server, and unless you have the opportunity to have many challenges to stretch your skills, you may seemingly work in a silo and never learn all of it, which is a good reason to buy this book: "Inside Microsoft SQL Server 2008: T-SQL Programming". I am glad I had the T-SQL class before reading this book.

This book contains the typical coverage for a standard T-SQL statement, and then User-Defined Functions (UDFs), Triggers, Stored Procedures, Views, etc., but also some new things. For example, extending SQL Server by using CLR (Common Language Runtime) user defined types, the use of XML, dynamic SQL, and Service Broker for reliable, asynchronous processing, and Spatial Data (i.e. geodata).
On the subject of Spatial Data in Chapter 14, Microsoft has brought forth new data types, operators, and indexes to the database. Microsoft introduces the core spatial concepts and provides key programming constructs to successfully navigate this new feature in SQL Server 2008. There are 70 pages covering Spatial Data. Obviously, this is a heavy topic.

Because of auditing and compliance requirements, the issue of tracking access and changes to data has become much more important. This book shows how previous versions of SQL Server did take care of this to some degree, but in SQL Server 2008, Microsoft has added the following: change tracking, change data capture, Extended Events, and SQL Server Audit. The book shows provides guidance on where each of these new technologies is best used, and then goes on to show how to implement each technology.

This is not a beginner's T-SQL book, but it does cover beginner topics, as mentioned above. In addition, it covers some of the new aspects of SL Server 2008 that are more complex. This is most assuredly a valuable reference book that all T-SQL and .NET developers and database administrators should have nearby. It will give you excellent instruction and answers to your T-SQL questions.
1 internautes sur 1 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Easy to follow and offers a bit of insight 11 juillet 2013
Par Daniel Haro - Publié sur
Format:Broché|Achat vérifié
This is a verily good book. I would give it four star but this particular book kind of leaves something to be desired when it comes to theory which in this case is very important. On the other hand there is much that can be learned from this book and there are some great and challenging example problems that come with it.
1 internautes sur 1 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Excellent reference for T-SQL 3 mars 2013
Par Marc Livingston - Publié sur
Format:Broché|Achat vérifié
I'm not expert in SQL Server or T-SQL. This book seems to have everything I need to develop the databases I'm designing.
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?