SQL Server Premier Field Engineer Blog
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