All About SQL

SQL server and Java?

• by Arun Sirpal

• All About SQL

I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only. It then led me to...

2019-07-29

78 reads

Azure SQL Database Connect and Query

• by Arun Sirpal

• All About SQL

There is a lightweight and quick way to start querying your database in Azure which doesn’t involve SQL Operations Studio or Management Studio. You can use the query editor...

2019-07-25

13 reads

Moving Databases into Azure SQL Elastic Pools

• by Arun Sirpal

• All About SQL

Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below. As you can see I have a standard elastic pool...

2019-07-22

14 reads

Azure SQL Database SLA Updates

• by Arun Sirpal

• All About SQL

I am sure many missed the updates to Azure SQL Database SLA (Service Level Agreement). It used to be 99.99% across all tiers  but split between two different high-availability...

2019-07-19

169 reads

SQL Server 2019 Query Store And SSMS

• by Arun Sirpal

• All About SQL

While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis...

2019-07-17

19 reads

Azure SQL Elastic Jobs

• by Arun Sirpal

• All About SQL

The purpose of an Elastic Job is to execute a T-SQL script that is scheduled or executed ad-hoc against a group of Azure SQL databases.  Targets can be in...

2019-07-11

170 reads

Microsoft MVP #2

• by Arun Sirpal

• All About SQL

It is always a dark art trying to suss out why he/she is an MVP? Do they deserve it? What does it take? Why can’t I get it? The...

2019-07-05

16 reads

Azure SQL DB Maxdop Hint

• by Arun Sirpal

• All About SQL

I had a good question from JP via a comment on my blog about whether you can use the MAXDOP query hint in Azure SQL Database. The answer? Yes....

2019-06-24

5 reads

Azure Cosmos DB – Graph DB

• by Arun Sirpal

• All About SQL

Using Graph DB is a good way to show relationships between entities (more specifically a vertex and edges). This is why you would use this approach over classic SQL...

2019-06-24

13 reads

Globally Distributed Azure Cosmos DB

• by Arun Sirpal

• All About SQL

Let’s use the Azure portal to build a globally distributed  Cosmos DB.  Before doing this, why would you ? what are the benefits? Regional based. By this I mean...

2019-06-18

55 reads