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.

pic1

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.

pic2

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

pic1

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.

Implementation

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”

pic3

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

– ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
– =============================================
– Author:        Ayyappan Thangaraj
– Create date: 3/22/2014
– Description:    This function is used to lead fill a given character in a string
– =============================================
CREATE FUNCTION udf_CharFiller
(
@txt varchar(max),
@fillerchar varchar(1),
@txtsize int = 0
)
RETURNS varchar(max)
AS
BEGIN

DECLARE @rttext varchar(max)

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

RETURN @rttext

END
GO

– ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
– =============================================
– Author:        Ayyappan Thangaraj
– Create date: 3/22/2014
– Description:    This function reutrns the count of a given character in a string value.
– =============================================
CREATE FUNCTION udf_CharCounter
(
@txt varchar(max),
@searchchar varchar(1)
)
RETURNS int
AS
BEGIN
declare @charcount as int

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

END
GO

Implementation

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
23
1
123
5332

SQL Query

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

Output

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
1*2*3
***3
***2
1***2
29***
0**1*1*

SQL Query

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

Output

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.

pic2

We got the source file.

pic3

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

pic1

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:

pic2

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

accesstoSQLServer

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

 Useful links:

SQL Server Migration Assistant for Access

Follow

Get every new post delivered to your Inbox.

Join 304 other followers

%d bloggers like this: