2013-07-22 (first published: 2009-04-30)
3,909 reads
Scripts
2013-07-19 (first published: 2013-07-01)
670 reads
Quick view of User database and server roles
Outputs an easily readable result of the database and server roles for database principals.
2013-07-18 (first published: 2013-06-14)
1,084 reads
The Automated DBA: Space Usage Snapshotter (sysadmin; central DB)
Records snapshots of space usage & buffer cache usage stats by partition, index, table, schema, filegroup, & database. Stats incl Reserved, Used, Data, buffer cache for row, lob, & overflow.
2013-07-17 (first published: 2009-05-30)
2,821 reads
Simple and efficient way to split string with seperator
Split a string with separator without looping. Can be efficiently used with joins if necessary.
2013-07-12 (first published: 2013-06-15)
2,466 reads
2013-07-10 (first published: 2013-06-19)
1,674 reads
usp_addcolumns
This is a stored procedure to add a columns to multiple tables, if column doesn't exist
2013-07-09 (first published: 2008-05-27)
991 reads
Changing database mail account SMTP servers
This will generate a script that drops and recreates existing db mail accounts and change the smpt server.
2013-07-08 (first published: 2013-06-19)
840 reads
2013-07-03 (first published: 2013-06-07)
922 reads
Free space for all database files
I wrote this script to help determine which data files are taking up space on an instance.
2013-07-02 (first published: 2013-06-05)
1,623 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Alamat BCA KCP Atrium Telp:08218520154
WhatsApp CS 628218520154 Ruko Atrium Blok E. 12-13, RT.5/RW.18, Sunter Agung, Kec. Tj. Priok,...
Alamat BCA KCP Bungur Telp:08218520154
WhatsApp CS 628218520154 Jl. Bungur Besar Raya No.32 & 32A, RT.3/RW.1, Gn. Sahari Sel.,...
Alamat BCA KCP Cempaka Putih Raya Telp:08218520154
WhatsApp CS 628218520154 Jl. Cempaka Putih Raya No.118 B,C,D, RT.16/RW.3, Cemp. Putih Tim., Kec....
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers