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, September 12 At this online …
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 Distribution database down to your …
Initialize a Transactional Replication from a Database Backup + 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
We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies every few months and must keep our knowledge up-2-date to be competitive. A lot of us are learning through reading, and a lot of us are also learning through watching web casts and training videos. …
SQL Server Quickies – a new way to learn about SQL Server + read more
Yesterday evening (European Time zone) Microsoft has released the SP2 for SQL Server 2008 R2. You can download the Service Pack here: http://www.microsoft.com/en-us/download/details.aspx?id=30437 Because I’m currently working on a Database Mirroring Test Lab that is based on SQL Server 2008, I thought it would be a good exercise to perform a Rolling Upgrade to SP2 …
Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario + read more
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
