One use case for NOT using schema prefixes

I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.

In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of your T-SQL code, because the schema prefix is important and useful most of the time. At Stack Overflow, though, there is a very specific pattern we use where not specifying the schema is beneficial.

Working with NULL Values in SQL

In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell.

How to Use SQL to Analyze the Bitcoin Blockchain

You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.

Decision Tree - Credit Card Fraud Detection

Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.

A Brief Introduction to PowerShellAI, an Intelligent Command-line

Learn how you can interact with ChatGPT from PowerShell.

PASS Data Community Summit 2023 - Sessions are available to view!

As hosts, Redgate are delighted to announce PASS Data Community Summit 2023 sessions are now live and available to view!

Quickstart: Connect SQL Server machines to Azure Arc

Get started with Azure Arc-enabled SQL Server to manage and govern your Windows and Linux SQL Server instances hosted across on-premises, edge, and multicloud environments.

How To Use Flyway for Database Migration in Spring Boot

In this article, we're going to look at how we can use Flyway to manage our SQL database schema in a Spring Boot application.

Optimized Plan Forcing with Query Store in SQL Server 2022

In this Article ,  We will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system's performance.

Running Queries Across Many SQL Server Databases

A challenge that reappears periodically in the world of databases (especially database management) is the need to run code on a subset of databases and to do so in a nuanced manner.