I explain how SQL Server 2016 improves tempdb configuration and performance.

Tip : Search all string columns in all SQL Server databases

I add a few tidbits to follow up on a popular post on default cursor options in SQL Server.

Tip : SQL Server 2016 Always Encrypted

Tip : SQL Server 2016 Row Level Security Limitations, Performance and Troubleshooting