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.

SQL Server: What will REPAIR do?

by Arun Sirpal

All About SQL

So I had a corruption issue and I was thinking about running repair but I wanted to know what would...

2017-10-24 (first published: 2017-10-16)

2,079 reads

Azure SQL Database Level Firewall Rules

by Arun Sirpal

All About SQL

I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...

2017-10-20 (first published: 2017-10-11)

1,710 reads

Connecting to Azure SQL Database Primary Endpoint – Failover Groups

by Arun Sirpal

All About SQL

When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / Write) endpoint...

2017-10-19

696 reads

SQL Server 2017 Encrypted Backups And Compression

by Arun Sirpal

All About SQL

Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...

2017-10-18 (first published: 2017-10-09)

3,108 reads

When Things Go Wrong in Azure

by Arun Sirpal

All About SQL

Things go wrong in IT, it is no different with the cloud. When I say cloud I am thinking quite...

2017-10-12

467 reads

Checking Out SQL Vulnerability Assessment

by Arun Sirpal

All About SQL

Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool...

2017-10-09 (first published: 2017-09-28)

1,594 reads

Azure SQL Database Data Integrity Checks

by Arun Sirpal

All About SQL

If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it...

2017-10-04

542 reads

SQL Server Tracking Tempdb Size

by Arun Sirpal

All About SQL

Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...

2017-10-03

498 reads

SQL Server – Pause VS Stop

by Arun Sirpal

All About SQL

You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...

2017-10-02

367 reads

SSMS 17 Dark Theme

by Arun Sirpal

All About SQL

Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...

2017-09-29

2,713 reads

Blogs

Getting the SQL Server MCP Server Running

If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

By MarlonRibunal

Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...

Rambling about Data on Wheels – origins, branding, expansion

By DataOnWheels

I have been asked many times about how the name “Data on Wheels” came...

Read the latest Blogs

Forums

Make It Routine

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Make It Routine

DBCC CHECKDB Limits III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DBCC CHECKDB Limits III

CROSS APPLY Fundamentals: Part 1

Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1

Visit the forum

Question of the Day

DBCC CHECKDB Limits III

On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?

See possible answers