External Article

Try Before You Commit in Flyway

Sometimes we want to check whether it is possible to run a Flyway migration without error, but not actually make the changes. We might just need to 'sanity test' the performance of a migration on the Staging server, for example. By using a placeholder 'switch' to trigger a SQL Exception, we can get Flyway to roll-back its transaction, and therefore the migration, on demand.

Stairway to SQL Server Indexes

Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.

Blogs

SQL Server 2025 RegEx and AI

By

One of the language changes in SQL Server 2025 that I’ve seen a lot...

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

By

I hosted this month, but I decided to put my own entry in as...

Why Databases Still Fascinate Me

By

I get asked a lot about why or how I began working with databases...

Read the latest Blogs

Forums

Layanan Agoda Indonesia

By sqlnoobie

Call Center Agoda: 0811-222-143, Layanan Pelanggan 24 Jam Hubungi WhatsApp: +62 811 222 143....

Call Center Agoda Indonesia

By sqlnoobie

Call Center Agoda: 0811 222 143 dan 0811 222 611, Hubungi WhatsApp Untuk Refund...

Call Center Agoda 24 Jam

By sqlnoobie

Layanan Pusat Bantuan Pelanggan 24 Jam Call Center Hubungi WhatsApp: 0811 222 143. Untuk...

Visit the forum

Question of the Day

Identify a Slipstream Installation

I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?

See possible answers