Database Recovery

How to Use Generally Available Transactional Replication for Azure SQL Databases

In this article, we will some advanced features offered by Azure SQL Database, how they can be used effectively to migrate between different databases. Good news for SQL users, now the transactional replication feature of Azure SQL Database is generally available in SQL Server. Users can use this generally available transactional replication to migrate to Azure in minimal downtime from their on-premises system’s SQL Server Database. It is also being noted that this generally available...

Read more »

4 Quick Steps to Use Query Designer in SQL Server 2017

This article addresses the importance and benefits of Query Designer Support in SQL Server 2017, while also addressing the proper way to use it. Query Designer Support was recently launched in SQL Server 2017, which allows users to use DAX to generate the query which can be used in both tools for dropping or dragging the fields which are required for displaying your query, instead of writing it manually. Query Designer Support uses DAX to generate queries instead, eliminating the manual...

Read more »

2 New Features Introduced in SQL Server Management Studio 17.3

This article addresses the newest features of SQL Server Management Studio 17. 3, particularly Import Flat File Wizard and XEvent Profiler, and how users can use them to increase their efficiency. When it comes to managing nearly any SQL infrastructure, most DBA swear by SQL Server Management Studio (SSMS). In its effort to make this application more effective, Microsoft regularly updates with. The latest iteration, SSMS 17.3 supports all features of SQL Server starting from the 2008...

Read more »