In my session Session „Hasta la vista Profiler – Tracing with Extended Events“, which I have presented at several occasions, I used to ask the audience which tools they used for monitoring so far. I would like to use this platform to survey on a broader range as to which tools are being used by […]
No big science, more out of curiosity this time.. The Extended Events File Target for SQL Server saves data using xml, which as is well known, is a bit “chatty”. A student in my recent SQL Server Master-Class workshop on extended events came up with the question for how much (more) space he would have […]
One of the features new in Analysis Services 2012 is the support of the SQL Server Extended Events Framework. While there is no GUI support for that, yet, it is however possible to set up a XEvent session via DDL commands – just like it was in the “old days” with SQL Server 2008/ 2008 […]
My First Blog Post here is partly for my own cause, but on the other hand, it is for You and all those who are inquisitive and eager to learn in terms of SQL Server: I have often been asked if I wouldn’t want to write a book sometime to share my knowledge, or to […]
The Topic Locking and Read-Only for filegroups and databases is one of the ongoing myths around SQL Server in forums – and at least half of the information unfortunately wrong. Since I recently fell into the trap myself, I want to write down, how it really is. To have a definite picture, I made 3 […]
