Azure SQL DB Maxdop Hint
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
17 reads
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
17 reads
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
18 reads
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
57 reads
Technically you do not have to create a cosmos DB and incur costs to test cosmos DB based applications, you could use the local emulator. This means that you...
2019-06-11
86 reads
Cosmos DB falls into the “NoSQL” technology group, call it a buzz word if you like but it is very different to classic Relational Databases such as SQL Server....
2019-06-10
201 reads
Quite simply the objective as follows: Move data from Azure SQL Database to Azure SQL DW via Azure Data Factory v2 (ADF). Overview Before I begin, what exactly is...
2019-05-22
179 reads
Quite a significant change has taken place within the Azure SQL Database space, more specifically the development of Azure SQL Database Serverless. Currently in preview mode this “compute” tier changes...
2019-05-14
317 reads
Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product. At a high level it involves a control...
2019-05-07
105 reads
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
32 reads
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
53 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I wrote a PowerQuery that parses a table from a PDF, and I want...
Comments posted to this topic are about the item Attaching an SQL Server database...
Comments posted to this topic are about the item Superseded Indexes
Which of these indexes is superseded by another?
See possible answers