Weekly reading #6

Coding Family is late this week with the blog post! It is due to heavy storms and wind! It started on Sunday evening and was on Monday as well. Now, as the electricity (more less) is back and the wind is no more 100 km/h I can start blogging!

How Your Hypervisor Can Impact Your CPU

Monica Rathbun explains an unusual case where third-party hosting provider had overallocated virtual processors on the physical host where SQL Server VM were started. That was causing query performance degradation and very high CPU.

[Demo] sqlworkshop

Buck Woody has given a great present for all of us! Like for Christmas! But we have March already. Nevertheless go there and pick the code!

Using Indexing To Solve Blocking and Deadlocking Issues

Do you think that you can actually solve a deadlocks with indexes? Read about the details!

The Case of the NULL Query_Plan

What would you do if your query plan is so big so it cannot be displayed or grabbed in SQL Server Management Studio? Here you find the resolution!

SET Statistics IO Update in SQL Server 2019

Niko Neugebauer is excited about what he has found in the SQL Server 2019 CTP. It is a feature that has never been mentioned before. I am excited, too. It is a good chance you will love the new feature!

Coding Family attended ITechDay in Warsaw

More details come soon! Including the deck and code! We talked famous “Mushroom Session – Eat or Die!”

Cheers,

Damian

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.