Browse by Tags

All Tags » c# (RSS)

Nullable parameters in SQL 2005 & SQL 2008 - Column, parameter, or variable #1: Cannot find data type Nullable`1

When writing CLR code for SQL you need to handle nulls. You can do this in two ways, either your data types are nullable or you configure your functions to always return null when a parameter is null. The last only works for some objects and so understanding...

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...

Virtual Earth Silverlight Control - Register Now

If you want to get your hands on the CTP of the Silverlight Virtual Earth Control then you will need to go to Connect. There you will have to complete a short survey and I guess you will then be informed when the download is available. https://connect...
Posted by simonsabin | with no comments
Filed under: , ,

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...
Posted by simonsabin | with no comments

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...
Posted by simonsabin | 2 comment(s)
Filed under: , ,

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...

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...

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...
Posted by simonsabin | with no comments
Filed under: ,

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...

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...