<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=204641&amp;fmt=gif">

Rey Lawrence Torrecampo

Recent Posts

Save more time with dbWatch Control Center

Posted by Rey Lawrence Torrecampo on Sep 15, 2022 6:21:00 AM

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".  

Read More

Management studio vs. dbWatch Control Center: Which is best for monitoring SQL Server

Posted by Rey Lawrence Torrecampo on Sep 12, 2022 8:00:00 AM

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. 

Read More

Optimizing database integrity – automating dbcc checkdb

Posted by Rey Lawrence Torrecampo on Jun 22, 2022 6:12:43 AM

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? 

Read More

Customizing your dbWatch Job for SQL Servers

Posted by Rey Lawrence Torrecampo on Feb 8, 2022 4:54:32 PM

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.  

 

Read More

Recovering and migrating your dbWatch Control Center

Posted by Rey Lawrence Torrecampo on Feb 3, 2022 10:03:00 AM

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. 

 

Read More

Database Locks - how to monitor and manage

Posted by Rey Lawrence Torrecampo on Jan 31, 2022 10:00:00 AM

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.

 

Read More

Topics: database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager

dbWatch 101: The dbWatch File Structure

Posted by Rey Lawrence Torrecampo on Jan 28, 2022 9:49:00 AM

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.  

 

Read More

dbWatch multi-domain: A practical approach for your Oracle Database and SQL Server Database farm

Posted by Rey Lawrence Torrecampo on Dec 6, 2021 4:00:00 PM

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. 

 

Read More

Breaking in as an Accidental DBA in the world of database administration

Posted by Rey Lawrence Torrecampo on Aug 4, 2021 6:23:00 AM

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.

 

Read More

Restoring your database: A how-to with dbWatch Control Center

Posted by Rey Lawrence Torrecampo on May 20, 2021 7:30:00 AM

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.

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

Read More

Topics: database operations, sql server monitoring, sql monitoring tools, database monitoring, sqlmonitor, sqlperformance, sqlmanager

control-center-cta