4 min read
0
Password reset of SQL service account
Impact of resetting password for SQL Server service account Resetting the password of your SQL Server service account is a…
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
Customizing the Status Bar Color in SQL Server Management Studio
Introduction In database management, it is common to work with multiple environments, such as development, staging, and production. Each environment…
4 min read
0
How and Why to become a SQL Server DBA?
What is a SQL server dba? A database administrator (DBA) is responsible for the performance, integrity, and security of a…
4 min read
0
Get CPU Utilization Data from SQL Server
Monitoring the CPU utilization of a SQL Server instance is crucial for maintaining optimal performance and identifying any potential bottlenecks.…
6 min read
0
Driver could not establish a secure connection to SQL Server
Driver could not establish a secure connection to SQL Server Recently windows patching was done on a server and also…
3 min read
0
Migrating SQL Server Database Mail Settings
Migrating SQL Server Database Mail Settings Migrating SQL Server Database Mail profiles, accounts and settings can be a complex and…
2 min read
0
Checking SQL Server Job History by Script
Mainly msdb.dbo.sysjobs and msdb.dbo.sysjobhistory contains all major information regarding the SQL Server job and its running status and history. We…
3 min read
0
Checking Compatibility Level Of All Databases In SQL Server
SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is a server-based system that can be…
5 min read
0
Find active transactions by duration
Recently frequently we faced blocking issues on our production server. The main reason that I understand, recently we merged a…
1 min read
0
Certificate chain issued by authority that is not trusted
Certificate chain issued by authority that is not trusted Recently we moved whole on-premises resources to the cloud. In an…