SSIS and SSRS upgradation process

With the introduction of new MSBI versions, we get excited with new features and love to be upgraded with latest. But it’s not that easy to upgrade our ecosystem of MSBI applications. Below are few options to do the tech refresh (either version up-gradation or migrating to new environment with different version of application). In…

0

Usage of shared resources on Azure (WAP)

Here we are going to discuss regarding the usage of shared resources which are available on premise, to be accessed on Azure. What is shared resource? The resource (hardware, software etc.) which is created once and can be accessed by other systems / processes remotely multiple times. Here we are discussing about printer, shared physical…

0

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 HttpWebRequest to access the web service (Rest Based), but was getting error “The underlying connection was closed: An unexpected error occurred on a send.” I used the fiddler tool to analyze the internal of request, but strange…

0

SSIS Encrypt and Decrypt Connection String

              Sometimes it is needed to secure the connection string which we use in SSIS package. Even we store the connection string in sql server database as config, the users who has access to the config table, can read the connection string. In order to secure it, we should encrypt the connection string and store…

0

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 the job (stored procedure execution) on Azure. There are 2 approaches to do this. 1. By scheduler available in Azure mobile service. We can execute sql procedures on Azure based on our need (schedule configuration). Create…

8

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 application and it may be from upstream, same system, for downstream etc. Consider an upstream system from where we get 100,000 to 200,000 records every day and the data does not have any differentiator to…

0

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 system along with enhancements previous version features. Performance improvements New In-Memory (codenamed  as Hekaton) OLTP built in to core SQL Server database allows to improve performance of database applications. Enhanced In-Memory ColumnStore for Data Warehousing – now…

0

SQL Azure Database Deployment

SQL Azure Database Updates and Deployment                Before going for the deployment plan, we assume the database is created in SQL Azure database server.  In case of hybrid model where we have both on-premise and azure databases, we can create a data-sync agent and group to sync the databases. The syncAgent need to be created…

0

SQL Azure Migration

Since SQL Azure doesn’t support the database restore option, we have to create each db objects and execute them in Azure. So we have created our empty database in Azure and below steps to be performed for database objects.  User Login creation – We have to generate scripts for the required logins from on-premise database…

3

What is SQL Azure

SQL Azure A cloud based SQL Server database on clustered servers. Servers are load balanced, replicated databases and failure detection. Which provides high availability, scalability and reliability. Each user database is having 3 replicated databases. Before a transaction gets committed, one primary and one secondary replicated database should also be updated. It supports .net framework…

0