External Article

Piping, Filtering and Using Flyway Output in PowerShell

Flyway's output is often overwhelmed with verbose messages, most of which we can ignore but some of which provide vital warnings about failed compilations, or useful details about what a migration or callback did. I'll show how to use some pipeline-aware PowerShell functions to filter out and save the bits we want and pass the results along in a form that is useful to the next process in the pipeline.

External Article

Using TOP clause in a SELECT statement

There might be a time when you might want to return just a few rows of a result set, instead of the complete set. This might be useful if you want to just validate a selection criteria or a few rows of data. For whatever the reason the TOP clause can be used to return a specific number or a percentage of rows from a result set. This article will cover using the TOP clause in a SELECT statement and how it can be used to return a partial set of records.

Blogs

New Job -> Week 3 -> Creating Alerts

By

This is part of a series of new job blog posts. You can find...

Using SQL Alerts to Spot Suspicious Activity in SQL

By

SQL doesn’t really give us too many tools out of the box to allow...

How to Change the Browser Used by SSMS for AAD Auth

By

Did you know that you can change the browser used by SQL Server Management...

Read the latest Blogs

Forums

Error: 18456, Severity: 14, State: 149, no matter what I try

By webrunner

Hello experts, I'm seeing a strange issue. A user reported that they could not...

Production Rollback

By tham58

Hi, is it possible to restore an SQL Server DB to an earlier snapshot...

Azure SQL database AAD user management

By tommiwan

I have an Azure SQL DB where I have set up the Azure active...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers