measure twice, cut once.

Blog Post

SQL Server STUFF

The STUFF function in SQL Server is one of those little gems that is very under-used but when needed can be a real handy utility – at least that’s...

2022-01-10

15 reads

Blog Post

OPENJSON and CROSS APPLY

OPENJSON is pretty central to manipulating JSON documents in T-SQL. As we’ve seen, we can use a default schema that will return metadata about the JSON document or we...

2020-06-24 (first published: )

6,557 reads

Blog Post

OPENJSON and an Alias

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...

2020-06-08

274 reads

Blog Post

OPENJSON and an Alias

Using Aliases in T-SQL is very common. We can alias both Tables (FROM clause) and Columns (SELECT clause) and some other things too. It’s all pretty fundamental to writing...

2020-06-08

4 reads

Blogs

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Is Your Business Truly Ready for AI?

By

The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...

Data Governance: The Invisible AI Accelerator

By

Introduction Do you remember the effort of tidying up your BI and reporting systems,...

Read the latest Blogs

Forums

Moving On After a Technology Fail

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Moving On After a Technology...

Configuring Maintenance Plans in SQL Server

By Kenneth Igiri

Comments posted to this topic are about the item Configuring Maintenance Plans in SQL...

Counting Bits III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Bits III

Visit the forum

Question of the Day

Counting Bits III

What is the output of this code in SQL Server 2022?

select bit_count(0xEF)

See possible answers