Change the server name of the SQL Server Instance
How to change the server name of SQL Server Instance?
2018-03-27 (first published: 2018-03-19)
1,288 reads
Scripts
Statistics Outdated
Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.
2018-03-21
210 reads
2018-03-19 (first published: 2018-03-15)
446 reads
Unused Indexes in your databases
This Script allows you to determine the list of unused indexes in your databases.
For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude
2018-03-06 (first published: 2011-02-10)
6,156 reads
2018-02-28 (first published: 2018-01-10)
3,100 reads
Custom Replication Status Record Latency Monitor
Monitors replicated tables for any publisher/subscriber for latency in record counts, alerts via email if latency exists beyond a specified threshold
2018-02-27 (first published: 2015-01-23)
571 reads
2018-02-23 (first published: 2018-02-19)
163 reads
2018-02-19 (first published: 2018-02-07)
1,017 reads
Compression estimates
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
2,053 reads
2018-02-12 (first published: 2018-01-24)
331 reads
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
ALAMAT KONTAK BCA KCP Morowali Telp:08218154393
WA:08218154393 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
ALAMAT BCA KCP Bulukumba Telp:08218154393
WA:08218154393 Jl. Sam Ratulangi, Caile, Kec. Ujung Bulu, Kabupaten Bulukumba, Sulawesi Selatan 92517
Alamat kantor BCA KCU DAAN MOGOT Telp:082144477715
Wa:0821-4447-7715 Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers