2018-08-24 (first published: 2014-06-17)
729 reads
Scripts
Create Database Snapshot Dynamically
Dynamic SQL can be used to generate a database snapshot. Useful for a database with a number of files.
2018-08-23 (first published: 2016-11-04)
3,592 reads
2018-08-13 (first published: 2018-07-18)
720 reads
2018-08-08 (first published: 2018-07-22)
463 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)
843 reads
2018-07-17 (first published: 2018-06-26)
945 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,954 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)
559 reads
2018-07-09 (first published: 2018-07-04)
544 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,982 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
Layanan Resmi BCA KCU BEKASI Telp:0817°82°5533
Telp/Wa 62817825533 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks,...
Layanan Resmi BCA KCU GARUT Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Ciledug No.162, Kota Kulon, Kec. Garut Kota, Kabupaten Garut, Jawa Barat...
Layanan Resmi BCA KCU SUBANG Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Question of the Day
SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers