(Siddharth Mehta) Exploratory data analysis is a very standard, fundamental and preliminary process of data exploration before it is considered suitable for different kinds of statistical analysis like machine learning, deep learning, etc.

(Daniel) When you followed the Azure docs on how to dynamically create Azure disks via a Kubernetes PVC, you saw the instructions to create a backup of the disk.

(Itzik Ben-Gan) Last month, I covered a puzzle involving matching each row from one table with the closest match from another table. I got this puzzle from Karen Ly, a Jr. Fixed Income Analyst at RBC.

(Thomas LaRock) At VMworld in Barcelona this year there arose a question regarding SQL Server Standard edition and if it is NUMA aware. I was certain the answer was “yes”, but it was pointed out to me that the documentation says otherwise.

(Pinal Dave) Every user wants their applications to run faster. My primary responsibility is to help people with SQL Server Performance Tuning and Optimization, and I believe there are three important challenges any DBA faces.

(Pinal Dave) I wrote a blog earlier about reading data from excel via SQL Server. This was done using ‘OpenRowset. One of my blog readers sent an email to me that they were getting an error.

(Greg Larsen) Azure Data Studio is a cross-platform database tool to allow data professionals a single user interface to work with databases on premise and in the cloud.

(Bob Dorr) I was doing backups and clean-ups and ran across a couple of sample projects for XEvent and event_sequence processing I thought others might find helpful. – Enjoy!

(blobeater) Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an extended events script to see what sort of I/O patterns my query was doing (This is a fun post).

(Jason Brimhall) Not only is this mystery of missing backup files worth discussing now, but has been a mystery worth talking about previously (albeit in slightly different form).