Transparent Data Encryption (TDE) in SQL Server

Transparent Data Encryption (TDE) is another new feature in SQL Server 2008. It performs real-time I/O encryption and decryption of the data and log files, that is the entire database. For achieving that, it uses a database encryption key stored in the database boot record. A derived benefit of TDE is that whenever a database … 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

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…

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…

My first blog entry – Welcome

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.