5 min read
0
Shrinking the Large Log File in SQL Server
Scenario We recently came across a situation where one of…
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.
2 min read
0
Find the database file growth for all the databases in SQL Server
Introduction Find the database file growth for all the databases.…
2 min read
2
Database-Level Roles in SQL Server
Introduction There are two types of database-level roles: Fixed-database roles…
2 min read
1
How to get all statistics information for a database in SQL Server
Introduction: Sometimes your query gives you very bad performance because…
2 min read
0
Table backup in SQL Server
Introduction Here we will discuss different backup strategies and methodologies…
3 min read
1
Step By Step Installation Of Microsoft SQL Server 2016
Introduction In this post, we will try to show step…
6 min read
0
Database Backup & Restore in SQL server
Introduction Backing up a database is one of the most…
3 min read
0
List of jobs associated with database in SQL Server
Introduction As a Database Administrator (DBA), my recent task involved…
3 min read
1
4 min read
2
How to create database user on secondary node if DB is in readonly mode in SQL Server?
Scenario How to provide ‘db_dataread’ database role to a SQL…