Michael Entin's notebook

Michael Entin's notebook

Posts
  • Michael Entin's notebook

    Trust Services Lab updated

    • 0 Comments
    Trust Services Lab has been updated today: http://www.microsoft.com/en-us/sqlazurelabs/labs/trust-services.aspx The update does not need registration code anymore (ignore "Get Invited" link - it is leftover from previous release and will be removed...
  • Michael Entin's notebook

    Microsoft Codename "Trust Services" Lab at RSA

    • 0 Comments
    We have a Trust Services booth at the RSA conference in San Fancisco - good time to come, learn more and see several cool demos.
  • Michael Entin's notebook

    Microsoft Codename "Trust Services" Lab

    • 1 Comments

    The project I've been working recently has shipped our first Lab:

    Microsoft Codename "Trust Services"

    Trust Services provides a unique combination of end-to-end application level encryption and power of the cloud to roam encryption keys in a totally secure way. It enables data driven applications to work with sensitive data, securely stored in different cloud-based storages while continuing to maintain control over access to this data.

    ...
  • Michael Entin's notebook

    Computer display size calculator

    • 0 Comments

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

    ...
  • Michael Entin's notebook

    PowerPivot beginner journey 3

    • 0 Comments
    PowerPivot lesson #3 - if the data can't be refreshed, it should be in Excel, or copied to PowerPivot. I added zip code data from CSV file by loading to PowerPivot, and discarded the CSV since I did not plan to update it. Bad idea. PowerPivot wants...
  • Michael Entin's notebook

    PowerPivot beginner journey 2

    • 0 Comments
    I was exploring the data, and found lots of interesting info from my data set. But I could not find how to join some tables in PowerPivot, and after looking at the source data - it turned out my source data used GUID columns, stored as binary, for row...
  • Michael Entin's notebook

    Undocumented PowerPivot installation requirement

    • 0 Comments
    Trying to use PowerPivot, just found undocumented PowerPivot installation requirement: Excel .NET Programmability Support. If PowerPivot silently fails to load, and in Event Viewer you've got an event like below, run Office Setup / Add or Remove Features...
  • Michael Entin's notebook

    Making Asynchronous Programming Easy

    • 0 Comments
    Great post by Somasegar about upcoming language support for async programming: http://blogs.msdn.com/b/somasegar/archive/2010/10/28/making-asynchronous-programming-easy.aspx I guess soon the idea hack of using C# iterators as poor-man's language...
  • Michael Entin's notebook

    SSIS custom component performance tidbit

    • 0 Comments
    I was helping a friend of mine to debug performance issue with his SSIS package. The package was pretty simple – he needed to read data, shard it using some partitioning scheme, then insert the results into 8 SQL destinations. The hashing algorithm...
  • Michael Entin's notebook

    When April Fools jokes become reality

    • 1 Comments
    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...
  • Michael Entin's notebook

    The way NOT to write HTTPS server

    • 0 Comments
    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...
  • Michael Entin's notebook

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

    • 1 Comments
    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:...
  • Michael Entin's notebook

    It's Not Easy Being BI

    • 0 Comments
    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
  • Michael Entin's notebook

    Lookup multiple rows?

    • 3 Comments
    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...
  • Michael Entin's notebook

    Application termination when user logs off

    • 7 Comments
    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. ...
  • Michael Entin's notebook

    Configuring .NET for running SSIS packages from custom applications

    • 1 Comments
    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. ......
  • Michael Entin's notebook

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

    • 0 Comments
    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...
  • Michael Entin's notebook

    SSIS event handler threading

    • 0 Comments
    If the package has an event handler that can handle multiple events, and these events fire at about the same time. What happens? ...
  • Michael Entin's notebook

    Functional sort in C#

    • 0 Comments
    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...
  • Michael Entin's notebook

    SQL 2008 & VS 2008

    • 5 Comments
    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?...
  • Michael Entin's notebook

    VALVe/Steam horrors

    • 0 Comments
    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 ......
  • Michael Entin's notebook

    SQL Server ETL Survey: Win a Zune!

    • 1 Comments
    Improve SSIS and win a Zune: https://mscuillume.smdisp.net/Collector/Survey.ashx?Name=SqlETLSurvey2
  • Michael Entin's notebook

    SQL 2008 November CTP is available

    • 0 Comments
    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.
  • Michael Entin's notebook

    Deploying packages

    • 0 Comments
    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...
  • Michael Entin's notebook

    SSIS Lookups modes or leaky abstractions

    • 4 Comments
    I've got a question about SSIS Lookup, how-to change Partial or No_Cache mode in Lookup task ? I could give a quick answer, but wanted to explain what I think we did wrong in SQL 2005, and how are we planning to fix this. Before continuing...
Page 1 of 2 (43 items) 12