SQL Server 2016 : Getting tempdb a little more right
I explain how SQL Server 2016 improves tempdb configuration and performance.
Monthly Archive: September 2015
Search all string columns in all SQL Server databases
Tip : Search all string columns in all SQL Server databases
Slides and samples from SQLSaturday Holland
I share my deck and sample code from my most recent SQLSaturday appearance.
SQL Server 2012 Service Pack 2 Cumulative Update #8
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...
Follow-up on cursor options
I add a few tidbits to follow up on a popular post on default cursor options in SQL Server.
24 Hours of PASS: Summit Preview Edition
I share my slide deck and sample code from a recent 24HOP presentation, and address audience questions from the session.
SQL Server 2016 Always Encrypted
Tip : SQL Server 2016 Always Encrypted
SQL Server 2016 Row Level Security Limitations, Performance and Troubleshooting
Tip : SQL Server 2016 Row Level Security Limitations, Performance and Troubleshooting
Enabling "Super Admin" on Windows 10
How I worked around a recent problem with Windows 10 and its not-so-administrator administrator account.