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.
The post Using TOP clause in a SELECT statement appeared first on SQLServerCentral.

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.
The post Piping, Filtering and Using Flyway Output in PowerShell appeared first on SQLServerCentral.

With the SQL WHERE clause in SQL Server, users can filter their query results in many ways. In most cases, we do not utilize all the options the WHERE clause provides, so we tend to forget that they exist. In this SQL tutorial, we will look at several examples of how to use the WHERE clause.
The post How to use the SQL WHERE Clause with Examples appeared first on SQLServerCentral.

This article looks at an interesting way to help your users get filtered data from a TVF instead of using a stored procedure or specialized view.
The post Passing parameters to query without TVFs appeared first on SQLServerCentral.

In this webinar, Microsoft Data Platform MVP, Grant Fritchey, is joined by our expert panel to share the pros and cons to building a monitoring system versus purchasing one.
The post Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.

Learn about how you can work with your SQL Server data from C#. A good basic tutorial for beginning C# developers.
The post How to Connect SQL Server and Create C# Objects for Data Management appeared first on SQLServerCentral.

This article covers the concepts of roles, schemas, grants, privileges, and owners and the similarities and differences in SQL Server, Oracle, and PostgreSQL.
The post SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners - Part II appeared first on SQLServerCentral.

Find the latest insights on digital modernization and the role of the database in it in our new resource page. With articles and webinars from Redgate leaders and friends of Redgate.
The post Thought Leadership resource page appeared first on SQLServerCentral.