SQL Server 2014 Download and Installation Guide

This April 2014 Microsoft has announcements lots of new things that are good for development and it customers, such as .Net native, Free Windows and etc. But, one of the most excited release is SQL SERVER 2014 on 1st April 2014. It is an evaluation version for 180-day trial with all amazing features like in-memory technologies for OLTP, data warehousing, analytics and more.

You can download your copy from Microsoft website. The download link is given below.


I have already installed in my machine and exploring the unlimited new features. While installing the software, I have prepared a simple installation step by step document for my reference. But, I would like to share it with the readers in the blog post. Please click the link given below to download the Installation step by step document.

Install_SQLSERVER2014_Evaluation_Edition- PDF document.

After installation, you will be happy to see this screen by opening SSMS.


Then, explore the new features and share it with others. Thanks for reading.

Database Image Viewer – SQL Server Utility Software

This is a SQL Server database utility software used to browse data in the table. This software has two simple screens one for SQL Server authentication and database object selection. The second screen is to browse table data. It is not like typical table browser application. But, if a table contains images then this software will display it along with the other columns.

Screenshots of the ImageViewer software

1)  Authentication and Database object selection screen


This window contains three sections

1. Provide SQL Server Authentication

2. Connect to Database server

3. Select database and table. Finally click browse button.

2) This is the data viewing screen

pic2We got three buttons in this window

1. Back -> go back to the home screen

2. Load Data – > This action will load the data in the grid

3. Close – > Close the application.


You can download this software here  -  BrowseImagesInDB.

After download is completed. We have to rename this application file extension with EXE instead PDF.

Thanks. Please write your comments below.

Categories: Tools Tags: ,

Hide chart axis label in SSRS reports – Tips

This blog post is to share a simple work around (tips)  to hide the chart axis label in SSRS report.

Below given is a sample report. It has a date value in  the x-axis. But, the required is that the report should not have the x-axis label, but the graph should be plot based on the date value.

Sample report

pic1The requirement may look little tricky. But, we just need to mark the check box to hide the label in horizontal axis properties. Let me show how to do that.


Step 1: Right click on the chart horizontal axis and select the “Horizontal Axis Properties” menu item.

Step 2: Select the Labels tab in the property dialog box.

pic2Step 3: Check mark the check box “Hide axis labels”


Step 4: Click OK to apply the property change.

Below given is the sample report preview after the change in is applied to horizontal axis property.

pic3Thanks for reading.

Categories: SSRS Tags: , ,

Filler and Counter – SQL SERVER User Defined Function

SQL Server has  plenty of built-in functions that help developers to use the functionality that simplifies and reduces the development time. But, sometimes we may not get some functionality thru built-in functions. So, we have to develop user defined stored procedure or function to accomplish our task.

In general, functions and procedures are reusable code in the application that we can share with other developers during development process. It is developed once and called many times as we need.

Today, I am going to share two user defined functions that may help us in application development. It is an open source code. So fell free to use.

User Defined Functions

udf_CharFiller(@input_text, @filler_character, @actual_size_of_input_text)

- This function returns the given string value with right justify and fill leading filler character.

udf_CharCounter(@input_text, @char_to_count)

- This function returns the count the given character in the input string value

Function Definition

– ================================================
– =============================================
– Author:        Ayyappan Thangaraj
– Create date: 3/22/2014
– Description:    This function is used to lead fill a given character in a string
– =============================================
@txt varchar(max),
@fillerchar varchar(1),
@txtsize int = 0
RETURNS varchar(max)

DECLARE @rttext varchar(max)

set @rttext = REPLICATE(@fillerchar, @txtsize – len(@txt)) + @txt

RETURN @rttext


– ================================================
– =============================================
– Author:        Ayyappan Thangaraj
– Create date: 3/22/2014
– Description:    This function reutrns the count of a given character in a string value.
– =============================================
@txt varchar(max),
@searchchar varchar(1)
declare @charcount as int

set @charcount = len(@txt) – len(replace(@txt, @searchchar, ”))
RETURN @charcount



1. In this example, I am going to show how to use ufd_CharFiller function.

I have created a table with sample values as given below. It is a string column containing numbers. So, I am going to use ufd_CharFiller function to fill the string with leading *.

num is a character column of size 8. These are the sample values

SQL Query

dbo.udf_CharFiller(num, ‘*’, 8) as Filler,num
FROM [dbo].[tblfiller]


Filler            num
******23    23
*******1    1
*****123    123
****5332    5332

2. In this example, I am going to show how to count a character in a string value using ufd_CharCount function

I have already created a table with some sample value as shown below

txt is a varchar column name of size 10. These are the sample values

SQL Query

select dbo.udf_CharCounter (txt, ‘*’) as charcount, txt from tbltext


charcount    txt
2                      1*2*3
3                      ***3
3                      ***2
3                     1***2
3                     29***
4                    0**1*1*

I think, these functions may be helpful to someone. So, please share this blog post with your friends or in your website.

I you need a special user defined function for your project feel free to post your requirement in the comment section.

Merging files using 7-zip

In the previous blog post, I talked about the splitting huge file into small file chunks. In this blog post, we are going to learn on how to merge those files in to the original source.

Available files:

pic1Now, we need to execute the following command to extract and merge these files.

7z e -y “SplitMyData.7z.001″

e = Extract

-y = switch to apply yes to all questions asked by the utility. In this example, it is yes to overwrite the file.

“SplitMyData.7z.001″ is the first file in the split sequence. 7 zip will automatically combine the next files in serial order to generate source file.


We got the source file.


Please read more about the 7 zip software here.

Categories: Tools Tags: , ,

Split a file into multiple files using 7-zip utility

February 19, 2014 1 comment

We may need to compress a huge file to reduce its actual size for storage or transmitting to remote locations. Sometimes, even the compressed file may look large than we expected. So, we may wish to split the huge file into multiple reasonable small chunks for storage or transfer.

There are various compression software available now-a-days. But I am going to use an open source software.

In my example, I am going to split a 484MB file into multiple files of size 128MB.

Step 1: My file


Step 2: Executing the following command

7z  a SplitMyData -mx0 -v125m MyData.txt

Color coded texts are the 7 zip’s arguments

a = Archive

-mx0 = No compression

-v125m = split size 125 MB

SplitMyData is the file name for file splitting

MyData.txt is the source file

After this command is executed we will get the output as shown below.

pic1So, now we got the files of size we want and it is very simple to do so. This will be really helpful to transfer large file in the slow network.

In the next blog post, I will talk about merging these files into original file.

Full list of 7-zips arguments is given below:


Thanks for reading.

Categories: Tools Tags: , ,

Data Type Mapping between MS Access and MS SQL Server

Access database is one of the famous traditional database management system.  But, the need has changed in rapidly developing digital world  to handle huge amount data to make decisions. This blog post is not about data management but I want to share data migration tips that is required while migration the data from MS Access to MS SQL Server.

Data Type compatibility matching


We can always use SSMA for the database migration project. We can download this tool here.

 Useful links:

SQL Server Migration Assistant for Access


Get every new post delivered to your Inbox.

Join 304 other followers

%d bloggers like this: