T-SQL Tuesday #98 – Your Technical Challenges Conquered

Welcome to the January 2018 edition of T-SQL Tuesday and I am your host BlobEater (Arun Sirpal).
If you do not...

A Basic Bot using Azure Bot Services

I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....

SQL Server DBCC CHECKDB – Going Parallel

DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...

SQL Server Failed to Open Loopback Connection – What?

I could not read my error log on one of my local SQL Servers, when I executed the following code:

EXEC...

Moving to an Azure SQL Database via Command Line

I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...

Azure SQL Database – Using sp_BlitzIndex

I was doing some normal activities on one of my Azure SQL Databases, I went to make a cup of...

I have a new Passion

Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...

Azure SQL Database – Service Tiers

Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...

SQL Server – DBCC CHECKTABLE

If you know about DBCC CHECKDB then most likely you will know about DBCC CHECKTABLE. Quite simply this command performs...

Azure SQL Database Alerting

It’s good to be proactive and one way is to setup alerts and it is no different when using Azure...