Posts

Full day PreCon Practical Performance Analysis in Melbourne at Asia & Australia Tour 2018

/0 Comments/in , , , , ,
As it has almost become a habit by now for me, I will be touring Asia this summer. This year not only Asia, but for the first time also Australia. (There, however, is winter, which sometimes leads to funny confusion in agreements until you get used to this.) 1st stop: Singapore – Azure SQL Database […]
Read more

Performance/ Management Data Warehouse Data Collector & AlwaysOn Availability Groups

/0 Comments/in ,
This time, we are dealing with the „MDW“, short for Management Data Warehouse,( http://msdn.microsoft.com/en-us/library/bb677306.aspx), which I like to recommend as a minimal performance logging-approach. From time to time, and most recently in the context of my PASS Essential „SQL Server Analysis tools & Techniques for Performance und general Monitoring“, the question arises as to whether […]
Read more

Article “SQL Server 2014 – New Fundament” in iX Issue 5/2014

/0 Comments/in , ,
In the May-issue of the iX, on page 56, there is an article by me which I wrote together with my colleagues Volker Heck (Cloud- and BI-Part) and Holger Schwichtenberg (copy-editing).
Read more

Locking & READONLY Filegroups vs READONLY Databases

/0 Comments/in , ,
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 […]
Read more