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.

Query Store – SQL Server 2017 vs Azure SQL Database

by Arun Sirpal

All About SQL

I love the query store, it is powerful (can be dangerous) , easy to use and packed full of information. I...

2017-11-02 (first published: 2017-10-24)

2,049 reads

Azure SQL Database Automatic Tuning – Questions Answered

by Arun Sirpal

All About SQL

I used to be on the fence regarding whether or not Automatic Tuning should be on as the default when...

2017-11-01

373 reads

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,068 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,657 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

675 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,052 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

454 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,573 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

478 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

482 reads

Blogs

How to clear the SSMS cache?

How to clear the SSMS cache? If you are reading this,...

Master SQL Subqueries with This Free Course

By Tracy McKibben

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

Using Flyway Prepare for State-Based Deployments

One of the neat enhancements made to Flyway was the addition of state-based workflows...

Read the latest Blogs

Forums

When trying to use a LocalDB, I get an error

By Doctor Who 2

I tried to find an appropriate forum to post the question. This one seems...

Resolving Access Denied Errors During SQL Server Database Attachment

Comments posted to this topic are about the item Resolving Access Denied Errors During...

The Lesser Used Functions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Lesser Used Functions

Visit the forum

Question of the Day

SQL in an Azure VM Backup

If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)

See possible answers