Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This is a shared team blog of the SQL Server Premier Field Engineer team
The Problem You restored a database on top of an existing database to refresh your development...
Date: 02/25/2019
The Problem One of the best things about Azure, and the cloud in general, is we can automate most...
Date: 02/25/2019
I have been asked to provide some information on best practice for SQL Server Backup and Restore...
Date: 10/05/2018
AlwaysOn Availability Groups unable to query against readable secondary replica database: Wait Type HADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONING
Recently a customer reported an interesting issue, while querying against recently added readable...
Date: 07/13/2018
Configure SQL Server Failover Cluster Instance If you are running a SQL Server Failover Cluster...
Date: 07/05/2018
What is a Domain Independent Cluster? Did you know that you can have a Windows cluster that is a...
Date: 07/05/2018
What is a Read-Scale Availability Group? A Read-Scale Availability Group is a Clusterless...
Date: 07/05/2018
The MSDTC Configuration Conundrum MSDTC configuration is not as straight forward as you might think....
Date: 07/05/2018
There has been a recent discussion about migrating symmetric keys between instances and version of...
Date: 06/08/2018
How do you monitor Azure Analysis Services? How many users are connected and who are they? These are...
Date: 04/02/2018
Starting in Windows Server 2012 R2 you now have a way to upgrade a cluster to Windows 2016. The...
Date: 12/08/2017
SQL Server 2017 was recently launched, having multiple new features. One of these included something...
Date: 11/17/2017
Buffer Pool Extension was released in SQL 2014 so it's not new. It is also not advertised very...
Date: 10/19/2017
Background As you may know, TLS 1.0 is being deprecated due to various known exploits and will no...
Date: 09/27/2017
In this post I'll point you to some options to sync SQL logins and then I'll demo my favorite option...
Date: 08/21/2017
In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth...
Date: 07/18/2017
I have had several Query Store questions come in from customers lately. Some of the questions...
Date: 07/17/2017
Background One of the new features of SQL Server 2016 is the ability to use SQL Server with Failover...
Date: 06/28/2017
Hello again and welcome back to the series on Temporal Tables! Today we will take a look at two...
Date: 06/20/2017
In previous blog, I discussed the CDC failure due to guest user disabled in MSDB. My customer also...
Date: 05/30/2017
My customer had recently experienced 2 interesting CDC issues and I would like to share the...
Date: 05/17/2017
I recently ran into an issue in which a machine was connecting to SQL and continuously generating a...
Date: 05/04/2017
Back in 2012 when the project deployment model came out for SSIS, many questions were asked...
Date: 04/18/2017
We've all been in the position where we are doing research and need to add commas or single quotes...
Date: 04/11/2017
While troubleshooting SSIS package performance, having the ability to view the performance monitor...
Date: 03/15/2017
Periodically we are asked how to split an existing filegroup into multiple data files. The quick...
Date: 03/03/2017
Several years ago, I wrote a blog post as to how you can collect your own custom SQL data from a...
Date: 02/24/2017
Last week, I have had one mystery challenge while creating Availability Group listener in Azure. We...
Date: 02/21/2017
Recently I was assisting a customer with a review of their SSIS implementation and one the security...
Date: 02/14/2017
In my last post, I discussed how to increase the error logs through the GUI and explained the back...
Date: 02/09/2017
In a previous post, we have reviewed Azure RM: How to create SQL Server AlwaysOn Availability Groups...
Date: 01/31/2017
In SQL Server, when you perform a partition switch, a schema lock is acquired briefly to do the...
Date: 01/30/2017
Recently after installing SQL Server and configuring SSIS for project deployment in a SQL Server...
Date: 01/24/2017
As we continue our journey with Temporal Tables, the next topic will be how do you drop them. While...
Date: 01/19/2017
So many new features get added with each release of SQL it is hard to use them all. Sometimes, I...
Date: 01/17/2017
APS customers who use Polybase and will be soon upgrading to APS 2016 from AU5 or prior should...
Date: 01/11/2017
One of the challenges for DBA's are to work on heavy load and critical systems where maintenance...
Date: 12/22/2016
I was recently asked if after you setup a Temporal Table, can you modify the schema? It was a great...
Date: 12/21/2016
I recently came across a missing LDF file case that I would like to share some interesting findings....
Date: 11/16/2016
One of the tempdb best practices when you configure SQL Server is to create additional data files...
Date: 11/10/2016
In this blog, we are going to take a deep dive into a connectivity issue my customer encountered a...
Date: 11/08/2016
What are Temporal Tables? This is the start of a series of posts about one of my favorite new...
Date: 11/01/2016
I recently ran into an issue (will describe it in a follow-up post) in which I needed to review SQL...
Date: 10/28/2016
Performing transaction log backups using AlwaysOn Availability Group read-only secondary replicas-Part2
Describe the log backup process on a ROSR This is the second post in a planned series of articles...
Date: 10/19/2016
Performing Transaction Log Backups using AlwaysOn Availability Group Read-Only Secondary Replicas - Part 1
This is the first post in a planned series of articles relating to SQL Server Transaction Log...
Date: 10/19/2016
This is a follow up to my first post Finding What Availability Group Listeners Applications Are...
Date: 10/18/2016
In this blog post I am going to discuss a very little-known performance metric introduced in SQL...
Date: 10/11/2016
It's 3 AM on a Saturday morning and you receive that dreaded phone call – "The SQL Server just had...
Date: 10/05/2016
In a previous blog post, I showed you how you can set a target server version for an SSIS project in...
Date: 09/29/2016
The Background Before SQL Server 2016, businesses had to choose between securing their databases...
Date: 09/27/2016