The Problem: I have 2 SQL Server names Server A and Server B. I have created a linked server on Server A to Server B which means I would like to run a query on Server A which pulls some Read more…
I came across a situation where I had to write a query to calculate difference of 2 rows of datetime column based on a condition of another field. I was troubleshooting performance issues of few stored procedures which are setup Read more…
An ideal way to verify if the connections are using TLS 1.2 protocol or not is through some network monitoring tools like Netmon or Wireshark. However from SQL Server, we can monitor them using extended events and can be done only for SQL Server Read more…
SQL VDI Errors (SQLVDIMemoryName_0) SQL Backup failed messages logged in SQL Error Log On one of our SQL Servers, we have noticed backup failed messages in SQL Error Logs. BACKUP failed to complete the command BACKUP DATABASE master. Check the Read more…
Nowadays security takes utmost importance in the wake of several data breaches reported in the last few years. These are also enforced by some regulatory authorities (GDPR or Data Protection Act or PCI standards) as compliance. Particularly the companies involved Read more…
This post is continuation to the previous posts on Data Science process. We will try to predict housing prices based on some training dataset. I am using Ames housing dataset and based on my previous posts on the process this Read more…
Outlier treatment and Featuring Engineering would be the next steps in continuation to Missing Data Treatment. Outliers Definition: An outlier is an observation that lies an abnormal distance from other values in a random sample from a population. It is an observation Read more…
SQL SERVER – Configuration Manager – Cannot Connect to WMI Provider When you try to open SQL Server Configuration you get the below error: Cannot connect to WMI provider. You do not have permission or the server is unreachable. This Read more…
In my previous post i briefly discussed about different techniques of handling missing data for building Machine Learning model. Below is Python script for treating missing data in Ames dataset. (Download the dataset from here) As usual open Jupyter notebook Read more…
Missing data is one of the most common / frequent occurrence in real world Data Science. This can happen in data collection phase in different ways. For Example, people may not answer all questions during a survey or the data Read more…