Use SELECT statements to query a MySQL database. In this article, Robert Sheldon explains how.
The post Introducing the MySQL SELECT statement appeared first on SQLServerCentral.

Learn about various SQL Server system functions to return meta data from SQL Server such as SERVERPROPERTY, DATABASEPROPERTYEX, DB_NAME, DB_ID, FILE_NAME, FILE_ID, FILE_IDEX, SCHEMA_NAME, SCHEMA_ID, OBJECT_NAME, OBJECT_ID and STATS_DATE.
The post Metadata Functions in SQL Server and Their Use Cases appeared first on SQLServerCentral.

A generic way of exporting, deleting and loading data, for database development work. It uses Flyway Teams, a PowerShell framework, JSON files for storage and a table manifest to define the correct order of dependency for each task. It should help a team maintain datasets between database versions, as well as to switch between the datasets required to support different types of testing.
The post Managing Datasets for Database Development Work using Flyway appeared first on SQLServerCentral.

Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]
The post Manage Your Business Rules in T-SQL Query appeared first on SQLServerCentral.

Dependency information will allow you to avoid errors during a database build or tear-down, by ensuring you create or remove objects in the right order. It will also help you to avoid future 'invalid object' errors, because it will allow you to check that no database alterations have introduced broken references, during Flyway migrations.
The post The Uses of Dependency Information in Database Development appeared first on SQLServerCentral.

In this article, we look at the SQL Server WAITFOR command to allow delays in processing either for a specified time or a set amount of time.
The post SQL WAITFOR Command to Delay SQL Code Execution appeared first on SQLServerCentral.

Motivation At some point in the carrier, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]
The post Manage Your Business Rules in T-SQL Query appeared first on SQLServerCentral.

This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
The post SQL Server 2022 Build List appeared first on SQLServerCentral.