I explain how SQL Server 2016 improves tempdb configuration and performance.
Monthly Archive: September 2015
Tip : Search all string columns in all SQL Server databases
I share my deck and sample code from my most recent SQLSaturday appearance.
Microsoft has released Cumulative Update #8 for SQL Server 2012 Service Pack 2. KB Article: KB #3082561 24 fixes total (23 fixes listed publicly at time of publication) Build number is 11.0.5634 Relevant for...
I add a few tidbits to follow up on a popular post on default cursor options in SQL Server.
I share my slide deck and sample code from a recent 24HOP presentation, and address audience questions from the session.
Tip : SQL Server 2016 Always Encrypted
Tip : SQL Server 2016 Row Level Security Limitations, Performance and Troubleshooting
How I worked around a recent problem with Windows 10 and its not-so-administrator administrator account.