Get all user tables with size
Returns User Tables by SIZE in DESCENDING ORDERAdd TOP n clause in SELECT to get selective results (i.e. TOP 10 TABLES)
2006-01-25 (first published: 2003-06-07)
2,460 reads
Scripts
Script Tbl Data to Insert Stmts. - Handles Unicode
Script Table Data to Insert Statements - Handles Unicode datatypes (nchar, nvarchar, ntext). This script works with SQL 2000 and has been improved to handle properly the nchar, nvarchar, and ntext data types for Unicode, as well as handle apostrophes in data correctly. Usage is to run the script to create the stored proc in […]
2006-01-24 (first published: 2006-01-11)
607 reads
Script to perform http(s) post
Post data as coming from an HTML FORM with METHOD=POST to an url and retrieve the result. The procedure uses WinHttp.WinHttpRequest.5.1
2006-01-24 (first published: 2005-01-27)
1,751 reads
BASE64 Encode and Decode in T-SQL
This is BASE64 Encoding/Decoding in a T-SQL procedure. This code is provided as is, and is free to use and modify. Version 2 June 2005
2006-01-23 (first published: 2004-11-17)
4,892 reads
MS Word VBA to Format T-SQL Text as Rich Text
This VBA script was written for MS Word. It formats the text and sets default colors for keywords. SQL 2005's Management Studio now does this by default but the previous Query Analyzer did not offer this functionality. This is useful if you prefer to print and review code from time to time (not recommended for […]
2006-01-23 (first published: 2006-01-11)
491 reads
Verify that your backups are archived.
If you backup your databases to a disk file, you should make sure that these disk files are then being archived to tape. Without this, your ability to recover the database is compromised in the event of a disaster. This script will examine the "archive" flag on all of the backup files to make sure […]
2006-01-22 (first published: 2005-03-25)
308 reads
Delete Old backup Files
The following script deletes files in the specified folder, older than specified no of days and outputs the details to the specified file location. I use this VB script to delete some old backup files those can't be deleted with the regular maintenance plans. All you need to do is to supply the backup folder […]
2006-01-20 (first published: 2006-01-11)
1,771 reads
Calculate upcoming business day from date (Updated)
Calculates the next business day based upon the work weeklength, number of days from the start date and a list of holiday dates kept in a table called HolidayDate.Created this script for determining the next banking day from 2 days after a request for wiring funds. Can be used for things like calculating shipping dates […]
2006-01-19 (first published: 2005-07-16)
1,538 reads
Script Login Roles Permissions in all DBSs
Populate @list variable with account(s) to script. Save output to recreate:Login, Password,Default DB,Server Roles,DB Access,DB Roles,DB Object PermissionsDB level permissions are scripted in all databases. Can recreate a single login, or accepts comma delimted list of logins.NOTE:Stored procedures are created in Master, but are deleted
2006-01-19 (first published: 2005-10-19)
1,765 reads
Create Excel XLS from T-SQL
This is a T-SQL script that uses OLE, ADO, Jet4 ISAM, and Linked Server to create and populate an Excel Workbook (XLS) file from T-SQL query. If the Excel Worksheet exists, the query will append to the "table". The code is designed to be used by SQL Agent and to append to the step output […]
2006-01-18 (first published: 2003-04-24)
13,525 reads
Blogs
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Forums
Alamat BCA KCU Singkawang Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. GM Situt No.12 B, Pasiran, Kec. Singkawang Bar., Kota...
Alamat Kantor BCA KCU Bandar Lampung Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. Yos Sudarso No.100, Bumi Waras, Kec. Bumi Waras, Kota...
Alamat Kantor BCA KCU JAMBI Telp:08218200233
Hub Via Wa:628218200233 Alamat: Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers