2018-08-13 (first published: 2018-07-18)
698 reads
Scripts
2018-08-08 (first published: 2018-07-22)
430 reads
Table Space Used in DB
A quick script that provides the sizes of the tables in your database, including schema and choice of sort method
2018-08-07 (first published: 2018-07-29)
806 reads
2018-07-17 (first published: 2018-06-26)
926 reads
STRING and FIND SQL Functions
SQL Functions that simplify search and operations over strings on SQL Server (starting with 2012)
2018-07-11 (first published: 2018-07-06)
4,899 reads
User Stored Procedure for Backup of user databases
This script is intended to demonstrate how we can create a stored procedure for the user responsible for backing up user databases in a default storage location.
2018-07-10 (first published: 2018-07-05)
511 reads
2018-07-09 (first published: 2018-07-04)
499 reads
Create Database using dynamic SQL
The T-SQL script created a databases using the default file locations from SQL server configuration and prints them in the end.
2018-07-05 (first published: 2018-06-28)
1,957 reads
User access management on DB & object level
It will help to find and manage the users access on DB level
2018-07-05 (first published: 2018-06-26)
421 reads
2018-06-15 (first published: 2018-01-04)
2,098 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers