Recently, I am working on a request to check the possibility to use SQL Server as Powershell DSC Pull Server’s backend. As DSC server supports both of ESENT DB and MDB which is connect… Read More
In this post, we would like to explain on how we can overcome the limitation of using the feature “backup to URL” in Maintenance Plan wizard in SQL 2012
Symptoms
W… Read More
Azure Data Factory allows data to move from a multitude of sources to a multitude of destinations. A common usage case is to take on premise data and place it into a cloud database such as A… Read More
Brian Harry’s recent blogpost about a twitter sentiment analysis as a release gate impressed me a lot and I wanted to find out how complicated it is to do an analysis for my own stuff… Read More
Workloads that rely on auto-commit (each operation like an INSERT has an implied, corresponding begin and commit transaction) and perform a large number of small transactions may take signif… Read More
Azure SQL Data Warehouse manages query workload through a combination of concurrent query execution slots and resources classes. The SQL Data Warehouse workload manager enables you to manage… Read More
Writer: Simon SuTechnical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah
Scheduling and Yielding Knowledge Recap
We all know that SQL server is a multi-threads and multi… Read More
Hello all,
Recently I had worked on an interesting issue with rapid growth of Tempdb on AlwaysOn secondary replica. In this article, we will cover the approach and the queries used to isola… Read More