How to Backup SQL Server Backups to Amazon S3 Storage

It’s been a long time since i posted in my blog. One of the common request i have been asked by my colleagues, friends about “Is there a way to automate backups that are taken on the SQL Server database server running on EC2 instance to Amazon S3 storage?”  Today, I would like to showContinue reading “How to Backup SQL Server Backups to Amazon S3 Storage”

How to Migrate SQL Server Database running on EC2 instance to Amazon RDS Instance

Recently i worked on migrating sql server databases running on amazon EC2 instances to Amazon RDS instances. Starting from 27th Jul 2016 Amazon announced you can ship your databases from ec2 to rds using native backup and restore method. Let’s see how it works. Steps: Assume you have RDS Instance ready with default setting Create aContinue reading “How to Migrate SQL Server Database running on EC2 instance to Amazon RDS Instance”

How to debug SSIS package

You or your team or someone has written an SSIS package which is running flawlessly over few days/months/years. One fine day SSIS package is failing continuously and you need to troubleshoot and fix the issue. Error message is not showing much information about why the package has been failed and until what step the packageContinue reading “How to debug SSIS package”

New SQL Server 2016 Online Alter column

Over the few months i have been playing with SQL Server 2016 new features. Microsoft SQL Server 2016 introduced new alter column with ONLINE option. Let’s explore this. Create a table and insert data    Find what page has been allocated for the above operation. I have used un documented function fn_PhysLocCracker to get the informationContinue reading “New SQL Server 2016 Online Alter column”

The SQL Server Basic Installer: Just Install it in three clicks

Microsoft introduced the new Basic Installer experience for SQL Server 2016 Express, SQL Server 2016 Developer, and SQL Server 2016 Evaluation Editions. Just three clicks you can get a default installation of these editions. You may check full details here Cheers Ramasankar Molleti MSDN:LinkedIn:Twitter

SQL 2014 Service Pack 2 is now Available !!!

Microsoft released SQL Server 2014 SP2 is available for download. These are the improvements introduced in SQL Server 2014 SP2 Automatic Soft NUMA partitioning Dynamic Memory Object Scaling MAXDOP hint for DBCC CHECK* commands Enable >8TB for Buffer Pool SOS_RWLock spinlock Improvement Spatial Native Implementation Database Cloning Tempdb supportability Database Instant File Initialization Logging New DMFContinue reading “SQL 2014 Service Pack 2 is now Available !!!”