DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

How to Find Buffer Pool Usage Per Database in SQL Server

Posted on May 10, 2016 Written by Andy Hayes 1 Comment

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]

Filed Under: All Articles, SQL Server Performance Tagged With: performance, sql server

Revoking Access for All Users of a Database in SQL Server

Posted on May 9, 2016 Written by Andy Hayes Leave a Comment

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]

Filed Under: All Articles, SQL Server Administration Tagged With: sql server

How to Determine Which Port MySQL is Running On

Posted on May 9, 2016 Written by Andy Hayes Leave a Comment

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]

Filed Under: All Articles, MySQL Administration Tagged With: mysql

MySQL Replication Events – Statement versus Row-Based Formats

Posted on May 8, 2016 Written by Andy Hayes Leave a Comment

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]

Filed Under: All Articles, MySQL Administration Tagged With: mysql, replication

  • « Previous Page
  • 1
  • …
  • 3
  • 4
  • 5
  • 6
  • 7
  • …
  • 22
  • Next Page »

Categories

  • All Articles (82)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (19)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • How to shrink tempdb
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to move tempdb

Recent Posts

  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial
  • How to Use SQL CASE for Conditional Logic in Your SQL Queries
  • Using ISNULL in SQL Server to Replace NULL Values

Search

Connect

  • Twitter
  • Facebook
  • Google+
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright © ‘2021’ DBA Diaries built on the Genesis Framework

This site uses cookies. We assume you are happy with cookies but click the link if you are not. Close