Database Administrators (DBA) are often stuck in a loop of monitoring database instances manually. To monitor each database instance, we would open a database management IDE, copy-paste our SQL command, and execute it. We would store those database management commands as procedures and automate their monitoring process. It is possible for some, but tricky if you do not have the technical "know-how".  

SQL Server Management Studiois the default management tool when we want to query information from your Microsoft SQL Server. Query complexity can range from ad-hoc SELECT queries to more complex SQL queries involving recursive statements, SQL Injections, and stored procedures. 

Database maintenance is an important aspect of database management. As a DBA, you need to check for any hardware malfunction and network connectivity anomalies. Aside from physical maintenance, you are also tasked to check database integrity and patches. Sounds a lot, huh? 

What’s inside a template job? 

After learning about the different directories, we will now proceed on how you can add a job template to your active dbWatch Control Center. Download the job_templates.json to your local server. Preferably, this should be in the same machine where your active dbWatch Control Center is placed.  

As a Database Admin, your role is to ensure the organization's storage facility is working in tiptop condition. With the database monitoring tools at your disposal, it's easier to execute mundane database admin tasks such as database monitoring and database reporting with only a click of a button. 

Database locks have been a bane to most DBAs.

They cause unnecessary problems to databases and business processes. In this blog, we will examine what database locks are and issues that can arise from them and provide ways to deal with them on SQLServer.

Not only that, but we will also implement it in dbWatch Control Center as an example.

Database Monitoring Tools are essential tools for Database Admins. When it comes to tracking the performance and health of their database systems, these tools need to capture your database instance's vital information.  

In our previous webinar entitled “Leveling up your Oracle and SQL Server Farm Management,”, we discussed ways to distribute server load, automate DBA tasks, and utilize internal communication. For this blog, we will tackle the essentials of multi-domain on a deeper level. 

It is a typical Wednesday afternoon. A call with your manager is scheduled around this time to discuss updates. As you enter the conference call, you don’t see anyone from your team, yet you see a familiar face in one of the window screens. “Isn’t that the Database Administrator who tendered his resignation letter a week ago?” you say to yourself. And it dawned upon you. This call is not your typical meeting but a reception to your new role. You, my friend, are now a DBA.

About the Author:

Rey Lawrence Torrecampo is a Pre-sales Engineer for dbWatch and full-time Database Administrator. He has extensive knowledge in Postgres and MSSQL database management systems with SQL as his most proficient language. Coupled with his experiences in Data Science and data migration, he has confidently handled roles in data migration job developments, data analytics and data cleansing.

----------------------------------------------------------------------------------------------------------