2008-02-21 (first published: 2008-01-09)
2,017 reads
Scripts
2008-02-18 (first published: 2007-12-27)
834 reads
2008-02-14 (first published: 2007-12-20)
1,062 reads
2008-02-13 (first published: 2007-12-18)
1,773 reads
Change column type on constrained columns
Use this proc if you need to alter a column that is part of a primery key
2008-02-04 (first published: 2007-12-10)
1,138 reads
String Tokenizer with Complex Search
Sample solution to replace string in expressions with multiple delimiters.
2008-01-31 (first published: 2007-12-05)
2,019 reads
2008-01-29 (first published: 2007-11-23)
1,991 reads
2008-01-28 (first published: 2007-12-03)
1,728 reads
Server Login/Role And DB User/Role Script
This script will produce the server login/role and db user/role in all databases in the server.It is best advised that you first delete/recreate orphaned users for best results
2008-01-25 (first published: 2007-11-27)
3,823 reads
2008-01-24
1,258 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers