Uncategorized

SQLServerCentral Editorial

People Matter

  • Editorial

I'm writing this sitting in a hotel room. PASS Data Community Summit has just finished (and we're going to do it again next year, twice). Before writing editorials, unless I've got a burning idea, I like to glance back through the editorials I've written to be sure I'm not repeating myself too much. Funny enough, […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-11-14

62 reads

SQLServerCentral Editorial

I Struggle

  • Editorial

This one is going to involve a lot of honesty & self-reflection. Run now. You've been warned. I know for a fact that I'm blessed. I'm healthy. I have a loving family. There are friends out there happy to see me when we meet. I've got one of the single greatest jobs ever. I live […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2026-10-16

118 reads

SQLServerCentral Editorial

The DBA is Dead! Long Live the !

  • Editorial

I'm sure I've never mentioned this before, but I'm a little aged. I'm not real far from 40 years in IT, and I got started a little late in life. Regardless, I've heard this tale of woe before. And no, this isn't going to be a rehash of all the old stories ("self-tuning" SQL Server […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2026-10-14

242 reads

SQLServerCentral Editorial

It's Never Just One Thing

  • Editorial

I was reading about a recent security failure when I saw the phrase "...a series of missed opportunities...". Made me giggle and say to myself "No Kidding Kojak" except I used Sherlock Holmes and a different word. Fact is, security failures, and hey, let's face it, process failures, almost never come down to a single […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2026-10-12

108 reads

SQLServerCentral Editorial

Let's Talk Certifications

  • Editorial

In just over a week, I'm going to be in Valencia, Spain, for pgConf.eu. While there, I'm planning to take the first certification to come out of the Open Alliance for PostgreSQL Education. I'm more than a little nervous because I'm not sure I'm ready. However, I've been studying and reading, watching videos, practicing my […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2026-10-10

124 reads

Stairway icons Database Deployments

Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7

  • Stairway Step

This final level focuses on the practical application of changesets in complex scenarios. From table transformations to ETL-driven logic, it explores how to manage database changes when rollback is no longer purely structural, emphasizing control, predictability, and pragmatic solutions.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-09-30

1,723 reads

SQLServerCentral Article

Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix

  • Article

Reproduce traditional row-lock accumulation and writer blocking, then see how SQL Server 2025 uses transaction ID locking and Lock After Qualification to improve concurrency—and where hints, isolation levels, and query shapes limit the benefit.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2026-09-23

3,161 reads

Blogs

Should You Use CHOOSE(): #SQLNewBlogger

By

I was experimenting with CHOOSE() recently after I was asked a question. In a...

T-SQL Tuesday #204 – Are blogs still relevant? (Roundup)

By

I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...

Build vs Buy AI: When to adopt, partner, build or buy

By

Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...

Read the latest Blogs

Forums

Cs Digital BCA KCP Palmerah Call//Cs:082374977784

By Halo_BCA

Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...

Kontak BCA KCP Ratu Plaza Call//Cs:082374977784

By layanan 24jam BCA

Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...

Weird problem altering logins with sysadmin account

By Brandie Tarvin

Has anyone ever seen this before? I have sysadmin permission on a server. I...

Visit the forum

Question of the Day

Switching Schema II

I run this query:

SELECT 
 s.name AS schemaname
 , o.name AS objectname
 FROM sys.objects o
 INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
 WHERE o.name = 'Beer'
I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beer
What happens?

See possible answers