MS-Tech learning with Prasant
SSIS and SSRS upgradation process
With the introduction of new MSBI versions, we get excited with new features and love to be upgraded...
Date: 08/29/2017
Usage of shared resources on Azure (WAP)
Here we are going to discuss regarding the usage of shared resources which are available on premise,...
Date: 05/24/2016
HttpWebRequest POST method Err. The underlying connection was closed
Currently I faced an issue while posting an xml file through the 3rd party web service. I used...
Date: 05/14/2015
SSIS Encrypt and Decrypt Connection String
Sometimes it is needed to secure the connection string which we use in SSIS package. Even we store...
Date: 03/17/2015
Scheduling job on SQL Azure
The SQL Azure doesn't support sql jobs. So we cannot deploy the jobs on Azure. But we can schedule...
Date: 07/09/2014
Data compare between tables in SQL Server
Problem Now days we are dealing with lot of data every day. We process more and more data in our...
Date: 06/06/2014
First hands on using SQL Server 2014
SQL Server 2014 The new version of SQL server 2014 comes with various capabilities for OLTP and DW...
Date: 04/28/2014
SQL Azure Database Deployment
SQL Azure Database Updates and Deployment Before going for the deployment plan, we assume the...
Date: 01/20/2014
SQL Azure Migration
Since SQL Azure doesn’t support the database restore option, we have to create each db objects...
Date: 12/27/2013
What is SQL Azure
SQL Azure A cloud based SQL Server database on clustered servers. Servers are load balanced,...
Date: 12/17/2013