SQL Server Database Recovery

5 Innovative Enhancements in Analysis Services in SQL Server 2017

The article brings the innovative features in SQL SERVER 2017 into limelight and provides a quick walkthrough of the new features. In the 2017 edition of SSAS i.e. MS SQL-Server Analysis Services, the Redmond based software giant has introduced new features of connectivity and modeling for enterprise scale solutions which can deliver valuable insights. SSAS is basically a part of SQL server suite and runs on windows allowing professionals to design semantic models. The features introduced...

Read more »

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 »