6 min read
4
SQL Server Databases
Database: Database is a container which stores data and data objects. It manages data and allows fast storage and retrieval…
Author: OTI
Welcome to OurTechIdeas.com, your go-to destination for SQL Server DBA-related tech insights. We are a dedicated team of experts passionate about sharing our knowledge and expertise with the community. Join us as we explore the world of SQL Server, offering valuable tips, tutorials, and innovative solutions.
8 min read
1
SQL Server installation
Installation Whenever we want to start the installation of the SQL server we need to gather details of installation. SQL…
3 min read
2
SQL Server Transaction Log Architecture
Transaction Log Architecture SQL Server uses LSN (Log Sequential Number) in identifying the transaction. Each and every transaction that comes…
4 min read
10
SQL Server Database Architecture
SQL Server data mainly in 2 types of files, Data file stores actual data with .mdf extension. It stores permanent…
3 min read
3
SQL Server Storage Architecture
In an SQL server all the data will be stored in the form of records, these records also called row…
5 min read
4
SQL Server Architecture
Introduction If you’re curious about how SQL Server works behind the scenes or you’re new to the world of databases,…
2 min read
7
SQL Server Database Administration Introduction
1. Database Administration A database administrator is a person responsible for the database design, implementation, maintenance, and repair of the…
4 min read
12
Complete SQL Server DBA Tutorials
MS SQL Server DBA Training Welcome to Complete SQL Server DBA Tutorials ! This course is designed to help beginners…
2 min read
0
All about SQL Server KT
Knowledge Transfer in IT Companies In the IT industry, knowledge transfer is the process of sharing technical and/or business knowledge…
2 min read
0
All about ticketing tools for DBA?
Ticketing tools improves communications tracking whatever is happening in the environment, reporting that what has happened within the specified duration.…