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

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 date value and time value. There is no way to store only the date …

Performance Tips with SqlClient

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 getters instead of GetValue/GetSqlValue Turn on CommandBehavior.SequentialAccess and call GetChars/GetBytes when working with BLOBs Use parameterized queries …

New Adventure

After working in SQL for more than 19 months, I have decided to pursue a new opportunity in Office Live. On June 1, I’ll begin my Office Live adventure.

Microsoft Surface

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.com/presspass/features/2007/may07/05-29Surface.mspx Microsoft Launches New Product Category: Surface Computing Comes to Life in Restaurants, Hotels, Retail Locations and Casino Resorts http://www.microsoft.com/presspass/press/2007/may07/05-29MSSurfacePR.mspx

10 Reinvigorating Facts About Microsoft’s Profits

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 other words, Microsoft’s daily net income is about $55 million. That’s $55 million in pure profit every 24 …