If your Database Master Key (DMK) is encrypted by the Service Master Key, then you will need to re-encrypt the DMK with the new Service Master Key on the new...

The behavior changed in SQL 2016:
https://support.microsoft.com/en-us/help/4010261/sql-server-and-azure-sql-database-improvements-in-handling-some-data-t

If you run the query on a SQL 2017 database set to compatibility level 120 (SQL 2014) or less, it will...

I looked at the mask: 111111111100000000001111111111, which I'm guessing is:
00000000001111111111
00000000001111111111
...and they have 10-core processors with hyperthreading turned on, and this mask is to stick to the physical...

I have done a lot with Distributed Replay. Some things you should know:

Distributed Replay is 32-bit code from the SQL2005 days, even if you pulled it off the...

GETDATE() returns a datetime data type, which lacks time zone information. The date provided from the server is treated as though it came from time zone offset +0:00 (GMT). Time...

Check your email. The links recently went out  🙂

You're correct about the latch contention caused by heavy create/drop #temp table traffic - specifically, adding the first row to...

I've replayed many 2008 traces (taken with the "T-SQL Replay" template) on 2016, using both Profiler and Distributed Replay.

To which doc are you referring?

select A.name, case when A.id=2 then C.ID else null end as [ID]
from TableOne A
left join TabletTwo B on A.id=B.id
left join TableThree C on A.id=C.id...