Michael Entin's notebook

Michael Entin's notebook

Microsoft <-> Google dictionary

If you know Microspeak, what about a small dictionary - Microsoft speak Google speak Explanation By...

Author: Michael Entin Date: 01/30/2017

Trust Services Lab updated

Trust Services Lab has been updated today:...

Author: Michael Entin Date: 07/09/2012

Microsoft Codename "Trust Services" Lab at RSA

We have a Trust Services booth at the RSA conference in San Fancisco - good time to come, learn more...

Author: Michael Entin Date: 02/27/2012

Microsoft Codename "Trust Services" Lab

I did not post for a long time, was mostly working on internal and not-yet-released projects. But...

Author: Michael Entin Date: 02/03/2012

Computer display size calculator

Surprisingly, could not find quick tool to compare various screen sizes and resolutions. It is...

Author: Michael Entin Date: 07/07/2011

PowerPivot beginner journey 3

PowerPivot lesson #3 - if the data can't be refreshed, it should be in Excel, or copied to...

Author: Michael Entin Date: 02/15/2011

PowerPivot beginner journey 2

I was exploring the data, and found lots of interesting info from my data set. But I could not find...

Author: Michael Entin Date: 01/28/2011

Undocumented PowerPivot installation requirement

Trying to use PowerPivot, just found undocumented PowerPivot installation requirement: Excel .NET...

Author: Michael Entin Date: 01/28/2011

Making Asynchronous Programming Easy

Great post by Somasegar about upcoming language support for async programming:...

Author: Michael Entin Date: 10/30/2010

SSIS custom component performance tidbit

I was helping a friend of mine to debug performance issue with his SSIS package. The package was...

Author: Michael Entin Date: 05/24/2010

When April Fools jokes become reality

Couple years ago Charles Petzold wrote about C# Application Markup Language - XML syntax for C#. Go...

Author: Michael Entin Date: 12/11/2008

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

Author: Michael Entin Date: 12/05/2008

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

Author: Michael Entin Date: 10/19/2008

It's Not Easy Being BI

A very funny post by Matthew Roche, for everybody working in Business Intelligence:...

Author: Michael Entin Date: 06/18/2008

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

Author: Michael Entin Date: 06/07/2008

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

Author: Michael Entin Date: 04/04/2008

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

Author: Michael Entin Date: 03/14/2008

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

Author: Michael Entin Date: 02/05/2008

SSIS event handler threading

I've got an interesting question/statement about event handlers: Tasks fire the same EH at the same...

Author: Michael Entin Date: 02/01/2008

Functional sort in C#

On an internal mailing list, we were discussing functional languages, and this Haskell sort code:...

Author: Michael Entin Date: 12/11/2007

SQL 2008 & VS 2008

Currently SQL Business Intelligence Development Studio (BIDS) and all the project types (AS, IS and...

Author: Michael Entin Date: 12/05/2007

VALVe/Steam horrors

(Update: VALVe has removed the worst recommendations that I described below. I don't know if my...

Author: Michael Entin Date: 11/23/2007

SQL Server ETL Survey: Win a Zune!

Improve SSIS and win a Zune: https://mscuillume.smdisp.net/Collector/Survey.ashx?Name=SqlETLSurvey2

Author: Michael Entin Date: 11/20/2007

SQL 2008 November CTP is available

Get it from https://connect.microsoft.com/SQLServer One of the improvements in this build is the...

Author: Michael Entin Date: 11/19/2007

Deploying packages

How can one deploy packages programmatically? Here is the original question - Is it possible to...

Author: Michael Entin Date: 11/07/2007

SSIS Lookups modes or leaky abstractions

I've got a question about SSIS Lookup, how-to change Partial or No_Cache mode in Lookup task ? I...

Author: Michael Entin Date: 10/03/2007

Custom transforms: determining end of rowset

With SQL 2008 CTPs starting to get into the hands of customers and ISVs, we've found that some...

Author: Michael Entin Date: 08/31/2007

Don't run SSIS package using SQL/CLR

A recent commenter suggested running SSIS using SQL/CLR: Just an idea on how to do this that may be...

Author: Michael Entin Date: 08/24/2007

Redirecting output of Execute Process Task

Can you guess why this does not work? A customer is trying to use the Execute Process Task to...

Author: Michael Entin Date: 08/02/2007

Network causing SSIS package startup delays?

This issue is covered pretty well by blogs in the context of SSMS (Dan Jones and Euan Garden) and in...

Author: Michael Entin Date: 07/29/2007

Do I have to be admin?

Often, I see people reporting "zzz fails if I'm not admin". Do I have to be machine admin to use...

Author: Michael Entin Date: 06/26/2007

SSIS Backpressure Mechanism

One of the mechanisms that SSIS data flow engine utilizes to achieve high performance is “back...

Author: Michael Entin Date: 06/12/2007

Katmai SSIS data flow task improvements

With first Katmai (SQL Server 2008) CTP out, I think it is time to blog about some performance and...

Author: Michael Entin Date: 06/11/2007

SqlPerf blog on SSIS performance

Runying Mao and Len Wyatt did a great study of SSIS performance, and posted some results: Getting...

Author: Michael Entin Date: 04/24/2007

COM references within an SSIS Script Component

The SSIS Script Task and Script Component editors don't provide functionality (available in full VS)...

Author: Michael Entin Date: 04/22/2007

64-bit references within an SSIS Script Component

I was forwarded a question about SSIS Script Component on 64-bit, I think the answer may benefit...

Author: Michael Entin Date: 04/19/2007

Using SSIS object model from C++

All the samples in MSDN show how use SSIS API from C# or VB.NET code. Is it possible to do this from...

Author: Michael Entin Date: 03/29/2007

Running SSIS package programmatically

I got several questions asking what is the best way to run SSIS packages programmatically. One...

Author: Michael Entin Date: 03/22/2007

Why Debug command is disabled for my SSIS package?

Debugging support for SSIS packages is probably one of the best features of the SSIS 2005 designer,...

Author: Michael Entin Date: 03/16/2007

[ADV] SQL BI is hiring

If you like SSIS, and want to work in SQL BI team, we are hiring....

Author: Michael Entin Date: 02/23/2007

Why do I get "product level is insufficient..." error when I run my SSIS package?

This is a common question at SSIS forum, so I decided to post an answer here to save myself from...

Author: Michael Entin Date: 11/11/2006

Where is my SQL Server Integration Services package running?

By 'where package is running' I mean what CPU and memory resources are used, and where the SSIS...

Author: Michael Entin Date: 08/11/2006

Using C# 2.0 iterators to simplify writing asynchronous code (part 2)

Previous article describes the idea of using C# 2.0 iterators to write asynchronous code, now it's...

Author: Michael Entin Date: 04/01/2006

Using C# 2.0 iterators to simplify writing asynchronous code

A neat idea how C# 2.0 iterators can simplify the task of writing code that uses .NET async pattern....

Author: Michael Entin Date: 03/30/2006