An Ihren Kindle oder ein anderes Gerät senden


Kostenlos testen

Jetzt kostenlos reinlesen

An Ihren Kindle oder ein anderes Gerät senden

Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Keine Abbildung vorhanden


Beginning Spatial with SQL Server 2008 (Expert's Voice in SQL Server) [Kindle Edition]

Alastair Aitchison
5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)

Kindle-Preis: EUR 28,09 Inkl. MwSt. und kostenloser drahtloser Lieferung über Amazon Whispernet

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 28,09  
Taschenbuch EUR 50,60  



Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications.

Beginning Spatial with SQL Server 2008 covers everything you need to know to begin using these new spatial datatypes, and explains how to apply them in practical situations involving the spatial relationships of people, places, and things on the earth.

  • All of the spatial concepts introduced are explained from the ground up, so you need not have any previous knowledge of working with spatial data.
  • Every section is illustrated with code examples that you can use directly in SQL Server.
  • All of the topics covered in this book apply to all versions of SQL Server 2008, including the freely available SQL Server 2008 Express.

What you'll learn

  • Understand the fundamental concepts involved in working with spatial data, including spatial references and coordinate systems.
  • Apply these concepts in the collection and storage of spatial data in SQL Server 2008, using the new geometry and geography field types.
  • Create different types of spatial data objects—points, lines, and polygons—and use these to describe real–world objects.
  • Learn how to analyze spatial data using a range of supported methods, and be aware of a number of different practical applications for these methods.
  • Be shown how to integrate SQL Server with other tools, such as Microsoft Virtual Earth, to display a visual representation of spatial data.
  • Know how to ensure the performance of spatially enabled databases by creating appropriate spatial indexes.

Who is this book for?

SQL Server developers who wish to use spatial data in Microsoft SQL Server 2008.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry–level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." You'll start your journey by seeing what you need to know—but without needless theory and filler. You'll build your skill set by learning how to put together real–world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there—it is your trusted guide through unfamiliar territory!

Über den Autor

Alastair Aitchison has over eight years of experience as a management information consultant, specializing in the design and deployment of online reporting systems. For the last three years, he has been employed as a reporting and analysis manager at Aviva, the world's fifth largest insurance group. In this role, he has championed the use of spatial data in corporate applications including the geographic analysis of risk patterns, plotting the success of regional marketing campaigns, and understanding the impact of major weather incidents. Alastair is a Microsoft Office Specialist Master Instructor and has delivered numerous training courses to individuals and small groups on a range of software packages.


  • Format: Kindle Edition
  • Dateigröße: 11729 KB
  • Seitenzahl der Print-Ausgabe: 456 Seiten
  • Verlag: Apress - A; Auflage: 1 (21. Januar 2009)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B002LLRE3M
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Durchschnittliche Kundenbewertung: 5.0 von 5 Sternen  Alle Rezensionen anzeigen (1 Kundenrezension)
  • Amazon Bestseller-Rang: #470.942 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?

Mehr über den Autor

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


4 Sterne
3 Sterne
2 Sterne
1 Sterne
5.0 von 5 Sternen
5.0 von 5 Sternen
Die hilfreichsten Kundenrezensionen
2 von 2 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch|Verifizierter Kauf
Das Buch ist sehr systematisch aufgebaut, hat viele Beispiele und ist ein wirklich gelungener Einstieg in die SQL-Server Spatial-Technologie.

Alle Beispiele werden in C# und VB.Net präsentiert. Dabei werden auch Technologien, wie CLR-Integration angerissen.

Zu dem Thema zur Zeit wahrscheinlich die vollständigste Informationsquelle.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf (beta) 4.4 von 5 Sternen  16 Rezensionen
5 von 6 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Fantastic Introduction 17. April 2009
Von Grant Fritchey - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
When I started reading Alastair Aitchison's book on Beginning Spatial with SQL Server 2008 I thought to myself, "Wow, I'm glad this is the beginning book." The concepts that make up spatial data and the means necessary to store and retrieve this data from your SQL Server database are quite difficult. Luckily Mr. Aitchison has written this book. I've just read the entire thing, running most of the samples. My copy has a number of post-it flags hanging out all over the place on topics that I want to re-explore or explore in more depth. I'm already planning on handing this off to co-workers so that they can learn the basics of working with spatial data as well.

The book is very clearly written. All the examples I tried worked. As I said before, Mr. Aitchison does a great job of explaining very difficult concepts so that even someone completely new to the topic will understand. That's the goal of a beginners book and it is very well met.

Now I want to see Intermediate Spatial please?
1 von 1 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen Good beginning, with shortcomings that matter to me 21. November 2011
Von Tom von Alten - Veröffentlicht auf
The book provides a good introduction to spatial data and the specifics of working with it in the context. It extends to providing examples of ONE-WAY web apps with GoogleMaps and VirtualEarth, to offer read-only spatial data to browsers. It does not anticipate that one might want to obtain user input and write something back to a database, a rather significant oversight.

I was also disappointed to realize (after some digging; it might have been apparent from the publishing date, but the text doesn't highlight the fact) that his GoogleMaps API target was v2. That's OK, that was what was current when he wrote it, but the apress booksite doesn't seem to think a $30 to $50 code book needs any follow-up information. v3 should be covered at this point.

The text and the code (VB in print, but you can get C# from both could have used more effective editing. Storytelling is fine, but this is a means to an end, not a novel.
1 von 1 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen Good as a starter 13. Mai 2010
Von Magnus Salgo - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
I think this book is good for someone new to GIS. The feeling I get is that the author is paid by number of pages so we get some additional things like creating Web applications in Visual Studio which maybe could have been left for another book and instead focus on SQL Server 2008 and the functionality.....

SRP => focus on SQL Server 2008 is my wish....

Summary worth reading to get started but where is the next step......
1 von 1 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Spatial Analysis for Databases 18. März 2010
Von David M. Kulpanowski - Veröffentlicht auf
Format:Taschenbuch|Verifizierter Kauf
I would give this book a high recommendation. Using this book I was able to take GPS data of ambulances travelling around our county and import it into SQL Server 2008, spatialize the tables and write queries against it. Examples of my queries are; what is the distance between standby locations and the subsequent dispatch location? How far away are emergency incidents from the fire station? By hour of day, where are emergency incidents happening within the county? Where in the county are we NOT meeting our response time standard?
I used to use ArcInfo for this type of work, but processing all the spatial data within SQL Server makes a lot of sense. It eliminates several steps such as exporting the data out of the database, importing it into ArcGIS and making points, then doing point in polygon overlays. Beginning Spatial with SQL Server 2008 goes a long way towards helping me perform operational planning for Fire Services and Emergency Medical Services. This book helps me solve real-world problems. Mr. Aitchison has a clear writing style and the book covers topics that are useful for solving geographic issues.
So many issues in business and government have a spatial component such as: which schools in Detroit to close, where to locate a new fire station in Fort Myers, where are customers relative to my stores, etc. This book goes a long way in helping you analyze your spatial data.
Once again, I would give this book a high recommendation.
3 von 4 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Review Of Beginning Spatial With SQL Server 2008 15. Juni 2009
Von Denis Gobo - Veröffentlicht auf
I will just start of by saying that this is a truly awesome book. Although I have tinkered a little with the new geospatial capabilities in a blog post, I did not really understand or know that there were some many nuances and things that you had to be careful about.
Did you know that there are different map projections? This book will show you the differences between the Hammer-Aitoff map projection, the Mercator map projection and the equirectangular map projection. You will also learn what the different spatial reference systems that SQL server 2008 supports are.

If you are a SQL server developer and you have to incorporate some spatial data on your website or perhaps on your intranet then this is the book for you. The book is written in a casual style, things that might seem complicated at first are explained thoroughly over several pages. There are many images in this book (we all know that an image is a thousand words) which really help explain concepts. There are links in this book that point to great resources.

I highly recommend this book if you want to learn about spatial data in SQL Server 2008. You will not be disappointed!
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

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