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.

Azure SQL Database – Failed to Delete Database Nightmare

by Arun Sirpal

All About SQL

After demo building and testing features out within Azure SQL Database I like to delete the databases to save costs....

2018-04-03

363 reads

Database Has Been Paused

by Arun Sirpal

All About SQL

I was looking forward to do some work with Azure SQL Data Warehouse (DWH) when I hit the new query...

2018-04-03 (first published: 2018-03-27)

3,443 reads

Azure SQL Database and Cost Threshold for Parallelism

by Arun Sirpal

All About SQL

We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated...

2018-03-26 (first published: 2018-03-16)

2,305 reads

Backup and Restore Options for Azure SQL DB

by Arun Sirpal

All About SQL

I have decided to do a summary blog post on backup and recovery options for Azure SQL Database. If you...

2018-03-26

574 reads

SQL Vulnerability Assessment for Azure SQL Database

by Arun Sirpal

All About SQL

Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....

2018-03-22

986 reads

Understanding DBCC FLUSHAUTHCACHE

by Arun Sirpal

All About SQL

This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...

2018-03-14

721 reads

Azure SQL Database – Allow Azure Services to Access Server

by Arun Sirpal

All About SQL

When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there...

2018-03-09 (first published: 2018-03-01)

2,480 reads

Saving Costs in Azure

by Arun Sirpal

All About SQL

Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient...

2018-02-27 (first published: 2018-02-15)

1,780 reads

How to setup Azure SQL Analytics

by Arun Sirpal

All About SQL

I am a big fan of this feature, I have written and spoken about it before ( https://blobeater.blog/2018/01/04/azure-sql-analytics/) but I did...

2018-02-26

1,035 reads

Azure SQL Database sa Connections?

by Arun Sirpal

All About SQL

I was using a query on one of my local SQL Servers where I wanted to know what logins were...

2018-02-07

1,046 reads

Blogs

A Couple Quick GENERATE_SERIES Tests

I had someone reach out about generate_series() recently, saying they hadn’t realized this was...

How I passed the DP-700 Exam

By Koen Verbeeck

I recently took and passed the DP-700 exam, which is required for the Microsoft...

Which approach to take: Build it, buy it, cloud it?

By Joyful-Craftsmen

As a Consultant, I would typically answer with – it depends! Then a typical...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

How to Download and Restore AdventureWorks 2019 Database

Comments posted to this topic are about the item How to Download and Restore...

Tracking Table Sizes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking Table Sizes

Visit the forum

Question of the Day

Counting Bits IV

What does this code return in SQL Server 2022+?

select bit_count(2.4)

See possible answers