(Pinal Dave) Earlier this weekend, I had an urgent product to help. One of my clients reached out to me as their application stopped running in the middle night on Saturday. The issue was indeed a strange one as they have very little traffic on weekends and particularly during the night.

(Kenneth Fisher) If you started out as a developer you were probably taught how important loops are.

(Paul White) This is a companion post to my main article Batch Mode Bitmaps in SQL Server. This post provides demos and illustrations to supplement the technical article.

(Akhil Mahajan) In a previous tip, Securely Manage Secrets in Azure Databricks Using Databricks-Backed, we looked at how to secure credentials that can be used by many users connecting to many different data sources.

(Pinal Dave) The other day, I was hired for the most strange issue I have encountered. One of my previous client of Comprehensive Database Performance Health Check recently reached out with a strange bug where DBCC CHECKDB WITH PHYSICAL_ONLY failed and DBCC CHECKDB Succeeded.

(K. Brian Kelley) We had an issue with our database where the files grew larger unexpectedly. Unfortunately, we didn’t have proactive monitoring in place to know exactly what caused the issue.

(Nisarg Upadhyay) In my previous article, I have briefly covered database statistics, its importance, and why statistics should be updated.

(Dinesh Asanka) In this article, we will walk through Microsoft Naive Bayes algorithm in SQL Server.

(Pinal Dave) While performing an in-place upgrade from SQL Server 2014 SQL server 2016 my client faced an error. In this blog, I am going to share the cause and the solution of error Microsoft .NET Framework 4.0 installation has failed with exit code -2146498511 which was faced during SQL Server up

(Jack Vamvas) Question: We had an unexpected application outage due to a SQL Login which had Enforce password expiration set .