Marc Petros, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts Remote Database Administration Mon, 16 Dec 2024 15:53:29 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://virtual-dba.com/wp-content/uploads/cropped-VirtualDBA-favicon-32x32.png Marc Petros, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts 32 32 How to Build a CockroachDB Sandbox on Windows https://virtual-dba.com/blog/how-to-build-a-cockroachdb-sandbox-on-windows/ https://virtual-dba.com/blog/how-to-build-a-cockroachdb-sandbox-on-windows/#respond Thu, 22 Feb 2024 22:24:43 +0000 https://virtual-dba.com/?p=242162 Setting up a lab environment on your local machine to run CockroachDB is very helpful for learning about this exciting database platform and testing applications locally. This article outlines the procedure for setting up a local installation of CockroachDB on a Windows system. It’s based on CockroachDB’s documentation but adds significant quality-of-life enhancements. All steps […]

The post How to Build a CockroachDB Sandbox on Windows appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/how-to-build-a-cockroachdb-sandbox-on-windows/feed/ 0 Investigating Locking in Db2 https://virtual-dba.com/blog/investigating-locking-in-db2/ https://virtual-dba.com/blog/investigating-locking-in-db2/#respond Wed, 04 May 2022 09:15:00 +0000 https://virtual-dba.com/?p=240604 The purpose of this article is to provide guidance on the various ways available for getting basic information about locking events in a Db2 database. Where possible the information gathered allows for targeting a specific table. The information provided by these methods is only for starting investigations into locking issues. Links are provided after each […]

The post Investigating Locking in Db2 appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/investigating-locking-in-db2/feed/ 0 Writing SQL with SQL https://virtual-dba.com/blog/writing-sql-with-sql/ https://virtual-dba.com/blog/writing-sql-with-sql/#respond Thu, 23 Apr 2020 22:21:11 +0000 https://virtual-dba.com/?p=37330 The Db2 RDBMS offers many great tools for getting things done. There are, however, times when tools are unavailable. This isn’t a problem when you’re performing a simple and discrete task. When the task has many iterations then like dropping triggers or granting privileges then running the commands manually can be tedious and time-consuming. For […]

The post Writing SQL with SQL appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/writing-sql-with-sql/feed/ 0 Three Text Highlighting Tricks with PuTTY https://virtual-dba.com/blog/three-text-highlighting-tricks-with-putty/ https://virtual-dba.com/blog/three-text-highlighting-tricks-with-putty/#respond Fri, 07 Jun 2019 16:47:24 +0000 https://virtual-dba.com/?p=36037 PuTTY is a free, cross-platform terminal program that supports SSH, telnet, and raw socket connections. For authentication it supports public key and kerberos single-sign-on. This application, is one of the oldest clients for Microsoft Windows, released by Simon Tatham in 1998. It’s a wonderful application that can be trusted to work when many others fail. […]

The post Three Text Highlighting Tricks with PuTTY appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/three-text-highlighting-tricks-with-putty/feed/ 0 Working with Crontab Files https://virtual-dba.com/blog/working-with-crontab-files/ https://virtual-dba.com/blog/working-with-crontab-files/#respond Thu, 07 Mar 2019 16:23:45 +0000 https://virtual-dba.com/?p=35576 The purpose of this article is to review the three approaches to working with crontab. The first is the mainstream proposed best practice of using crontab -e. The second is to edit the crontab file directly. The third method is to use your text editor to create files for crontab and then sync them using […]

The post Working with Crontab Files appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/working-with-crontab-files/feed/ 0 Db2 System Authorities https://virtual-dba.com/blog/db2-system-authorities/ https://virtual-dba.com/blog/db2-system-authorities/#respond Thu, 14 Feb 2019 20:27:27 +0000 https://virtual-dba.com/?p=35470 How do I grant a user SYSADM, SYSCTRL, SYSMAINT, or SYSMON privileges in Db2? As a newbie to the database administration world, I was tasked with giving a pretend user the ability to create databases in a virtual environment setup for learning. I easily found that the lowest level of permission that the user would […]

The post Db2 System Authorities appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/db2-system-authorities/feed/ 0 Why won’t SQL accept my value? Msg 8115, Level 16, State 8 https://virtual-dba.com/blog/fix-sql-arithmetic-overflow-error/ https://virtual-dba.com/blog/fix-sql-arithmetic-overflow-error/#respond Thu, 19 Jul 2018 15:51:14 +0000 https://virtual-dba.com/?p=34967 Arithmetic overflow error; converting it to data type numeric Understanding Decimal and Numeric arguments The problem: Entering a number in a field that is data type of decimal (5, 3) works for values like [85.200] but not others like [500]. The Cause: The arguments for decimal and numeric data types are (p, s) where ‘p’ […]

The post Why won’t SQL accept my value? Msg 8115, Level 16, State 8 appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/fix-sql-arithmetic-overflow-error/feed/ 0