Verify Login SID and Machine SID
This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.
2015-01-12 (first published: 2014-12-24)
1,661 reads
Scripts
Calculate Temperature - Most Advanced UOC
This function is used to calculate the actual unit of conversion for temperature.
2015-01-09 (first published: 2014-12-11)
1,032 reads
Find no of records in each table in database (against Clustered Index)
If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.
2015-01-08 (first published: 2014-12-26)
1,528 reads
Calculate Angle - Most Advanced UOC
This function is used to calculate the actual unit of conversion for angle.
2015-01-06 (first published: 2014-12-10)
661 reads
Calculate Area - Most Advanced UOC
This function is used to calculate the actual unit of conversion for area.
2015-01-02 (first published: 2014-12-10)
698 reads
Calculate Mass/Weight - Most Advanced UOC
This function is used to calculate the actual unit of conversion for mass.
2015-01-01 (first published: 2014-12-10)
559 reads
Dynamic Script to Generate Backup Script
Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.
2014-12-31 (first published: 2014-12-10)
1,313 reads
Calculate Energy - Most Advanced UOC
This function is used to calculate the actual unit of conversion for energy.
2014-12-30 (first published: 2014-12-11)
730 reads
All OS version info in one function
Always wanted to know the OS details? This function tells you everything (MSSQL 2008R2 and newer version only)
2014-12-29 (first published: 2014-12-06)
1,573 reads
2014-12-25 (first published: 2014-12-04)
1,132 reads
Blogs
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers