(James Serra) Microsoft has announced the public preview of Azure SQL Database Managed Instance. I blogged about this before. This will lead to a title wave of on-prem SQL Server database migrations to the cloud. In summary:

(Denny Cherry) Having VMs in Azure which are members of your on-premises domain is a pretty important part of your Cloud implementation. There’s a couple of ways to do this, but I’ll be covering what we at DCAC think is the best option. In basic terms, you’ll set up a VPN from the Azure vNet to yo

(Grant Fritchey) Along with a lot of other people, I’ve been attempting to call people’s attentions to the new General Data Protection Regulation (GDPR) that was created two years ago and becomes effective in May of this year.

(Pinal Dave) After cleaning up some data from my user profile, when I launched SQL Server Management Studio 17.4, I got an error. related to automatically saved settings.

(Matt Usher) 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 your workload within your data warehouse that are contending for system resources.

(johnsterrett) This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other 3rd party tools like ClearTrace, ReadTrace would be used to aggregate the data to get insight into the top offenders.

(Sandeep Raturi) This article explains how we can take SQL database backup through SQL Scripts.

(Greg Robidoux) One issue that I am often faced with is determining what service pack is installed on the SQL Server. In this tip we look at how to find the version of SQL Server that is running and also what service pack or hotfix is installed.

(Pinal Dave) Recently, I wrote a blog about “Change Pending” state of SQL Server service. After looking at that blog one of my readers contacted me via email for the “similar” issue. In this blog, we would learn about another variation of “Change Pending” state. ­­­­

(Jeffrey Yao) With Microsoft releasing new SQL Server versions more frequently, patching all of the different SQL Servers in a timely way can be challenging especially in a big environment with hundreds of SQL Server instances, ranging from SQL Server 2008 to the latest SQL Server 2017.