Microsoft Defender for open-source relational DB
If you navigate to the overview section of your MySQL server you will see a notification area, here you will find security section. It’s basically an area to provide...
2022-03-08
8 reads
Arun Sirpal
MySQL server Query Store
The query store, sounds familiar? The idea of the black box sitting within the database server watching what is going on within the environment. This is available within MySQL,...
2022-03-03
142 reads
Azure DB for MySQL – Replication
No doubt there will be a need for you to split off your analytical queries from the main database for performance reasons. If you have been following me in...
2022-02-15
20 reads
Azure DB for MySQL – server parameters
If you have used MySQL before you will know about the system server variables, you know such commands as SHOW VARIABLES; You can access most of them via the...
2022-02-10
41 reads
Azure DB for MySQL – Storage v1 vs v2
When it comes to MySQL and storage you will normally have to decide on 3 options: basic, general purpose v1 or v2. Basic does support up to 1TB and...
2022-02-07
12 reads
Connecting to Single Server MySQL
We have already created the server now it’s time to connect to it. What you will need – connection string details, correct networking setup and a tool like MySQL...
2022-02-03
13 reads
Creating Azure DB for MySQL – Single Server
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: Click create...
2022-01-31
29 reads
Azure DB for MySQL – Single server vs Flexible
When you start the build process for MySQL you will be shown the below screen, the question is what option would you select? It really does depend; I don’t...
2022-01-19
377 reads
Azure Database for MySQL
SQL Server is not the only database you build and deploy into Azure. Another very popular option is MySQL. Going back many years, this was actually my first database...
2022-01-11
46 reads
SQL Managed Instances – Failing Over
This is our current setup shown below. There is not much to failing over with Managed Instances, from experience it is similar to that of Azure SQL Database. Let’s...
2021-12-17 (first published: 2021-12-07)
261 reads
Blogs
Why Data Analysts Love PostgreSQL (and You Will Too!)
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
How to Connect Your WordPress Site to the Fediverse
By Rob Sewell
Make it easier for your audience to engage with you by connecting your site...
What I learned volunteering at a children's summer camp
By Rayis Imayev
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
AI Sings the Blues
Comments posted to this topic are about the item AI Sings the Blues
Question of the Day
Disabling Indexes
I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?
See possible answers