Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

Thursday, December 11, 2008 12:02 PM

When jokes become reality

Couple years ago Charles Petzold wrote about C# Application Markup Language - XML syntax for C#. Go read it if you've not seen it yet. Well, it was a fool day's joke of course (the publishing date at the bottom hints about it). But yesterday, when playing
Posted by michen | 1 Comments
Filed under: ,
Thursday, December 04, 2008 11:28 PM

The way NOT to write HTTPS server

Note: posted under rant tag, so you are warned ;) I've just got a new wi-fi router, DIR-655 from DLink. Seems like a nice router, but at least one feature is just plain horrible broken. And it is security feature, which makes me wonder how secure the
Posted by michen | 0 Comments
Filed under: ,
Sunday, October 19, 2008 12:33 AM

Does buffer.NextRow() skips the first row in a buffer?

I got a follow up question to my old post regarding enumerating rows in SSIS buffer , that suggested using following code to process rows in custom SSIS transform: while (buffer.NextRow()) {   // do something with the row } Here is the question:
Posted by michen | 1 Comments
Filed under: ,
Wednesday, June 18, 2008 12:45 PM

It's Not Easy Being BI

A very funny post by Matthew Roche, for everybody working in Business Intelligence: http://bi-polar23.blogspot.com/2008/06/it-not-easy-being-bi.html
Posted by michen | 0 Comments
Filed under:
Saturday, June 07, 2008 1:37 AM

Lookup multiple rows?

Can SSIS Lookup do what this user wants it to do? I have a problem with a lookup output, I get this warning: The Lookup transformation encountered duplicate reference key values when caching reference data. I know what it is, but I don't like to avoid
Posted by michen | 3 Comments
Filed under: ,
Friday, April 04, 2008 5:02 PM

Application termination when user logs off

Do you know how windows terminates all the applications when user logs off? I did not think too much about this, and assumed that it is a normal process - after all the WM_QUERYENDSESSION and WM_ENDSESSION processing, the application main window closes, posts WM_QUIT and the application quits in a regular way. But a recent bug reported for one of my GUI applications caused me to look deeper. The bug caused the application settings to be lost, and this made me look closer at what happens at logoff.
Posted by michen | 7 Comments
Filed under:
Friday, March 14, 2008 3:45 PM

Configuring .NET for running SSIS packages from custom applications

If you execute SSIS packages from custom applications, you own the application and thus you are responsible for configuring .NET runtime properly to get the maximum performance. .NET configuration is usually performed using .exe.config files, so it is a just matter of providing good config file. How do you know what is good? The simplest way is to look at the config file that SSIS provides, and copy the appropriate settings. Now let's take a look at DTExec.exe.config provided with SQL Server 2008 and discuss the choices made by SSIS team. ...
Posted by michen | 1 Comments
Filed under: ,
Tuesday, February 05, 2008 12:53 AM

Random() is only random if you are using it right

I like the quote "With great power comes great responsibility" when used in regards to .NET - .NET gives one great powers, but use it wisely and know how this stuff works. Recently I saw code (it was written by a guy interviewing to our team) that demonstrated
Posted by michen | 0 Comments
Filed under:
Friday, February 01, 2008 12:25 PM

SSIS event handler threading

If the package has an event handler that can handle multiple events, and these events fire at about the same time. What happens?
Posted by michen | 0 Comments
Filed under:
Tuesday, December 11, 2007 11:46 AM

Functional sort in C#

On an internal mailing list, we were discussing functional languages, and this Haskell sort code: qsort [] = [] qsort (x:xs) = qsort ( filter ( < x) xs) ++ [x] ++ qsort ( filter ( >= x) xs) While trying to explain how this code works (which is very
Posted by michen | 0 Comments
Filed under: ,
Tuesday, December 04, 2007 10:42 PM

SQL 2008 & VS 2008

Currently SQL Business Intelligence Development Studio (BIDS) and all the project types (AS, IS and RS) live in Visual Studio 2005. So don't try to open a solution that contains IS project in VS 2008 yet. What about final SQL 2008 - now that Visual Studio 2008 is released - what are the plans for BIDS and support of BI projects VS 2008?
Posted by michen | 5 Comments
Filed under: ,
Friday, November 23, 2007 3:20 PM

VALVe/Steam horrors

I run Vista on my home PC (and at work too, actually), and all of us run as non-admins (not Vista's protected admin, but real non-admin). My son plays Counter Strike, and thus has to run Steam. It worked mostly fine, until recently it started to ask to install Steam as a service. Well, a service for internet-facing software seems not good. Before installing, I decided to find out more about it, and the finding are much worse than I've ever expected ...
Posted by michen | 0 Comments
Filed under: ,
Tuesday, November 20, 2007 3:11 PM

SQL Server ETL Survey: Win a Zune!

Improve SSIS and win a Zune: https://mscuillume.smdisp.net/Collector/Survey.ashx?Name=SqlETLSurvey2
Posted by michen | 1 Comments
Monday, November 19, 2007 9:56 AM

SQL 2008 November CTP is available

Get it from https://connect.microsoft.com/SQLServer One of the improvements in this build is the ability to persist Lookup reference data and use non-OLEDB sources for Lookup.
Posted by michen | 0 Comments
Filed under: ,
Wednesday, November 07, 2007 1:48 AM

Deploying packages

How can one deploy packages programmatically? Here is the original question - Is it possible to deploy a package programmatically? We have an application which has a work flow for approval of object. If the object (ssis package) is approved by the concerned
Posted by michen | 0 Comments
Filed under:
More Posts Next page »
 
Page view tracker