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.

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

462 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,588 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

513 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

486 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

356 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,708 reads

Azure SQL Database Active Geo Replication Changes

by Arun Sirpal

All About SQL

Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...

2017-09-25

524 reads

SQL Server Tracking Suspect Pages

by Arun Sirpal

All About SQL

Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...

2017-09-25 (first published: 2017-09-19)

1,592 reads

SQL Server Schema Compare

by Arun Sirpal

All About SQL

A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...

2017-09-18

566 reads

Azure SQL Database Resumable Online Index Rebuild

by Arun Sirpal

All About SQL

If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...

2017-09-14

1,316 reads

Blogs

Using Prompt AI for a Travel Data Analysis

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By Ige Adetokunbo Temitayo

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

2025 Wrapped for Steve

I’ve often done some analysis of my year in different ways. Last year I...

Read the latest Blogs

Forums

reaching ftp thru winscp but erroring in ssis ftp task connection

Hi, below i show various results trying to reach our ftp site (a globalscape...

Finding Motivation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Motivation

The Last Binary Value of the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Binary Value of...

Visit the forum

Question of the Day

The Last Binary Value of the Year

What does this code return?

SELECT cast(0x2025 AS NVARCHAR(20))

Image 1:

Image 2:

Image 3:

Image 4:

See possible answers