Data Engineering – Learn from the experts
-
IP Address Blocking or Restriction in SQL Server
I have seen some questions in forums asking for the answer is it possible to block connections to SQL Server based on IP address. As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS…
-
SQL Server Service accounts
Most entry level DBAs still have the confusion on what is a service account and which is the best to be used and when. This article will take you through that. Depending on the selection that you made while installing SQL Server, you will have the services installed in your server.
-
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
-
November Month UG Presentation materials
On 21st November we have conducted our UG in Microsoft Training Center, Chennai. We are pleased to provide you the presentation materials used in user group.
Got any recommendations?