March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
network port

SQL SERVER – Network Port Used

November 24, 2020
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Scripts, SQL Server

During the recent Comprehensive Database Performance Health Check, I got a question from a client if there is an easy way to figure out the Network port.

Read More
Volume Mount Point

How to Get Volume Mount Point for SQL Server Files? – Interview Question of the Week #295

September 27, 2020
Pinal Dave
SQL Interview Questions and Answers
Computer Network, SQL Scripts, SQL Server

Question: How to Get Volume Mount Point for SQL Server Files? 

Answer: I was asked this question by my client during the recent Health Check.

Read More
error 21

SQL SERVER – Fix: The operating system returned error 21(The device is not ready.)

August 15, 2020
Pinal Dave
SQL
Computer Network, SQL Error Messages, SQL Server

The client was in very much panic as they were getting the following error – The operating system returned error 21(The device is not ready.)

Read More
Azure Firewall

SQL Server – T-SQL – Add and Remove IP Address to Azure Firewall

July 21, 2020
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Azure, SQL Server, SQL Server Security

The question was is there any way to list all the IP addresses which have access to the Azure Firewall and remove them via T-SQL in SSMS.

Read More
ip address

SQL Azure – Add IP Address to Firewall

July 20, 2020
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Azure, SQL Server, SQL Server Security

However, recently my client was working from home and he was not able to access the SQL Azure database. Let us learn how we can and IP Address to Access.

Read More
network protocol

SQL SERVER – Network Protocol and IP Address

June 23, 2020
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Scripts, SQL Server

The question was if there is a way to know how many sessions are connected to current SQL Server instance with their network protocol as well as IP address.

Read More
IP Address

How to Find IP Address of All SQL Server Connection? – Interview Question of the Week #280

June 7, 2020
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL DMV, SQL Scripts, SQL Server

Question: How to Find the IP Address of All SQL Server Connection?

I had recently received this question during a recent consultation.

Read More
1 2 3 4 … 10 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version