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 – 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,469 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,774 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,024 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,029 reads

Deleting Azure SQL Database VNETs

by Arun Sirpal

All About SQL

This is quite a new feature (currently in preview) but an important one where we now have the ability to...

2018-02-07 (first published: 2018-01-29)

1,014 reads

The world of Automatic Tuning – SQL Server 2017

by Arun Sirpal

All About SQL

Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...

2018-01-31 (first published: 2018-01-22)

2,404 reads

Azure Portal – Bad Request

by Arun Sirpal

All About SQL

I had a strange issue recently when trying to login to the Azure Portal. Quite simply I would enter my...

2018-01-16

260 reads

Azure SQL Database – Optimizing For Ad-hoc Workloads

by Arun Sirpal

All About SQL

Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database...

2018-01-16 (first published: 2018-01-08)

1,596 reads

T-SQL Tuesday #98 Round Up

by Arun Sirpal

All About SQL

Thank you to everyone that took the time to write and contribute, I enjoyed reading about how you conquered your...

2018-01-11

573 reads

Azure SQL Analytics

by Arun Sirpal

All About SQL

Azure SQL Analytics is currently in preview mode, still it is very impressive. The goal of this feature is to...

2018-01-04

982 reads

Blogs

Part 2: The Modern Azure Data Warehouse – ADF and ADLS

By hellosqlkitty

In today’s data-driven world, having the right tools to manage and process large datasets...

A New Word: Flichtish

flichtish – adj. nervously aware how much of your self-image is based on untested...

Automating Container Image Builds with Docker Build Cloud and Github Actions

By Andrew Pruski

In a previous post we went through how to use Docker Build Cloud to...

Read the latest Blogs

Forums

Backup with Checksum Show No Issues, While DBCC CHECKDB Reports Errors

By IT researcher

I took a backup with the CHECKSUM option, which was successful and showed no...

Realities of Predictive Analysis

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Realities of Predictive Analysis

Linked Server Product Name?

By Brandie Tarvin

Just came across something weird. Was wondering if anyone else has ever seen this....

Visit the forum

Question of the Day

Creating Statistics on XML

I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?

See possible answers