Category: DBA
-
Installing SQL Server 2008 R2
In this article we are going to discuss about installing SQL Server 2008 R2, I know Im little late as R2 is released last month. Before we stepping into installation make sure you have necessary hardware and software requirements, check http://technet.microsoft.com/en-us/library/ms143506(SQL.105).aspx this KB article for the same.
-
Configure DB Mail Profile in SQL Agent for Automated Alerts
In the recent times I have seen so many people asking the same question in MSDN forums on how do I activate database mail for the use of SQL server agent alerts system. So I am taking a chance to document it by using screen shots which can help others. Normally what the newbies tending…
-
Creating Linked server to SYBASE from SQL Server
In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to SYBASE database server from SQL Server environment and then going to query datas from Sybase. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For…
-
Configuring Data Compression
In this article we are going to configure Data compression in SQL Server 2008. Configuring data compression is very easy with just an couple of steps. The steps are below Estimate the Compression Ratio (Optional) Configure Data Compression
-
Types of Data Compression
In my previous article we have seen the need for compression, goal of compression etc. In this article we are going to discuss the types of compression supported in SQL Server 2008. There are two types of compression supported and they are Row Level Compression and Page Level Compression Lets discuss on each compression type