Month: June 2020

Open Letter to PASS

  By

As you know, I spoke to 12 Chapter Leaders and 4 Regional Mentors yesterday. All are very upset with PASS right now and feel slighted, which as a volunteer myself, I empathize. I have given the feedback, to you. After talking with them here is where the problem lies IMHO: communication and transparency. We received an email taking away our token of appreciation PASS gives us for all our yearlong hard work that helps to build and amplify this community. In the email we also were asked to please promote and encourage Summit registrations among other things. You cannot take… Continue Reading

What is Batch Mode on Rowstore in SQL Server?

  By

Under compatibility level 150, in both SQL Server 2019 and Azure SQL Database, you now can use batch mode for CPU-bound analytic type workloads without requiring columnstore indexes. There is no action needed to turn on batch mode aside from being on the proper compatibility mode. You also have the ability to enable it as a database scoped configuration option (as shown below), and you can hint individual queries to either use or not use batch mode (also shown below). If you recall in my earlier blogs on columnstore, it is batch mode in conjunction with page compression that drastically… Continue Reading

My Thoughts on PASS Virtual Summit – An Editorial

  By

On June 3rd PASS announced their annual Summit for Data Professionals was moved to a virtual format. This is not surprising to those of us in the SQL Server community. Many events are moving to a virtual platform as well as being able to offer them at no costs to all attendees. PASS though, is a different kind of “company” for lack of a better word. We are a community of people that built this “company” from the ground up. Due to normal day to day commitments, like jobs, most of us do not have time to run the day… Continue Reading