Attention: We are retiring the ASP.NET Community Blogs. Learn more >

Gunnar Peipman's ASP.NET blog

ASP.NET, C#, SharePoint, SQL Server and general software development topics.

  • You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column

    One error you may get when querying SQL Server databases through MS Access is "You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column". This error appears when you open recordset that contains IDENTITY column. Usually you have to do something like this to get this error (FindTrainer query gets data from SQL Server table).

  • SharePoint and constant [Today]

    If you are creating views on sites that use different language than english then you cannot use constant [Today]. This constant is translated to site language and it depends on language you are using. Example: when developing sites in estonian language I have to use constant [Täna] instead of [Today]. Otherwise error message will be shown and I cannot save the view.

  • Software Estimation - Demystifying the Black Art

    Software Estimation - Demystifying the Black Art
    Software Estimation: Demystifying the Black Art (Best Practices (Microsoft))
    Software Estimation - Demystifying the Black Art is another masterpiece by Steve McConnell. I introduced in last june book Code Complete 2 by same author - it is suggested reading for developers. Software Estimation, as title sais, tells about how to estimate software projects. Estimating is not easy thing to do if you want to achieve good estimates.

  • Authenticating programmatically to Exchange Server 2003 FBA

    In one of my projects I had to read data from Exchange Server 2003 programmatically. I had access to Outlook Web Access that used Form Based Authentication (FBA). After some hacking and testing I got authentication part of my utility work. The point was easy - before making WebDAV requests to Exchange Server we need authentication cookies, so there is active session we can use.

  • Three signals of death march projects

    Death march projects are standard in software development and they are usually the most complex ones to handle. It seems to me that this is more like question how to handle the chaos and how to survive it with as less losses as prossible. There are some signals of dangers I would like to share with you.

  • TechEd 2008 Developers - Microsoft data center in Chicago

    Although I'm hardware guy I heard some interesting facts about Microsoft data center in Chicago I want to share with you. As I understood this data center will run also Azure services, so it may also be interesting to see some non-official estimates about how much applications can run in this center.