Transact-SQL

SQLServerCentral Article

Playing popular game of Wordle using T-SQL

  • Article

Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now  play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.

You rated this post out of 5. Change rating

2022-01-19

4,539 reads

Technical Article

Execute on DMVs without user having View Server State

  • Script

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

(1)

You rated this post out of 5. Change rating

2020-09-24

2,289 reads

SQLServerCentral Article

SQL Server Name Convention and T-SQL Programming Style

  • Article

There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]

(10)

You rated this post out of 5. Change rating

2019-12-10

25,134 reads

SQLServerCentral Article

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

  • Article

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

(10)

You rated this post out of 5. Change rating

2019-08-08

6,319 reads

Blogs

Using CAT for Testing of Data Agents

By

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By

Do you spend so long manipulating your data into something vaguely useful that you...

The Book of Redgate: SQL Server Central

By

It was neat to stumble on this in the book, a piece by me,...

Read the latest Blogs

Forums

Backup to Immutable Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backup to Immutable Storage

Microsoft Security Changes and SQL Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Microsoft Security Changes and SQL...

Expanding into Print

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Expanding into Print

Visit the forum

Question of the Day

Backup to Immutable Storage

In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?

See possible answers