HTML Email Using SQL
This would help you to send HTML email using T-SQL script, you just need to provide necessary parameters and you would have HTML email.
2006-05-19 (first published: 2006-04-19)
1,474 reads
Scripts
Calculate distance between two points
The calculation of distance between two points using standard spherical geometry can be inaccurate for short distances (ten miles or less) because the sine function of very small angles approaches zero. The haversine approach (http://en.wikipedia.org/wiki/Haversine_formula) turns this around, so it is very accurate at small distances but has larger errors (about ten miles) for points […]
2006-05-18 (first published: 2006-04-25)
703 reads
2006-05-17 (first published: 2006-04-25)
273 reads
2006-05-16 (first published: 2006-04-26)
284 reads
Display Person Initials
Display a person's initials regardless if they have a middle name or not.Just pass in the persons name
2006-05-15 (first published: 2006-04-27)
592 reads
BCP OUT all table data in your Database
Data Recovery is vital. This script will cursor through your database and BCP OUT the table data to a directory specifically for each day of the week (in numbers - where 1 = Sunday and 7 = Saturday) in order to have table recoverability up to 7 days. The first step is to create the […]
2006-05-11 (first published: 2006-05-02)
703 reads
2006-05-10 (first published: 2006-05-03)
317 reads
Seach any DB object across database server.
This procedure will help you to find particular database object in all databases across database server. Like search gives you all objects from all databases whos name includes seach word critera.
2006-05-01 (first published: 2006-03-06)
367 reads
Server Backup History Report (updated 2006-04-11)
Server Backup History Report (Full DB Backups only) 1. lists all databases with no backup history 2. lists last backup for other databases includes Date, User, Size, Duration, Age, Finish Date & Location Includes system databases Excludes TempDB Excludes backup history data where backupmediafamily.device_type = 7 these are typically created by Veritas BackupExec Tested on […]
2006-04-28 (first published: 2006-03-23)
4,598 reads
To move all the table data from database to xls or
To move all the table data from database to xls or doc or txt files tableMany times we come accross to move data from database to external files such as word,xls or data files. Here is the script that move all tables data to specified files. Target file names are the table names. specify the […]
2006-04-27 (first published: 2006-04-05)
1,697 reads
Blogs
Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
The Book of Redgate: Products
By Steve Jones
We are product focused at Redgate Software. Here is another of our values that...
KDA: Echoes of Deception - Case 7
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Forums
whats that ssis analyzer product that documents lineage
hi, a few years ago was at a very large company that bought a...
Implicit Conversions Cripple SQL Server
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
BIT_COUNT() III
Comments posted to this topic are about the item BIT_COUNT() III
Question of the Day
BIT_COUNT() III
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers