The year 2017 is almost over, and therefore I want to announce today some important announcements about my SQL Server trainings that I will offer in the next year. Design, Deploy, and Optimize SQL Server on VMware Today I’m quite proud to announce that I will offer beginning with next year a brand-new SQLpassion workshop: …
Design, Deploy, and Optimize SQL Server on VMware + read more
As we all know the Black Friday approaches quite fast, and therefore I also want to offer you a great deal from my side: Beginning with now until November 26 I will offer my 4 available Online Trainings for only EUR 990 + 20% VAT instead of EUR 1560 + 20% VAT. This will give …
Because of the huge success and additional requests I’m offering my webinar about SQL Server Availability Groups again on October 30. High Availability with previous versions of SQL Server was always complex: you had Clustering, Database Mirroring, Log Shipping, and Replication. Beginning with SQL Server 2012 Microsoft changed everything and introduced a new High Availability …
SQLpassion Online Training about Availability Groups + read more
Today I want to talk about a very important topic in SQL Server – setting a Processor Affinity – and the unwanted side effects that you introduce with this approach. First of all I want to talk a little bit about what a Processor Affinity is, and how it relates to SQL Server. What is a …
Setting a Processor Affinity in SQL Server – the (unwanted) Side-Effects + read more
In one of my last blog postings I have already described a common pitfall when you try to add a new Replica into an Availability Group. In today’s blog posting I want to talk a little bit more about how you can add a Replica back into an Availability Group – when you have removed …
Adding a Replica back into a SQL Server Availability Group + 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.
