What to Do When DBCC CHECKDB Fails – Here is A Complete Guide

“Recently, I ran DBCC CHECKDB command to check the consistency of SQL Database. After running that command, I noticed that the database was not showing online. To fix it, I started SQL Service but it also went in the suspect-mode. I am not able to understand why DBCC CHECKDB  fails. Is there any way to resolve this issue?”

Continue reading “What to Do When DBCC CHECKDB Fails – Here is A Complete Guide”

Advertisements

Strategies for developing an Internet emergency response system

Article by Atdhe Buja
Published on PCWorld.al

Control the flow of information

All events occurring in the security field i.e. vulnerabilities, compromises, crashes, different attacks, or cause-of-action takes the basis and the starting point for the information flow. A process or cycle that defines the entire model, mode of operation and operation of different systems, services and infrastructures. Continue reading “Strategies for developing an Internet emergency response system”

Metadata and Privacy: Limits of Freedom online

Article by Atdhe Buja
Published on PCWorld.al

The data collection boundary (IP, Time, User, Receiver, etc.), preserving the privacy of the citizen and observing the regulations in force are the ethical principles of the democratic system that everyone has to adhere.

Metadata is information created depending on how you use the technology. For example, include the date and time you can call / set as someone or the location from which you managed to access your e-mail.

Continue reading “Metadata and Privacy: Limits of Freedom online”

Performance Effect of Number of Virtual Log Files in SQL Server

Overview

The transaction log files, records all the changes made to the SQL Server database as well as keeps the transactions. It is known to be the inevitable part of the SQL Server. These files are again divided into smaller virtual log files. If the number of virtual log files is more then, it is clear that the performance of transaction logs will get slow down. Here, in this session you will get to know about it in detail. Anyways, before moving into the effects, let’s have a check on what is ‘Virtual Log’ file. Continue reading “Performance Effect of Number of Virtual Log Files in SQL Server”

Blog at WordPress.com.

Up ↑