Calculate Pressure - Most Advanced UOC
This function is used to calculate the actual unit of conversion for pressure.
2015-02-13 (first published: 2014-12-12)
565 reads
Scripts
2015-02-12 (first published: 2010-03-12)
4,953 reads
Rename Foreign Key Constraints
Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.
2015-02-09 (first published: 2013-03-19)
1,364 reads
Calculate Length - Most Advanced UOC
This function is used to calculate the actual unit of conversion for length.
2015-02-06 (first published: 2014-12-15)
856 reads
2015-02-05 (first published: 2013-03-22)
4,494 reads
Users , Roles and Logins
Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.
2015-02-03 (first published: 2015-01-25)
2,982 reads
Calculate Volume - Most Advanced UOC
This function is used to calculate the actual unit of conversion for volume.
2015-01-30 (first published: 2014-12-16)
836 reads
Update Statistics for databases where you have access
Run this stored procudure to update statistics for those SQL Server databases where you have permission
2015-01-27 (first published: 2015-01-08)
1,261 reads
Script to remove Backup Files except Recent One for Same Day
This script is useful to remove SQL backup files except latest one for same day from Backup Path.
2015-01-26 (first published: 2014-12-12)
1,111 reads
Calculate Power - Most Advanced UOC
This function is used to calculate the actual unit of conversion for power.
2015-01-23 (first published: 2014-12-16)
863 reads
Blogs
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
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...
Forums
ALAMAT BCA KCU PONTIANAK Telp:083178278662
WA,CS:083178278662 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT BCA KCU Karawang Telp:083178278662
WA,CS:083178278662 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang, Jawa Barat...
The SQL Server 2016 Plan
Comments posted to this topic are about the item The SQL Server 2016 Plan
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