As a DBA it's important to understand what the buffer pool is doing and which databases are using it the most. Data in SQL Server is stored on disk in 8k pages. The buffer pool (Aka "buffer cache") is a chunk of memory allocated to SQL Server. … [Continue reading]
Revoking Access for All Users of a Database in SQL Server
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
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]
- « Previous Page
- 1
- …
- 3
- 4
- 5
- 6
- 7
- …
- 22
- Next Page »