NTSEQ:- A IT Infrastructure and Cyber Security Blogs

How can I hide databases from other users?

I have received this query on my fb last night ,One of my friend asking me to how can I

Performance Tunning :- Find I/O Usage Per Databases in SQL Server

Through Below Script you are able to identify the I/O utilization By per databases in your SQL Server.The information returned

Performance Tunning :- How to find out CPU Uses By each Databases in SQL Server

Through Below Script you are able to identify the CPU utilization By per databases in your SQL Server:– WITH CPU_Uses_Per_Db

How to check status on Database Shrink Task in SQL Server?

Through Below Query we can check the status of database Shrink Operation :- SELECT percent_complete, start_time, status, command, estimated_completion_time, cpu_time,

Difference Between Log Shipping and Database Mirroring

Log Shipping:- It automatically sends transaction log backups from one database On another server. T-Logs are backed up and

Recover Database from Suspect Mode in SQL Server

Today morning I observed that one of our logshipped secondary database reached into Suspect mode, I just investigated and found that log

What MAXDOP setting should be used for SQL Server?

You can run the below query and identify the suitable MAXDOP for your SQL Server then you can set the

How to recover or attached a database which transaction log (.LDF) file is missing or corrupt?

There might be a situation due to some reason the transaction log file is corrupted or removed , But we

Find All Logins Having SA(SYSADMIN) Rights to Access SQL SERVER

Through below query we can find out the logins having SYSADMIN Rights:-