in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » c# (RSS)

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

  • MARS - does anyone use it?

    I read recently about MARS - Multiple Active Result Sets, functionality that came with SQL Server 2005. I tried to find some 'real life' example of using MARS. Most of the resources I found showed examples on AdventureWorks database and they were, to say the least, showing how NOT to access the...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Wed, Apr 8 2009

  • 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.microsoft.com/silverlightmapcontrolctp [SS 20:53...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Mar 20 2009

  • 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

  • SSAS Stored Procedures - connecting to the transactional data source

    There are often circumstances where an SSAS stored procedure needs to connect to the transactional database to perform a query. This is certainly the case in a near-real-time OLAP solution where the cube sits directly on top of the application database and dynamic dimension security is implemented by...
    Posted to Sparks from the Anvil (Weblog) by DrJohn on Wed, Apr 23 2008
Page 1 of 2 (16 items) 1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems