indiandotnet

A simple way for consistency TIP #106

  Whenever we develop application of maintain application we define sets of rules or policies  like naming convention , data type, database & SQL SERVER properties (like which property should be unable or disable)  but the problem is to cross check or to enforce these properties is very tedious. To enforce the policies SQL SERVER …

A myth about view TIP #102

  I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer will roaming around like so Can you update record using View?  or Can you delete record using view ? I  hope everyone who is reading this article will be aware of what is …

Bulk Copy Program (BCP)–A simple way to export data in a file TIP#101

  Let’s consider a scenario where the end user require a CSV file of all the records in a table then BCP is one of the simplest way. BCP stands for Bulk copy program. By the name you got the feeling of lots of data . Although, there are various options & parameters available with …

How to hide my SQL Server instance in network ? TIP #99

  In TIP #70  we saw how to find all the running SQL SERVER instance in a network or a machine. to revise see below image. This tip is just opposite to tip #70 you don’t want that your co-worker see your SQL Server instance running on your machine machine. (There are several reason behind …

I am not able to access my SQL server instance on another computer tip #98

  On last Friday , one of my colleagues had some issue related to accessing of SQL Server instance of database server machine in the office through his machine. I think this is generalized problem and might be faced by many of us. So to begin with  default port of SQL SERVER is 1433 , …

How to send E-mail/E-mail with Attachments in SQL Server TIP #97

  In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail in SQL SERVER. Sometimes we need to send mail for different requirements like 1) Notification mails like  data inserted /updated/deleted successfully 2)Send data reports like no of amount earned, failed transaction  etc. for this …

How to Configure E-mail in SQL Server Step by Step–TIP #96

  For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL  Server provides E-mail functionality using “Database Email” feature. We can setup any E-mail  in few simple steps. Let’s follow below steps Step 1:- Open “Management” option of object Explorer in SQL SERVER  …

How to resolve Space issue in SQL server 2005 TIP #93

Hello friends,Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more solution which is VARDECIMAL feature. ** VARDECIMAL feature exist in SQL SERVER’s Developer & Enterprise edition. ** This feature is not available in SQL Server 2005’s Standard edition. I hope by the name it is …

Data Compression–A unique feature PART–II TIP #92

In last post TIP #91  we talked about  What is Data compression ? What are the  features ?  Now in this tip we will take implement the data compression with basic steps.So lets follow the steps1) Right click on the table on which you need to implement compression. You will get following menu just select …

Data Compression– a unique feature of SQL Server TIP #91

A part from performance many times we faced challenges related to space  of our database. Sometimes our database is actually taking huge space and sometimes it our mistake due to which it took space. It is worst condition when you are on a dedicated hosting or cloud hosting with limited space. In such case “Compression” …