Madeira TeamApr 8, 20152 min readHow to Measure IO Latency for Database Files in SQL ServerIn order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a DMV called...
Madeira TeamFeb 24, 20151 min readSpeaking at SQLBits and SQLRallyNext week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun. SQLRally On...
Madeira TeamJun 26, 20131 min readThis Can Be the Best Thing in SQL Server 2014New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that matter the most. I...
Madeira TeamMar 12, 20132 min readDo You Know sys.dm_exec_text_query_plan?One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan. This Dynamic Management Function allows us to...