Common Misconceptions About Microsoft Certification Exams
An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.
2026-02-09
An experienced exam writer explains common misconceptions about Microsoft certification exams, question design, preparation, and real-world expectations.
2026-02-09
This is part of a look back at the history of SQL Server Central as a part of our 25-year celebration in Feb 2026. "They want how much?" That was a question I got from Andy one afternoon as we discussed how we were going to manage the growth of SQL Server Central. I had […]
2026-02-06
2,480 reads
In my previous tip, Pagination Performance in SQL Server, I showed how to make SQL pagination more predictable – turning O(n) into O(1). I materialized and cached row numbers to page through instead of calculating them on every request. It wasn’t the whole story, though; real pagination queries rarely get to sort without filtering. Users always want more control, and filtering can threaten that predictability.
2026-02-06
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2026-02-05 (first published: 2001-07-04)
9,163 reads
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
2026-02-05 (first published: 2004-03-25)
9,181 reads
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2026-02-05 (first published: 2002-04-04)
7,791 reads
2026-02-04 (first published: 2026-02-03)
156 reads
In this article by Steve Jones, he shows you how to manipulate strings.
2026-02-04 (first published: 2004-04-05)
18,171 reads
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
2026-02-04 (first published: 2002-05-31)
16,046 reads
The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.
2026-02-04 (first published: 2001-04-18)
17,323 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers