2017-06-16
2,575 reads
Jason Givens
2017-05-01 (first published: 2017-04-19)
1,195 reads
SQL Server Cluster Automatic Memory Management
Don't waste memory in a cluster! Learn how to allocate memory between instances.
2017-04-06
3,037 reads
2017-01-30 (first published: 2017-01-26)
19,513 reads
Get Table Sizes and Percent of Database Size
This script uses two undocumented stored procedures that retrieve all tables in the database in which it is run and lists the data and index sizes, the sum of these sizes, and the table's size percentage of the entire database. The results are presented in descending order of the sum of the data and index […]
2004-11-24 (first published: 2004-10-25)
2,408 reads
Find Instances of a Column Name
This script will allow you to find all instances of a column name, or partial column name, in all user tables in the database in which it is run. This is sometimes helpful during upgrades, etc. There is no error checking in this script. You can modify it to add, if needed.Run this by simply […]
2004-06-21
186 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Batu Ceper TLP/WA 08216977749
Jl. Batu Ceper No.18 A-B, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
Alamat kantor resmi BCA KCP Balaraja Telp:08218200205
WhatsApp:08218200205Jl. Raya Serang Km. 24, Kp. Cariu, RT 003/001, Talagasari, Kec. Balaraja, Kabupaten Tangerang,...
BCA KCU SUNTER,Telp/Wa 0821.3111159
Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18, Sunter Agung, Kec. Tj....
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers