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 […]
As some of you already may have heard: this June I passed my Lab Exam for the Microsoft Certified Master SQL Server 2008. – almost exactly 3 months after my first attempt. In fact the Exam has already taken place in the middle of May. – Unfortunately this time I had to wait more than […]
This year, too, I am going to be present with two sessions until now at the SQL Con 2011 (26-29 September) in Mainz. Update (09/2011): I cancelled the presentation on “Reporting Services in SQL Server Denali” in favor of a topic I feel even more strongly about. (Besides, the Reporting Services themselves will hardly go […]
Almost a year ago I discovered an issue with SQL Server (all Versions from 2005 – 2008 R2, haven’t tested 2000) regarding the usage of the guest-account and impersonation. It also was presented by Ralf Dietrich and me at the SQL Server PASS Summit 2009 in Seattle where we informed Microsoft about it. – Thanks […]
