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,087 reads
Scripts
2015-06-15 (first published: 2015-05-22)
2,418 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,091 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
349 reads
Detach & Attach Procedure
For successful run, Your SQL Server service account should have permission to old location & new location
2015-05-27 (first published: 2015-05-10)
1,058 reads
2015-05-26 (first published: 2015-05-08)
1,144 reads
2015-05-20 (first published: 2015-05-05)
2,346 reads
Taking Backup Of All DBs
Wrote the script to take compressed backup with combining many other features.
2015-05-18 (first published: 2015-04-29)
1,073 reads
2015-05-13 (first published: 2013-03-14)
7,288 reads
Find the position of all occurrences of an expression within a string
This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string.
2015-05-12 (first published: 2013-03-24)
2,271 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Pasar Minggu Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Raya Pasar Minggu No.6, RT.6/RW.8, Kalibata, Kec. Pancoran, Kota Jakarta...
Alamat BCA KCP Pejaten Telp:0821-8200-203
Telp/WA 62 821-8200-203 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No....
Alamat BCA KCP Tebet Timur Telp:0821-8200-174
Telp/WA 62 821-8200-174 Jl. Tebet Timur Dalam Raya Blok GG No. 97, RT.3/RW.6, Tebet...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers