This is something that I've seen pop up a couple of times on various forums recently, how can we export the results of an XEvent session. So I thought I'd answer the question here. It's actually a very simple thing to do in SSMS, although the option is not always easy to spot. When we... Continue Reading →
My Application is Getting SQL Timeout Errors, But What Query is the Problem?
This is something that comes up time and time again. A developer or member of the service desk comes up to me and says "SQL's timing out, you see what the query is?". Well I'll tell you now that SQL's not timing out your query, SQL will happily run a query for a year and... Continue Reading →
