Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I thought this might be question in everyone’s mind. So lets start with couple of well know statements then we will see the actual problem where we need it explicitly. There are two type of aliasing …
We always take NULL very lightly. Like if we are designing database then whether it is necessary or not we allow the data field to accept null.We think it will not affect anything. Actually , at some point this is not always true. According to Microsoft NULL is an Unknown value. It is not …
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 …
It’s almost one month that I didn’t write anything on the blog due to some personal reason. I am really sorry for that. Now , Lets talk about the scenario sometimes we need to generate a report of total sales in particular date range but the condition is you need to show all the …
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 …
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 …
Although , It is out of box but I would like to share here. I am very choosy in food. When my mother/wife cooked food and I didn’t like the taste then I explicitly said I didn’t like but when food taste was awesome then I didn’t say a word. My mother taught me “You …
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 …
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” …