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...
Date: 01/30/2017
Trust Services Lab updated
Trust Services Lab has been updated today:...
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...
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...
Date: 02/03/2012
Computer display size calculator
Surprisingly, could not find quick tool to compare various screen sizes and resolutions. It is...
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...
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...
Date: 01/28/2011
Undocumented PowerPivot installation requirement
Trying to use PowerPivot, just found undocumented PowerPivot installation requirement: Excel .NET...
Date: 01/28/2011
Making Asynchronous Programming Easy
Great post by Somasegar about upcoming language support for async programming:...
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...
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...
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...
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...
Date: 10/19/2008
It's Not Easy Being BI
A very funny post by Matthew Roche, for everybody working in Business Intelligence:...
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...
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...
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...
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...
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...
Date: 02/01/2008
Functional sort in C#
On an internal mailing list, we were discussing functional languages, and this Haskell sort code:...
Date: 12/11/2007
SQL 2008 & VS 2008
Currently SQL Business Intelligence Development Studio (BIDS) and all the project types (AS, IS and...
Date: 12/05/2007
VALVe/Steam horrors
(Update: VALVe has removed the worst recommendations that I described below. I don't know if my...
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
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...
Date: 11/19/2007
Deploying packages
How can one deploy packages programmatically? Here is the original question - Is it possible to...
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...
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...
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...
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...
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...
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...
Date: 06/26/2007
SSIS Backpressure Mechanism
One of the mechanisms that SSIS data flow engine utilizes to achieve high performance is “back...
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...
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...
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)...
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...
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...
Date: 03/29/2007
Running SSIS package programmatically
I got several questions asking what is the best way to run SSIS packages programmatically. One...
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,...
Date: 03/16/2007
[ADV] SQL BI is hiring
If you like SSIS, and want to work in SQL BI team, we are hiring....
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...
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...
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...
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....
Date: 03/30/2006