SQL DBA Blog

Tag: MySQL

Why Use WHERE 1=2 in SQL

May 5, 2022

In a previous blog post, I explained why WHERE 1=1 is often used in SQL queries. This time, let’s discuss WHERE 1=2 — or any condition that results in a FALSE value, such as WHERE 1=9. Essentially, the point is to use a condition that is guaranteed to…
Read More
Creating a Linked Server with a MySQL Database

July 15, 2020

This is my third Linked Server demo post, and this time, we’re connecting to a MySQL database. Here’s a simple diagram of the setup covered in this post, configuring a Linked Server to a MySQL Database: For this setup, I’ve covered it all in previous blog posts: –…
Read More
How to Create MySQL Databases & Tables

October 8, 2019

Setting up MySQL databases and tables is a foundational skill for database administrators and developers. Whether you’re using Windows, Linux, or a cloud environment, this guide is aimed to help you create databases and tables in MySQL. Topics covered: > Create a MySQL Database> The USE DATABASE Command>…
Read More
How to Install MySQL on a Windows Computer

October 3, 2019

Installing MySQL on a Windows computer is a straightforward process, however selecting the right options is key for a smooth setup. This is a simple how to for installing MySQL Community Server and MySQL Workbench on Windows. I recommend you walk through this yourself if learning MySQL and…
Read More

Useful SQL DBA Posts

SQL Server Performance
– Get Full SQL Server System Info Fast
– Quick Performance Troubleshooting Scripts
– Identify Missing & Unused Indexes
– Get Wait Stats & Top Consuming Queries
– Get Exclusive Locks on Tables
– Get Last Node Blip in SQL Server FCI
Security & Maintenance
– Get Estimated Database Backup/Restore Time
– Get Last Database Backup Dates/Times
– Get Database Sizes & Space Used
– How to Get Table Sizes
– Get Index & Heap Fragmentation Levels
– Get SQL User Permissions and Roles
– Creating SQL Users on Availability Groups
– Audit Failed Login Attempts

Categories

Tags