1. SSRS 2008 R2: Authentication Extension (upgrade issue)

    Recently we have to upgrade our MS SQL Server 2008 to R2. After upgrade we met a problem - our custom authentication extension stopped to work. We were able to login to Reporting Service directly, but unable to login to Reports Manager. Also our system was unable to login using ReportExecution2005.asmx service. After hours of testing and research I’ve found a workaround at social.msdn.microsoft.com. I’ve created HttpModule described in NialoIreland’s latest comment (posted on Monday, February 22, 2010 10:54 AM). And authentication started to work correctly! …


  2. Getting Real

    Getting Real is the amazing “must read’ book. Then I read it for the first time I’m was wonder how I was close to that philosophy (as a programmer). It’s just a book of great advices. Read more at the official website


  3. WatiN - Web Application Testing

    I would like to recommend you an amazing testing framework - WatiN. If can make Web Application Testing to be the easiest thing in a world :) …


  4. Exception HRESULT: 0×800A03EC (.NET Excel automation)

    Got the same issue on the same server after several months of correct work. The first idea was that the issue is related to the updates. But it wasn’t… All that I needed to do is just to activate Office… …


  5. Undo/Redo functionality in .NET

    You need to implement Undo/Redo functionality? Seems I have something to show you… …


  6. Ndb v. 1.0.1 was published

    Just uploaded new Ndb maintenance release.

    • Quote tables & columns names in generated SQL queries.
    • Shared Connection support added.
    • IsDbGenerated property added to DbPrimaryKeyFieldAttribute (currently supported by MySql only).
    • DbLinqAttributesLoader supports composite primary keys & IsDbGenerated flag.
    • NdbConsole now able to check mapping attributes and generate xmlreport.
    • Other minor changes
    Also now using new version model. …


  7. Languages table (MSSQL)

    Often I need languages list in database, so I decided to post it here. Hope it will save several minutes for someone ;) …


  8. Notes about temporary tables support in MSSQL

    MSSQL provides wide abilities to use it’s temporary tables. I. Visible locally.

    declare @SomeTableName table ( Id int, Title nvarchar(50) ); create table #SomeTableName ( Id int, Title nvarchar(50) )
    Note that the first table will be in memory (in most cases), but second will be stored in tempDB II. Visible to everyone:
    create table ##SomeTableName ( Id int, Title nvarchar(50) )


  9. Excel 2007 Automation under Windows Server 2008 x64

    Today I’ve run into the strange problem. I developing a windows service which should generate an Excel files. I’ve tested it’s logic using unit tests and all worked fine. But then I started testing for the windows service, I saw the following strange error: …


  10. Mysql Performance Tips

    Some MySql perfomance tips from greate “How to Kill Mysql Performance” presentation

    • Use Explain
    • Use the smallest data type possible
    • Store IP addresses as INT UNSIGNED (The INET_ATON & INET_NTOA functions will help you)
    • Persistent connection is evil
    • Heavy abstraction layer is evil
    • Learn both the benefits and drawbacks of each table engine (slide 21)
    • Clustered layout is faster for lookup by primary key operations (than Non-clustered layout) (slide 26)
    • If you don't pick a primary key, one will be created for you automatically
    • Understand query cache (slide 32)
    • Don't use stored procedures (slide 34)
    • Be aware of deep scan slowdowns
    • Be aware of COUNT(*) in InnoDB table
    • Use ON DUPLICATE KEY UPDATE
    How to Kill Mysql Performance