The TIME data type in SQL Server 2008 (and later)

Similarly to my previous post about the DATE data type in SQL Server 2008 and later, another new data type in SQL Server 2008 is the “TIME“. Again, without having to manipulate the current datetime for getting the time, you just have to cast it to the TIME data type. Here’s the syntax: SELECT CAST(SYSDATETIME() … Read more…

TechEd EMEA Developers 2008

Today it was the last day of Tech·Ed EMEA Developers 2008 in Barcelona, Spain. The conference took place between the 10th and 14th November 2008. It was my first time in such big event and I have to admit that I was excited! Thousands of developers around Europe and other countries near Europe, huge amounts … Read more…

Exam 070-432: Microsoft SQL Server 2008

Yesterday I managed to pass the Microsoft exam 070-432: Microsoft SQL Server 2008, Implementation and maintenance and thus, earned the Microsoft Certification MCTS: SQL Server 2008, Implementation and Maintenance. Additionally I earned the title of Charter Member for my MCTS on SQL Server 2008. Microsoft SQL Server 2008 provides many useful features thus forming a … Read more…

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

There are some times where database applications give the above error when trying to convert strings to the datetime format in SQL Server. This error is related to the default language and consequently the dateformat used by the corresponding SQL Server login. There are two approaches for avoiding/resolving this issue. The first approach is to … Read more…

Changing the startup form in a C# project

Open the C# project properties. In the “Application” tab set the Startup object to “WindowsFormsApplication1.Program”. The “WindowsFormsApplication1” reflects the name of your current C# project so it could be different than the project name presented here. Then in the solution explorer, under the project tree, open the “Program.cs” file. The code should be similar as … Read more…