Today is a very sad day for me. My love, my dear Windows has passed away. We were together for over 20 years, her illness took control over her, and during the last days she passed away.

Before I give you further details about the disease she had over the… Read more

Every one of us knows Bookmark Lookups in SQL Server. They are great, because you don’t need to care about your indexing strategy. They are bad, because with Bookmark Lookup you just introduce a bunch of other problems for your SQL Server installation. Almost every time when I’m on client… Read more

Since September 2012 I'm a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server that is currently available. Because I want to share my performance tuning & troubleshooting knowledge, and because of the huge demand on performance tuning I'm running again this year… Read more

Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server that is currently available. Because I want to share my performance tuning & troubleshooting knowledge, and because of the huge demand on performance tuning I’m running again this year… Read more

Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks in SQL Server. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Santa Claus

Read more

Today I have uploaded the 5th SQL Server Quickie to YouTube. This time Santa Claus talks about Bookmark Lookup Deadlocks in SQL Server. You can find the script used during the demonstration here as a download.

Thanks for watching!

-Santa Claus

Read more

Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I'm running on January 29 (Vienna/Austria) and January 31 (Zurich/Switzerland) my 1 day workshop called "Practical SQL Server Performance Troubleshooting Day" (see http://www.SQLpassion.at/events.html for further information).

During this 1 day workshop we will take a… Read more

Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I’m running on January 29 (Vienna/Austria) and January 31 (Zurich/Switzerland) my 1 day workshop called “Practical SQL Server Performance Troubleshooting Day” (see http://www.SQLpassion.at/events.html for further information).

During this 1 day workshop we will take a… Read more

Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I’m talking about IAM Pages in SQL Server. You can find here the script I have used during the demonstration as a download.

Thanks for watching!

-Klaus

Read more

Today I have uploaded the 4rd SQL Server Quickie to YouTube. In this episode I'm talking about IAM Pages in SQL Server. You can find here the script I have used during the demonstration as a download.

Thanks for watching!

-Klaus

Read more

A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we go into the details of this approach and if it could work, I want to give you an overview about the requirements, and why the customer wanted to have Nested… Read more

A few weeks ago I had a customer engagement, where the customer wanted to implement Nested Partitioned Views. Before we go into the details of this approach and if it could work, I want to give you an overview about the requirements, and why the customer wanted to have Nested… Read more

Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I’m talking about Allocation Units in SQL Server.

Thanks for reading & watching

-Klausy

Read more

Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I'm talking about Allocation Units in SQL Server.

Thanks for reading & watching

-Klausy

Read more

The summer goes by and in a few weeks the conference season starts over again. The last weeks were a little bit stressful, but now I had finally some time to prepare my sessions for upcoming SQL Server conferences, where I'm speaking over the next months.

24 Hours of PASS,… Read more

The summer goes by and in a few weeks the conference season starts over again. The last weeks were a little bit stressful, but now I had finally some time to prepare my sessions for upcoming SQL Server conferences, where I’m speaking over the next months.

24 Hours of PASS,… Read more

During the last days I’m working on Replication – especially with Transactional Replication. The main idea of Transactional Replication is that you have a so-called Log Reader Agent on your Publisher SQL Server database running, that is analyzing the Transaction Log File and synchronize changes on so-called Articles through a… Read more

During the last days I'm working on Replication – especially with Transactional Replication. The main idea of Transactional Replication is that you have a so-called Log Reader Agent on your Publisher SQL Server database running, that is analyzing the Transaction Log File and synchronize changes on so-called Articles through a… Read more

Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I’m talking about Extents, and how SQL Server manages those through GAM and SGAM pages.

Thanks for reading & watching!

-Klaus

Read more

Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I'm talking about Extents, and how SQL Server manages those through GAM and SGAM pages.

Thanks for reading & watching!

-Klaus

Read more