SQLServer

How my SQL Server trainings helped Hannes and his company to improve their SQL Server based software

In the last months I have done a lot of SQL Server consulting engagements where I have seen the craziest performance problems and learned how to solve them effectively. Sometimes these problems occurred because of misconfigured hardware (mostly because of I/O subsystems), but almost every problem also had some source in the development, maybe a …

How my SQL Server trainings helped Hannes and his company to improve their SQL Server based software + read more

Replaying workloads with the RML Utilities

In today’s weblog posting I want to talk about replaying SQL Server workloads with the RML Utilities. RML Utilities stands for Replay Markup Language Utilities and are provided by Microsoft as a free download. You can download them here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7EDFA95A-A32F-440F-A3A8-5160C8DBE926. I have first encountered the RML Utilities when I read the book “Professional SQL Server …

Replaying workloads with the RML Utilities + read more

My SQLPASS session

Yesterday we got confirmation from SQLPASS if our submitted sessions for the upcoming SQLPASSS summit in Seattle (October 11 – 14) were accepted. I’m very lucky to announce that my submitted session “Advanced SQL Server 2008 Troubleshooting” made it to the summit as a regular session (75min)! Here’s the abstract that I have submitted: It’s …

My SQLPASS session + read more

My advanced SQL Server Performance Troubleshooting workshop goes to the international level!

I’m working my whole professional work life (around 11 years) with SQL Server, and have see so many pitfalls in configuration options, deployments, and database designs. From all this know-how I’ve done in the past a lot of consulting engagements and have spoken at the various SQL Server conferences across the world about performance tuning …

My advanced SQL Server Performance Troubleshooting workshop goes to the international level! + read more