SQLKitty

Blog Post

Azure Workbooks

I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I am trying to reproduce it in workbooks. While it isn’t an exact match, workbooks provide...

2023-12-13 (first published: )

311 reads

Blog Post

Temporal Table Data Fixes

I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...

2023-09-29 (first published: )

569 reads

Blog Post

Microsoft Fabric Overview

First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn...

2023-07-19 (first published: )

467 reads

Blogs

Teaching at the SC Statewide Audit Conference

By

Instead of teaching the CISA exam prep course, I'm teaching in the IT track....

Upgrading SQL Server in a Container

By

I decided to update software on my laptop recently during a trip. I’m loathe...

SQL Server Editions: What’s the Difference and Why It Matters

By

Understanding the Limits Before You Hit Them If you’re responsible for a SQL Server...

Read the latest Blogs

Forums

is there a reorg available in sql server?

By stan

hi i have a 67 million row fact table that needs about 30 million...

The Technical Debt Anchor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Technical Debt Anchor

Getting the Updated Column List

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Updated Column List

Visit the forum

Question of the Day

Getting the Updated Column List

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge
 SET CustomerContactFirstName = 'Andy'
 WHERE CustomerID = 1

SELECT COLUMNS_UPDATED()

See possible answers