SQL Server Database Recovery

How Snapshot Replication Works in MS SQL Server

This article explains the snapshot process by going into the details of its working. Snapshot replication in SQL Server comes handy when you wish to share your database exactly the way it is right now, not focusing on any of the updates that would be made in it. Snapshot replication feature of SQL Server helps users to share data the way it appears in the current moment to the subscribers. It is important to note that although the snapshot replication process can be used in isolation, it...

Read more »

How On-demand Analytics Service Works with Azure Data Lake

This article addresses how on-demand analytics service works with Azure Data Lake. Azure Data Lake is an analytics service, which aims at easing big data analytics into a simpler avatar. This allows organizations to focus on managing, running and writing jobs instead of operating on a distributed infrastructure. Users use queries to extract valuable insights and transform their data, instead of configuring or deploying or tuning their hardware. This on-demand service can be used for...

Read more »

How to Authorize Additional Connections after Connecting to SQL Server

In this article, users can learn to authorize additional connections after connecting them to a Database Engine in SQL Server. Users can easily connect Database Engine to tools which are running in a computer, especially if they know the names of the instance, or if they are connecting to the engine as a part of the Administrator group. Note that in order to connect a database engine user needs to operate the connection procedure from the host SQL server. Steps for...

Read more »