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.

SSMS 2016& Azure SQL DBs

by Arun Sirpal

All About SQL

When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that...

2016-10-11 (first published: 2016-09-27)

1,500 reads

Azure SQL Database – TDE

by Arun Sirpal

All About SQL

I work in the financial space so you can imagine that security is quite high on the agenda. TDE (Transparent...

2016-10-10

452 reads

SQL Performance Dashboards – update

by Arun Sirpal

All About SQL

SQL Server Performance Dashboards – update The first article that I ever wrote (http://www.sqlservercentral.com/articles/SQL+Server/127992/) was last year where I wanted to...

2016-10-07

625 reads

ALTER INDEX….ABORT!

by Arun Sirpal

All About SQL

I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes...

2016-10-06

489 reads

Detaching corrupt databases

by Arun Sirpal

All About SQL

Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...

2016-10-04

606 reads

Query Store – Quick Tour

by Arun Sirpal

All About SQL

The query store, Borko Novakovic Senior Program Manager from Microsoft calls this feature “Similar to an airplane’s flight data recorder”....

2016-10-03

459 reads

My application to Microsoft

by Arun Sirpal

All About SQL

I have been eager to write this blog post for a while now. I want to share my experience of...

2016-09-29

878 reads

Restoring Azure SQL Database

by Arun Sirpal

All About SQL

A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering...

2016-09-23 (first published: 2016-09-16)

1,231 reads

Azure SQL Data warehouse

by Arun Sirpal

All About SQL

For this blog post I want to show you the steps required to setup an Azure SQL Data warehouse and...

2016-09-21

519 reads

SSMS Keeps Crashing

by Arun Sirpal

All About SQL

It is quite frustrating when SSMS (SQL Server Management Studio) randomly crashes, all too often for my liking. If you have...

2016-09-20

1,867 reads

Blogs

Learn about Modern Microsoft Apps in San Diego

I wrote about learning today for the editorial: I Can’t Make You Learn. I...

How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps

Fabric has CI/CD built in, but if you've tried to use it for database...

A New Word: Attriage

attriage – n. the state of having lost all control over how you feel...

Read the latest Blogs

Forums

Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393

WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156

Alamat Kontak Bank BCA KCP Pati Telp:08218154393

By layanan 24jam BCA

WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114

SSRS Reminded Me of the Time Microsoft Retired TMG

Comments posted to this topic are about the item SSRS Reminded Me of the...

Visit the forum

Question of the Day

BIT_COUNT II

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37
4       NULL

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

See possible answers