2024-08-16
428 reads
T-SQL
2024-08-14
369 reads
Express a Number or Currency in Words with T-SQL Code
This SQL script allows you to take a number and convert the number to words, and convert a currency value into words.
2024-08-09
Create Document Templates in a SQL Server Database Table
Learn how to create document templates in a database table and use SQL to replace specific keywords in the templates for content customization.
2024-08-05
2024-08-02
497 reads
2024-07-29
597 reads
XML Performance Tuning and Added Options
SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes less space, all while ensuring efficient access to critical data. At its core, the metadata-styled XML format runs counter to the data that SQL Server is optimized to manage.
2024-07-15
2024-07-15
424 reads
2024-07-12
606 reads
2024-07-08
453 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers