Since I have already touched a topic of SQL Server, I want to inform that Discount ASP.NET has launched SQL 2008 Hosting Beta Program. If you are already a subscriber of Discount ASP.NET, you can activate it in your control panel, if not, then you can subscribe if you are looking for a good hosting provider.

Microsoft SQL Server Compact Edition is an embeded database that allows you to integrate it in your destkop and mobile applications. It can be used in a variety of scenarios.

As you may notice I don’t use categories in my blog, only tags. Whether it’s good or bad – is a matter of another topic.  Now I’m going to talk about how to make the archive work properly if you don’t have any categories, because it doesn’t display any posts unless they are filed under some category. I hope this will be fixed in the next versions, but you can fix it yourself, it’s not difficult.

I remember a moment that happened some weeks ago when Google was unavailable to me. I needed to search for something, but I couldn’t reach Google. I could visit other web sites, but not Google. I asked my friends if Google was working for them, some of them told me that it was working, while other ones said that it wasn’t working for them either. In a few minutes it started working again. So, I suppose it was a temporary problem with my ISP, probably some DNS problems. But I swear it was such a frustrating moment!

Have you ever faced a situation when you need to manipulate Excel spreadsheets with PHP on the server that is running Linux? If you had a Windows Server you could use PHP COM extensions. However they are unavailable on Linux. Hopefully, there is a solution. It is called Open XML. It’s a new format of Microsoft Office documents introduced in Microsoft Office 2007. Basically, an Open XML file is a ZIP archive that contains XML files that represent the document mark-up. You can view it yourself or read some documentation, my article isn’t about Open XML, but about the PHP library for working with Excel 2007 files. It also supports Excel 97 format by incor porating a PEAR library. The library is called PHPExcel. It allows you to read/write Excel spreadsheets, save them in many formats including PDF and HTML. It supports formulas,styles and etc

Do you remember your first experience of using a computer? It doesn’t matter whether it was DOS with Norton Commander or Windows. Anyway you had to learn how to find the necessary applications, how to execute them, once again it doesn’t matter whether you clicked on the folders and files on the blue background or used the Start menu. It’s important that you learnt the definitions or metaphors; you learnt that icon is an application or something else; you learnt that you have to click twice on it to open it and so on. Having got used to those metaphors, we easily use a computer unless we face an application with a non-standard interface that confuses us because we have to learn again.

In the article called "Getting BlogEngine.NET To Work With The Local Time Zones" I described how to convert the times of the posts to the local time zones of users relying solely on JavaScript. However I got a complaint that if JavaScript is disabled for some reasons, then no date and time are displayed.

LINQ to SQL is a great tool that saves a lot of time. However it has one disadvantage – it supports only SQL Server. Anyway it’s possible to write your own LINQ provider. Sure, there is one for MySQL. It is called DbLinq, in fact in supports many databases.

I was in the store the other day paying for my mobile phone. There was a middle-aged woman in front of me who was trying to pay for her mobile phone with the payment machine. This payment machine was recently installed, so it was difficult for some people to get used to it. Even I saw the machine for the first time. Anyway that woman was nervously trying to pay, however she even couldn’t go further than entering her phone number, since I hadn’t any experience with that machine as well, I advised her to read the manual that was under the button in the bottom of the screen. She got angry when she heard my advice. Then I noticed that she just didn’t fill in the region code, I told her about that, she didn’t listen, got angry and went away.

This tutorial doesn’t cover the theoretical basics of the new features and controls, instead it concentrates on the practical example of using the new features. This tutorial covers the following features: