Database Solutions

Understanding Import Wizard Improvements in SQL Server Management Studio

This article addresses all the improvements that have been made in SSMS’s Import Wizard and how they can be used for efficiency. SQL Server Management Studio aka SMSS is used for multiple purposes like managing, administrating, accessing, configuring and developing all components of any SQL application like Azure SQL Database, SQL Data Warehouse, and SQL Server. Recently, the 17.3 SMSS was released, and today we are going to talk about how its Import Wizard has improved. The...

Read more »

7 Salient Aspects about SQLPackage.exe and Key Development Tasks It is Used For

This article explains the multiple tasks that can be automated using SQLPackage.exe along with a brief description of those tasks. Out of the multitude of tasks and operations that you can perform in Microsoft SQL Server, there are a few that can be automated using the SQLpackage.exe. This is one of those command lines utility which can be used for automating the given development tasks in SQL Server. This not only makes performing a given a task easier but also helps you save the precious...

Read more »

Understanding Business Continuity Features in Azure SQL Databases

In this article we look at business continuity features present in Azure SQL databases ranging from Point in time restore to active geo-replication. Azure SQL Database is a service provided by Microsoft in the form of cloud database. Azure is a cloud computing platform, which enables organizations to create backups and store their relational data on a large scale on cloud. Azure also helps in scaling the size of business’s database based on their changing storage...

Read more »