Muthusamy Anantha Kumar

Microsoft introduced many additional features to SQL server 2005, one of which is SYNONYM. This article explains and illustrates the use of SYNONYMS. What is SYNONYM? SYNONYM is a single-part name that can replace a two, three or four-part name in many SQL statements. Using SYNONYMS in RDBMS cuts down on typing. SYNONYMs can be […]

This article discusses how to upload multiple image or text files to the SQL Server database varbinary column. Pre-requisite a.  Make sure xp_cmdshell is enabled. If it is not enabled, execute the following command.use master go sp_configure ‘xp_cmdshell’,1 go reconfigure with override go b.  Make sure to create a table with a varbinary(max) column, since […]

DML or Data Manipulation Language is a set of statements used to store, retrieve, modify, and erase data from a database. DML does the following actions: Insert – Adding new data Delete – Removing existing data Update – Modify existing data with new data In SQL Server 2005, Microsoft introduced a new data type called […]

The SQL Mail problems, that we faced in SQL Server 7.0 and 2000, are no more. SQL Server 2005 supports and uses SMTP email now and there is no longer a need to MAPI client to send email. In SQL Server 2005, the mail feature is called Database Mail. In this article, I am going […]

Service pack install – Server and Client Components In Part I, Part II and Part III of this series, you have seen how to install SQL Server client components, server components using command line parameters and using configuration file such as .ini. In Part IV, we discussed how to patch the SQL Server client machine […]

Service pack install – Client Components In the previous articles in this series (Part I, Part II and Part III) you have seen how to install SQL Server client components, server components using command line parameters and how to use a configuration file, such as .ini. In this section of this series, I am going […]

Server and Client Components using .ini File In Part I and Part II of this series, we saw how to install the SQL Server 2005 Data Service component. In this section of this series, I am going to illustrate how to install SQL Server 2005 Database Services and SQL Server Analysis Services on a host […]

Server Components In the previous article, we saw how to install the SQL Server 2005 client components. In this section of this series, I am going to illustrate how to install SQL Server 2005 Database Services on a server using various command line switches. Let us assume that we need SQL Server Database Service installed […]

Client Components Automating the installation of SQL Server was made simple in SQL Server 2005. SQL Server 2005 can be installed using a GUI, an ini file or just run setup.exe with a bunch of parameters. If more than three installations need to be done, it is not worth it to spend time clicking a […]

Microsoft introduced a new operator, INTERSECT, in SQL Server 2005. INTERSECT returns any distinct values that are returned by both the query on the left and right sides of the INTERSECT operator. Let us create two databases and tables as shown below. USE [master] GO /****** Object: Database [MyDBTest] Script Date: 04/25/2006 20:51:51 ******/ IF […]

Microsoft introduced the EXCEPT operator in SQL Server 2005, which returns all of the distinct rows from the left side of the EXCEPT operator. It also removes all of the rows from the result set that match the rows that are on the right side of the EXCEPT operator. Let us create two databases and […]

A SQL Server 2005 feature that I appreciate and want to demonstrate is the OUTPUT clause. The OUTPUT clause helps in returning the actual data from a table soon after an insert. Applications require return values such as the new identity value, the computed column value or the default value generated by the default constraint. […]