Hi friends, this article discusses the “Backup Compression” feature in SQL Server. About Backup Compression in SQL Server How many times have we backed up a database and then we have tried to minimize the size of the backup set by compressing it with an archiving utility? I am quite sure that such cases … Read more…
This article discusses about Grouping Sets in SQL Server 2008 and later. Read below to see how you can work without and how you can work with Grouping Sets in order to understand the benefits of this cool feature. Consider a database table containing sales data. The name of the table is dbo.[sales] Example without using … Read more…
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…
In this article, we will talk about Row Constructors in SQL Server, which was originally shipped with SQL Server 2008. Inserting Records to a Table Prior to the Row Constructors Feature There are many cases were we just want to insert some data to a table. The traditional ways of doing that in SQL … Read more…
In this article, we will be discussing about Table-Valued Parameters (TVPs) in SQL Server 2008 and later. Support of Table-Valued Parameters is another great new feature in SQL Server 2008 and later. I am sure that all of us had to make a stored procedure or function call in SQL Server many times. In the … Read more…
In this article, we will compare DATETIME2 vs DATETIME in SQL Server, discuss about their precision and see some examples. About DATETIME2 in SQL Server The DATETIME2 is a data type in SQL Server, that was originally included in SQL Server 2008. We all know of the existence of the DATETIME. So, what is … Read more…
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…