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...

Author: Prasant Nanda 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,...

Author: Prasant Nanda 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...

Author: Prasant Nanda 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...

Author: Prasant Nanda 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...

Author: Prasant Nanda 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...

Author: Prasant Nanda 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...

Author: Prasant Nanda Date: 04/28/2014

SQL Azure Database Deployment

SQL Azure Database Updates and Deployment Before going for the deployment plan, we assume the...

Author: Prasant Nanda Date: 01/20/2014

SQL Azure Migration

Since SQL Azure doesn’t support the database restore option, we have to create each db objects...

Author: Prasant Nanda Date: 12/27/2013

What is SQL Azure

SQL Azure A cloud based SQL Server database on clustered servers. Servers are load balanced,...

Author: Prasant Nanda Date: 12/17/2013