Collecting Server Performance Metrics: PowerShell

In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...

Collecting Server Performance Metrics: PowerShell

In a recent post I wrote about collecting server performance metrics using Performance Monitor, a free utility built into Windows. With a little work up front, we are able...

Execution Plans: Statistics

Watch this week’s Statistics video on YouTube. Last week we looked at what execution plans are and how you can view them. This week I want to discuss what data...

Execution Plans: Statistics

Watch this week's video on YouTube

Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans

Last week...

Execution Plans: Statistics

Watch this week's video on YouTube

Part 1: Introduction to Execution Plans
Part 2: Overview of Statistics
Part 3: Reading an Execution Plan
Part 4: Commonly Troublesome Operators
Part 5: Troubleshooting Execution Plans

Last week...

The tools you should know for the Machine Learning projects

I would like to start my first Machine Learning project. But I do not have tools. What should I do? What tools (environments, libraries etc) shoudl I use? I...

Information Measurement with SQL Server Part 4.6: The Jaccard Distance and Its Relatives

By Steve Bolton …………Over the course of this inexpert exploration of the distance measures used for such data mining applications as clustering, we’ve gradually introduced a system of classification...

Weekly reading #23

New week has started and apart from the usual information from the data world I would like to share one more. The Machine Learning topic published last week has...

More Kubernetes Concepts

This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). Now that I had a break from...

Top SQL Server migration questions

Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to...