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.

Blog Post

Azure Redis Commands

Now that we have created our Redis Cache lets connect to it. You can use the most common tool redis cli.exe https://redis.io/download or as I am going to do,...

2022-04-14

38 reads

Blog Post

MySQL server Query Store

The query store, sounds familiar? The idea of the black box sitting within the database server watching what is going on within the environment. This is available within MySQL,...

2022-03-03

113 reads

Blogs

Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21

By

You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...

The Effectiveness of Solar Estimation

By

We added a solar system to the ranch as a way to hedge against...

How do I tell if identity_insert is turned on and if so what table?

By

TLDR; The code to do this is below but it’s a bit hokey and...

Read the latest Blogs

Forums

Shared Work Spaces: Hell, Heaven, Both?

By Grant Fritchey

Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...

T-SQL : Slicing time Islands and gaps

By MrRobot

Hello, Consider the following table that gives the validity dates of an item :...

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers