Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
It is possible to define the email notification for the scheduled job. An e-mail can be sent when a job-related event occurs. The following …
Read More »DBCC CHECKCONSTRAINTS Command On SQL Server
DBCC CHECKCONSTRAINTS checks the consistency of a specified constraint, or all constraints in a table. So what is Constraint? Constraints are the restrictions …
Read More »How To Move a Datafile in the File System to the ASM Disk Group
Files that are created accidentally or deliberately in the file system in a database that uses ASM often cause problems. In particular, a file …
Read More »DBCC CHECKFILEGROUP Command On SQL Server
DBCC CHECKFILEGROUP checks the consistency of all tables and indexed views on the filegroup. To examine in more detail what Filegroup is, you can read …
Read More »DMV: sys.dm_db_persisted_sku_features(Check Database Before Migration Between Editions)
In some projects or scenarios, we need to move some databases between different SQL Server editions. For example, in some organizations, SQL Server Evaluation …
Read More »How do successful backups not be saved in the Error Log
With a single command: [crayon-673f75b83dfb8122666951/] If you run this way, you will be opening this Trace Flag to Global, and even if your SQL …
Read More »The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’
ERROR: Message Executed as user: DOMAIN\svc_SQLService. The transaction log for database ‘dbname’ is full due to ‘LOG_BACKUP’. [SQLSTATE 42000] (Error 9002) BACKUP DATABASE is …
Read More »How secure is the passwords of your SQL logins
I was doing some security work to make a SQL Server production environment safer and ready for inspections. I had more than 900 SQL …
Read More »How To Change the Size of the ACFS File System Online
We can change the size of the ACFS file system online without requiring any umount or disable volume. We use the acfsutil tool for …
Read More »DBCC CHECKDB Command On SQL Server
The DBCC CHECKDB command is used to detect and repair logical and physical errors that occur in the database. When you run the DBCC CHECKDB …
Read More »