Inside Microsoft SQL Server 2008 T-SQL Programming und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr

Loggen Sie sich ein, um 1-Click® einzuschalten.
Jetzt eintauschen
und EUR 6,47 Gutschein erhalten
Alle Angebote
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Keine Abbildung vorhanden

Beginnen Sie mit dem Lesen von Inside Microsoft SQL Server 2008 T-SQL Programming auf Ihrem Kindle in weniger als einer Minute.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

Inside Microsoft® SQL Server® 2008: T-SQL Programming (Developer Reference) [Englisch] [Taschenbuch]

Itzik Ben-Gan , Dejan Sarka , Roger Walters

Preis: EUR 40,03 kostenlose Lieferung. Siehe Details.
  Alle Preisangaben inkl. MwSt.
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
Gewöhnlich versandfertig in 1 bis 3 Wochen.
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 18,74  
Taschenbuch EUR 40,03  


16. September 2009 Developer Reference
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.

Hinweise und Aktionen

  • Studienbücher: Ob neu oder gebraucht, alle wichtigen Bücher für Ihr Studium finden Sie im großen Studium Special. Natürlich portofrei.

Wird oft zusammen gekauft

Inside Microsoft® SQL Server® 2008: T-SQL Programming (Developer Reference) + Inside Microsoft® SQL Server® 2008: T-SQL Querying (Developer) + Microsoft® SQL Server® 2008 Internals (Developer Reference)
Preis für alle drei: EUR 114,96

Einige dieser Artikel sind schneller versandfertig als andere.

Die ausgewählten Artikel zusammen kaufen


Mehr über die Autoren

Entdecken Sie Bücher, lesen Sie über Autoren und mehr


Über den Autor und weitere Mitwirkende

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.

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Hier reinlesen und suchen:


Es gibt noch keine Kundenrezensionen auf
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne
Die hilfreichsten Kundenrezensionen auf (beta) 4.2 von 5 Sternen  13 Rezensionen
14 von 16 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Outstanding Book Covering T-SQL Programming w/ SQL Server 2008 9. April 2010
Von Dan McKinnon - Veröffentlicht auf
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 von 5 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Probably the best focused on T-SQL Programming 18. Juni 2011
Von Andre Guerreiro - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
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 von 6 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Inside Microsoft SQL Server 2008-T-SQL Programming Book Review 27. Oktober 2010
Von Cecil T. Champenois Jr. - Veröffentlicht auf
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 von 1 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Easy to follow and offers a bit of insight 11. Juli 2013
Von Daniel Haro - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
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 von 1 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Excellent reference for T-SQL 3. März 2013
Von Marc Livingston - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
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.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Erster Beitrag:
Eingabe des Log-ins

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen

Ähnliche Artikel finden

Ihr Kommentar