Migrating Symmetric Keys Between SQL 2016 and SQL 2017/Azure

There has been a recent discussion about migrating symmetric keys between instances and version of SQL Server. It doesn’t seem to be a widely known process and there have been some changes between versions. Background There are many ways to migrate between versions of SQL Server, some of these ways have more moving parts than…

0

Trace Flag 1117 Growth and Contention

In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth with multiple data files in TempDB consistent.  You’ll see how growth occurs if the files are disproportionate and also the effect it has on TempDB contention with SQL Server special pages (PFS, GAM, SGAM). For…

0