List schemas in a database
This is an expansion of the sys.schemas table.
User schemas are sorted to the top, schema type is decoded, schema authorization is included.
2015-07-14 (first published: 2015-06-10)
1,857 reads
Scripts
2015-07-10 (first published: 2015-06-11)
1,004 reads
Delete Backup Files From Default Backup Location
IF you have need to schedule job to cleanup backup files older than N days, you can use my written script.
2015-07-02 (first published: 2015-06-04)
673 reads
Move database files to another Drive
This script either generates or execute statements to SQL data and log files from C:\ to D:\
2015-07-01 (first published: 2015-06-03)
2,477 reads
Backup Growth Trend Check
-- Backup Growth Trend Check To Understand how much disk space you need in future
2015-06-23 (first published: 2015-06-02)
1,296 reads
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-17 (first published: 2015-06-03)
1,666 reads
Standardizing DBMAIL Profile & Account Setup for Notification
If you have a requirement to setup with a default global dbmail profile and account you can use my script.
2015-06-16 (first published: 2015-05-28)
1,086 reads
2015-06-15 (first published: 2015-05-22)
2,408 reads
Count character matches with DATALENGTH function
https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql
2015-06-08 (first published: 2015-05-18)
1,090 reads
Disk Free Space Check
IF you have a requirement to check disk free space and want to report to the team using email, can use my script
2015-06-03
347 reads
Blogs
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Forums
Alamat Kantor BCA KCU Magelang Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang,...
Alamat Kantor BCA KCU KUDUS Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus,...
Alamat Kantor BCA KCU Gang Tengah Telp:08217555651
Hub Via Wa:628217555651 Alamat Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa...
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers