People are sometimes asking me, how to become a better, well-rounded SQL Server DBA. Of course, the first reason with which I’m responding is “Experience, Experience, Experience”. Nothing helps you more than a daily experience with SQL Server. But on the other hand you also need to know how SQL Server works internally, how you …
How to become a better, well-rounded SQL Server DBA + read more
My complete last week was dedicated to XTP (Extreme Transaction Processing), better known as Hekaton, that is introduced with SQL Server 2014. My main goal of the week was to get a better understanding of Hekaton, the current limitations, and the scalability of this amazing new In-Memory technology. This blog posting covers the following things …
Extreme Transaction Processing (XTP, Hekaton) – the solution to everything? + read more
I know a handful people who are SQL Server Professionals and using for their day-2-day job a Mac system. Since the summer of last year I have also joined that group of people, and I’m doing the same. In my case I’m using a 2012 MacBook Air with a VMware Fusion VM where my SQL …
Survey: Are you a SQL Server Professional and running on Mac? + read more
Today I have uploaded the 7th SQL Server Quickie to YouTube. This time I’m talking about Latch Contention in TempDb. Thanks for watching! -Klaus
Today I have uploaded the 6th SQL Server Quickie to YouTube. This time I’m talking about THREADPOOL Starvation in SQL Server. Thanks for watching! -Klaus
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.
