Browse by Tags

SSIS: Deploying OLAP cubes using C# script tasks and AMO

As part of the continuing series on Building dynamic OLAP data marts on-the-fly , this blog entry will focus on how to automate the deployment of OLAP cubes using SQL Server Integration Services (SSIS) and Analysis Services Management Objects (AMO). OLAP cube deployment is usually done using the Analysis...

Posted to Sparks from the Anvil (Weblog) by DrJohn on Mon, Feb 7 2011
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 nullable types is essential. If you are using...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Oct 29 2010
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
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 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)