(Pinal Dave) While working with one of the clients to recover from a disaster, I encountered an error. In this blog we would talk about error Drop failed for Availability Group. If you want any such assistance, you can hire me for quick consultation using On Demand offering.

(Sadequl Hussain) We have a lot of time-series data stored in our SQL Servers. Our analysts are looking for a simple way to make sense of this data. Is there any good tool for this? We don’t have the budget for a commercial product at the moment.

(Denny Cherry) Cost Threshold for Parallelism is a setting in SQL Server that’s been around for as far back in the product that I can think of. It decides how expensive an operator needs to be because SQL Server will use multiple threads for that operator instead of a single thread.

(blobeater) Quite simply the objective as follows: Move data from Azure SQL Database to Azure SQL DW via Azure Data Factory v2 (ADF).

(Pinal Dave) One of my clients was trying to automate SQL deployment. While testing they were stuck with an interesting error and then they contacted me. In this blog, I would share my learning about an installation error: System.ArgumentNullException – Value cannot be null.

(Rajendra Gupta) This article describes the data synchronization process on SQL Server Always On Availability Groups in both Synchronous, and Asynchronous data commit mode.

(Jack Vamvas) Question: What are the powershell commands to create to ASSIGN a drive letter and then create a MOUNT POINT?

(Jason Brimhall) How does one consistently find the correct path to the Extended Event Log file (XEL file)?

(Bhavesh Patel) There is often a need to zip and unzip files that we get that need to process with SQL Server Integration Services (SSIS). There are several different tools that exist that have this functionality.

(Tibor Karaszi) Does fragmentation hurt? Last time, I said “probably not”. I’m glad I added that “probably” in there.