SQLServerCentral Editorial

A Thrill of Hope

I realize that this isn’t the last Database Weekly editorial of the year – that honor is reserved for Louis Davidson next week. 😊 However, as we approach the end of the year and various holiday celebrations, one of my favorite Christmas carols has been of particular encouragement to me recently. 2023 hasn’t gone exactly […]

SQLServerCentral Article

Creating a Hyperscale Database in Azure Using the Azure Portal

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.

External Article

Sending resource alerts on Managed Instance using db_mail

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.

Blogs

Friday Flyway Tips–Above Target Migrations

By

Recently I was working with Flyway Desktop (FWD) and practicing deploying certain migrations and...

A New Word: the whipgraft delusion

By

whipgraft delusion – n. the phenomenon in which you catch your reflection in the...

Creating a Scripts Folder in SQL Compare

By

While I was at a conference recently, someone asked me about the Scripts Folder...

Read the latest Blogs

Forums

A Thrill of Hope

By Ryan Booz

Comments posted to this topic are about the item A Thrill of Hope

Always On Failover Availability Group Automation

By sfnemis

Hi! I have successfully installed the always-on system from your current repository, and I...

SQL Server 2022: AlwaysOn AG databases can not sync after applying CU6 or higher

By Tom_HJ

The setup is: OS - Win Server 2022 & MSSQL - SQL Server 2022 AlwaysOn...

Visit the forum

Question of the Day

The PowerShell Array Removal

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
$numbers

See possible answers