DBA and DataScience

  • SQL Server
    • SQL Backup Recovery
    • SQL Security
    • SQL Performance
  • DataScience
    • Python
  • About Me

Database Administration and the path of Data Science

SQL Server

SQL Job resume automatically after server restart

As the title says, this script looks for any failed or cancelled jobs and will restart them from the failed step automatically. This type of script is useful in below scenario: You have a job with multiple steps which runs Read more…

By harimindi, 11 months11 months ago
SQL Security

Linked Server Double-Hop Issues with SQL Server

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…

By , 2 years2 years ago
TSQL

Calculate date difference of 2 consecutive rows of a column – TSQL

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…

By harimindi, 2 years2 years ago
SQL Security

Verify TLS 1.2 Connections from SQL Server

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…

By harimindi, 2 years2 years ago
SQL Performance

SQL VDI Errors

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…

By harimindi, 3 years3 years ago
SQL Security

Setting SSL or TLS encryption on SQL Server

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…

By harimindi, 3 years3 years ago
DataScience

House Price Prediction – Data Science

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…

By harimindi, 3 years3 years ago
DataScience

Outliers and Feature Engineering – DataScience

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…

By harimindi, 3 years3 years ago
SQL Server

SSCM – Cannot Connect to WMI Provider

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…

By harimindi, 3 years ago
DataScience

Missing data treatment – Python Script

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…

By harimindi, 3 years3 years ago

Posts navigation

1 2 3 Next
Categories
  • DataScience (10)
  • Python (5)
  • SQL Backup Recovery (1)
  • SQL Performance (9)
  • SQL Security (4)
  • SQL Server (17)
  • TSQL (2)
Recent Posts
  • SQL Job resume automatically after server restart
  • Linked Server Double-Hop Issues with SQL Server
  • Calculate date difference of 2 consecutive rows of a column – TSQL
  • Verify TLS 1.2 Connections from SQL Server
  • SQL VDI Errors
Contact Email:
  • harikumar.mindi@gmail.com
  • About Me
  • Contact Me
  • Data Science
  • Posts
  • Python Scripts
  • Scripts
  • SQL Server
Hestia | Developed by ThemeIsle