External Article

LIKE Constraints

In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK constraints to strengthen your data integrity.

SQLServerCentral Article

SQL Server 2022 Build List

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 […]

Blogs

SQL from A to Z: Your Path to SQL Mastery this Fall

By

I'm excited to tell you about the "SQL from A to Z" learning track....

Introduction to Advanced Analytics

By

The post Introduction to Advanced Analytics appeared first on Joyful Craftsmen.

A New Word: Feresy

By

feresy – n.  the fear that your partner is changing in ways you don’t...

Read the latest Blogs

Forums

The Cloud Security Problem

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloud Security Problem, which...

Merge rows in SQL

By Neils

I have a table like below ID Ident source val opendate closedate IsActive --------------------------------------------------------...

Blocking Connection to Server

By thomaspsimon

Good Afternoon, We recently procured a service management software for our company, which uses...

Visit the forum

Question of the Day

AUTO_DROP Statistics

In SQL Server 2022, what does this statement do?

CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ON

See possible answers