3 min read
1
Step By Step Installation Of Microsoft SQL Server 2016
Introduction In this post, we will try to show step…
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.
6 min read
0
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…
3 min read
0
Exploring Database File Information with T-SQL
Introduction In the world of database management, having a clear…
3 min read
2
Find database growth size and store in a table in SQL Server
Introduction Managing database sizes is a crucial task for database…
4 min read
8
Find disk space using Stored procedure or TSQL
Introduction xp_fixeddrives only provide how much disk space is free…
3 min read
0
Find text in Stored Procedures & then find JOB associate with Stored Procedure
Introduction Few days before I was asked to disable some…
3 min read
0
Increase the number of ErrorLog in SQL
If something goes wrong on the SQL database server, the…