What is a Temporal Database?
Temporal Databases stores information about states of the real world across time. Temporal Database is a database with built-in support for handling data involving time.
Database
Compatibility Level Field Is Disabled In SQL Server
Unable to change SQL Server database compatibility level from management studio. Because the compatibility level field in the database properties window is disabled and grayed out.
Move Database To Emergency Mode In SQL Server
How to move database to emergency mode in SQL Server. For repair and troubleshooting purpose you may need to set the status of database to emergency.
Offline Vs Detach Vs Emergency Database In SQL Server
Differences between taking database offline, detaching it and moving it to emergency mode in SQL Server? Offline Vs Detach Vs Emergency in table format.
Detach And Attach Database In SQL Server
Simple method to detach and attach database in SQL Server. T-SQL method and SSMS method to detach an database and attach it back.
Bringing Database Online In SQL Server
How to bring back an SQL Server database online? Simple methods for bringing database online state using transact-SQL or SSMS.
Taking Database Offline In SQL Server
How to take an SQL Server database offline? Simple methods to bring a MSSQL database to offline state using transact-SQL or management studio.
Shrink Database File (mdf) In SQL Server
Shrink database file (mdf) In SQL Server database and reduce it’s size. I.e. shrinking the mdf file without affecting the ldf file.
Shrink Transaction Log File In SQL Server
Shrink transaction log file In SQL Server database without altering the database files . I.e. shrinking the ldf file without affecting the mdf file.
Generating More Data In WideWorldImporters Database
Generating more and recent transaction data In SQL Server WideWorldImporters sample database. Steps for generating more data In WideWorldImporters database.
Installing Wide World Importers Sample Database
Choosing, downloading and installing (restoring) Wide World Importers Sample Database for SQL Server for training purpose. What is WideWorldImporters?
Installing AdventureWorks Sample Database
Choosing, downloading and installing (restoring) AdventureWorks Sample Database for SQL Server 2014 for training purpose. What is AdventureWorks?
SQL Server: Joining Tables from Different Databases on the Same Server
SQL query for joining tables from multiple databases on the same server. Joining tables from different databases in a single select query.
What Is Oracle Database?
What Is Oracle Database? Here is a brief description about Oracle and it’s Database.
What is DBMS? What is RDBMS? DBMS vs RDBMS
What is DBMS? What is RDBMS? This article will give you a basic idea about SQL DBMS & RDBMS as wells as the difference between DBMS and RDBMS in tabular form.