Posts

Showing posts from 2017

DTS package conversion in SSIS to use in SQL 2012 and SQL 2016

Image
In my company my team decided to migrate whole SQL 2008 to brand new SQL 2016 in Azure VMs. This was a good idea as we should always be up to date in terms of technology. We did migration all SQL 2008 to SQL 2016 without any problem but suddenly we saw we need to migrate warehouse as well and it was containing very complex DTS package almost 50 in number and we have very less time to finish this task. We first decided to do following things: Upgrade DTS in SSIS with wizard available in SQL 2008 But this was not helpful because if you have some VB script written in DTS and it enables or disables any step then it will not work in SSIS because enabling and disabling is not allowed in SSIS. YOu will have to manually correct all these code. So we tried this and dropped this idea. Manually Convert whole DTS in SSIS: This was blunder for us as it was going to take many months of re creation and testing so tried this and dropped this idea as well because we got a very motivati

SQL Server Failover Clustering in SQL Server 2016 with DNS in Azure

Image
As we know that database mirroring is no longer supported in the latest version of SQL Server i.e. in MS SQL Server 2016. So people are moving toward SQL Server failover clustering as they want to achieve High Availability of database. Here we will setup the things in Azure cloud service, you can enjoy your free subscription of Azure cloud for 1 month. So we can do this in two ways: 1. by using DNS Server which will cost you extra server need more money and maintenance. 2. By using workgroup i.e. without DNS Server this will take less cost in comparison to first one. Best way to do implement SQL Server failover clustering Its all up to your requirement if you have low budget then go without DNS and if have sufficient budget then go with DNS Server extra. Both ways have their own pro and cons so we can't rigid with one way. Steps by Steps to create a   SQL Server Always On Availability Group on Azure Virtual Machines. Create resource group 1)     Sign in to the