Dave does Data
Tutorials, Performance Tuning, Tips & Techniques on SQL Server & its ecosystem.
Translate This Page
Translate this page
SQL Analysis Services (SSAS)
SQL Data Mining (SSAS-DM)
SQL Integration Services (SSIS)
SQL Management Studio (SSMS)
SQL Reporting (SSRS)
SQL Server Analysis Services
SQL Server Intergration Services
SQL Server Spatial
Visual Studio DBPro
Browse by Tags
Dave does Data
Tagged Content List
How to get Database Edition Power Tools to work on Visual Studio Team System 2008 Database Edition GDR
If you want to compile sample code or write your own extensions for Visual Studio Team System 2008 Database Edition GDR (also known as DBPro or Datadude) this post will save you hours. Summary In Nov 08 when Microsoft shipped the GDR (General Distribution Release) for the Database Edition of VSTS . They...
20 Sep 2009
News: Look at the CTP3 of our upcoming Distributed Cache technology - Velocity
If you develop high scale, scale out/distributed apps, check out Microsoft Project Code Named “Velocity” Community Technology Preview 3 (CTP3) Released to Web on 7 April 09. "Velocity" is a distributed in-memory application cache platform for developing scalable, high-performance applications...
20 Apr 2009
Free Chart Controls for .NET: Windows and Web – Handy Links
Even though its been available for more than 6 months, many people have overlooked this little gem. Those that are using it get terribly excited when they discover how easy it is to use the features & capability it offers. So if you need very powerful charts in your application, read on. Below are...
20 Apr 2009
SQL Spatial - How to get Spatial data. (FREE Maps 'n Demographics)
This post lists ways to get spatial maps, some of them are Free. If you are in a hurry jump to the last link, it is so cool. Then check out the Free Map sites. Overview There are 3 ways to get the spatial data for your application:- Buy it Download it - FREE Build it Yourself - FREE but costs time I...
13 Nov 2008
SQL 2008 - Ways to architect Spatial apps
Adding spatial capability to your app might be simpler than you think. This is not a comprehensive coverage on architecture, but rather just a few ideas to stimulate your thinking. Overview In an N-Tier environment you have one of 3 options :- All spatial processing occurs on the Server(s) - Mid-Tier...
2 Nov 2008
SQL 2008 Spatial Samples, Part 1 of 9 - How to Learn SQL Spatial
This post covers how to get started with SQL Spatial methods & the best way to test things for yourself. One of the goals in this series of articles is to give you code you can cut, paste & try. I hope you find this handy. Overview Visual Studio is better than SSMS because: One of the best ways...
1 Nov 2008
SQL 2008 Spatial Samples, Part 2 of 9 - Background on Spatial Types & Well Known Text (WKT)
This post covers all the Methods to enter data in WKT, WKB & XML(GML) as well as functions to view the in Human Readable form. It also covers MakeValid, STIsValid & STSrid. Summary of Methods to convert Geometric Formats The following table shows all the Methods create or import a spatial...
1 Nov 2008
SQL 2008 Spatial Samples, Part 3 of 9 - SQL Builder API
This post covers the SqlGeographyBuilder & SqlGeometryBuilder Classes & their methods. Overview of Methods to make your own Spatial Objects using the Builder API. SQL provides a Builder API that permit you to easily write your own Spatial Data Importing utilities. It is also handy manipulating...
30 Oct 2008
SQL 2008 Spatial Sample, Part 4 of 9 - Methods for Drawing Spatial Shapes
This post covers the following methods: STDimension, STGeometryType, STNumGeometries, STGeometryN, STNumPoints, STPointN, STNumInteriorRing / NumRings, STInteriorRingN / RingN, STExteriorRing, STX / Long, STY / Lat, Z & M (measure). Note: Unless otherwise stated. All code samples are designed to...
29 Oct 2008
SQL 2008 Spatial Samples, Part 5 of 9 - Performance Improvement Methods
This post covers the following methods: Reduce, STEnvelope, EnvelopeCenter, EnvelopeAngle, STConvexHull. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio (SSMS) & run. Sometimes I've added extra detail than what is in the sample...
26 Oct 2008
SQL 2008 Spatial Samples, Part 6 of 9 - Geometric “Set Theory” Methods
This post covers the following methods: STUnion, STIntersection, STDifference, STSymDifference, STCentroid / STEnvelopeCentre, STPointOnSurface, STBoundary. Overview of Geometric "Set Theory" Methods These Methods help to understand the relationship between spatial objects & also to create...
25 Oct 2008
SQL 2008 Spatial Samples, Part 7 of 9 - STBuffer ... Spatial starts here.
This post covers only 2 methods: STBuffer & BufferWithTolerance . They are so handy, they deserve a post all to themselves. Note: Unless otherwise stated. All code samples are designed to be Cut n Pasted directly into SQL Server Management Studio (SSMS) & run. Sometimes I've added extra detail...
24 Oct 2008
SQL 2008 Spatial Samples, Part 8 of 9 - Conditional Methods
This post covers the following methods: STDisjoint, STIntersects , Filter, STTouches , STWithin , STContains , STOverlaps , STCrosses, STRelate, & STEquals One day these examples may find their way to Books Online. For now they can live here. Overview of Conditional Methods You...
24 Oct 2008
SQL 2008 Spatial Samples, Part 9 of 9 - Handy but Obvious Methods
This post covers the following methods: STArea, STLength, STDistance, STIsEmpty, STIsClosed, STIsSimple, STIsRing. Overview of Handy but obvious Methods The following methods are self evident. I’ve included here for the sake of completeness. You do need to be aware of them, They are great for calculating...
16 Oct 2008
Page 1 of 1 (14 items)
© 2014 Microsoft Corporation.
Privacy & Cookies