In this post I want to do a one-stop post for Data Platform one-stop posts. Some of you are probably wondering what on earth this post is about?
Well, I thought I would do something different since I am getting ready to attend the Pass Summit in the USA for the first time ever. Something that I am certainly looking forward to.
Since a lot of members of the Data Platform community will be there I thought I would cover some Data Platform one stop posts for certain items. In other words, the kind of post you go to that’s a one stop place for something.
In reality, it’s not a complete list. With this in mind, feel free to comment on others you feel should be included. Since I live in Europe I will cover my fellow Europeans first.
I’ve decided to do Hugo’s post first since we live in the same country. He’s been very busy and compiled a list of all the current execution plan operators for SQL Server and their icons here.
In this post Wolfgang has been busy collecting links to all the Power Platform sites. Hence there is a wealth of knowledge if you follow the links he has gathered here.
Niko is well-known for his knowledge about Columnstore indexes. He has compiled an impressive blog series of all things relating to Columnstore indexes. To date he has posted 126 separate posts relating to the workings of Columnstore indexes. You can read them in detail here.
Over the years Vincent has compiled a very impressive list of who’s who within the SQL Server Analysis Services (SSAS) community. You can read the list in detail here. It contains a very impressive list that includes a lot of names, some of whom are familiar to me. He’s taken the time to write about all of these, so credit given where it’s due.
With his extensive SQL internals knowledge Paul has compiled two comprehensive libraries about SQL Server wait types and latches. You can view the posts about them in detail here.
The anonymous sqlserverbuilds contributor(s)
I’ll admit I have no idea who compiles this list and neither do a fair few other members of the community. It’s certainly an impressive list all the SQL Server build version numbers. So you can easily see which version of SQL Server you have here.
If you follow the links it also lists all the database and SSMS versions as well. From the look of it they also cover SharePoint and Exchange versions as well. Whoever is responsible, kudos to you.
Microsoft’s Azure Customer Advisory team (AzureCAT) have published various white papers and ebooks over the years. You can now find the post detailing about the gallery for these here.
An honourable mention to…
An honourable mention to the late Robert Davis (SQLSoldier). When he gained his MCM certification I’m sure he posted his list of books he recommended for the exams. Even though I’ve not being able to find the post anywhere I’m still going to mention it to show just how helpful he was.
This week I’ve been thinking about him a bit. We talked online in the past and he personally recommended me for a job even though we had never met in person. Next week I was hoping to meet him in person and thank him for recommending me.
Other people in the community knew him a lot better than I did and I know he’s extremely missed. I wish Argenis Fernandez the best of luck in his current effort in keeping Roberts posts and his legacy online.
Well that’s it from me as far as this one-stop post for Data Platform one-stop posts is concerned.
Of course, if you feel I have missed anybody out feel free to comment.
[…] Neugebauer has a whole series dedicated to columnstore indexes which I talked about in a previous post. In this post I’m going to cover some immediate DBA related […]
[…] To check this, you can run ‘Select @@version’ in SQL Server to get the current version number. Alternatively, look in the latest log file in the setup bootstrap folder. If you have a version number for SQL Database Engine you can compare on it on the website I talked about in a previous post here. […]