APS 2016 External Object Changes

APS customers who use Polybase and will be soon upgrading to APS 2016 from AU5 or prior should consider this change and take action prior to upgrading. APS 2016 upgrades the underlying SQL instances to SQL 2016. Along with that comes Polybase that was added to SQL 2016. Polybase is a great feature to see…

0

CREATE INDEX Monitoring Progress

One of the challenges for DBA’s are to work on heavy load and critical systems where maintenance windows are usually very short, recently I was asked for a customer if there was any possibility to track or estimate the progress of a CREATE INDEX statement and my response was sys.dm_exec_query_profiles. Starting with SQL Server 2014…


SQL 2016 – Temporal Tables – Can you change the schema?

I was recently asked if after you setup a Temporal Table, can you modify the schema?  It was a great question because if you cannot change the schema, then you would have to drop and recreate the table every time you need to change the schema which means you would potentially lose all the history. …

0

Recover database without LDF file

I recently came across a missing LDF file case that I would like to share some interesting findings. In my case, the customer didn’t have any database backup (they did have maintenance plan created, however, the job had been being failing since the day it was implemented. Another sad story telling us how important to…


Troubleshooting intermittent connection timeout

In this blog, we are going to take a deep dive into a connectivity issue my customer encountered a while ago. DBA was pulled into this case because the error was caused by SQL Server connection timeout. We looked at SQL Server log and there was no messages about connection failure. The issue turned out to…


SQL 2016 – Temporal Tables – What are they and how do you set one up?

What are Temporal Tables?   This is the start of a series of posts about one of my favorite new features of SQL 2016, Temporal Tables.  Temporal Tables allow you go back in time and see what the data in table looked like at that point in time.  Unlike the movie series Back to the Future, you…

3

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 relating to SQL Server transaction log backups of databases using a read-only secondary replica (ROSR).  Since the introduction of ROSRs in SQL Server 2012, administrators have been able to perform full database (copy only) backups as…

2

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 Backups of databases using a read-only secondary replica (ROSR).  With the introduction of ROSRs in SQL Server 2012, administrators can now perform full database (copy only) backups as well as transaction log backups on one of the secondary…

0