2024-08-21
507 reads
T-SQL
2024-08-16
424 reads
2024-08-14
366 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
493 reads
2024-07-29
596 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
420 reads
2024-07-12
603 reads
Blogs
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Measuring What Matters: Operationalizing Data Trust for CDOs
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
ETL Framework In Production
Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through...
SQL Server Ghosts
Comments posted to this topic are about the item SQL Server Ghosts