-
MongoDB User and Role Management
A big feature of a database is user and role management. MongoDB user and role management is no different. In this article we are going to go over managing users for any number of databases in your MongoDB instance. Creating the MongoDB admin user First, you need to create a user. Although MongoDB user management…
-
MongoDB replace substring in field
Many times you will find yourself needing to do a MongoDB replace in a text field of a MongoDB collection. This can be a frustrating exercise as the syntax is not so straightforward. There are generally two conditions that you will likely need to replace the data in a field –> Where you just want…
-
Adding a Clustered SQL Server Disk for Windows 2008 in VMware
If you are running a clustered SQL Server instance on VMware, there are times when the drive will not mount into SQL Server. The clustered disk seems to be unknown to the clustered engine in Windows 2008. This is the typical error message (keep in mind your disk GUID and directories will be different) –>…
-
Auto commit for MySQL databases
In corporate database systems, it is generally preferred to build transaction stacks. This allows for having multiple database statements run and be finally committed if everything is ok. In MySQL, auto commit is on by default; which means that every statement is instantly committed. To check the value of auto commit, run the following MySQL…
-
Updating a database option in DB2
Sometimes after a database has been created, you may want to move where the default log path is. Or you may want to change DB2 places the log path in the home directory, and you may want to have the logs stored on another storage device. Login as the DB2 adminstrative user, then type the…
-
Updating the log path in DB2
Sometimes after a database has been created, you may want to move where the default log path is. DB2 places the log path in the home directory, and you may want to have the logs stored on another storage device. Login as the DB2 adminstrative user, then type the following command to change your log…
-
Adding custom palettes to Dundas pie charts in .NET 3.5x
One of the new features in Dundas 6.x and above, is the ability to create custom palettes of colors and apply them to pie charts. This way you no longer have to settle for Dundas’s default fluffy colors. In order to change the color palette, create a Color array and assign it to the series…
-
Dropping a DB2 database
Normally, to drop a database in DB2, you run the following command: >db2 drop db YourDb If you run into errors trying to drop the database, you may need to recatalog the database. You can run the following series of commands: >db2 uncatalog db YourDb >db2 catalog database Restart DB2. Then run: >db2 drop db…
-
Changing a DB2 server name
If you find DB2 not being able to start because of a server name problem, it most likely is caused by moving a virtual machine and not renaming the DB2 database. To update DB2 to the proper name: Stop DB2 as administrator (db2inst user). >su – db2inst >db2stop If there are open database connections, then…
-
Access to MySQL
To gain access to MySQL run the following command: mysql -u root -p mysql You will be prompted for the root password. mysqladmin command to change root password If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password…