Posts
  • Bill Lin's Blog

    Using MSDTC between Vista clients and Windows 2000 servers

    • 10 Comments
    Background Consider the following two scenarios: 1. You have implemented a .NET application accessing a specific COM+ service with automatic transaction processing. You derived a class from ServicedComponent, set the Transaction attribute for the...
  • Bill Lin's Blog

    DOS Command Script: Use Date/Time in File Names

    • 7 Comments
    Nowadays, we have different choices of script languages in Windows: VBScript, JScript, PowerShell script, etc. Coming from the old DOS world, I still prefer a simple batch (.cmd) script. Say we have a simple sql query and we want to run it every 10...
  • Bill Lin's Blog

    Timeout when using SqlBulkCopy

    • 4 Comments
    For certain size of data, SqlBulkCopy.WriteToServer() may throw a timeout exception, although it won't happen when MARS is turned on. The problem is caused by a bug in the code for handling some boundary scenarios. The workaround is to apply this patch...
  • Bill Lin's Blog

    DOS Command Script: uninstall an application

    • 3 Comments
    The scenario is you have an application which was installed through MSI. And you only know the application name (in this case, the beginning part of the application name). Using msiexec command requires you to know the product GUID but the application...
  • Bill Lin's Blog

    SQLClient Support for the New Date and Time Types in SQL Server 2008

    • 3 Comments
    Prior to SQL Server 2008 , SQL developers were restricted to using two types to work with date and time values: datetime and smalldatetime . While they are sufficient in most user scenarios, there are some limitations: 1) Both types include both the...
  • Bill Lin's Blog

    System.Data.SqlClient.SqlException 3988

    • 3 Comments
    Exception Type: System.Data.SqlClient.SqlException Number: 3988 Message: New transaction is not allowed because there are other threads running in the session If you have ever seen this type of exception when talking to RTM SQL Server 2005 (but never...
  • Bill Lin's Blog

    Weird Error of Log Parser

    • 2 Comments
    Log Parser is a great Microsoft tool for processing text-based data. Its scriptable COM components can be easily consumed by .NET applications. Recently I ran into an interesting error when using the COM components with C#. The data input for the parser...
  • Bill Lin's Blog

    Bill Gates' Transition

    • 2 Comments
    Today Bill Gates announced his transition plans: http://www.msnbc.msn.com/id/13348456/ Essentially in two years, Bill Gates will transition away from a daily role at Microsoft to focus on the charitable work of the Bill & Melinda Gates Foundation...
  • Bill Lin's Blog

    Seattle Works Day 2007

    • 2 Comments
    1,000+ participants at 30+ project sites added up to nearly 4,000 hours of service in a single day. Seattle Works Day is a fun and easy way to green up Seattle. Microsoft also broke Seattle Works Day records. We had three projects this year with over...
  • Bill Lin's Blog

    Performance Tips with SqlClient

    • 1 Comments
    Here's a list of things to know if you'd like achieve the best performance/scalability with SqlClient: Use SqlBulkCopy to send large sets of data to the server Set DbDataAdapter.UpdateBatchSize to send batches to the server Use strongly typed...
  • Bill Lin's Blog

    Lessons Learned from A Scam

    • 1 Comments
    This post contains some hard lessons I recently learned through a craigslist transaction. Hopefully it could help you to become more cautious if you decide to sell something through craigslist or other similar online sites. A while ago I won a competition...
  • Bill Lin's Blog

    Progressive Development

    • 1 Comments
    My mentor James at Microsoft recently started a blog with the name "Progressive Development". It talks about best and worst practices of software engineering in the format of entertaining conversations between two figures Motley and Maven. I knew James...
  • Bill Lin's Blog

    10 Reinvigorating Facts About Microsoft's Profits

    • 1 Comments
    I'd like to share an interesting article on Microsoft's profits published a while ago: 10 Reinvigorating Facts About Microsoft's Profits ... Microsoft last week announced quarterly revenue of $14.4 billion and net income of $4.93 billion. In...
  • Bill Lin's Blog

    Microsoft Surface

    • 1 Comments
    Cool product, cool name, cool website. I saw the demo in our company meeting and I really like it. http://www.microsoft.com/surface/ Executive Q&A: What the new surface computing category means for Microsoft and consumers http://www.microsoft...
  • Bill Lin's Blog

    Anonymous users are allowed to comment

    • 1 Comments
    Now you don't have to log in in order to make a comment in my blog.
  • Bill Lin's Blog

    Welcome to Bill Lin’s blog!

    • 1 Comments
    It’s not easy for me to start out the first blog entry so I’ll make it succinct. My name is Bill Lin and I’m a developer on the ADO.NET team. As a dev, I’ve worked on the team for 8 months. I currently am working for SqlClient. Moving forward, topics...
  • Bill Lin's Blog

    Resources

    • 1 Comments
    There're a lot of resources online talking about ADO.NET: 1. Data Access and Storage Developer Center : official Data website at microsoft.com. 2. Data Access Blog : team's blog site. You may find information interesting from different team members...
  • Bill Lin's Blog

    General Network Error in .Net Framework 1.1

    • 1 Comments
    Under some circumstances (such as with certain network bandwidth), you might get a general network error in .Net Framework 1.1 when executing a query that takes longer than SqlCommand.CommandTimeout value. This has something to do with how SqlClient...
  • Bill Lin's Blog

    Bluehat message recall incident: flashback to Bedlam DL3

    • 1 Comments
    If you don't know what Bedlam DL3 means, I encourage you to read this blog entry You Had Me At EHLO... : Me Too! Yesterday, a similar event happened, in a smaller scale though. Someone sent an announcement email to the Bluehat Alert DL with more...
  • Bill Lin's Blog

    Microsoft's Effort on 2008 Summer Olympics Coverage

    • 1 Comments
    Excited about upcoming Summer Olympics? Microsoft brings you a great digital coverage. Extracted from a promotional email : On the eve of 08.08.08 and the excitement around the XXIX Olympiad, Microsoft and NBC Sports have teamed to deliver event...
  • Bill Lin's Blog

    Moving to Office

    • 1 Comments
    Re-orgs happen frequently at Microsoft and I am about to experience one. I just got two Ship-Its for the product I have been working on for almost 2 years, Microsoft Equipt , which will be discontinued after April 30th. We just finished the last feature...
  • Bill Lin's Blog

    Live Maps China RTW

    • 1 Comments
    I got an email this morning saying the LIve Maps China was live today. According to the email, this first public release supports most basic map and local search features across China with details for 114 cities, plus a Public Transit feature for 11 cities...
  • Bill Lin's Blog

    Programmatically Paste Clipboard Text to a CMD Window (C# or C++)

    • 0 Comments
    To accomplish this, I have tried different approaches: posting WM_PASTE, SendKeys sending ctrl-v... None of the method seems to be working so well. A friend from work suggested trying WM_COMMAND. Since Spy++ doesn't work with cmd.exe, we had to use...
  • Bill Lin's Blog

    ExpectedExceptionBaseAttribute and "Object reference not set to an instance of an object"

    • 0 Comments
    You're writing unit tests with Visual Studio and you want to verify that you're throwing the correct Exception. You could use ExpectedExceptionAttribute class but it only allows you to verify the type of the Exception. You might want to verify other properties...
  • Bill Lin's Blog

    Me in A Magic Session

    • 0 Comments
    Other than being a software developer, I am also a magician. Check out this blog post (you will probably have difficulties understanding some of the magic jargons if you are not a magician): http://nnylfmit.blogspot.com/2009/06/no-way-jose.html .
Page 1 of 2 (30 items) 12