One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.
2023-12-22
496 reads
In this article, we will introduce Microsoft Fabric and how it relates to Power BI Premium Capacity we will turn to the mechanics of capacity utilization, and we will briefly look at how to monitor the performance loads of our Fabric resources.
2023-12-22
Is there a reason to upgrade your SQL Server in place instead of building a new instance? Andy Warren has a few thoughts today on why this might be the right choice.
2023-12-20
2,445 reads
One of the biggest issue that you might experience in Managed Instance is reaching storage limit or finding out that you don't have enough CPU. In this case you would need to get the bigger instance; however, this is not instant operation. In this post, you will see how you can monitor resource usage and send email alerts if there is a risk that you might reach the limits.
2023-12-20
The ForEach loop works with only one file type at a time by default. Learn how you can add code to your packages to work with multiple types of files.
2023-12-18
1,291 reads
Source control is fundamental when dealing with projects and sharing code between multiple developers. Power BI present some challenges related to source control. But it’s finally providing us with a solution to these challenges. Let’s analyse this piece-by-piece.
2023-12-18
This article examines the challenges with searches on encrypted data and presents a possible solution that you might use to speed up those queries.
2023-12-15
1,232 reads
2023-12-15 (first published: 2018-12-20)
9,170 reads
Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql.
2023-12-15
Tell me if you’ve heard this one before: I changed data from my application, but when I checked the database, I couldn’t see the change! I’ve seen this. Loads. It can be quite perplexing for folks because they expect to see an error message if the insert, update, or delete failed.
2023-12-15
By Steve Jones
Recently I was working with Flyway Desktop (FWD) and practicing deploying certain migrations and...
By Steve Jones
whipgraft delusion – n. the phenomenon in which you catch your reflection in the...
By Steve Jones
While I was at a conference recently, someone asked me about the Scripts Folder...
Hi! I have successfully installed the always-on system from your current repository, and I...
The setup is: OS - Win Server 2022 & MSSQL - SQL Server 2022 AlwaysOn...
I have this code in PowerShell:
$numbers = @(1,2,3,4,5,6,7,8,9,10)I run this code. How many rows are returned?
$numbers[4]=$null $numbersSee possible answers