Browse by Tags

SSIS - XML Source Script

The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 11 2010
Converting Mappoint routes to SqlGeography

The mapping services from microsoft aren't limited displaying maps in Virtual Earth, and not only limited to websites. There are numerous webservices for, resolving locations to longtiudes and latitudes as well as a routing api. I am working on something for SQLBits to enable people to lift share...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Feb 22 2009
Using LINQ with unfriendly collections

I've liked the idea of LINQ in that you can query in memory collections. It saves a huge amount of code if you want to filter users by other criteria. I'd seen demos and just couldn't figure out how it worked because I was just getting a red suiggly line "Error 2 Could not find an implementation...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jan 15 2009
TSQL Scalar functions are evil.

I’ve been working with a number of clients recently who all have suffered at the hands of TSQL Scalar functions. Scalar functions were introduced in SQL 2000 as a means to wrap logic so we benefit from code reuse and simplify our queries. Who would be daft enough not to think this was a good idea. I...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Nov 3 2008
Filestream access has just got simpler

SP1 of the .Net Framework 3.5 brought us a nice improvement in the usability of filestream data in managed code. Within the System.Data.SqlTypes namespace there is now a class called SqlFilestream. This makes it very easy to use filestream data as this inherits from the Stream class and so can be used...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Oct 22 2008
SQL Reflector

In the user group meeting today I mentioned an AddIn for Management Studio that did reflector on the assemblies in the database. I was either confused as I don't seem to be able to find the management studio add in. What I did find was a plugin for Reflector that can read assemblies from a SQL Server...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Feb 22 2008
SQL Server 2008 – iFTS Transparency – dm_fts_parser

SQL Server 2008 – iFTS Transparency – dm_fts_parser In the next in this series of posts on Integrated Full Text Search (iFTS) in SQL Server 2008, we look at the new dmv dm_fts_parser. Wow thats a cool function name what does it do Simon? Well in my first post I talked about the processes involved in...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Feb 20 2008
SQL Server 2008 Spatial - Which is faster WKT or WKB?

I've just posted two methods for creating geometries in client code. The examples use Stylus points from an ink canvas but any collection of points will go. After doing that I ran some tests to compare the two. I found that in generally the WKB method was ~70% faster to build the WKB and 40% faster...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jan 4 2008
SQL Server 2008 Spatial - Converting from Ink Strokes to geometries

The following snippet will convert an strok collected using an Ink Canvas in WPF to a LINSTRING geometry. The first uses the Well Known Text format WKT. //Text representation of a line is LINESTRING (x1 y1,x2 y2 x3 y3....) //create an string array to store the points string [] pnts = new string [e.Stroke...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jan 4 2008

Page 1 of 1 (9 items)