Hi friends, today I will explain how to create and configure a linked server to retrieve data from an Azure SQL database.
Few points are describe in this article for configure link server with SSMS
How to configure link server step by step in SSMS
Solve some common Problem/Issue when create link server
Using the Query/Script base to create...
Saturday, November 18, 2017
Wednesday, November 1, 2017
SSIS FOR BEGINNERS
Hi friend's, today we are going to understand about SSIS. i collect many information about SSIS blob and try to understand how to use SSIS. i hope it is useful for you.
Now first try to understand about SSIS.
What IS SSIS?
Why SSIS?
SSIS Variable.
SSIS Connection Manager.
SSIS ToolBox.
Data Flow Task.
1....
Friday, October 6, 2017
Data Table to XML Genrate
///
/// Write out XML to a DataTable to a file in a controlled manner.
/// Use a XmlWriterSettings to control the output formatting.
///
public static string DataTableToXML(DataTable table)
{
...
Tuesday, September 26, 2017
XML Helper for convert class object/List to xml and xml to class object/List conversion
Hi friend's, today we are going to understand ubout XMl Helper for convert class object/List to xml and xml to class object/List convertion.
let's start with example,
Create class for EmployeeDetail
public class EmployeeDetails
...
Thursday, September 21, 2017
Improve SQL Query Performance
Hi friend's, today we are going to understand step to improve t-sql query perfomance step by step mention below.
Use EXISTS instead of IN to check existence of data.
Avoid * in SELECT statement. Give the name of columns which you require.
Choose appropriate Data Type. E.g. To store strings use varchar in place of...
Wednesday, September 13, 2017
How
to make Visualization Report Using Power BI?
How
to use  Power BI Desktop Tool?
First
we need to Sign up/ Register on Power BI
For
register click hear
For
Download the Power BI Tool click hear
Fig 1.0
For
make any Visualization we need some data for visualize through Power BI
To
get data  go through following step
Home
Tab...
SSMS Formatter use with Microsoft SQL Server Management Studio 2016
Hi friend's, today we are going to understand
that how to apply Format for your query in SSMS(Microsoft SQL Server Management
Studio 2016).
You just need to go through some steps that
mentioned below.
First
start the SQL Server (SSMS 2016)
On
the top of the Menu -->...
Tuesday, August 29, 2017
Steps For Creating MSMQ Support Application
Hi friend's, today we are going to understand ubout MSMQ(Microsoft Message Queuing) and how will setup/configure MSMQ in our local machine.
Now first try to understand about MSMQ.
What is MSMQ?
How Does it Configure in local machine?
1. What is a MSMQ?
MSMQ is stand for Microsoft...
Step By Step Process To Upload Document In Azure Blob Storage Using .NET
Hi friend's, today we are going to understand how to upload document in azure blob storage. i read many blogs and articals about this but i couldn't find any useful blog for this or provided proper information about blob. i collect many information about azure blob...
