Arun Sirpal

I am a Senior DBA with interest in MS technology especially SQL Server and Azure. During 2015 I was mentored by Paul Randal – Data Platform (SQL Server) MVP and during 2016 I completed my SQLskills Immersion training on Internals and Performance Tuning. When I am not working I am in the gym burning calories.

All authors

Azure Redis Cache Intro

by Arun Sirpal

All About SQL

Redis Cache is a well know caching technology and you can run it in Azure as a fully managed service. A common requirement (the most basic one) is doing...

2022-03-21

19 reads

Microsoft Defender for open-source relational DB

by Arun Sirpal

All About SQL

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

MySQL server Query Store

by Arun Sirpal

All About SQL

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

by Arun Sirpal

All About SQL

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

by Arun Sirpal

All About SQL

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

by Arun Sirpal

All About SQL

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

13 reads

Connecting to Single Server MySQL

by Arun Sirpal

All About SQL

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

by Arun Sirpal

All About SQL

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

by Arun Sirpal

All About SQL

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

by Arun Sirpal

All About SQL

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

All authors

Arun Sirpal

Azure Redis Cache Intro

Microsoft Defender for open-source relational DB

MySQL server Query Store

Azure DB for MySQL – Replication

Azure DB for MySQL – server parameters

Azure DB for MySQL – Storage v1 vs v2

Connecting to Single Server MySQL

Creating Azure DB for MySQL – Single Server

Azure DB for MySQL – Single server vs Flexible

Azure Database for MySQL

Blogs

SQL Saturday Boston 2024 Slides

Small Data SF 2024

A New Word: Moledro

Forums

ETL data load DML SP slowness suggestion

Impact of adding the opening of the Master Key in a SQL job for SSIS packages

Being an extroverted introvert at a conference

Question of the Day

How are statistics stored?