Similarly to my previous post about the DATE data type in SQL Server 2008 and later, another data type, which was originally shipped in SQL Server 2008 is the “TIME” data type. Again, without having to manipulate the current datetime for getting the time, you just have to cast it to the TIME data type. … Read more…
One of the new data types originally shipped with SQL Server 2008 is the “DATE” data type. The DATE data type provides only the date without requiring from the database developers to extract the date from the datetime anymore. To this end you can just get the date with a single line of code: SELECT … Read more…
At some point in the past, I had to install Service Pack 1 for Visual Studio 2008. My machine ran Windows Vista SP1. During the installation process I was prompt with a warning message that the Machine Debug Manager service was still running. For completing the installation process on the safe side I had to … Read more…
In this article, we will be discussing about, the MERGE Statement in SQL Server. The MERGE Statement is a T-SQL enhancement, which was originally shipped with SQL Server 2008. What is the MERGE Statement in SQL Server? So what actually is the MERGE Statement? When and how should it be used? The MERGE Statement … Read more…
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…
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…
About the char data type to a datetime data type conversion error There are some times where database applications give the following error when trying to convert strings to the datetime format in SQL Server: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. How … Read more…
In this article, we will be discussing about the proper way for closing a C# application (including hidden forms). C# Applications with Multiple Forms There are many times when we develop C# applications, where we make use of several forms. To this end, there are times that we are using the Hide() method for … Read more…
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…
Well, the time has come to create my own Blog. After many years of browsing the internet and especially software development blogs for solutions to problems and guides, I believe it is time to share my knowledge with others as well.