2013-07-19 (first published: 2013-07-01)
666 reads
Scripts
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,078 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,813 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,461 reads
2013-07-10 (first published: 2013-06-19)
1,667 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)
986 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)
836 reads
2013-07-03 (first published: 2013-06-07)
916 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,622 reads
2013-06-25 (first published: 2013-06-03)
1,574 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Alamat BCA KCP Sambas Telp Cs 0817781222
WhatsApp:0817781222 Jl. Gusti Hamzah No.85, RT.02/RW.01, Pendawan, Kec. Sambas, Kabupaten Sambas, Kalimantan Barat 79465
Alamat BCA KCP Antasari Telp Cs 0817781222
WhatsApp:0817781222 Jl. P Antasari No.21, Tlk. Lerong Ulu, Kec. Sungai Kunjang, Kota Samarinda, Kalimantan...
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers