Revoking Access for All Users of a Database in SQL Server

evoke access for all users in a sql server database

I love Management Studio for SQL Server but sometimes it just doesn't cut the mustard. I had a scenario recently where I needed to revoke access for all users from a database. I could delete them all but that would be more effort than necessary. I … [Continue reading]

How to Determine Which Port MySQL is Running On

how to find mysql port using MySQL workbench

MySQL defaults to port 3306 when installed but sometimes for another reason, it may be listening on a different port. In this post, I list some ways in which you can find out which port your MySQL instance is running on. Using the MySQL … [Continue reading]

MySQL Replication Events – Statement versus Row-Based Formats

In a recent post, I briefly touched upon mysql replication events. It is important to know the advantages and disadvantages of each type. There are two types of replication event: Statement based – these are the write operations. They … [Continue reading]

MySQL Replication Use Cases

In my last post, I summarized when MySQL replication is typically implemented. I now want to expand on that and talk about MySQL replication use cases. Scaling out using MySQL Replication Let's take a typical example, the application is read-heavy … [Continue reading]

What is MySQL Replication and How Does It Work?

MySQL replication, a.k.a MySQL database replication provides the facility to make replicas of databases. The ability to make exact copies of databases and keep them in real-time sync as changes are made at the "master" provides a number of … [Continue reading]