NTSEQ:- A IT Infrastructure and Cyber Security Blogs

What action plan should be taken if SQL Server is not responding?

you might be face this situation in past, you tried to connect the SQL Server but SQL Server is not

How can you start SQL Server database Instance in different modes?

We can start SQL Server in different modes which are follows:- Single User Mode (-m) DAC (-A) Emergency Mode

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